right now, u r trying to connect t omyql with uer abc, not creating it. to create user abc grant <privs> on dbname.tablename to 'abc' identified by 'abc';
you can view the list of privileges available on myql website at http://www.mysql.com/doc/en/GRANT.html Enjoy Nitin ----- Original Message ----- From: "ads mysql" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, December 16, 2003 11:09 AM Subject: How to create mysql user? > > 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
