MySQL Forums
Forum List  »  Newbie

Re: assigning user privileges error
Posted by: Umesh Shastry
Date: April 29, 2005 02:41AM

Hi!

Have u started mysqld with --skip-grant-tables option? or just take a look at the options file (my.cnf/my.ini)..if you get this then just comment it..) then restart the mysqld.

Also try this(same as u did )
Login to mysql server with the root/any user who has got GRANT privileges..


C:\mysql\bin>mysql -uroot -p********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 4.0.18-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

(root@localhost) [(none)]>


(root@localhost) [(none)]> GRANT ALL ON test.* to 'umesh'@'%' IDENTIFIED BY 'shastry';
Query OK, 0 rows affected (0.09 sec)

// This will require only when u have directly updated/inserted into the mysql.user/db table..
(root@localhost) [(none)]> flush privileges;
Query OK, 0 rows affected (0.08 sec)

(root@localhost) [(none)]>



(root@localhost) [(none)]> \q
Bye

Now login using newly created user..

C:\mysql\bin>mysql -uumesh -pshastry test
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 4.0.18-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

(umesh@localhost) [test]>


If this doesn't help you then just let me know which version/os ur using & also what exactly error message showing when ur trying to login with the new user...

Hope This helps!

Options: ReplyQuote


Subject
Written By
Posted
April 28, 2005 08:12PM
Re: assigning user privileges error
April 29, 2005 02:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.