----- Original Message ----- From: "Nitin" <[EMAIL PROTECTED]> To: "ads mysql" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, December 16, 2003 2:01 PM Subject: Re: How to create mysql user?
> did u do a > flush privilege > > > ----- Original Message ----- > From: "ads mysql" <[EMAIL PROTECTED]> > To: "Nitin" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Tuesday, December 16, 2003 1:00 PM > Subject: Re: How to create mysql user? > > > > O K. I have tried following as advised. > > > > ##### > > [EMAIL PROTECTED] mysql]# mysql -u abc -p abc > > Enter password: > > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) > > ###### > > > > Then once again I accessed mysql as root user and Granted permission as > follows : > > > > [EMAIL PROTECTED] mysql]# mysql -u root -p > > Enter password: > > Welcome to the MySQL monitor. Commands end with ; or \g. > > Your MySQL connection id is 69 to server version: 4.0.16-standard > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > > > > > mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON abc.* TO > [EMAIL PROTECTED] IDENTIFIED BY 'abc'; > > Query OK, 0 rows affected (0.01 sec) > > mysql> USE abc > > Database changed > > mysql> exit > > Bye > > > > > > [EMAIL PROTECTED] mysql]# mysql -u abc -p abc > > Enter password: > > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) > > > > Don't know what is wrong. > > Thanks for support. > > > > > > Nitin <[EMAIL PROTECTED]> wrote: > > 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" > > To: "Nitin" ; > > 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 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 > > > > > > > > --------------------------------- > > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
