Page 1 of 1

Setting Up users and Privileges

Posted: Tue Feb 28, 2006 7:36 pm
by greeneel
Hello,

I just installed mysql and was testing to see if i could setup privileges, now I am logged in as root using the mysql console and wanted to create a user and also give them some privileges..
I am using

mysql> GRANT SELECT,INSERT,UPDATE
-> ON *.*
-> TO bro@localhost
-> IDENTIFIED BY 'bobo';

mysql doesn`t give me an error or anything so i figured that it accepted it, but when i try to login using this new user it seems as if its now there. now i used phpMyAdmin to login using root then went to look at privileges and I donb`t see the new user anywhere..
I guess i did something wrong somewhere, any ideas on what it was? abit lost as im new and just following an ebook on this stuff..

thanks in advance

Posted: Tue Feb 28, 2006 7:46 pm
by John Cartwright
try changing bro@localhost to 'bro'@'localhost'

you can also visit http://dev.mysql.com/doc/refman/4.1/en/ ... users.html to view an alternative to creating users

Posted: Wed Mar 01, 2006 1:49 am
by greeneel
will try this

Posted: Wed Mar 01, 2006 3:43 am
by greeneel
Just tried this and all systems are goo.. thx my friend.....