Execute mysql without sudo

Question

I am trying to install wordpress on Odroid C2. However, wordpress could not access mysql.

So, I tried this.

If I execute mysql with sudo, it is OK. But, without sudo, I can't.

The OS of C2 is Ubuntu Mate 16.04, so I installed mariaDB instead of mysql.

I followed the guide of mariaDB installation.

How can I use mysql without sudo, and how can my wordpress access the DB.

Answer 1

try this to solve the problem:

Login in your DB

sudo mysql -u root -p

then make these modifications:

MariaDB []>use mysql;
MariaDB [mysql]>update user set plugin='' where User='root';
MariaDB [mysql]>flush privileges;
MariaDB [mysql]>exit

try login again without sudo

Answer 2

This should be an serverfault.com issues. But anyway, go through this checklist

1. Are you starting mysql with port other than 3306
2. Check access of mysql client is o+rx , i.e. ls -la /usr/bin/mysql
3. Did you grant user access other than "root" in mysqldb/mariadb. Mysql db may prevent you from using root@localhost if it is not running sudo

So if in case no 3, you must create a new user and grant access to it to solve this. i.e.

GRANT ALL ON <YOUR_WP_DATABASE_NAME>.* TO "wpuser"@"localhost" IDENTIFIED BY "somepassword"; 

Afterwards, try mysql using that user to confirm it works.