Search code examples
mysqlmariadbsudo

Execute mysql without sudo

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

enter image description here

So, I tried this.

enter image description here

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.

Solution

  • 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.