Install phpmyadmin ubuntu 204/30/2023 ![]() ![]() Now, create a new user, and then choose a name and a password by typing: $ CREATE USER 'username' 'localhost' IDENTIFIED BY 'password' If you have decided not to use the root user, type: $ sudo mysql In case of already configured password-based authentication for root user, type: $ mysql -u root -p To do so, log in again to the MySQL prompt. To access phpMyAdmin not as a root user but as a user created specifically for this purpose, there is nothing to do but create one. Configure the Password for the dedicated MySQL user Once done, use the password previously chosen to authenticate yourself as root user in the phpMyAdmin interface. If everything was done correctly, the authentication method for the root user will be changed and the screen displayed will be similar to the following: +-+-+-+-+ 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' | mysql.sys | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql_native_password | localhost | | ssion | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql_native_password | localhost | ![]() | user | authentication_string | plugin | host | 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. Configuring the Password for the MySQL root accountĪccessing as a MySQL root user requires an authentication auth_socket instead of a simple password. You can either choose to configure only one of these two users or both. instead log in as a MySQL user root or as a database manager via phpMyAdmin interface. To use phpMyAdmin, do not log in as the user created automatically during the installation. To apply all the changes, restart Apache by typing: $ sudo systemctl restart apache2 Managing access privileges ![]() 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. $ sudo apt install phpmyadmin php-mbstring php-gettextīy typing Y and pressing Enter to confirm. PhpMyAdmin is on the standard Ubuntu repository.įirst update the apt index, and then download and install phpMyAdmin: $ sudo apt update In case of a local server, go to the next step and open the terminal of your server. If you haven’t done so yet, following our guide is recommended to securely connect with the SSH protocol. In this guide you will learn how to install phpMyAdmin and how to secure its access on Linux Ubuntu 20.04.įirst, connect to your server via an SSH connection. PhpMyAdmin is a GUI (Graphic User Interface) that allows to create, store and edit entire databases created with MySQL. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |