Your spelling of PRIVILEGES is also spelled wrong =) specifying GRANT ALL PRIVILEGES on *.* to a user will make that user a member of the superuser group such as mysql, just without the GRANT OPTIONS, meaning that user's login wouldn't be able to GRANT other users.
if you want to specify the database just do a mydb.* meaning all tables within the mydb database. then, mysql>flush privileges; i hope that helps. Respectfully yours, Sherwin T. Ang Systems Administrator Tridel Technologies Incorporated 7F Hanston Building Emerald Avenue, Ortigas Center Pasig City 1605 Philippines Phone: 6345140 Local 1024 Web: http://www.tridel.net Email: [EMAIL PROTECTED] ----- Original Message ----- From: "Toto Gamez" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, March 27, 2003 2:11 PM Subject: MYSQL Database i got this mesage when creating a database for twig, I just followed the instruction in twig manual on how to create a database but resulted to this [EMAIL PROTECTED] mysql]# mysql -u root mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 to server version: 3.23.41 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> CREATE DATABASE maildb; Query OK, 1 row affected (0.00 sec) mysql> GRANT ALL PRIVELEGES ON *.* TO toto IDENTIFIED BY mikaela02; ERROR 1064: You have an error in your SQL syntax near 'PRIVELEGES ON *.* TO toto IDENTIFIED BY mikaela02' at line 1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
