allow mysql remote connection and installing phpmyadmin

 

1  allow remote connections

nano /etc/my.cnf.d/mariadb-server.cnf

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

log-error=/var/log/mariadb/mariadb.log

pid-file=/run/mariadb/mariadb.pid

bind-address = 0.0.0.0

2 restart the service

sudo systemctl restart mariadb

3 check status

sudo systemctl status mariadb

4 Grant   access to the user remotely 

MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'asterisk' WITH GRANT OPTION;

5 Reload  settings

MariaDB [(none)]> FLUSH PRIVILEGES;

6 Test connection

 mysql  -h 135.178.45.132 -u root -pasterisk

7 run phpmyadmin

docker run --name phpmyadmin -d -e PMA_ARBITRARY=1 -p 8080:80 --restart always phpmyadmin/phpmyadmin