Ubuntu MySQL edit users and permissions allow remote access

First, the new user

CREATE USER ' username ' @ ' host ' identified by ' password ';

Second, editing permissions

GRANT all on * * to ' username '. ' Host ' idendified by ' password ';

#刷新权限

Flush privileges;

Third, remote access

1. Edit the MySQL configuration file

Vi/etc/mysql/my.cnf

Note bind = 127.0.0.1

Four, restart the server

Service MySQL restart or/etc/init.d/mysql restart

Featured Articles

Http://www.2cto.com/database/201208/148843.html

Http://www.cnblogs.com/zeroone/articles/2298942.html

Ubuntu MySQL edit users and permissions allow remote access