ubuntu18.04 mysql数据库安装及配置
https://blog.csdn.net/weixx3/article/details/80782479
sql 语句
显示所有数据库
show databases;
显示所有表;
show tables;
显示mysql哪些线程正在运行;
show processlist;
配置远程访问权限;
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘password’; #更新一下用户的密码
update user set host=’%’ where user=‘root’ and host=‘localhost’;
flush privileges;
ubuntu重启数据库mysql
sudo /etc/init.d/mysql restart
如果报密码强度的错 ERROR_LOG(1819)
set global validate_password_policy=0;
set global validate_password_length=4;
ALTER USER ‘root’@’%’ IDENTIFIED BY ‘password’ PASSWORD EXPIRE NEVER;
ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘12345678’;
flush privileges;
sudo /etc/init.d/mysql restart