| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 94134 | 2008-10-15 20:48:00 | MySQL Problems | ubergeek85 (131) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 712521 | 2008-10-18 00:05:00 | When I go to the /bin directory and run mysql.exe it says: ERROR 2003 <HY000>: Can't connect to MySQL server on 'localhost' <10061> As for the webserver, I suppose it doesn't matter what I use. I'll check out those others now. Wrong program - that one is the client. The server is likely to be named 'mysqld.exe', assuming they use the same filenames on both the Linux and Windows versions. What happens when you run the server from the terminal? Note you may need to run it in debug mode to get any useful information. |
Erayd (23) | ||
| 712522 | 2008-10-19 03:05:00 | OK, here's the story now. I can't find a file called mysqld.exe. But there is a file called mysqld-nt.exe. When run, it just sits there for a bit, then exits, with no output whatsoever. Same goes for mysqld-debug.exe. I'm running these in safe mode at the moment too, after just reinstalling it. It seems to me that for some unknown reason, MySQL just won't start, whatsoever. |
ubergeek85 (131) | ||
| 712523 | 2008-10-19 09:29:00 | Mysqld-nt.exe sounds like the one you're after. If you're not getting any output, have you tried starting it with the debug switches? Leave mysql-debug.exe alone at this point - you probably won't need it. When starting mysqld-nt.exe from the terminal, did you remember --standalone? It won't start properly otherwise. Use --console if you want it to log to the screen rather than a logfile. What does the MySQL log say about your problem? I seriously doubt that this is empty. Have you remembered to edit the config files for your environment prior to starting the server? |
Erayd (23) | ||
| 712524 | 2008-10-20 02:23:00 | Hmm, ok, running mysqld-nt.exe --console give a crap load of 0's, then this: ;InnoDB: End of page dump 081020 15:55:35 InnoDB: Page checksum 1575996416, prior-to-4.0.14-form checksum 1371122432 InnoDB: stored checksum 0, prior-to-4.0.14-form stored checksum 0 InnoDB: Page lsn 0 0, low 4 bytes of lsn at page end 0 InnoDB: Page number (if stored to page already) 0, InnoDB: space id (if created with >= MySQL-4.1.1 and stored already) 0 081020 15:55:35 - mysqld got exception 0xc0000005 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=0 read_buffer_size=65536 max_used_connections=0 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 32000 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=00000000 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... 006CDEA6 mysqld-nt.exe!??? The manual page at dev.mysql.com contains information that should help you find out what is causing the crash. c:\Program Files\MySQL\MySQL Server 5.0\bin> Also, since reinstalling it, whenever I turn on my comp, it give me an error saying that mysqld-nt has stopped working. I'm beat. And to top it off, I installed Firebird to get around the MySQL problems, and phpBB can't see it! (Yes, I enables the right extensions in php.ini). Damn these infernal machines! Edit: Also, windows tries to start MySQL as a service with the following command: mysqld-nt --defaults-file="[Long path which I can't be bothered typing here]\my.ini" MySQL5 And I see the clock's gone LHC on us. |
ubergeek85 (131) | ||
| 712525 | 2008-10-20 04:45:00 | Out of curiosity, what is the overall goal you're actually trying to achieve here? Hmm, ok, running mysqld-nt.exe --console give a crap load of 0's, then this:<snip />Is that actually what you ran? If so, you forgot --standalone. Also, since reinstalling it, whenever I turn on my comp, it give me an error saying that mysqld-nt has stopped working. I'm beat. And to top it off, I installed Firebird to get around the MySQL problems, and phpBB can't see it! (Yes, I enables the right extensions in php.ini). Damn these infernal machines!Where, exactly, did you download MySQL from? Edit: Also, windows tries to start MySQL as a service with the following command: mysqld-nt --defaults-file="[Long path which I can't be bothered typing here]\my.ini" MySQL5Irrelevant, unless you forgot to configure it properly - you should be editing my.ini for this. That file is generally well-commented, and should be easy enough to understand. If you have questions about it, feel free to ask here. And I see the clock's gone LHC on us.Blame the ffbm server admins... |
Erayd (23) | ||
| 712526 | 2008-10-20 22:17:00 | Out of curiosity, what is the overall goal you're actually trying to achieve here? Just a sandbox setup really. Is that actually what you ran? If so, you forgot --standalone. running mysqld-nt --console --standalone gives the same thing, and to be sure, I ran it from an admin prompt. Where, exactly, did you download MySQL from? Why, only the official site, www.mysql.com. To be honest, I think I should just give up now. |
ubergeek85 (131) | ||
| 712527 | 2008-10-20 23:50:00 | Try that Microsoft link I posted earlier, and see if you have any luck with that. | somebody (208) | ||
| 1 2 | |||||