#Phpmyadmin ubuntu nginx how to
#Phpmyadmin ubuntu nginx install

To do this, log into MySQL as root, using the password you created upon installing and securing MySQL (or MariaDB). For this reason we’ll create a superuser account just for accessing it. There may be a possibility that you’re not able to log into phpMyAdmin as root. Step 3 – Create Administrative MySQL User You should now be able to access phpMyAdmin at Before doing that, however, we’ll create a superuser account just for accessing phpMyAdmin. Sudo ln -s /usr/share/phpmyadmin /var/www/html/phpmyadmin The phpMyAdmin directory is /usr/share/phpmyadmin and the default document root for Nginx on Ubuntu 18.04 is /var/Once you’ve established your Nginx document root, we’ll create a symbolic link from the phpMyAdmin directory to it. There are a few ways to do this, but since our domain’s server block is already set up to serve PHP files, we’ll just create a symbolic link from the phpMyAdmin installation files, to our domain’s document root. We’ll have to configure Nginx ourselves to serve phpMyAdmin files. Now phpMyAdmin is installed on your system. The last thing you have to do is to confirm your password:Īnd that’s it. If you insist on it, you can set your own password, however. You can just leave it empty and press ENTER and a random password will be generated. This screen is asking you for a password that will be used only internally by phpMyAdmin to communicate with MySQL.

#Phpmyadmin ubuntu nginx install

In this next screen, in which you’re asked to install and configure the database for phpMyAdmin, select YES and press ENTER. Just press TAB, so the cursor goes on OK, and press enter ENTER, without selecting a server. If you’re prompted to choose a web server, Nginx will most likely not be one of them, and you’ll have to choose between apache2 and lighttpd. They may vary in order, depending on your setup. Please make sure that you have LEMP Stack installed on your system before installing phpMyAdmin.ĭuring the phpMyAdmin installation you’ll be prompted with a few Package Configuration screens. To install phpMyAdmin on Ubuntu, just update the package index and then install the package from the default Ubuntu repositories: $ sudo apt update

#Phpmyadmin ubuntu nginx how to

If you don’t have it set up, you can follow our tutorial on how to install LEMP stack on Ubuntu 18.04 here.

LEMP Stack installed on your Ubuntu 18.04.

If you don’t have one set up, you can check out our tutorial on how to create a sudo user on Ubuntu and why it’s recommended.

While not required, it’s recommended that you use a non-root sudo user.

Set Up an Nginx Authentication Gateway for phpMyAdmin

Step 3 – Create Administrative MySQL User.