Patrick Dixon said the following on 01/25/2006 10:17 AM: > Hmm, well I've spent the 5 minutes and I'm getting nowhere ... > > I'm getting: > > mysql> Ungrant all on slimserver.* to slimserver [identified by > 'password']; > ERROR 1064 (42000): You have an error in your SQL syntax; check the > manual that corresponds to your MySQL server version for the right > syntax to use near 'Ungrant all on slimserver.* to slimserver > [identified by 'password']' at line 1
A few problems there... Assuming you've done the initial MySQL setup, changed the root password, etc., you need to use the following: # mysqladmin -u root -p create slimserver Enter password: (enter slimserver root password) # mysql -u root -p Enter password: (enter slimserver root password) Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2415 to server version: 4.1.7-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> grant all on slimserver.* to 'slimserver'@'localhost' identified by 'password'; Query OK, 0 rows affected (0.11 sec) mysql> quit Bye HTH, R. _______________________________________________ Discuss mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/discuss
