Всем привет. Настроил по урокам ламп. теперь захотел подключить phpmyadmin а такую ошибку выдает:
Как ее решить?
Вот какие команды вставлял в терминал с начала установки (там ссылки, это статьи по которым я делал все это):
#https://losst.ru/ustanovka-lamp-v-ubuntu-20-04?ysclid=l7yoe8gjvn834722367#7_%D0%9D%D0%B0%D1%81%D1%82%D1%80%D0%BE%D0%B9%D0%BA%D0%B0_MySQL
$ sudo apt update
$ sudo apt -y upgrade
$ sudo apt -y install apache2
$ sudo apt -y install default-mysql-server
$ sudo apt -y install php7.4 libapache2-mod-php7.4 php7.4-mysql php-curl php-json php-cgi php-gd php-zip php-mbstring php-xml php-xmlrpc
$ sudo ufw allow in 80/tcp
$ sudo service apache2 restart
$ sudo service mysql restart
$ touch index.php
$ echo "<?php phpinfo(); ?>" > index.php
$ sudo mv index.php /var/www/html/index.php
$ sudo a2dismod mpm_event
$ sudo a2dismod mpm_worker
$ sudo a2enmod mpm_prefork
$ sudo a2enmod rewrite
$ sudo sed -i '/\/var\/www\//,/\/Directory/s/AllowOverride None/AllowOverride All/g' /etc/apache2/apache2.conf
$ sudo sed -i '/\/usr\/share\//,/\/Directory/s/AllowOverride None/AllowOverride All/g' /etc/apache2/apache2.conf
$ sudo service apache2 reload
$ sudo sed -i 's/short_open_tag = Off/short_open_tag = On/' /etc/php/7.4/apache2/php.ini
$ sudo sed -i 's/error_reporting = E_ALL & ~E_DEPRECATED & ~E_STRi-cT/error_reporting = E_ALL/' /etc/php/7.4/apache2/php.ini
$ sudo sed -i 's/display_errors = Off/display_errors = On/' /etc/php/7.4/apache2/php.ini
$ sudo service apache2 reload
$ sudo mysql_secure_installation
... Failed! Error: SET PASSWORD has no signifi-cance for user 'root'@'localhost' as the authenti-cation method used doesn't store authenti-cation data in the MySQL server. Please consider using ALTER USER instead if you want to change authenti-cation parameters.'
#https://exerror.com/failed-error-set-password-has-no-significance-for-user-rootlocalhost-as-the-authentication-method-used-doesnt-store-authentication-data-in-the-mysql-server/
$ sudo mysql
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password by 'testPassword';
mysql> exit
$ sudo mysql_secure_installation
Enter password for user root:
Press y|Y for Yes, any other key for No: No
Change the password for root ? ((Press y|Y for Yes, any other key for No) : No
Remove anonymous users? (Press y|Y for Yes, any other key for No) : Y
Disallow root login remotely? (Press y|Y for Yes, any other key for No) : Y
Remove test database and access to it? (Press y|Y for Yes, any other key for No) : Y
Reload privilege tables now? (Press y|Y for Yes, any other key for No) : Y
#https://losst.ru/ustanovka-phpmyadmin-ubuntu-18-04?ysclid=l7zr7tpmb9179137130
$ sudo mysql -u root -p
mysql> CREATE USER 'Testuser'@'localhost' IDENTIFIED BY 'testPassword';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'Testuser'@'localhost';
mysql> FLUSH PRIVILEGES;
mysql> exit
$ sudo apt -y install php-mbstring
$ sudo apt -y install phpmyadmin
$ sudo ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf-available/phpmyadmin.conf
$ sudo sed -i ':a;N;$!ba;s/# limit/AllowOverride All\n # limit/' /etc/apache2/conf-available/phpmyadmin.conf
$ sudo a2enconf phpmyadmin.conf
$ sudo service apache2 restart
$ touch .htaccess
$ echo 'AuthType Basic
AuthName "Restricted Files"
AuthUserFile /etc/phpmyadmin/.htpasswd
Require valid-user' > .htaccess
$ sudo mv .htaccess /usr/share/phpmyadmin/
$ sudo htpasswd -c /etc/phpmyadmin/.htpasswd administrator
$ sudo htpasswd /etc/phpmyadmin/.htpasswd Testuser
