Re: all of a sudden can't connect to server..
Tobin Cataldo <[email protected]>
| Newsgroups | gmane.comp.db.mysql.windows |
|---|---|
| Message-ID | <[email protected]> |
And what does the event viewer say? Frances wrote: > > Tobin, thank you very much for your response.. last night finally > managed to run this successfully: mysqld-nt --install > (which I got from here, http://coronet.iicm.edu/mysql/start.html) > > then, when went to services, saw MySQL there, but when went to start > it got following error: > > could not start the MySQL service on Local Computer. > Error 1067: the process terminated unexpectedly. > > (tried again today, after rebooting machine, same thing..) > > to answer your question re path to executable: > > "C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt" MySQL > > (yes it's pointing to bin of my installation, in other words..) > > (check regkey? would need more info here, have never done anything to > registry, regkeys.. but well, hopefully won't come to that, since > path does seem to point to right location..) again many thanks for yr > help.. I really need to fix this.. can't understand what's gone wrong > here all of a sudden after having used MySQL server on my machine for > over a year now... > > > > Tobin Cataldo wrote: >> 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]