Users in a database...

AdamBrill · 2003-06-15T23:48:57+00:00

I have two questions. How can you get all of the users(like 'SHOW databases' to get the databases)? How can you add a new user? Thanks!

Users in a database...

AdamBrill

I have two questions.

How can you get all of the users(like 'SHOW databases' to get the databases)?
How can you add a new user?

Thanks!

LonelyPixel

noone else... hmm
get phpmyadmin (www.phpmyadmin.net) and see what queries it issues. you can learn from that.
a list of users can normally be found in the mysql.users table

TheIceman5

dude, u need serious help on SQL, go look for tutorial on google.

AdamBrill

Originally posted by TheIceman5
dude, u need serious help on SQL, go look for tutorial on google.

If these questions are so easy, is there any reason why you didn't answer them??

pyro

Originally posted by TheIceman5
dude, u need serious help on SQL, go look for tutorial on google.

Do you always go around insulting those asking for help? Helping people is the purpose of these forums, and AdamBrill was just asking for help with a very direct issue... not asking for a full script, or anything else. I agree with AdamBrill... If it is so easy, why don't you just give him a hand and tell him how to do it? :rolleyes: