Now, exit from the MySQL shell with the following command: mysql> EXIT Īt this point, your MySQL server is configured to use mysql_native_password authentication method. You should see the following output: +-+-+ Next, verify the authentication method again with the following command: mysql> SELECT user,plugin FROM er Next, flush the privileges to apply the changes: mysql> FLUSH PRIVILEGES Now, change the authentication plugin from auth_socket to mysql_native_password for your root user with the following command: mysql> ALTER USER IDENTIFIED WITH mysql_native_password BY 'secure-password'
| debian-sys-maint | caching_sha2_password | You should get the following output: +-+-+ To do so, login to MySQL shell with the following command: mysqlĪfter login, check the authentication method of all of your users run the following command: mysql> SELECT user,plugin FROM er So you will need to change this default authentication method from auth_socket to mysql_native_password in order to log in to phpMyAdmin as MySQL root user. Configure MySQL Serverīy default, the MySQL root user is set to authenticate using the auth_socket plugin by default rather than with a password in Ubuntu 20.04 running MySQL 5.7 or later versions. Once logged in, make sure that your server is up-to-date by running the following commands: apt-get update -yĪpt-get upgrade -y 2. Make sure to replace IP_ADDRESS and PORT_NUMBER with your actual server IP address and SSH port number. To connect to your server as the root user, use the following command: ssh -p PORT_NUMBER
#Phpmyadmin not found ubuntu 20 install#
Install PhpMyAdmin from Ubuntu 20.04 repositoryīefore starting, you need to connect to your server via SSH as the root user or any other user with sudo privileges.
0 kommentar(er)
