"The mind of a Mad Tech!"

If you are trying to access a mysql database and are rejected when you try to use a Mysql GUI tool, such as Mysql Front, chances are that this is due to the user only have access to local access. To create this, you will need to create the database and then assign it remote access.

For this example, I will create the database , testing. First you log into the mysql server locally. Then you create the database;

Mysql> Create database testing;

Now you will create the user, password and remote address.

Mysql> use database testing;

GRANT ALL ON testing.* TO admin@’56.56.2.2′ IDENTIFIED BY ‘PASSWORD‘;

This will create the user, password and grant remote access to the server. You will also want to create access for local access as well;

GRANT ALL ON testing.* TO admin@’127.0.0.1′ IDENTIFIED BY ‘PASSWORD‘;

OR

GRANT ALL ON testing.* TO admin@’localhost’ IDENTIFIED BY ‘PASSWORD‘;

That’s it!

This entry was posted on Tuesday, March 11th, 2008 at 8:33 am and is filed under MySql. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.