How to access MySQL (version 5.0.45) remotely

user-pic
Vote 0 Votes

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

No TrackBacks

TrackBack URL: http://www.isoracle.com/mt/mt-tb.cgi/2

Leave a comment

About this Entry

This page contains a single entry by Joe Wang published on September 27, 2007 1:32 AM.

ORA 600 error during 10g(10203) standby recovery is the next entry in this blog.

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