Skip to content
Advertisement

Ubuntu 18.04 start mysql without root privilege

I just installed ubuntu 18.04 and installed LAMP on it, however I had trouble using mysql without the root privilege. when I write:

mysql -u root -p

and enter the password I configured it throws access denied. unless if I write

sudo mysql -u root -p

and enter the password that I’m able to connect. But I don’t want the sudo cause it prevents having workbench to connect to mysql, same applies to phpmyadmin too. Any hints on how to fix that?

Advertisement

Answer

It should only be the “-u root” user that requires sudo. It’s good practice to not use root for most access anyways, so just login as root using sudo and create a newuser:

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON database_name.* TO 'newuser'@'localhost';

Then you should be able to access “mysql -u newuser” without sudo.

User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement