sudo vim.tiny /etc/mysql/my.cnf
comment out the following line
bind-address=xxxxxxxxx
Log into mysql as root user
Select the database you want to allow access to:
use $database_name
Run the command below, filling in the variables
GRANT ALL PRIVILEGES ON *.* TO $username@$remote_ip_of_client IDENTIFIED BY "$password";
No comments:
Post a Comment