Enabling a Port after configuring virtual host on nginx webserver

Posted 12 October 2018

Say you have finished Installing mysql on your ubuntu 16.01 LTS . We now now want to ensure we can access the database remotely

It is very important to make sure that there are no multiple root users with different password Check that by using the command below

# select user,host,authentication_string from user;
Update the password of both root users if there exit any Login to the database
use mysql; update user set authentication_string=PASSWORD("y67[?h123") where User='root';
Once that is done go to /etc/mysql/mysql.conf.d/mysqld.cnf And comment out the line below
bind-address = 127.0.0.1 to #bind-address = 127.0.0.1

Restart the server with the command below

Service mysql restart

Post Comments

  • Osborn koranteng

    2019-02-09 14:48:49

    Great post. You Saved my life

Leave a Reply