MySQL Forums
Forum List  »  Newbie

creating database?
Posted by: chris
Date: June 15, 2005 09:37PM

I have mysql installed and running. i want to run a phbb on my server. these are the instructions i am using. i create the databse all right bu when i get to grant command i get syntax error near 'INDENTIFIED BY 'PASSWORD' WITH GRANT OPTION'. I type in
GRANT ALL PRIVILEGES ON gators. TO 'hjscm'@'localhost'
INDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;




[root@axentraserver adminuser]# mysql -u root -p mysql
Enter password: (enter the password from oe-mysql.conf here)
[...]
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> CREATE DATABASE db_name;
Query OK, 1 row affected (0.01 sec)

mysql> GRANT ALL PRIVILEGES ON db_name.* TO 'db_user'@'localhost'
-> IDENTIFIED BY 'db_pass' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye

thanks for the help

Options: ReplyQuote


Subject
Written By
Posted
creating database?
June 15, 2005 09:37PM
June 16, 2005 04:12PM
June 16, 2005 06:44PM
June 17, 2005 02:08AM
June 17, 2005 07:28AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.