Learn about SQL Server, Oracle and other large database systems, recently want to learn about the relatively small size of the relatively poor MySQL database. When I used to do some course design, I used SQL Server and Oracle database, and now I think it's a bit of a job. So the dry, first download, this effortless, "mysql-essential-5.1.54-win32.zip" size only 34 MB. The next step is to unzip and start the installation. By the Windows7, the system I used was the normal home Edition. The installation process is smooth, and there are a lot of installation tutorials on the web. After the installation is complete, with the joy of the mood began to practice, from the interface and speed, the effect I am satisfied. In addition, I also installed a navicat for MySQL, so that a lot of user interface, which makes me more satisfied with MySQL. In the next few days of using MySQL, everything was smooth and satisfying. However, the very good, Lao Tzu said: "Queer", tragedy occurred, I really admire him. Talking so much nonsense, now start to get to the point: one day I suddenly want to learn more about Navicat for MySQL what the GUI can do for MySQL, and then double-click Start, the problem at this time with me: 2003-can ' t connect To MySQL server on ' localhost ' (10061).The sudden problem made me have an ominous feeling, there was a hint of uneasiness. From this point of view, there should be no connection with the MySQL service, I do not want to connect, then I go to the MySQL console to connect, but the result is to enter the password, the system issued a ' drop ' of the sound, the error is still: "2003-can" T connect to MySQL Server on ' localhost ' (10061). ", and prompt stay time is very broken, the window automatically closed, until now, I still do not forget, I still have the last move, in fact I have vaguely felt this trick actually also useless. The last trick is to log in from the DOS system MySQL, hey, but the results really as I expected, it is useless! What do we do? Of course you have to solve the problem. To solve the problem, first find out why the problem occurred. But I really do not know why the sudden emergence of this problem, I can provide clues only before I uninstalled two software, is it related to this? Hey, then Baidu Bar. 100 degrees, the answers come out a lot, after finishing, these answers can be broadly divided into two kinds: 1. Modify the My.ini file in the installation directory by modifying the following method: [Mysqld]basedir=c:/program files/mysql/mysql Server 5.1datadir=c:/programdata/mysql/mysql Server 5.1/data (that is, the MySQL installation directory, need to be reminded that my MySQL is installed on the C drive, After loading the data folder is in the Programdata directory, and Programdata this folder is hidden. In other disks, I think this data should not be hidden. ) default-character-server= GBK (or gb2312) [Winmysqladmin]
Server=c:/program Files/mysql/mysql Server 5.1/bin/mysqld-nt.exe But after I have modified the method above, the problem is not resolved.2.MySQL service does not start that seems to be the problem with the MySQL service. So I turned on Computer Management and looked at the list of services, but I didn't find the MySQL service after I looked through them several times. Can't even find the service, how to start it. I first tried to start the MySQL service with the net start MySQL command under DOS, and the prompt was: The service name does not exist. It seems that starting the service is not an easy task. Since the service cannot start, I can only reconfigure the MySQL, so open the MySQL Server Instance Configuration Wizard began to configure, all the way next, after execute, the first two moments completed, When the third start service was available, the problem arose, and the program began to be unresponsive, and that was the result. It seems that the MySQL service does not have a startup problem. Service does not start, what is the best way to do this? Simply pound, reload MySQL bar, can be installed in the end, MySQL service still can't start, I really collapsed. But this time is fortunately in the service list of MySQL, so I can start it personally, not chengxiang, the result of manual startup is the error message: "Windows cannot start the MySQL service (located on the local computer). Error 1067: The process terminated unexpectedly. ”Hey, once again Baidu Bar, after some efforts, a lot of answers is a kind, is to let write the My.ini file, but I modified to change, the problem is still ah. Then I had to look at the system log, open the Event Viewer, and then look at the error that was generated when starting the MySQL service with the following error: Error application name: Mysqld.exe, Version: 0.0.0.0, timestamp: 0x4cf4eb48
Error module Name: Mysqld.exe, Version: 0.0.0.0, timestamp: 0x4cf4eb48
Exception code: 0xc0000005
Error Offset: 0X001F1B20
Error process Id:0x15d4
Error application start time: 0X01CBB6DADC026C15
Error application path: C:\Program files\mysql\mysql Server 5.1\bin\mysqld.exe
Error module path: C:\Program files\mysql\mysql Server 5.1\bin\mysqld.exe
Report ID:2067F9DA-22CE-11E0-BACB-4061866ABBB1 When I modify the My.ini file again, the prompts in the log become:
ERROR: Aborting hint: Can ' t create test file C:\Program files\mysql\mysql Server 5.1\data\kiss-pc.lower-test
Now, when starting the service from DOS, the prompt becomes:
This issue has been resolved, if necessary, please refer to my other blog post:< 1067 error resolution and reflection on MySQL startup under Windows platform >
The MySQL service failed to start (2003-can ' t connect to MySQL server on ' localhost ' (10061).)
