create a mysql user that can connect from anywhere to anything

Code February 3rd, 2004

Obviously this is a huge security mistake to create this on a production server but if you just want to be able to get to all databases on a remote server in your intranet its a necessity:

On the server:

Create user: GRANT ALL PRIVILEGES ON *.* TO myuser@’%’ IDENTIFIED BY ’some_password’ WITH GRANT OPTION;

Now you can login from another machine

mysql -h 192.168.0.100 -u myuser -p

Share it:
These icons link to social bookmarking sites where readers can share and discover new web pages.

One Response to “create a mysql user that can connect from anywhere to anything”

Rodrigo Says:
April 16th, 2007 at 8:52 am
Hello,

I’ve tried this command to make a new user, however I just got:

“Query OK, 0 rows affected (0.00 sec)”

Then I think “ok, 0 rows, it seems I already built this user before”. However, it doesn’t works, the user isn’t created, therefore I cannot log-in the new user.