From: http://www.mysql.com/doc/en/Can_not_connect_to_server.html
"A MySQL client on Unix can connect to the mysqld server in two different ways: Unix sockets, which connect through a file in the file system (default `/tmp/mysqld.sock') or TCP/IP, which connects through a port number. Unix sockets are faster than TCP/IP but can only be used when connecting to a server on the same computer. Unix sockets are used if you don't specify a hostname or if you specify the special hostname localhost." So it means, from the machine's console. 1. mysql -h localhost -p (means connect to the mysql server through the socket file) 2. mysql -p (means connect to the mysql server through the socket file) 3. mysql -h 127.0.0.1 -p (means connect to the mysql server through the IP Port) 4. mysql -h 192.168.0.1 -p (means connect to the mysql server through the IP Port) 1 & 2 you need privileges like [EMAIL PROTECTED] 3 you need privileges like [EMAIL PROTECTED] or [EMAIL PROTECTED] 4 you need privileges like [EMAIL PROTECTED] or [EMAIL PROTECTED] Hope this helps Roger > -----Original Message----- > From: Jim McAtee [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 08, 2003 9:27 PM > To: Roger Davis; [EMAIL PROTECTED] > Subject: Re: [EMAIL PROTECTED] > > > Roger Davis wrote: > > > localhost does not mean 127.0.0.1 Localhost is the socket to > connect to and > > has is separate from IP addresses. > > Does this mean from the machine's console, or something else? > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.497 / Virus Database: 296 - Release Date: 7/4/2003 > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.497 / Virus Database: 296 - Release Date: 7/4/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
