Mysql troubleshooting page 1/2

Source: Internet
Author: User
I saw a good solution to common mysql errors on the Internet.

I saw a good solution to common mysql errors on the Internet.

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. d/, 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 (*. cnf files will be registered as SpeedDial files in Windows 2000 and cannot be operated in the resource manager. Use the command line to start notepad editing, such as running notepadd: mysqlmy-example.cnf, however, this file is in the format of a text file in the UNIX system. You can use write to open and edit the file because it cannot be entered correctly in notepad,
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

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.