dear buddy, when u specify permissions on a particular database, you need to give that database name to connect to db.
user created fine, while connecting, try this: mysql -u abc -p abc where last abc is ur database name. Nitin ----- Original Message ----- From: "ads mysql" <[EMAIL PROTECTED]> To: "Nitin" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, December 16, 2003 11:51 AM 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]
