MySQL Allow Remote Connection in Ubuntu

Open your mysql.conf.d/mysql.conf via some editor.

Change your bind address( to

Save and exit.

restart your mysql: systemctl restart mysql.service

now you can create remote access granted user on mysql:

CREATE USER ‘user’@’%’ IDENTIFIED BY ‘password’;

If you want to access just single ip you can use this parameters:

CREATE USER ‘username’@’’ IDENTIFIED BY ‘password’;


Written by Uğur

Leave a Reply

Your email address will not be published. Required fields are marked *