Ubuntu 18.04在没有root特权的情况下启动mysql [英] Ubuntu 18.04 start mysql without root privilege

问题描述

我刚刚安装了ubuntu 18.04并在其上安装了LAMP，但是在没有root特权的情况下使用mysql遇到了麻烦.当我写的时候:

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

mysql -u root -p

并输入我配置的密码，它将导致访问被拒绝.除非我写

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

sudo mysql -u根-p

sudo mysql -u root -p

，然后输入我可以连接的密码.但是我不想要sudo原因，因为它会阻止工作台连接到mysql，同样适用于phpmyadmin.关于如何解决该问题的任何提示?

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?

推荐答案

它只能是需要sudo的"-u root"用户.最好不要使用root来进行大多数访问，因此只需使用sudo作为root登录并创建一个新用户即可:

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';

然后，您应该能够在没有sudo的情况下访问"mysql -u newuser".

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

这篇关于Ubuntu 18.04在没有root特权的情况下启动mysql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！