I got this error


Error
MySQL said: You have an error in your SQL syntax near '' at line 1
Back


when I was trying to add a database through phpmyadmin. I installed my mysql at /usr/local/mysql/ . I need to know which file should I edit to solve the error there as I need to add databases for my clients.

Please help me .... I need to add all of the databases as soon as possible.

Donovan,

Are you sure about that? When we installed MySQL it defualted to /var/lib/mysql and the MySQL daemon defaulted to: /usr/sbin/mysqld.

I'm not familiar with phpmyadmin, but have you tried setting up the databases from the command line?

lol.. there is an error in your create statement.. check that out.. :) the error has nothing to do with your mysql installation..

If phpmyadmin is giving you that, then there is an incompatibility with the versions of phpmyadmin and mysql. Make sure the phpmyadmin you installed can communicate with that version of mysql you installed.

gosh... Then what should I do to add the databases???

Someone can show me the command line?
I saw a few in a few web sites, not really sure which I need to add and which I don't as I don't provide shell access for clients.

whats the command mysql is issuing to create the dbase? it usually comes up at the top of the page..

huh????

vizi ... I thought there are only one version of phpmyadmin available??? Anyone?? Please help !!!