18 messages in com.mysql.lists.win32Re: all of a sudden can't connect to ...| From | Sent On | Attachments |
|---|---|---|
| Frances | 07 Jun 2006 08:13 | |
| Januski, Ken | 07 Jun 2006 09:00 | |
| Leigh Sharpe | 07 Jun 2006 16:21 | |
| Frances | 07 Jun 2006 19:42 | |
| Tobin Cataldo | 08 Jun 2006 05:59 | |
| Frances | 08 Jun 2006 10:06 | |
| Tobin Cataldo | 08 Jun 2006 10:20 | |
| Frances | 08 Jun 2006 10:28 | |
| Daniel da Veiga | 08 Jun 2006 12:55 | |
| Frances | 08 Jun 2006 13:13 | |
| Randy Clamons | 08 Jun 2006 13:31 | |
| Frances | 08 Jun 2006 14:25 | |
| Frances | 08 Jun 2006 18:01 | |
| Daniel da Veiga | 08 Jun 2006 18:25 | |
| Markus Grossrieder | 09 Jun 2006 05:11 | |
| Frances | 09 Jun 2006 05:54 | |
| Daniel da Veiga | 09 Jun 2006 06:57 | |
| Frances | 09 Jun 2006 07:23 |
| Subject: | Re: all of a sudden can't connect to server.. |
|---|---|
| From: | Markus Grossrieder (mark...@alba-systems.com) |
| Date: | 06/09/2006 05:11:34 AM |
| List: | com.mysql.lists.win32 |
From: "Frances" <fdr...@yahoo.com> To: <win...@lists.mysql.com> Sent: Thursday, June 08, 2006 7:29 PM Subject: Re: all of a sudden can't connect to server..
what's event viewer? (searched google for error 1067, so opened .err file, this is what is says (at the bottom, long file):
060607 22:37:33 [Note] mysqld: Shutdown complete
InnoDB: Error: log file .\ib_logfile0 is of different size 0 10485760 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 060607 22:47:57 [ERROR] Can't init databases 060607 22:47:57 [ERROR] Aborting
060607 22:47:57 [Note] mysqld.exe: Shutdown complete
(someone in a MySQL.com forum is also helping me, he suggested changing this var in my.ini innodb_log_file_size to 20M, which I did, tried again
Try 10 MB ... Default is 5 MB (hence the "specified in the .cnf file 0 5242880 bytes!")
Hope I'm not too late...
Regards, Markus
to restart, same error.. (maybe need to restart machine? you know, this is all very weird, I never had MySQL server installed as a service (I think), yet never had to turn it on, never had to do anything or worry about it in any way, db's were always accessible to me with no problems..)
Tobin Cataldo wrote:
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 lsha...@pacificwireless.com.au web www.pacificwireless.com.au
-----Original Message----- From: Frances [mailto:fdr...@yahoo.com] Sent: Thursday, June 08, 2006 1:14 AM To: win...@lists.mysql.com 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