over 8 years ago
Without database any application is almost redundant. So this post might help you to setup access to MySQL database on Ubuntu.
Firstly you need to open up the MySQL server config file present at
and search for the line
bind-address = 127.0.0.1
Note - Always take backup of the file you are changing and use nano editor by typing the following command
sudo nano my.conf
It will ask for password. Enter the password and the file will open up.
The line bind-address = 127.0.0.1 actually binds MySQL connections to localhost only.
Comment out this line by adding # at the front of this line
After commenting out the line it should look like this
#bind-address = 127.0.0.1
Now save this file and restart MySQL by
You are all good to go but this only enables MySQL access on local network
If you want to access MySQL from a remote ip address then the following procedure will help you
Before granting user access, you need to login to MySQL from SSH:
$ mysql -u root -p
Enter the password when prompted. It is the same password which was specified during MySQL installation.
Grant user access
Change the IP address, database name, username and password according to yours.
To grant remote access, type the following command from MySQL prompt:
mysql> CREATE USER 'MY_USERNAME'@'localhost' IDENTIFIED BY 'MY_PASSWORD';
mysql> GRANT ALL PRIVILEGES ON TEST.* TO 'MY_USERNAME'@'18.104.22.168' IDENTIFIED BY 'MY_PASSWORD';
On successful execution you see a message saying something like Query OK, 0 rows affected (0.00 sec)
Restart MySQL by firstly quitting MySQL:
Then type the following command at the SSH prompt:
Now you can access MySQL remotely through the ip you granted access to.
Starting with Chrome version 45, NPAPI is no longer supported for Google Chrome. For more information, see Chrome and NPAPI (blog.chromium.org).
Firefox and Microsoft Internet Explorer are recommended browsers for websites using java applets.
Chrome Version Support
Are you sure, you want to delete this comment?
Terms of Service
| © copyright 2022 FindNerd.com. All rights reserved.
Sign up using