Hello,
I have a problem with mySql server: I can only run it as root. I use
mySql 4.0.15 and phpMyAdmin 2.5.5. on Mac OSX 10.3.2.
I run mySql server as root, log in via phpMyAdmin as root and I see
there is no user mysql when I click 'Privileges'. When I try to make
new user 'MySql' (with minimal privileges) and click 'Go' I get an
error 'unknown command'. The corresponding mySql statement is:
GRANT SELECT , INSERT , UPDATE , DELETE , CREATE , DROP , INDEX ,
ALTER , CREATE TEMPORARY TABLES ON * . * TO "mysql"@ "%"IDENTIFIED BY
"*****"WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0
MAX_UPDATES_PER_HOUR 0 ;
#1047 - Unknown command
How can I log in as user root and not have Grant privileges???
More importantly, how can I create a user mysql with the normal set of
privileges (update, create, alter etc)?
I have been using the procedure described on the mysql.com website
'A.4.2 How to Reset a Forgotten Root Password' to reset the password
for root.
Thanks.