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 | mysql> SELECT user,authentication_string,plugin,host FROM er - - - - 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |