--character-set-server: 'utf8' is currently an alias for the character set UTF8MB3
--character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release.
Please consider using UTF8MB4 in order to be unambiguous.
解决
将my.ini中的utf8改为UTF8MB4
mysql-bin.index' not found (OS errno 13 - Permission denied)
mysqld: File '/u01/my3306/mysql/mysql-bin.index' not found (OS errno 13 - Permission denied)
解决
chown -R mysql:mysql /u01/my3306/mysql/
The innodb_system data file 'ibdata1' was not found but one of the other data files 'ibdata1' exists.
[root@taishan-atlas mysql]# ls
ib_buffer_pool ib_logfile0 ib_logfile1 ib_logfile2 ib_logfile3 ibdata1 ibdata2 lizard.ibd mysql-bin.000001 mysql-bin.index
删除/u01/my3306/mysql目录下的所有文件
You are not allowed to create a user with GRANT
mysql> use mysql;
Database changed
mysql> update user set host='%' where user='root';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> grant all privileges on *.* to 'root'@'%' with grant option;
ERROR 1410 (42000): You are not allowed to create a user with GRANT
mysql> grant all privileges on *.* to 'root'@'%' with grant option;
Query OK, 0 rows affected (0.04 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.02 sec)
有意思的是下面语句需要执行两次,MySQL版本8.0.19
mysql> GRANT ALL PRIVILEGES ON . TO 'root'@'%';
You must reset your password using ALTER USER statement before executing this statement
修改密码
mysql> alter user user() identified by ‘admin@123456’;
Query OK, 0 rows affected (0.03 sec)
mysql>flush privileges ;
Query OK, 0 rows affected (0.01 sec)
授权远程访问
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'admin@123456' WITH GRANT OPTION;
mysql>flush privileges ;
Query OK, 0 rows affected (0.01 sec)
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;