Solution to MySQL 1067 error _ MySQL

MySQL 1067 error solution: bitsCN.com

Content:
*************
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. 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 (*. the cnf file is registered as a SpeedDial file in Windows 2000 and cannot be operated in the resource manager. use the command line to start notepad Editing. for example, run notepadd: mysqlmy-example. cnf, but this file is a text file format in UNIX systems. it cannot be entered correctly in notepad. you can use write to open and edit the file,
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 put under the windows directory. from the windows directory of my Directory, copy it to the windows directory and start the service. OK !!!

----- Personal experience ------

Today, I encountered this error. I installed a software, installed another mysql, and directed the service to the new mysql. I deleted the service, in mysqladmin, the mysql path is modified and the service is re-installed. However, when the service is started, the error 1067 is always reported! After my. ini is deleted, restart mysqladmin and enter the username and password-it turns out OK!

 

Summary:The above information is collected from the internet. it is strange that I deleted the service, registry, and other mysql-related information. I still cannot reinstall mysql. Finally, I can see the information on the Internet, as shown below:

 

1. open the my. ini file, find the line default-storage-engine = InnoDB, and change it to default-storage-engine = MyISAM.
2. delete
Ib_logfile0
Ib_logfile1
3. Find the specified InfoDB directory when configuring the MySQL server and delete it.
Ibdata1
4. Restart MySQL Service

 

From: http://wenwen.soso.com/z/q131788276.htm

After "open the my. ini file, find the line default-storage-engine = InnoDB, change it to default-storage-engine = MyISAM", and then execute the command"Net start mysql", Prompting mysql service to start successfully...

Ah, I finally succeeded... Why cannot the default storage engine be "InnoDB? Depressed...

Here is the sweetest happiness, the greatest effort, the most profound betrayal, the strongest despair, the most brave and strong, and the most powerful counterattack! Standing outside of the right and wrong, watching the red dust is the most beautiful, but the moon is pure brightness, flowers and clusters! Note: In this era of moral loss, if you want to abandon your vow and turn around easily, you don't have to look back, because no one is waiting for you!

BitsCN.com