In this way, the server will be notified that the authentication method for the root user has to be updated.Ĭheck if the changes are saved by retyping: SELECT user, authentication_string, plugin, host FROM er Instead of password, enter a password that you will have to remember.Ĭonfirm the changes you just made by typing: FLUSH PRIVILEGES To change the authentication type from auth_socket to mysql_native_password and use a password to log in to the root user, type: ALTER USER 'root' 'localhost' IDENTIFIED WITH mysql_native_password BY 'password' Here you can clearly see how the root user has an auth_socket authentication type. To do so, open the MySQL prompt $ sudo mysqlĬheck the authentication methods for each MySQL user by typing: SELECT user, authentication_string, plugin, host FROM er Ī list of all authentication methods for MySQL users is now displayed. To log in as MySQL root via phpMyAdmin change the authentication method. To apply all the changes, restart Apache by typing: $ sudo systemctl restart apache2ĬONFIGURING THE PASSWORD FOR THE MYSQL ROOT ACCOUNTĪccessing as a MySQL root user requires an authentication auth_socket instead of a simple password. To do so type in: $ sudo phpenmod mbstring The only thing you will need to do is activating the PHP mbstring extension. Once the installation is completed, a phpMyAdmin configuration file will be added here: /etc/apache2/conf-enabled/nf The Just like beforehand, enter a new password, press TAB to select Ok and press Enter. Now enter and confirm a password for the application.

Enter a new password, press Tab to select OK and press Enter. You are now required to enter a password for the administrator database. Once pressed Enter, the following screen will be displayed: If you do not press the spacebar, the files required for installation will not be transferred. To select it, press the spacebar and then press Enter. Select apache here, but be careful, the red dash does not select apache 2. PhpMyAdmin is on the standard Ubuntu repository.įirst update the apt index, and then download and install phpMyAdmin: $ sudo apt update $ sudo apt install phpmyadmin php-mbstring php-gettextīy typing Y and pressing Enter to confirm.

Install filezilla on ubuntu 18.04