MySQL Tutorial: 1067 Error resolution

Source: Internet
Author: User
Tags error code ini mysql tutorial

1

After installing MySQL, change the root password and use

NET Startmysql

I ran into this problem when I started. After using the following command

C:mysqlbinmysqladmin-u root-p shutdown

Again net start MySQL does not have this error hint!

2

MySQL's 1067 error

Q: My MySQL ran into 1067 errors

The error message is:

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, increase

[Mysqld]

#设置basedir指向mysql的安装路径

Basedir=d:programtoolsmysql

Datadir=d:programtoolsmysqldata

3

It's ready!!!

It's like this ...

The mysql_install_db script only needs to run once during the initial installation, and then it doesn't have to run anymore, and I don't know if that's the case. I'm going to copy Mysql.server to/etc/rc.d/init.d/and run Chkconfig Mysql.server, so that the MySQL server automatically start every time, as long as you set the path, on the command line to enter MySQL on everything to fix!

It seems that the groping process is really painful ah, this has tortured me for several days ...

4

Q: My MySQL ran into 1067 errors

The error message is:

A system error has occurred.

System error 1067 has occurred.

The process terminated unexpectedly.

Answer: The solution:

1. Check your MySQL directory for system user privileges.

2. Delete your%windows%/my.ini file.

3. Check that your C:/MY.CNF file is configured correctly.

5

"☆☆☆mysql Outline ☆☆☆"

MySQL's default installation directory is C:mysql, after the installation of the end without any hint that the installation is over, please click the Finish button and so on, directly out of the. If you need to install to a different directory, it is recommended that you first install to C:mysql, and then move the entire directory to where you want, for example, after moving to D:mysql, you need to edit d:mysqlmy-example.cnf (*.cnf files in Windows 2000 will be registered as a SpeedDial file, unable to operate in the explorer, to start Notepad editing with the command line, such as running NOTEPADD:MYSQLMY-EXAMPLE.CNF, but this file is a text file format under the UNIX system. In Notepad, you can't wrap the line correctly, you can open the edit with write,

or save it once with write open, then use Notepad to edit it. Locate the Basedir row, remove the previous "#" comment, change the following path to the moved directory (the directory delimiter should be slash instead of backslash), and save as: c:my.cnf

MySQL started with service if you stop with net stop MySQL, you get an error message, such as:

C:>net stop MySQL

The MYSQL service is stopping.

System error.

The system has 1067 errors.

The process terminated unexpectedly.

The MYSQL service has stopped successfully.

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

, you can use the following command to stop:

C:>mysqlbinmysqladmin-u Root shutdown

If there is no hint, MySQL has successfully stopped.

What needs to be said is that MySQL, although known as simple installation, easy to use, but this is based on SQL database management system, so if not very proficient in SQL, I'm afraid I can not take it to do what

6

Workaround for MySQL service not to start

MySQL Service failed to start

My operating system is win XP

No matter what version of MySQL is installed, the MySQL service starts in the service of the Admin tool and the error occurs halfway through.

Content is: Unable to start MySQL service on local computer error 1067: Process aborted unexpectedly

After a variety of advice, we have to solve the following methods

Look for the My.ini file in the system (which later verifies that it should be the Windows directory), edit the content (create a new one if there is no file), and include at least basedir,datadir two basic configurations.

[Mysqld]

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

# set to 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 to MySQL data directory

Datadir=d:/www/webserver/mysql/data

In addition, the idea

[Winmysqladmin]

Server=d:/www/webserver/mysql/bin/mysqld-nt.exe

User=root

Password=xxxxxxxx

#以上是设置WinMySQLadmin的配置

[Client]

User=root

Password=xxxxxxxx

hehe~ solved it.

7

Just finished MySQL "keyword 1067 error"

More depressed, unexpectedly did not think of installing a MySQL will also error, error code is 1067 loading and unloading several times, is not, and some disabled services are open, but still not. In the end, I solved it this way:

Find a My.ini in the c:windows. Then delete and then start Winmysqladmin.exe interface configuration MySQL, save My.ini can start MySQL try hehe

8

MySQL Error 1067: Process terminated unexpectedly

This problem bothered me for a morning, very depressed! I have never encountered in the installation of MySQL, but now Zhuang this high version of the problem, I changed the lower version of my installed or the same problem (the most critical is the operating system is the same). Start the MySQL service in the Windows2000 service but always pops up "error 1067: Process terminated unexpectedly"!

I feel the problem in the configuration file, so I wrote My.ini, start or the same effect, I find no fruit on Google, crash State! At this moment, a bright, an expert's advice is I suddenly enlightened, your INI file has been placed in the Windows directory, I'll copy it to the system Windows directory from my personal directory's Windows directory, start the service, OK!!!

        Note : More wonderful articles please pay attention to the triple programming Tutorial column.

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.