mysql common problem solving
- 2020-05-06 11:50:23
- OfStack
1
After installing MYSQL, change the password of ROOT and use
net startmysql
I had this problem when I started. Use the following command after
c:\mysql\bin\mysqladmin-u root -p shutdown
No more net start mysql!
*************
2
MySQL 1067 error
Q: my Mysql encountered 1067 error
The error message is:
A system error has occurred.
System error 1067 has occurred.
The process terminated unexpectedly.
A: on my plane the solution is:
Modify %windir%\ my.ini and add
[mysqld]
Set basedir to point to
, the installation path for mysql basedir=D:\Program\Tools\mysql
datadir=D:\Program\Tools\mysql\data
*************
3
It's done!!
It seems so...
mysql_install_db script only need to run the installation for the first time once, don't have to run after, don't know if it the way it is. I put mysql server copy to/etc/rc d/init d /, run chkconfig mysql. server, thus mysql server each start automatically switched on, as long as the set PATH, on the command line input mysql all done!
It seems that the process of groping is really painful ah, it has tortured me for several days...
*************
4
Q: my Mysql encountered 1067 error
The error message is:
A system error has occurred.
System error 1067 has occurred.
The process terminated unexpectedly.
A:
Solution:
1. Check if your Mysql directory gives the system System user permission.
2. Delete your %WINDOWS%/ my.ini file.
3. Check that your c:/ my.cnf file configuration is correct.
*************
5
* MySql
The default installation directory of MySql is c:mysql. After the installation, there is no prompt to say the installation is over. If you need to install to another directory, it is recommended to install to c:mysql first, and then the entire directory move to where you want, for example, after moving to d:mysql , d: mysqlmy-example.cnf (*.cnf) will be registered as SpeedDial in Windows 2000. This cannot be done in explorer. However, this file is a text file format under the UNIX system. It cannot wrap properly in notepad, so you can use write to open editing,
Or open it with write and save it once, then edit it with notepad.) Find the basedir line, remove the "#" comment in front, change the following path to the moved directory (use a slash instead of a backslash for the directory separator), and save as: c: my.cnf
MySql started in service mode, if stopped with net stop mysql , will get an error message, such as
C: > net stop mysql
MySql service is being discontinued.
System error.
System error 1067 .
The process terminated unexpectedly.
MySql service has been stopped successfully.
It doesn't matter. MySql has indeed stopped. But suppose you don't want to see any error messages
If so, stop with the following command:
C: > mysqlbinmysqladmin -u root shutdown
If there is no message, MySql has stopped successfully.
It is important to note that MySql is a database management system based on SQL, although it claims to be easy to install and easy to use. So if you are not proficient in SQL, what can you do with
**************
6
The mysql service could not start the solution
The mysql service could not start
My operating system is win xp
No matter what version of mysql is installed, an error is reported in the middle of starting the mysql service in the administrative tools service local computer could not start mysql service error 1067: process aborted
After seeking advice from many parties, the solution is as follows:
Find the my.ini file in the directory of the system (later verified to be the windows directory), edit the content (if not, create a new one), and at least include the basic configuration of basedir and datadir.
[mysqld]
# set basedir to installation path, e.g., c:/mysql
# is set to MYSQL's installation directory
basedir=D:/www/WebServer/MySQL
# set datadir to location of data directory,
# e.g., c:/mysql/data or d:/mydata/data
# is set to MYSQL's data directory
datadir=D:/www/WebServer/MySQL/data
Also, consider
[WinMySQLadmin]
Server=D:/www/WebServer/MySQL/bin/mysqld-nt.exe
user=root
password=xxxxxxxx
The above is the configuration setting WinMySQLadmin
[Client]
user=root
password=xxxxxxxx
hehe~ solved
**************
7
Just completed Mysql "keyword 1067 error"
I was so depressed that I even failed to think of installing Mysql. The error code was 1067. was installed and uninstalled several times. Here's how I ended up:
Find my.ini in C:\windows and then delete and then start mysql
***************
8
mysql error 1067: process accidentally terminated
This problem has been bothering for a whole morning, very depressed! I've never had a problem with the mysql before, but now I have a problem with the higher version. I have the same problem with the lower version (the most important thing is that the operating system is the same). Starting the mysql service in windows2000 always pops up "error 1067: process unexpectedly terminated"!
I felt that the problem was in the configuration file, so I rewrote my.ini, and it still started with the same effect. At this moment in the eyes of a bright, a senior person's guidance is I suddenly enlightened, your ini files have been placed in the windows directory, I from the personal directory of windows directory, copy it to the system windows directory, start the service, ok!!
After installing MYSQL, change the password of ROOT and use
net startmysql
I had this problem when I started. Use the following command after
c:\mysql\bin\mysqladmin-u root -p shutdown
No more net start mysql!
*************
2
MySQL 1067 error
Q: my Mysql encountered 1067 error
The error message is:
A system error has occurred.
System error 1067 has occurred.
The process terminated unexpectedly.
A: on my plane the solution is:
Modify %windir%\ my.ini and add
[mysqld]
Set basedir to point to
, the installation path for mysql basedir=D:\Program\Tools\mysql
datadir=D:\Program\Tools\mysql\data
*************
3
It's done!!
It seems so...
mysql_install_db script only need to run the installation for the first time once, don't have to run after, don't know if it the way it is. I put mysql server copy to/etc/rc d/init d /, run chkconfig mysql. server, thus mysql server each start automatically switched on, as long as the set PATH, on the command line input mysql all done!
It seems that the process of groping is really painful ah, it has tortured me for several days...
*************
4
Q: my Mysql encountered 1067 error
The error message is:
A system error has occurred.
System error 1067 has occurred.
The process terminated unexpectedly.
A:
Solution:
1. Check if your Mysql directory gives the system System user permission.
2. Delete your %WINDOWS%/ my.ini file.
3. Check that your c:/ my.cnf file configuration is correct.
*************
5
* MySql
The default installation directory of MySql is c:mysql. After the installation, there is no prompt to say the installation is over. If you need to install to another directory, it is recommended to install to c:mysql first, and then the entire directory move to where you want, for example, after moving to d:mysql , d: mysqlmy-example.cnf (*.cnf) will be registered as SpeedDial in Windows 2000. This cannot be done in explorer. However, this file is a text file format under the UNIX system. It cannot wrap properly in notepad, so you can use write to open editing,
Or open it with write and save it once, then edit it with notepad.) Find the basedir line, remove the "#" comment in front, change the following path to the moved directory (use a slash instead of a backslash for the directory separator), and save as: c: my.cnf
MySql started in service mode, if stopped with net stop mysql , will get an error message, such as
C: > net stop mysql
MySql service is being discontinued.
System error.
System error 1067 .
The process terminated unexpectedly.
MySql service has been stopped successfully.
It doesn't matter. MySql has indeed stopped. But suppose you don't want to see any error messages
If so, stop with the following command:
C: > mysqlbinmysqladmin -u root shutdown
If there is no message, MySql has stopped successfully.
It is important to note that MySql is a database management system based on SQL, although it claims to be easy to install and easy to use. So if you are not proficient in SQL, what can you do with
**************
6
The mysql service could not start the solution
The mysql service could not start
My operating system is win xp
No matter what version of mysql is installed, an error is reported in the middle of starting the mysql service in the administrative tools service local computer could not start mysql service error 1067: process aborted
After seeking advice from many parties, the solution is as follows:
Find the my.ini file in the directory of the system (later verified to be the windows directory), edit the content (if not, create a new one), and at least include the basic configuration of basedir and datadir.
[mysqld]
# set basedir to installation path, e.g., c:/mysql
# is set to MYSQL's installation directory
basedir=D:/www/WebServer/MySQL
# set datadir to location of data directory,
# e.g., c:/mysql/data or d:/mydata/data
# is set to MYSQL's data directory
datadir=D:/www/WebServer/MySQL/data
Also, consider
[WinMySQLadmin]
Server=D:/www/WebServer/MySQL/bin/mysqld-nt.exe
user=root
password=xxxxxxxx
The above is the configuration setting WinMySQLadmin
[Client]
user=root
password=xxxxxxxx
hehe~ solved
**************
7
Just completed Mysql "keyword 1067 error"
I was so depressed that I even failed to think of installing Mysql. The error code was 1067. was installed and uninstalled several times. Here's how I ended up:
Find my.ini in C:\windows and then delete and then start mysql
***************
8
mysql error 1067: process accidentally terminated
This problem has been bothering for a whole morning, very depressed! I've never had a problem with the mysql before, but now I have a problem with the higher version. I have the same problem with the lower version (the most important thing is that the operating system is the same). Starting the mysql service in windows2000 always pops up "error 1067: process unexpectedly terminated"!
I felt that the problem was in the configuration file, so I rewrote my.ini, and it still started with the same effect. At this moment in the eyes of a bright, a senior person's guidance is I suddenly enlightened, your ini files have been placed in the windows directory, I from the personal directory of windows directory, copy it to the system windows directory, start the service, ok!!