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;


Copyright 2021. All rights reserved.

Posted November 19, 2021 by Timothy Conrad in category "Databases

About the Author

If I were to describe myself with one word it would be, creative. I am interested in almost everything which keeps me rather busy. Here you will find some of my technical musings. PGP: 4CB8 91EB 0C0A A530 3BE9 6D76 B076 96F1 6135 0A1B