Jump to content


Photo

Setting up user and Privileges


  • Please log in to reply
No replies to this topic

#1 greeneel

greeneel
  • New Members
  • Pip
  • Newbie
  • 7 posts

Posted 01 March 2006 - 01:30 AM

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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users