Instead of changing the authentication method for the MySQL user root, we will create a new administrative MySQL user. This means that you can’t authenticate as a root by providing a password. The auth_socket plugin authenticates users that connect from the localhost through the Unix socket file. In Ubuntu systems running MySQL 5.7 (and later), the root user is set to use the auth_socket authentication method by default. Next, run the following command to install the phpMyAdmin package from the default Ubuntu repositories: sudo apt install phpmyadminĪt this point phpMyAdmin has been installed on your Ubuntu server. Start by updating the packages list: sudo apt update Installing phpMyAdmin is a fairly simple task.
#Upgrading phpmyadmin ubuntu how to#
If you don’t have SSL enabled on your sites, check our article about how to secure your Nginx with Let’s Encrypt on Ubuntu 18.04.
Īlthough not necessary, it is highly recommended to access your phpMyAdmin instance over HTTPS. Logged in as a user with sudo privileges.LEMP (Linux, Nginx, MySQL, and PHP 7) installed on your Ubuntu server.Prerequisites #Įnsure that you have met the following prerequisites before continuing with this tutorial: This tutorial describes how to install phpMyAdmin with Nginx on Ubuntu 18.04. PhpMyAdmin allows you to interact with MySQL databases, manage user accounts and privileges, execute SQL-statements, import and export data in a variety of data formats and much more.
PhpMyAdmin is an open-source PHP based tool for managing MySQL and MariaDB servers over a web-based interface.
0 kommentar(er)
