Access Denied for User ‘root’@’localhost’ (using password : NO) or ERROR! The server quit without updating PID file (/usr/local/var/mysql/`username`.lan.pid)

If you have error like this.

MySQL said: Cannot connect invalid settings.

Access Denied for User ‘root’@’localhost’ (using password : NO)

Solution

Firstly check your mariadb or mysql already installed or not

brew info mysql

brew info mariadb

If installed already open your terminal and run;

$ mysql.server start
Starting MySQL
. SUCCESS!

sublime-text /usr/local/etc/phpmyadmin.config.inc.php

Set your root password same as in phpmyadmin.config.inc.php

/usr/local/etc/phpmyadmin.config.inc.php

mariadb -h 127.0.0.1 -u root -p

ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPassword!';

If doesnt work try below commands;

$ sudo rm -rf /usr/local/var/mysql
brew reinstall mysql

After installation start mysql

$ mysql.server start

mariadb -h 127.0.0.1 -u root -p

or

sudo mysql -u root -p

—

ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPassword!';