There are 5 solutions as follows, I generally use the first one to solve the problem, and the other online searches are organized as follows for reference
1. Kill the existing mysql process
ps -ef | grep mysqld kill -9 xxx
2. Insufficient mysql file permissions
chown -R mysql:mysql /mnt/mysql chmod -R 755 /mnt/mysql /etc/init.d/mysqld restart
3. When mysql is installed for the second time, there is residual data that affects the service startup
Delete the mysql-bin.index file in the /mysql_data directory
4. View the configuration file my.cnf
[[email protected] mysql]# cat /etc/ my.cnf [mysqld] user = mysql basedir =/mnt/ mysql datadir =/mnt/ mysql_data #Check if there is this line socket =/tmp/ mysql.sock server_id = 6 port = 3306 [mysql] socket =/tmp/mysql.sock
5. Turn off selinux
[[email protected] mysql]# cat /etc/selinux/config # This file controls the state of SELinux on the system. # SELINUX= can take one of these three values: # enforcing - SELinux security policy is enforced. # permissive - SELinux prints warnings instead of enforcing. # disabled - No SELinux policy is loaded. SELINUX=disabled # SELINUXTYPE= can take one of three two values: # targeted - Targeted processes are protected, # minimum - Modification of targeted policy. Only selected processes are protected. # mls - Multi Level Security protection. SELINUXTYPE=targeted
Read More:
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’
- How to Solve can‘t connect to local mysql server through socket ‘/var/lib/mysql/mysql.sock‘
- After installing mysql5.7 on centos7, an error 1045 (28000) is reported: access denied for user ‘root’ @’localhost ‘(using PAS)
- Failed to load file or assembly MySql.Web Solution
- linux mysql ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
- How to Fix MySQL ERROR 1130 (HY000): Host ‘XXXX’ is not allowed to connect to this MySQL server
- Solve ERROR 1136 (21S01) in Mysql: Column count doesn’t match value count at row 1
- Ubuntu ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
- The setobject() method reports an error. The parameter index out of range and MySQL syntax error exception report an error
- mysql ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executin
- Error 1406 (22001) in MySQL: data too long for column (Fixed)
- (Fixed) workbench MySQL Error Code: 2013. Lost connection to MySQL server during query
- Mybatis Error: The server time zone value ‘����1532a0’ is unrecognized
- MYSQL Error 1045 (28000): access denied for user ‘root’ @’localhost ‘(using password: Yes)
- [How to Fix] Database can’t open file (errno:24)
- MySQL 8.0 error 1114 (HY000): the table’sbtest1’is full (Fixed)
- ERROR 1054(42S22) Unknown column ‘password’ in ‘field list’ (Fixed)
- Docker mysql8 modify password
- DVWA Uncaught Error: Call to undefined function mysql_connect() in /Applications/XAMPP/xampp