try this: grant ALL on abc.* to 'abc'@'localhost' identified by 'abc'; >I have created database 'abc' . >mysql> grant ALL on abc.table to 'abc' identified by 'abc'; >Query OK, 0 rows affected (0.00 sec)
-----Original Message----- From: ads mysql [mailto:[EMAIL PROTECTED] Sent: Monday, December 15, 2003 11:21 PM To: Nitin; [EMAIL PROTECTED] Subject: Re: How to create mysql user? O K. I accessed to mysql as root user and tried to created user 'abc' as folows : [EMAIL PROTECTED] mysql]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 61 to server version: 4.0.16-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. I have created database 'abc' . mysql> grant ALL on abc.table to 'abc' identified by 'abc'; Query OK, 0 rows affected (0.00 sec) I want to give all permission to user abc to handle database 'abc'. Then I tried to connect as user 'abc' to mysql as follows : [EMAIL PROTECTED] mysql]# mysql -u abc -p Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Some problem. Help appreciated. Nitin <[EMAIL PROTECTED]> wrote: right now, u r trying to connect t omyql with uer abc, not creating it. to create user abc grant 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" To: 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 --------------------------------- 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]