云服务器安装MySQL设置自启实现远程
设置开机自启:sudo systemctl enable --now mysqld
设置密码:sudo mysql_secure_installation YYYYY
实现远程:use mysql;
update user set host = '%' where user = 'root';
报错:ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY'
不予理会:执行刷新:flush privileges;
sudo systemctl restart mysqld 重启服务