Provide your username / password and click on the Go button. Now, access your phpMyAdmin web interface by visiting the URL You should see the phpMyAdmin log in page: Next, exit from the MySQL console with the following command: MariaDB > GRANT ALL PRIVILEGES ON *.* TO WITH GRANT OPTION MariaDB > CREATE USER IDENTIFIED BY 'password' Next, create a separate user for phpMyAdmin with the following command: MariaDB > SELECT user,authentication_string,plugin,host FROM er Next, check the authentication method again by running the following command: MariaDB > ALTER USER IDENTIFIED WITH mysql_native_password BY 'password' Now, change the authentication method from auth_socket to mysql_native_password with the following command: | mysql.sys | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql_native_password | localhost | | ssion | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql_native_password | localhost | | user | authentication_string | plugin | host | You should see the authentication method used by root user in the following output: MariaDB >SELECT user,authentication_string,plugin,host FROM er Next, check the authentication method of MySQL user by running the following command: To do so, log in to MySQL shell with the following command: Then, you will need to change its authentication method from auth_socket to mysql_native_password. If you want to login phpMyAdmin with root user and password. By default, the root MySQL user is set to authenticate using the auth_socket plugin in the latest version of MariaDB. Systemctl restart apache2 Setup Authenticationīy default, phpmyadmin database user automatically created with the administrative password you set during installation. Next, restart Apache service to apply all the changes: Next, provide your MySQL password and click on the OK button to start the installation.Īfter installing phpMyAdmin, enable the mbstring PHP extension by running the following command: Select Apache web server and click on the OK button. You will need to select web server during the installation as shown below. Next, update the repository and install phpMyAdmin with the following command: You can add it with the following command:Īpt-get install software-properties-common -y So, you will need to add ondrej PHP repository to your system. Install phpMyAdminīy default, phpMyAdmin is not available in the Ubuntu 18.04 repository. Once you have done, you can proceed to the next step. Once all the packages are installed, start Apache and MariaDB service and enable them to start on boot time with the following command: You can install all of them with the following command:Īpt-get install apache2 mariadb-server php php-cgi libapache2-mod-php php-common php-pear php-mbstring php-gettext -y Install LAMP Serverįirst, you will need to install Apache, MariaDB and php to your server. Once your system is up-to-date, restart the system to apply all the changes. You can do it with the following command: A root password is configured on your server.įor security reason, it is very important to update your system with the latest stable version.In this tutorial, we will explain how to install and secure phpMyAdmin on Ubuntu 18.04 server. So, it very important part of any system administrator to secure phpMyAdmin from unauthorized user. With phpMyAdmin, you can also set up database replication between multiple MySQL hosts easily through the web browser. You can easily create, delete, import and export database using phpMyAdmin. It is specially designed to manage and administer MySQL databases through a graphic user interface. PhpMyAdmin is an open source and one of the most popular MySQL administration tools written in PHP.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |