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, 11 years and 359 days ago. Viewed 2,553 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
see also:
snipsnap-index Why Kerry Lost 2004 mysql Unrecogniz...
Detecting Hyper ... snipsnap-search snipsnap-index SNMP po...
Netscreen VMware dave Juniper
Network Co... pubkey Why Build From Source? Mythbusters ...
mysql mysql/backup+and+restore Reading BIOS Inf... backup+and+restore

Virtual Dave Megaplex:

(read this note about local search)

Logged in Users: (1)
… and 6 Guests.

Recently Changed

Editing: snipsnap-help, Image Macro

(Et auditum est, et idcirco ego nunc simulare)

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