I have rented unmanaged vds wich is running on ubuntu.
How i allow external connections in mysql db?
I havent changed any default configs... just did use this quide viewtopic.php?f=46&t=11140
Do i need to use vds ip or just localhost for external connections? and is port default 3306?
Thanx for any help...
External connections in mysql wich is running in ubuntu.
-
- New to forums
- Posts: 2
- https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
- Joined: Sun Sep 10, 2017 3:09 pm
Re: External connections in mysql wich is running in ubuntu.
If you've followed that guide, then you'll need to take only a few additional steps to allow a remote MySQL connection.
First, you'll need to edit the MySQL config file, using:
Arrow down to the following line:
Replace 127.0.0.1 with 0.0.0.0.
Now, restart MySQL:
You'll then need to create a new MySQL user with remote access permissions, as the default setup will not allow the root user to login remotely. You can create a new user via the "Users" tab of phpMyAdmin. You'll want to ensure the "Host:" field has "Any host" selected, to allow the user to login remotely.
First, you'll need to edit the MySQL config file, using:
Code: Select all
sudo nano /etc/mysql/my.cnf
Code: Select all
bind-address = 127.0.0.1
Now, restart MySQL:
Code: Select all
sudo service mysql restart
Re: External connections in mysql wich is running in ubuntu.
Thank you Spray