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

This article focuses on "multiple solutions to mysql service 1067 errors". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "multiple solutions to mysql Services 1067 errors".

Today, my mysql server suddenly came out with a 1067 error prompt and could not start normally. Today, I have found a large number of ways to solve the mysql service 1067 error from the Internet. Friends in need can have a look.

My.ini is in the MySQL directory, so I copied a my.ini on my colleague's machine to modify it and put it in a separate place as a backup. Its contents are as follows:

The code is as follows

# Uncomment or Add only the keys that you know how works.

# Read the MySQL Manual for instructions

[mysqld]

Basedir=d:/MySQL5.0/

# bind-address=127.0.0.1

Datadir=d:/MySQL5.0/data

# language=D:/usr/local/mysql/share/your language directory

# slow query log#=

# tmpdir#=

# port=3306

# set-variable=key_buffer=16M

[WinMySQLadmin]

Server=d:/MySQL5.0/bin/mysqld-nt.exe

User=root

Password=

Then under the bin directory

Mysqld-nt-remove

Mysqld-nt-install

Net start mysql

Ok!

It seems that the most crucial problem lies in this my.ini.

I looked at the MySQL service, the service my.ini startup path has long been set, is in the installation directory, there is no need to do it in the directory. Helpless is in the search engine search results, are basically reprinted (good to say called reprint, not good to hear called collection, not good to hear called plagiarism). After many turns, I finally found a different one. The following is the solution:

Modify my.ini

The code is as follows

# The default storage engine that will be used when create new tables when

Default-storage-engine=INNODB

Change "INNODB" to "MYISAM" to:

Default-storage-engine=MYISAM

It is mainly due to the fact that the version used does not support INNODB.

Other reference methods

After installing MYSQL5, it is found that there is an error in startup, sometimes the startup is normal, but there is an error immediately when you add it.

Error code: 1067

The solution is as follows:

1. Delete windows%/my.ini

two。 Delete my.ini elsewhere

3. Copy my-small.ini to my.ini in the installation directory

4. Insert in the last line of my.ini:

[mysqld]

# set the installation path where basedir points to mysql

The code is as follows

Basedir=C:mysql-5.1.11-beta-win32

Datadir=C:mysql-5.1.11-beta-win32data

5. Restart.

The code is as follows

C:mysql-5.1.11-beta-win32bin > net start mysql

The MySQL service is starting.

The MySQL service could not be started.

System error.

A system error 1067 occurred.

The process terminated unexpectedly.

The code is as follows

C:mysql-5.1.11-beta-win32bin > mysqld-nt-- remove

Service successfully removed.

C:mysql-5.1.11-beta-win32bin > mysqld-nt-- install

Service successfully installed.

C:mysql-5.1.11-beta-win32bin > net start mysql

The MySQL service is starting.

The MySQL service has started successfully.

The code is as follows

C:mysql-5.1.11-beta-win32bin > net stop mysql

The MySQL service is stopping..

The MySQL service stopped successfully.

Solution 1: copy a my-***.inf file from the mysql directory to the system's windows directory. Modify the file name to my.inf.

Then add a similar code to the [mysqld] code area:

The code is as follows

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

# set to the installation directory of MYSQL

Basedir=D:/Program Files/mysql-5.0.45-win32

# 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:/Program Files/mysql-5.0.45-win32/data

Solution two mysql 1067

The error is as follows:

1. Execute winmysqladmin to generate my.ini file

2. Mysqld-install starts the mysql service

3. Net start mysql starts mysql service and shows normal.

When connecting through mysql-u root-p, the server is reported to have no startup error. Check the server service. It is true that the mysql service has not been started. Manual startup produces a 1067 error. Mysql has been reinstalled several times, and the error remains the same. Check that there are no errors in each configuration.

My system environment win2003 mysql version 4.0.12.

The solution is to copy the my.ini generated by winmysqladmin to c:windows and then start mysql and everything will be OK.

Look for the my.ini file in the Windows directory. If you do not copy the my-medium.ini in the mysql installation directory as the c:windowsmy.ini restart service, you can

A way to reinstall

Add to the my.ini file in the home directory of mysql

The code is as follows

[WinMySQLServer]

Server=c:Program FilesMySQLMySQL Server 5.0binmysqld-nt.exe

Run under CMD:

C:Program FilesMySQLMySQL Server 5.0binmysqld-nt.exe remove

C:Program FilesMySQLMySQL Server 5.0binmysqld-nt.exe install

Net mysql start

But the parameter is caused by coding.

Adjusting the character set of the server causes a 1067 error

A 1067 error occurs in the following situations:

1. Set the character set of the server and then change the character set of the my.ini server

two。 After setting the character set of the server, use MySQLWorkbench.exe to change the character set of the server in Server Administration

How to solve this problem?

Use

The code is as follows

% MySQLInstallPath%bin/MySQLInstanceConfig.exe

To change the character set, and then restart, in future use, try to use the above program to change the character set

There are a large number of solutions to the errors in mysql Services 1067 described above, and I think your problem will be well solved.

At this point, I believe you have a deeper understanding of "multiple solutions to mysql Services 1067 errors". 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.