[SOLVED]MySQL -> How to create users?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Jonah Bron
DevNet Master
Posts: 2764
Joined: Thu Mar 15, 2007 6:28 pm
Location: Redding, California

[SOLVED]MySQL -> How to create users?

Post by Jonah Bron »

Hello, world!

After using XML for a while, I saw that there are many uses for a DB. So, I'm learning SQL, with MySQL.

I set it up, but can't figure out how to make users. I ask, because I CREATE DBs.

Thanks for your help!
Last edited by Jonah Bron on Sat Apr 05, 2008 11:29 am, edited 1 time in total.
User avatar
onion2k
Jedi Mod
Posts: 5263
Joined: Tue Dec 21, 2004 5:03 pm
Location: usrlab.com

Re: MySQL -> How to create users?

Post by onion2k »

With CREATE USER and GRANT PRIVILEGES.

http://dev.mysql.com/doc/refman/5.0/en/ ... users.html
User avatar
Jonah Bron
DevNet Master
Posts: 2764
Joined: Thu Mar 15, 2007 6:28 pm
Location: Redding, California

Re: MySQL -> How to create users?

Post by Jonah Bron »

Thanks, onion. Was connected as 'localhost' instead of 'root'. Silly me. :crazy:
Post Reply