After the installation of mysql5.7 physical machine, modify the binlog log in my.cnf, restart mysql, log in and connect to MySQL with the client of the machine, and report error 2000 (HY000): unknown MySQL error. This error will also be reported when mysqldump exports data of all tables,
solve:
1. When using systemctl restart mysqld, you can’t connect by using Navicat, but after using systemctl stop mysqld, you can connect by using systemctl start mysqld, but you still can’t export data by using mysqldump connection.
2. Directly back up the data file on MySQL, and then use docker to install mysql5.7, copy the data file to/var/lib/MySQL, a permission error will be reported, and then change the permission to chown mysql:mysql datadir Can be used normally, user name root password root
reference resources: https://dba.stackexchange.com/questions/91712/whats-causing-this-error-2000-hy000-unknown-mysql-error
Read More:
- ERROR 2005 (HY000): Unknown MySQL server host
- Solve MySQL error 2002 (HY000)
- Solution to error 2002 (HY000) in MySQL
- Error 2003 (HY000): can’t connect to MySQL server on ‘localhost’ (10061)
- Solution to error 2002 (HY000) in MySQL login startup
- Error 2005 (HY000) unkonw MySQL server host…
- Mysql start slave error 1201 (HY000)
- Golang MySQL error SQL: unknown driver “MySQL” (Forgotten import?) solution
- ERROR 2002 (HY000): Can’t connect to MySQL server on ‘localhost’ (10061)
- [MySQL] error 1396 (HY000): Operation create user failed for ‘MySQL’ @’localhost ‘
- Linux-mysql8.0 password reset problem – error 1396 (HY000): Operation alter user failed for ‘root’ @’localhost ‘
- SQL exception handling – MySQL error 1005 (HY000): can’t create table ‘TMP’ (errno: 13)
- MYSQL:ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
- MySQL error 1205 (HY000): lock wait timeout exceeded; try restarting transaction
- mysql load data infile ERROR 13 (HY000): Can’t get stat of
- MySQL error: error 1010 (HY000) when deleting database
- About error 1005 (HY000) in MySQL: can’t create table ‘_______ ‘(errno: 150) fool’s plan
- ERROR 1820 (HY000): Unknown error 1820,ERROR 1046 (3D000):
- MySQL appears: ERROR 1049 (42000): Unknown database’XXX’ solution
- MySQL error 1054 (42s22) unknown column ‘password’ in ‘field list’