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