mysql 常用命令

创建库

create database test default character set utf8mb4 collate utf8mb4_general_ci;

创建用户并对 test 库授权

create user test@'%' identified by '123456';
grant all privileges on test.* to test;
flush privileges;

登录

mysql -uroot -p123456
mysql -h xx.xx.xx.xx -utest -p123456 -D test