MySQL1067 collection of error solutions _ MySQL

MySQL1067 collection of error solutions bitsCN.com

1

After installing MYSQL, change the ROOT password and use
Net startmysql
I encountered this problem at startup.
C:/mysql/bin/mysqladmin-u root-p shutdown
Net start mysql does not have this error prompt!

*************
2
MySQL error 1067

Q: I encountered a 1067 error in Mysql.

Error message:
A system error has occurred.
System error 1067 has occurred.
The process terminated unexpectedly.

A: The solution on my machine is:
Modify % windir %/my. ini and add
[Mysqld]
# Set basedir to the mysql installation path
Basedir = D:/Program/Tools/mysql
Datadir = D:/Program/Tools/mysql/data

*************
3
It's done !!!
It seems like this ......
The mysql_install_db script only needs to be run once during the initial installation, and does not need to be run any more. I set mysql. server copy to/etc/rc. d/init. d/, run chkconfig mysql. the mysql server starts automatically every time it starts up. you only need to set the PATH and enter mysql on the command line!
It seems that the process of exploration is really painful. it has been suffering me for several days ......

*************
4

Q: I encountered a 1067 error in Mysql.

Error message:

A system error has occurred.
System error 1067 has occurred.
The process terminated unexpectedly.

A:
Solution:

1. check whether your Mysql Directory has the System user permission.
2. delete your % WINDOWS %/my. ini file.
3. check whether your c:/my. cnf file is correctly configured.

*************
5

[☆☆☆Mysql summary ☆☆☆]
The default installation directory of MySql is c: mysql. after the installation is complete, there is no message indicating that the installation is complete. click the Finish button and then exit. If you want to install it in another directory, we recommend that you first install it in c: mysql, and then move the entire directory to the desired place. for example, after moving to d: mysql, you need to edit d: mysqlmy-example.cnf (*. cnf files will be registered as SpeedDial files in Windows 2000 and cannot be operated in the resource manager. use the command line to start notepad editing, such as running notepadd: mysqlmy-example.cnf, however, this file is in the format of a text file in the UNIX system. you can use write to open and edit the file because it cannot be entered correctly in notepad,
Or use write to open and save it once, and then use notepad to edit it .) Find the basedir line, remove the comment "#", change the path to the moved Directory (the directory separator should use a slash instead of a backslash), and save it as: c: my. cnf
If a MySql instance started in service mode is stopped using net stop mysql, an error message is displayed, for example:
C:> net stop mysql
The MySql service is stopping.
System error.
The system has a 1067 error.
The process stops unexpectedly.
The MySql service has been stopped successfully.
This does not matter. MySql has indeed stopped. However, if you do not want to see any error messages
You can use the following command to stop:
C:> mysqlbinmysqladmin-u root shutdown
If no message is displayed, MySql has been stopped successfully.
It should be noted that although MySql is known to be simple to install and easy to use, it is an SQL-based database management system after all. if it is not very proficient in SQL, I am afraid it cannot be used for anything.

**************
6

Solution to mysql service failure
Mysql service cannot be started

My operating system is win xp
No matter what version of mysql is installed, an error will be reported midway through the mysql service started in the management tool.
Content: unable to start mysql service on local computer error 1067: process aborted unexpectedly

The solution is as follows:

Find my. ini file, edit the content (if the file does not exist, create a new one), including at least two basic configurations: basedir and datadir.
[Mysqld]
# Set basedir to installation path, e.g., c:/mysql
# Set it to the MYSQL installation directory
Basedir = D:/www/WebServer/MySQL
# Set datadir to location of data directory,
# E.g., c:/mysql/data or d:/mydata/data
# Set it to the MYSQL data directory
Datadir = D:/www/WebServer/MySQL/data

In addition, you need an idea
[WinMySQLadmin]
Server = D:/www/WebServer/MySQL/bin/mysqld-nt.exe
User = root
Password = xxxxxxxx
# The above is the configuration for setting WinMySQLadmin
[Client]
User = root
Password = xxxxxxxx

Hehe ~ Solved

**************
7
Just completed Mysql "keyword 1067 error 』
When I was depressed, I didn't even think that an error would occur when I installed Mysql. the error code was 1067 installation and uninstalling several times, but I couldn't, and I turned on some disabled services, but it still does not work. Finally, I solved the problem as follows:

Find my. ini in C:/windows and delete it. Then, start winmysqladmin.exe to configure mysql. Save my. ini and start mysql.

***************
8
Mysql error 1067: Unexpected process termination
This problem plagued the morning and was very depressing! I have never encountered mysql before, but now there is a problem with Zhuang's high version, the problem is the same for the earlier versions I installed (the most important thing is that the operating system is the same ). When mysql is started in Windows 1067, "error: Unexpected process termination" is always displayed "!

I felt the problem was in the configuration file, so I re-wrote my. ini, and the startup was still the same. I searched for failure on google and crashed! At this point, I was very surprised to see whether your INI file was stored in the windows directory, copy it to the windows directory and start the service. OK !!!

Author: Jerry"

BitsCN.com