Hi,
I have installed mysql. As per documentation with user as 'root'.
I can create Database, table. I can enter data into table.
I have created user 'abc' with passowrd 'abc' on my Linux 8.0 server.
by using command :
adduser abc -p 'abc'
Now I want to create mysql database user 'abc' with command :
[EMAIL PROTECTED] mysql]# mysql -u abc -p
Enter password: (entered abc)
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
Is it granting permission to abc. I refered documentation but could not get it clearly
Neet sample code.
Then I connected mysql as 'root' user. and tried.
mysql> mysql -u abc -p;
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresonds to
your MySQL server version for the right syntax to use near 'mysql -u ab -p' at line 1.
Syntax I got from Documentation for GRANT as follows:
###########
4.4.1 GRANT and REVOKE Syntax
GRANT priv_type [(column_list)] [, priv_type [(column_list)] ...]
ON {tbl_name | * | *.* | db_name.*}
TO user_name [IDENTIFIED BY [PASSWORD] 'password']
[, user_name [IDENTIFIED BY [PASSWORD] 'password'] ...]
#######
Please guide me how to create users for mysql with password.
Thanks for support.
---------------------------------
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing
