AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Ubuntu install phpmyadmin8/14/2023 mysql> SELECT user,authentication_string,plugin,host FROM er - - - - Now check again to make sure root is using password instead of auth_socket. mysql> ALTER USER IDENTIFIED WITH caching_sha2_password BY ' your_password' To configure the root account to authenticate with a password, run the following command. Here, you can see that the root user does in fact authenticate using the auth_socket plugin. | mysql.sys | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password | localhost | | ssion | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password | localhost | | schema | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | caching_sha2_password | localhost | | debian-sys-maint | $A$005$ktHnp7_`CgS.LxIaFEB1P2zjE.O3EptCEyPqlUbOPXeLoGIcr.5DGTp4 | caching_sha2_password | localhost | | user | authentication_string | plugin | host | ![]() Now, check the authentication method, by following command. To do this, open up the MySQL prompt from your terminal $ sudo mysql To access phpMyAdmin as your root MySQL user, you will need to switch its authentication method from auth_socket to one that makes use of a password. In Ubuntu server MySQL version 5.7 or later version, the root MySQL user is set to authenticate using the auth_socket plugin by default rather than with a password. It is recommended to use root instead of phpmyadmin user. When you installed phpMyAdmin onto your Ubuntu server, it automatically created a database user called phpmyadmin. $ sudo systemctl restart apache2 Step 2: Adjust Authentication and Privileges for phpMyAdmin Once installation completed, restart Apache by following command for changes to take effect. Press space bar on keyboard to select apache2. You have to choose the web server that should be automatically configured to run phpMyAdmin. $ sudo apt install phpmyadminĪfter running this command, an installer prompt will be shown. Now, install phpMyAdmin from default Ubuntu repository by following command. Open terminal to update and upgrade the Ubuntu packages to the latest version. To install phpMyAdmin on Ubuntu 20.04 server, follow below steps Step 1: Installing phpMyAdmin on Ubuntu
0 Comments
Read More
Leave a Reply. |