had previously installed Mysql database on CentOS 6.4 and wanted to upgrade to a newer version so I updated the database. However, after reinstallation, run: service mysqld start to restart the database will always appear with the following prompt:
MySQL Daemon failed to start.
Starting mysqld: [failed]
. If direct input mysql – root – p landing will appear (HY000)/mysql ERROR 2002: Can ‘t connect to local mysql server through socket’/var/lib/mysql/mysql. The sock ‘(2) errors. In general, the MySql server always fails to start. Many of the solutions offered online have not worked. Finally, the solution is as follows:
runs the following command:
rm -fr /var/lib/mysql/* rm /var/lock/subsys/mysqld killall mysqld
service mysqld restart
then run service mysqld start to launch mysql as shown in the figure below:
then run: service mysqld start
/etc/rc. D/init. D/mysqld status p>
view the database state as follows
found that the database is working properly problem solved.
- MySQL uses net start MySQL startup prompt (failed to start, the service did not report any error)
- MySQL error set: failed to start mysql.service : Unit mysql.service is masked.
- Solve net start mysql, start MySQL service, prompt system error 5. Access denied.
- MySQL appears: ERROR 1049 (42000): Unknown database’XXX’ solution
- [mysql] “Failed to start MySQL Server” error resolution
- Initctl: Job failed to start appears when installing VMware-tools
- Solution to the error of installing MySQL install remove of the Service denied
- Solve MySQL installation error: initializing database prompts an error when installing mysql
- Error in installing MySQL devel for CentOS MySQL
- Module not found error: the solution to the problem of no module named ‘MySQL’
- It can’t connect to local MySQL server through socket ‘/ tmp/ mysql.sock ‘(2) “;
- MySQL error — multiple methods of failed to find valid data directory and MySQL setting password appear
- MySQL Workbench: Error Code: 2013. Lost connection to MySQL server during query solution
- MySQL failed to start prompt: job failed to start
- The MySQL service suddenly hangs up with the error message can’t connect to MySQL server on ‘localhost’ (10061)
- django.core.exceptions . improveconfigured: error loading MySQL DB module. Django configuring MySQL database
- MySQL local connection Error 1130_ The solution of MySQL 1130 error report when remote connection through Navicat for MySQL
- MySQL: if the remote connection using navicatip fails, prompt “is not allowed to connect to this MySQL server”
- Golang MySQL error SQL: unknown driver “MySQL” (Forgotten import?) solution
- Solution to error 2002 (HY000) in MySQL login startup