☰ Categories

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;