mysql8

 https://www.tecmint.com/fix-mysql-error-1819-hy000/

SET GLOBAL validate_password.length=6;

SET GLOBAL validate_password.policy=0;

ALTER USER 'root'@'localhost' IDENTIFIED BY 'Vhere@03301';

CREATE USER 'root'@'%' IDENTIFIED BY 'Vhere@03301';

GRANT CREATE ON *.* TO 'root'@'%';

CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'Vhere@03301';

CREATE USER 'phpmyadmin'@'%' IDENTIFIED BY 'Vhere@03301';

sudo gedit /etc/mysql/mysql.conf.d/mysqld.cnf

GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY 'Vhere@03301';
FLUSH PRIVILEGES;

=====================================================

sudo apt update

sudo apt install firewalld

sudo systemctl enable firewalld

sudo systemctl start firewalld

sudo firewall-cmd --state

========================================

sudo apt install mate-utils
mate-search-tool

==========================================================

sudo gedit /etc/phpmyadmin/config.inc.php
$cfg['Servers'][$i]['port'] = '3333';

=============================================================

GRANT DROP ON *.* TO 'root'@'%';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
FLUSH PRIVILEGES;

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, ALTER, INDEX on *.* TO 'root'@'localhost';

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, ALTER, INDEX on *.* TO 'root'@'%';

FLUSH PRIVILEGES; 

==========================================================

sudo gedit /etc/apache2/conf-enabled/phpmyadmin.conf

===========================================================

SELECT 
    user, 
    host, 
    Select_priv, 
    Insert_priv,
    Update_priv,
    Delete_priv,
    Create_priv,
    Drop_priv
FROM
    mysql.user;
 
GRANT ALL PRIVILEGES ON *.* TO 'phpmyadmin'@'%';

GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.12';

============================================================

sudo gedit /etc/mysql/mysql.conf.d/mysqld.cnf