connecting to remote server using mysql command

famms · 06-07-2010, 09:23 PM

hi I am fresh out the box to linux I am using mysql for the 1st time also, my question is what is the correct command to run on a mysql command line to connect to remote server.

famms · 06-07-2010, 09:24 PM

does anyone know the correct command to run on mysql command line to connect to a remote server???

jstephens84 · 06-08-2010, 12:07 AM

Quote:

Originally Posted by famms

does anyone know the correct command to run on mysql command line to connect to a remote server???

use the -h or --host argument.

theNbomr · 06-08-2010, 12:56 AM

Your first lesson is about man. It is short for manual (in Unix, everything is shortened). You use it to find out about commands:

Code:

man mysql

It will tell you, at minimum, what commandline arguments it knows/uses. Often lots more interesting stuff.
Use the man pages whenever you know a command, and don't know all about how to use it.
--- rod.

arashi256 · 06-08-2010, 01:49 AM

Code:

mysql -h <host ip address> -u<user> -p<password>

chrism01 · 06-08-2010, 01:53 AM

... and you'll find this useful http://dev.mysql.com/doc/refman/5.0/en/ in the long run.