Log in

View Full Version : Sorry need help again ><

D-Loading
02-27-2004, 02:42 PM
Hello,
sorry for asking this noob question but how do i create a eq database using mysql?

I did run cmd

i ran mysql in dos prompt
i tried to create a eq database there
code

create database eq;

I get error 1064 &lt;42000>: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server verison for the right syntax to use near.

I'm currently using MySQL-5.0.0a-alpha-win

anyone know what i did wrong?
samandhi
02-27-2004, 09:35 PM
create database eq; Should be:
CREATE DATABASE eq;
Monrezz
02-27-2004, 11:16 PM
I'm not sure Emu works with Mysql 5.0 yet - I tried it and had a lot of problems, went back to 4.1 and everything worked fine.

Are you sure you ran mysql.exe? Try downloading Mysql Front and creating the database that way.
samandhi
02-28-2004, 08:05 AM
&lt;agrees> aaaah yes, you are using an alpha version of the program. Try downloading and installing the release version of MySQL database server....from here: http://www.mysql.com/ (http://www.mysql.com/) . If you are NOT an expert at it, I would download the 4.1.1 version. That one is KNOWN to be stable. Anything newer than that is alpha, which means it is still in very early stages....