MySQL create user

Every time I have to setup users in MySQL I seem to have problems.
I was setting up a system to do some WordPress testing and installed MySQL OK, but ran into problems with the users and permissions. Again.

So I had to search the net, again, and find out what I was doing wrong, again.
Maybe I’m just used to the way oracle does it, my MySQL does it in a strange way, why is it so hard ?

Luckly I found out how to do it at a site called Database F1.

What you have to do is this :

SQL> CREATE USER 'user1'@'localhost' IDENTIFIED BY 'pass1';
SQL> GRANT SELECT,INSERT,UPDATE,DELETE ON *.* TO 'user1'@'localhost';

I think the problem I keep running into is that you can refer to users by either ‘user1’@’localhost’ or just user1. I think the trick is to always use the ‘user1’@’localhost’ syntax.

Let me know if you think otherwise, as it confuses me!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s