MySQL: September 2007 Archives

In MySQL server side(assuming the MySQL server IP is 192.168.1.1), create a user and grant the remote access privilege to the new created user.

mysql> use mysql;
mysql> GRANT ALL ON *.* TO admin@'%' IDENTIFIED BY 'adminpwd' WITH GRANT OPTION;


Comments:
Here, admin@'%' means allow user 'admin' to connect with this MySQL from any IP address remotely.

Then we can try to connect to MySQL server 192.168.1.1 from any MySQL client.
mysql -h192.168.1.1 -uadmin -padminpwd

About this Archive

This page is an archive of entries in the MySQL category from September 2007.

MySQL: January 2008 is the next archive.

Find recent content on the main index or look in the archives to find all content.