2020-12-29 MySQL基本语句

MySQL登录：
mysql -u root -p
创建新用户：
create user 'blog'@'localhost' identified by 'koM5gTR';
刷新权限：
flush privileges;
直接修改密码：
set password for blog@localhost = password('sz1nQLGY');
alter user blog@localhost identified by 'sz1nQLGY';
间接修改密码：
use mysql;
select host,user,plugin,authentication_string from user;
update user set password=password('sz1nQLGY') where user='blog' and host='localhost';
flush privileges;
创建可从外部访问的MySQL用户并赋予访问权限：
create user 'bingquan'@'%' identified by 'koMaFiZL!8bO';
退出：
exit
MySQL导出SQL文件：
mysqldump -u blog -p blog > blog.sql
mysqldump -u blog -p blog users> blog_users.sql