Tips and tricks

Add user / admin to mysql
go to MySQL service from the terminal
use
sudo mysql
or
sudo mysql -u root -p
if you have a password
then
CREATE USER 'new_user'@'localhost' IDENTIFIED BY 'password';
then
GRANT ALL PRIVILEGES ON * . * TO 'new_user'@'localhost';
then, to restart privileges
FLUSH PRIVILEGES;
check users with
SELECT user,host FROM mysql.user;