#PHPMYADMIN UBUNTU 16.04 BROKE DATABASE INSTALL#

When prompted reinstall database for phpmyadmin? select yes. Invoke dbconfig-common dpkg-reconfigure phpmyadmin

Tell dbcommon-config we want to use a remote database nano /etc/dbconfig-common/configДЇind the following line dbc_remote_questions_default='false'Д¬hange it to dbc_remote_questions_default='true' When asked Configure database for phpmyadmin with dbconfig-common? select no When asked Web server to reconfigure automatically: select none

#PHPMYADMIN UBUNTU 16.04 BROKE DATABASE INSTALL#

Update, install phpMyAdmin and some dependancies apt-get update apt-get install phpmyadmin php-mbstring php-gettext Grant all privileges GRANT ALL PRIVILEGES ON *.* TO GRANT USAGE ON *.* TO WITH GRANT OPTION Д¬reate a phpMyAdmin user with access from the web server and grant privileges CREATE USER IDENTIFIED BY 'supersecurepassword' GRANT ALL PRIVILEGES ON phpmyadmin.* TO privileges to have everything take effect FLUSH PRIVILEGES Restart MySQL to apply changes service mysql restartД¬reate a root user that can login from the web server CREATE USER IDENTIFIED BY 'supersecurepassword' Or change to the serverвЂ™s local IP address bind-address = 192.168.0.100 To allow remote access to the MySQL, open the following file in a text editorДЇind the following line bind-address = 127.0.0.1Д®ither comment it out like so #bind-address = 127.0.0.1 Here are guides for Nginx and MySQL Server. This guide assumes you have already deployed separate MySQL and Nginx (with php 7) servers on Ubuntu 16.04. If youвЂ™ve ever wanted to do something similar, today is your lucky day. One thing I always meant to do but never got around to figuring out was the initial setup of phpMyAdmin with a remote MySQL server.

IвЂ™ve been rebuilding my lab recently, most notably breaking down my LXD stack into individual Ubuntu virtual machines for each service.

Phpmyadmin ubuntu 16.04 broke database