Entry

Why mysql_query, when I tries to do a query like "CREATE TABLE ..." or "GRANT ...", works at home (Lynx & mySQL 3.22.26a),not at work (IE5 & 3.22.32)?

Jul 15th, 2002 22:39
Justin Dalrymple, Ferdinando Simonetti,

Chances are you have permissions setup which limit your ability to 
create tables and grant priviledges.
Log into MySQL using the root user and use the 'mysql' database. Then, 
check to see that the user you are attempting to create/grant with has 
permission to do so in the 'user' table. The columns that need to be 
set to 'Y', for your two actions, are;
Create_priv
...and...
Grant_priv