MySQL Allow Remote Connection
- Chris Speed
- Nov 27, 2022
- 1 min read
The following allows for remote connection to mySQL view TCP/IP considering the firewall port 3306 is currently open and active.
mySQL> CREATE USER 'user'@'%' IDENTIFIED BY 'password';
mySQL> GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' WITH GRANT OPTION;
mySQL> FLUSH PRIVILEGES;
sudo service mysqld restart
References:
https://stackoverflow.com/questions/1559955/host-xxx-xx-xxx-xxx-is-not-allowed-to-connect-to-this-mysql-server
Comments