Grant all privileges to root@localhost for mariadb or mysql on ubuntu 16.04 to use phpmyadmin

Post Reply
User avatar
sonik
Site Admin
Posts: 37
Joined: 12 Nov 2018, 22:12

Grant all privileges to root@localhost for mariadb or mysql on ubuntu 16.04 to use phpmyadmin

Post by sonik » 13 Nov 2018, 10:59

If you have ever had a problem to login to phpmyadmin with root you will need to add the rights.
login to mariadb/mysql:

Code: Select all

mysql -uroot -p
check if user is added:

Code: Select all

SELECT User, Host FROM mysql.user WHERE Host <> 'localhost';

Code: Select all

MariaDB [(none)]> SELECT User, Host FROM mysql.user WHERE Host <> 'localhost';
+----------+------+
| User | Host |
+----------+------+
| librenms | % |
+----------+------+
Now add the root user:

Code: Select all

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'YOUR PASSWORD' WITH GRANT OPTION;
And now flush:

Code: Select all

flush privileges;

Code: Select all

MariaDB [(none)]> SELECT User, Host FROM mysql.user WHERE Host <> 'localhost';
+----------+-------------+
| User | Host |
+----------+-------------+
| librenms | % |
| root | % |
+----------+-------------+

Post Reply