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
Subject
Written By
Posted
creating database?
June 15, 2005 09:37PM
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.