For When You Can't Have The Real Thing
[ start | index | login ]
start > mysql > Access From Remote Systems

Access From Remote Systems

Created by dave. Last edited by dave, 6 years and 232 days ago. Viewed 1,397 times. #1
[edit] [rdf]
labels
attachments

Accessing mysql From Remote Systems

$ mysql -h 192.168.1.8 -u root -p
Enter password:

You have to set up the remote access first:

$ mysql -u root -p
Enter password:

mysql> use mysql

mysql> GRANT ALL ON *.* to root@'192.168.1.4' IDENTIFIED BY 'your-root-password';

mysql> FLUSH PRIVILEGES;

no comments | post comment
This is a collection of techical information, much of it learned the hard way. Consider it a lab book or a /info directory. I doubt much of it will be of use to anyone else.

Useful:


snipsnap.org | Copyright 2000-2002 Matthias L. Jugel and Stephan J. Schmidt