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;