4
Accessing MariaDB without sudo on Ubuntu
source link: https://fuzzyblog.io/blog/mariadb/2016/12/06/accessing-mariadb-without-sudo-on-ubuntu.html
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Accessing MariaDB without sudo on Ubuntu
Dec 6, 2016
So I'm finally able to get back to trying Rails development on my Ubuntu box and the first real error I found was when I tried to create a database – I couldn't get into MariaDB unless I used sudo – very, very odd. I found the solution on Ubuntu Forums:
sudo mysql -u root
use mysql;
update user set plugin='' where User='root';
flush privileges;
\q
Honestly I have no idea what this is. Sigh. Oh well it works and it is documented at least.
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK