Re: all of a sudden can't connect to server..
Tobin Cataldo <[email protected]>
| Newsgroups | gmane.comp.db.mysql.windows |
|---|---|
| Message-ID | <[email protected]> |
Have you checked the services panel in admin tools? Is there a service called mysql? If not you need to install a service "http://dev.mysql.com/doc/refman/5.0/en/windows-start-service.html". When you look at the properties of the of an existing service where is the Path to executable pointing? Is it pointing at the bin of your mysql installation? If not you need either to delete the service and reinstall or change the path to executable. Check your regkey: HKEY_LOCAL_MACHINE.SYSTEM.CurrentControlSet.Services.MySQL Can you start an existing service that is pointing at your valid MySQL/bin directory? If not, check the event viewer. If the database isn't running you won't be able to call mysql from command line or connect from a java class. Tobin Frances wrote: > 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]