Solution to MySQL 1067 errors

Source: Internet
Author: User

 

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 is
It only needs to be run once during the initial installation, and then it does not need to be run any more. I wonder if this is the case. I set MySQL. server copy to/etc/rc. d/init. d/medium, run
Line chkconfig mysql. server. At this point, every time the MySQL server is automatically started upon startup, you only need to set the path and enter MySQL on the command line, everything is done!

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. Please
Click the finish button to 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, move
D: MySQL, You need to edit D: mysqlmy-example.cnf (*. CNF files will be registered
The speeddial file 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 in the format of a text file 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 』

I was depressed. I didn't even think that an error would occur when installing MySQL.CodeIt is because 1067 has been installed and uninstalled several times, that is, it won't work, and some Disabled Services have been turned on, but it still won't 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 used
I have never encountered MySQL installation 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 ). In
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 moment, a high person's finger
The point is that I am suddenly enlightened. Have you put your INI file under the Windows directory? I copy it from the Windows directory of my directory to the Windows directory of the system and start the server?
OK !!!

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

Today, I encountered this error. I installed a software, installed a MySQL, and directed the service to the new MySQL.
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 deleting my. ini, restart mysqladmin and then
Enter the username and password-it's OK!

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.