mysql -u root -p -A -S /home/mysqldata/data/mysql.sock --port=51680
输入密码后
CREATE DATABASE XXXX
创建用户并分配权限:
grant all privileges on 数据库名称.* to 用户名@localhost identified by '密码' WITH GRANT OPTION;
grant all privileges on 数据库名称.* to 用户名@'需要连接的机器' identified by '密码' WITH GRANT OPTION;
grant all privileges on 数据库名称.* to 用户名@'需要连接的机器' identified by '密码' WITH GRANT OPTION;
grant all privileges on 数据库名称.* to 用户名@'需要连接的机器' identified by '密码' WITH GRANT OPTION;
grant all privileges on 数据库名称.* to 用户名@'%' identified by '密码' WITH GRANT OPTION;
flush privileges;