first access to mariadb/mysql

first access to mariadb-mysql

Sorry dont have a name to give credit too but sourced from: https://askubuntu.com/questions/766334/cant-login-as-mysql-user-root-from-normal-user-account-in-ubuntu-16-04/801950

I recently upgrade my Ubuntu 15.04 to 16.04 and this has worked for me:

    First, connect in sudo mysql

    sudo mysql -u root

    Check your accounts present in your db

    SELECT User,Host FROM mysql.user;
    +------------------+-----------+
    | User             | Host      |
    +------------------+-----------+
    | admin            | localhost |
    | debian-sys-maint | localhost |
    | magento_user     | localhost |
    | mysql.sys        | localhost |
    | root             | localhost |

    Delete current root@localhost account

    mysql> DROP USER 'root'@'localhost';
    Query OK, 0 rows affected (0,00 sec)

    Recreate your user

    mysql> CREATE USER 'root'@'%' IDENTIFIED BY '';
    Query OK, 0 rows affected (0,00 sec)

    Give permissions to your user (don't forget to flush privileges)

    mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
    Query OK, 0 rows affected (0,00 sec)

    mysql> FLUSH PRIVILEGES;
    Query OK, 0 rows affected (0,01 sec)

    Exit MySQL and try to reconnect without sudo.

I hope this will help someone :)