greeneel Posted March 1, 2006 Share Posted March 1, 2006 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 Quote Link to comment https://forums.phpfreaks.com/topic/3793-setting-up-user-and-privileges/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.