Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to solve the 1067 error in MySQL". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how to solve the 1067 error in MySQL.

Content:

*************

one

After changing the password of ROOT after installing MYSQL, use the

Net startmysql

I encountered this problem when I started. After using the following command

C:\ mysql\ bin\ mysqladmin-u root-p shutdown

There will be no such error prompt in net start mysql!

*************

two

1067 error of MySQL

Q: my Mysql encountered a 1067 error

The error message is:

A system error has occurred.

System error 1067 has occurred.

The process terminated unexpectedly.

A: the solution on my plane is:

Modify% windir%\ my.ini to add

[mysqld]

# set the installation path where basedir points to mysql

Basedir=D:\ Program\ Tools\ mysql

Datadir=D:\ Program\ Tools\ mysql\ data

*************

three

It's done!

It seems to be so...

The mysql_install_db script only needs to be run once during the initial installation, and then you don't have to run it again. I don't know if that's the case. I copy mysql.server to / etc/rc.d/init.d/, run chkconfig mysql.server, and every time the mysql server starts up, as long as you set up PATH, type mysql on the command line and everything is done!

It seems that the process of groping is really painful, which has been torturing me for several days.

*************

four

Q: my Mysql encountered a 1067 error

The error message is:

A system error has occurred.

System error 1067 has occurred.

The process terminated unexpectedly.

A:

Solution:

1. Check that your Mysql directory gives System permissions to the system.

two。 Delete your% WINDOWS%/my.ini file.

3. Check that your c:/my.cnf file is configured correctly.

*************

five

[☆☆☆ MySql Overview ☆☆☆]

The default installation directory for MySql is c:mysql. After the installation is finished, there is no indication that the installation is over. Please click the Finish button and exit directly. If you need to install to another directory, it is recommended to install to c:mysql first, and then move the entire directory to the place you want. 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 Explorer. Use the command line to start notepad editing, such as running notepadd:mysqlmy- example.cnf. But this file is a text file format under UNIX system and cannot be wrapped correctly in notepad. You can use write to open and edit it.

Or open it with write and save it once, and then use notepad to edit it. Find the basedir line, remove the preceding "#" comment, change the trailing path to the moved directory (directory delimiters should be slashed instead of backslashes), and save as: c:my.cnf

If a MySql started in service mode is stopped with net stop mysql, it will get an error message, such as:

C: > net stop mysql

The MySql service is stopping.

System error.

A 1067 error occurred on the system.

The process terminated unexpectedly.

The MySql service stopped successfully.

It doesn't matter. MySql has really stopped. But if you don't want to see any error messages,

If so, you can stop it with the following command:

C: > mysqlbinmysqladmin-u root shutdown

If there is no prompt, MySql has stopped successfully.

It should be noted that although MySql claims to be easy to install and easy to use, it is, after all, a database management system based on SQL, so I'm afraid you can't do anything with it if you're not proficient in SQL.

**************

six

The solution to the failure to start the mysql service

The mysql service could not be started

My operating system is win xp

No matter what version of mysql is installed, an error will be reported halfway when starting the mysql service in the service of the administrative tools

The content is: unable to start the mysql service on the local computer error 1067: process aborted unexpectedly

After seeking advice from many parties, the solution is as follows

Find the my.ini file in the system (later verified to be a directory) directory, edit the contents (if not, create a new one), and include at least the two basic configurations of basedir,datadir.

[d]

# set basedir to installation path, e.g., c:/mysql

# set to the installation directory of MYSQL

Basedir=D:/www/WebServer/MySQL

# set datadir to location of data directory

# e.g., c:/mysql/data or d:/mydata/data

# set to the data directory of MYSQL

Datadir=D:/www/WebServer/MySQL/data

Besides, you need an idea.

[WinMySQLadmin]

Server=D:/www/WebServer/MySQL/bin/mysqld-nt.exe

User=root

Password=xxxxxxxx

# above are the configurations for setting WinMySQLadmin

[Client]

User=root

Password=xxxxxxxx

Hehe~ solved

**************

seven

Just got Mysql "keyword 1067 error".

Quite depressed, unexpectedly did not expect to install a Mysql will also make an error, the error code is 1067 installation uninstalled several times, but not, and some disabled services are turned on, but still not. In the end, I solved it like this:

Find my.ini in C:\ windows, delete it, and then launch the winmysqladmin.exe interface to configure mysql, save my.ini and start mysql.

***************

eight

Mysql error 1067: process terminated unexpectedly

This problem has been bothering me all morning, and it is very depressing! I have never encountered it when installing mysql before, but now there is a problem with this high version. I have the same problem with the lower version I installed (the most important thing is that the operating system is the same). Start the mysql service in windows2000's service but always pop up "error 1067: process terminated unexpectedly"!

I felt that the problem was in the configuration file, so I rewrote my.ini, and the startup effect was the same. I looked for fruitless, crash status on google! Right in front of my eyes, a master pointed out that I suddenly enlightened whether your ini file was put in the windows directory. I copied it to the system windows directory from the windows directory of the personal directory, and started the service.

-personal experience-

Today, I encountered this error, mainly because I installed a software, which installed another mysql on its own initiative, and pointed the service to a new mysql. I deleted that service, modified the mysql path in mysqladmin, and then reinstalled the service. But starting the service always reported an error: 1067! Delete my.ini and restart mysqladmin, then enter the user name and password-it's OK!

Summary: the above is the information collected from the Internet, it is very strange, delete the service, registry, and other mysql-related information, and then reinstall mysql is still not enough, finally see a piece of information on the Internet, as follows:

1. Open the my.ini file, find the line default-storage-engine=InnoDB, and change it to default-storage-engine=MyISAM.

2. Delete from the Data directory under the MySQL installation directory

Ib_logfile0

Ib_logfile1

three. Find the InfoDB directory specified when configuring the MySQL server and delete it

Ibdata1

four. Restart Service for MySQL

Extracted from: http://wenwen.soso.com/z/q131788276.htm

When you open the my.ini file, find the line default-storage-engine=InnoDB, and change it to default-storage-engine=MyISAM, execute the command "net start mysql" to indicate that the mysql service started successfully.

At this point, I believe you have a deeper understanding of "how to solve the 1067 error in MySQL". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.