Oct 22, 2023

Problem and Solution

 Error: Can't connect to local MySQL server through socket '[path to mysqld.sock]'

sudo apt purge --auto-remove mysql*
sudo rm -r /etc/mysql
sudo rm -r /var/lib/mysql*

sudo apt install mysql-client-8.0 mysql-server-8.0 --fix-broken -y

unit mysql.service is masked




unable to login phpmyadmin

- sudo nano /etc/apache2/conf-available/phpmyadmin.conf
- 
<Directory /usr/share/phpmyadmin>
    Options SymLinksIfOwnerMatch
    DirectoryIndex index.php
    AllowOverride All


mysqli::real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES)



Connection for controluser as defined in your configuration failed.

change

-$dbuser='root';

-dbpass='curentpassword'

systemctl restart mysql.service





NOT FOUND Apache/2.4.52 (Ubuntu) Server at 10.1.83.8 Port 80





unable to resolve host root: System error






By