November
19
MySQL: add a remote user connection
Show all user info:
SELECT host,user,authentication_string FROM mysql.user;
mysql -u root -p
SELECT User, Host FROM mysql.user;
GRANT ALL privileges on . to ‘root’@’servername.domainname.com’;
flush privileges;
