为自己创建的mysql数据库，添加新用户

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;