View Single Post
  #10  
Old 02-14-2004, 04:51 AM
Holy_Templar
Fire Beetle
 
Join Date: Jan 2004
Posts: 21
Default

Well after some more trouble shooting for MySQL, I tried these commands in the CMD window:


mysqladmin version
mysqladmin variables
mysqladmin -h `hostname` version variables
mysqladmin -h `hostname` --port=3306 version
mysqladmin -h 'ip for your host' version
mysqladmin --protocol=socket --socket=/tmp/mysql.sock version
telnet localhost 3306

I did them all in that order, and the messages for each are as follows.


Quote:

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Ajantiss>mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to MySQL server on 'localhost' (10061)'
Check that mysqld is running on localhost and that the port is 3306.
You can check this by doing 'telnet localhost 3306'

C:\Documents and Settings\Ajantiss>mysqladmin variables
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to MySQL server on 'localhost' (10061)'
Check that mysqld is running on localhost and that the port is 3306.
You can check this by doing 'telnet localhost 3306'

C:\Documents and Settings\Ajantiss>mysqladmin -h `hostname` version variables
mysqladmin: connect to server at '`hostname`' failed
error: 'Unknown MySQL Server Host '`hostname`' (11001)'
Check that mysqld is running on `hostname` and that the port is 3306.
You can check this by doing 'telnet `hostname` 3306'

C:\Documents and Settings\Ajantiss>mysqladmin -h `hostname` --port=3306 version
mysqladmin: connect to server at '`hostname`' failed
error: 'Unknown MySQL Server Host '`hostname`' (11001)'
Check that mysqld is running on `hostname` and that the port is 3306.
You can check this by doing 'telnet `hostname` 3306'

C:\Documents and Settings\Ajantiss>mysqladmin -h 'ip for your host' version
mysqladmin: connect to server at ''ip' failed
error: 'Unknown MySQL Server Host ''ip' (11001)'
Check that mysqld is running on 'ip and that the port is 3306.
You can check this by doing 'telnet 'ip 3306'

C:\Documents and Settings\Ajantiss>mysqladmin --protocol=socket --socket=/tmp/my
sql.sock version
mysqladmin: ERROR: unknown variable 'protocol=socket'

C:\Documents and Settings\Ajantiss>telnet localhost 3306
Connecting To localhost...Could not open connection to the host, on port 3306.
No connection could be made because the target machine actively refused it.
Any ideas? I really have no idea why the heck this is happening. Before this, my server was up and running near perfectly.
Reply With Quote