Ubuntu Server - Allow external Access to mysql database

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