linuxmysql添加用户名并实现远程访问

mysql>select host,user,password from mysql.user;
mysql>grant all on *.* to 用户名@"%" identified by "您的密码"
或
mysql>grant all privileges on *.* to 用户名@域 identified by "密码"
mysql>flush privileges;

附：如果只授权某一数据库操作：
mysql>grant all on `库名`.* to 用户名@"%" identified by "您的密码"

#mysql -u younamme -p -h ip

mysql>use msyql;
mysql>update user set password = password("密码") where user = "帐号"; 
mysql>flush privileges;

mysql>delete from mysql.user where user ='您的用户名' ;
mysql>flush privileges; (刷新系统权限表)

create database [库名] default character set utf8 collate utf8_general_ci;