| 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 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. We will be using HTML and CSS for this part of the tutorial as PHP will not be necessary on this page.Įdit the index.html file with your favorite code editor and add the following code:įont-family: -apple-system, BlinkMacSystemFont, "segoe ui", roboto, oxygen, ubuntu, cantarell, "fira sans", "droid sans", "helvetica neue", Arial, sans-serif īox-shadow: 0 0 9px 0 rgba(0, 0, 0, 0.3) We will now create a form that our users can use to enter their details and submit them for processing.
0 Comments
Leave a Reply. |