How to Enable Remote Acces To Mysql Database Server In Ubuntu

www.tehnopedia.net.  How to Enable Remote Acces To Mysql Database Server. 

After install Mysql Or MariaDb in your ubuntu,you cannot acces mysql in other komputer in your network. How to enable it?

1. Open my.cnf using terminal

sudo nano /etc/mysql/my.cnf

2. Press ctrl+w and type bind-address and give command #,then insert #skip-networking below

3. Save and now open your sql using terminal

mysql -u root -p

4. Give permission for user sql using command sql

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION; 

Flush Privileges;

5. Try acces in other pc in your network using

mysql -h hostsql -u root -p

If there is no error,you succesfully.Thanks. If any question please comment here.
You also read  How To Install WorkBrecnh In Ubuntu