//Case

2021-04-21T04:35:43.060338Z 0 [ERROR] Fatal error: Can’t open and lock privilegetables: Table ‘mysql.user’ doesn’t exist2021-04-21T04:35:43.061239Z 0 [ERROR] Fatal error: Failed to initialize ACL/grant/time zones structures or failed to remove temporary

在/etc/my.cnf文件中加入一行:lower_case_table_names=1  注意,一定要写在中间​[root@localhost ~]# vi /etc/my.cnf[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockuser=mysql# Disabling symbo

#授权db_1库只能用远程ip192.168.3.253的test用户访问grant all privileges on db_1.* to test@'192.168.3.253' identified by '123456';flush privileges;

select sha(123456);select sha1(123456);select sha2(123456,3);select md5(123456);select aes_encrypt('columnName', 'myKey');select aes_decrypt(aes_encrypt('columnName', 'myKey'),'myKey');SELECT ENCOD