#PHPMYADMIN NGINX UBUNTU 18.04 INSTALL#
#PHPMYADMIN NGINX UBUNTU 18.04 UPDATE#
#PHPMYADMIN NGINX UBUNTU 18.04 DOWNLOAD#

When the download is complete, unzip it into another folder such as /usr/share/ :~$ sudo tar xvzf phpMyAdmin-5.0. -C /usr/share/ In it, you can get the latest stable version which so far is 5.0.2 To download from the terminal run this command: :~$ cd /tmp/ On the PHPMyAdmin website, you can find the download section.

#PHPMYADMIN NGINX UBUNTU 18.04 UPDATE#

Update user set plugin='' where User='root' Įxit Configuring the root user account to work with PHPMyAdminĪs you may have noticed, in the end, you have to refresh user privileges in the database. To fix this, go to the MariaDB console and modify that plugin. This means that you cannot use PHPMyAdmin with this user. By default, MariaDB assigns an authentication plugin to the root user. If you do not want any problems, you can answer all of them with the “y” key. Next, you will see some configuration questions. Remember that it does not exist yet, so just press the enter key. For this purpose, it is necessary to use the mysql_secure_installation script :~$ sudo mysql_secure_installation Set a new root passwordĪt first, you will be asked to enter a root password.

Therefore, it has to be defined for security reasons.

#PHPMYADMIN NGINX UBUNTU 18.04 INSTALL#

Installing MariaDB in Ubuntu is a matter of one command: :~$ sudo apt install mariadb-server Installing MariaDBīy default, the installation does not include the definition of a root password. So if you do not have MariaDB installed, you have to do it. So, you already have what is necessary for the correct execution of PHPMyAdmin but something else important is missing: what it will manage. Open a web browser and go to the following address or using the server’s IP address Address]/test.php The result has to be an image similar to this: Apache and PHP working Checking the functioning of Apache and PHP. Save the changes by pressing CTRL + O and exit the editor with CTRL + X. For example, the phpinfo method is a good option. So, create the file: :~$ sudo nano /var/www/html/test.php The best way to do this is to create a PHP file and open it from the browser. Once the installation process is complete, you should check that Apache and PHP are working properly. So, all you have to do is run the following command in a terminal: :~$ sudo apt install apache2 php-tcpdf php-cgi php-mysqli php-pear php-mbstring php-gettext libapache2-mod-php php-common php-phpseclib php-mysql First step: installing Apache and PHP Like PHP, the apache web server is available in the official Ubuntu repositories. One of the necessary modules is the one that allows the connection between PHP and MariaDB / MySQL. For PHPMyAdmin to run on the server, you need to install the PHP language along with some modules. Since it is a web application written in PHP, one of the first steps to be taken is to install a web server. Apache web server and PHP before installing PHPMyAdmin on Ubuntu That is, you will probably not have to install any extras on a server. PHPMyAdmin has become popular because it combines a very good graphical interface with the practicality of being a web application. This avoids having to use complex commands or terminals. A graphical client for MariaDB / MySQL is an application that allows us to perform basic and advanced tasks from a graphical interface. So installing PHPMyAdmin on Ubuntu 18.04 is the main goal of this post as a guide. Of all these clients PHPMyAdmin is perhaps the most popular. That is why graphic clients have been created to help with this work.

Using MariaDB only from a command interface can be complicated.

Phpmyadmin nginx ubuntu 18.04