MySQL创建数据库和用户

1.登录mysql(默认账号root,密码为空)
mysql -h localhost -u root -p

2.创建数据库db_mysql
mysql>create database db_mysql;

3.创建用户admin_mysql

mysql>create user 'admin_mysql'@'%' identified by '123456';

4.授予用户拥有数据库db_mysql的所有权限,允许用户远程登录
mysql>grant all privileges on db_mysql.* to admin_mysql@'%';

5.刷新权限
mysql>flush privileges;