Re: all of a sudden can't connect to server..

Leigh Sharpe wrote:
> Mysql.exe is not how you restart the server. That is the client.
> You need to be looking for mysqld.exe.
> Better yet, if your mysql is configured to run as a service, try starting it using 
> 'services' in Administrative tools. If you can't find that, try "net start mysql" 
 > from a command prompt.
> 
> More to the point, however, you need to find out what went wrong. I suspect that installing XAMPP 
> (which apparently indtalls a new instance of mysql) has over-written or otherwise obliterated your 
 > original mysql. I sure hope you backed up your data first.
> You might want to check that your original mysql is still installed, and that XAMPP hasn't damaged it.

Thank you for your response..  this is the situation:  my orig MySQL 
installation, at at C:\Program Files\MySQL\MySQL Server 4.1.. is still 
all there (including data, bin, Docs, share dirs.. I copied data to 
somewhere else in my HD just in case, but it's still all where it always 
was..) in bin dir all executables are there..  in bin dir I run what you 
said, namely 'net start mysql' (I assume I need to run this from bin 
dir) and get this error:

   The service name is invalid.
More help is available by typing NET HELPMSG 2185.

when type net helpmsg 2185 (tried upper and lower case) get error "the 
service name is invalid"

I REALLY need to re-install XAMPP, I really need it for PHP (I 
uninstalled it in the hope that it would fix this problem, but it 
hasn't..)
I just ran 'mysqld.exe' and got no error, got taken back to prompt (do I 
need to type 'exe' here or not, at any rate tried both..)  but still 
can't connect to either console client or from a java class..  I also 
tried safe_mysqld &, which I saw on line, also doesn't work..  oh 
brother..  what on earth is going on here..  (tried changing port to 
3307, but I can't, there's no 'ok' or 'apply' button in 
MySQLInstanceConfig.exe, if I just close dialog after I change port it 
doesn't take, next time go to it it's back to 3306...  ok, again many 
thanks for your help..








>  
> 
> 
> Regards,
>              Leigh
>  
> Leigh Sharpe
> Network Systems Engineer
> Pacific Wireless
> Ph 9584 8966
> Mob 0408 009 502
> email [email protected]
> web www.pacificwireless.com.au
> 
> -----Original Message-----
> From: Frances [mailto:[email protected]] 
> Sent: Thursday, June 08, 2006 1:14 AM
> To: [email protected]
> Subject: all of a sudden can't connect to server..
> 
> 
> I've been using MySQL server (4.1) on my W2k machine for over a year w/no problems, connect from Tomcat and from Java stand-alone classes.. 
> but the other day installed XAMPP (for PHP development, comes w/Apache,
> MySQL) and since then cannot connect at all..  I simply have no idea what's happening here.. I uninstalled XAMPP altogether (so now am back to only my 4.1 installation I've always had..)
> 
> when try to connect directly from DOS shell (mysql -u.. etc.) I get this
> error:
> 
>    ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
> 
> when in DOS shell navigate to c:\....MySQL Server 4.1\bin and try to run mysql.exe (this is how you restart server?) get exact same error..
> 
> am running out of options.. would truly appreciate some suggestions here.. thank you very much..
> 
> Frances
> 
> 
> 
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:    http://lists.mysql.com/[email protected]
> 
> 
> 


-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]