![]() | mysql.sys | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql_native_password | localhost | | ssion | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql_native_password | localhost | $ sudo apt install phpmyadmin php-mbstring php-gettext /etc/apache2/conf-enabled/nf The $ sudo phpenmod mbstring $ sudo systemctl restart apache2 $ sudo mysql SELECT user, authentication_string, plugin, host FROM er +-+-+-+-+ How to install phpMyAdmin on Ubuntu 20.04 Htpasswd -c /etc/phpmyadmin/.htpasswd user1 New password: Systemctl restart apache2 nano /usr/share/phpmyadmin/.htaccess AuthType Basic Mysql> EXIT apt-get install phpmyadmin -y systemctl restart apache2 nano /etc/apache2/conf-available/nf Mysql> ALTER USER IDENTIFIED WITH mysql_native_password BY 'secure-password' mysql> FLUSH PRIVILEGES mysql> SELECT user,plugin FROM er +-+-+ | debian-sys-maint | caching_sha2_password | During the installation, you will be asked to choose a web server as shown below: Select the Apache web server … ssh _ADDRESS -p PORT_NUMBER apt-get update -yĪpt-get upgrade -y mysql mysql> SELECT user,plugin FROM er +-+-+ How to Install phpMyAdmin on Ubuntu 20.04Īpt-get install phpmyadmin -y. Sudo htpasswd /etc/phpmyadmin/.htpasswd additionaluser Sudo htpasswd -c /etc/phpmyadmin/.htpasswd username Sudo nano /usr/share/phpmyadmin/.htaccess sudo nano /etc/apache2/conf-available/nf GRANT ALL PRIVILEGES ON *.* TO WITH GRANT OPTION | root | *DE06E242B88EFB1FE4B5083587C260BACB2A6158 | caching_sha2_password | localhost |ĬREATE USER IDENTIFIED WITH caching_sha2_password BY 'password' | phpmyadmin | *5FD2B7524254B7F81B32873B1EA6D681503A5CA9 | caching_sha2_password | localhost |ĪLTER USER IDENTIFIED WITH caching_sha2_password BY 'password' ĪLTER USER IDENTIFIED WITH mysql_native_password BY 'password' | mysql.sys | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | caching_sha2_password | localhost | | ssion | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | caching_sha2_password | localhost | | user | authentication_string | plugin | host | SELECT user,authentication_string,plugin,host FROM er ![]() INSTALL COMPONENT "file://component_validate_password" UNINSTALL COMPONENT "file://component_validate_password" Sudo apt install phpmyadmin php-mbstring php-zip php-gd php-json php-curl How To Install and Secure phpMyAdmin on Ubuntu 20.04
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |