Selected from Linux Selected from PHP
- Ubuntu 17.10 Install google's mod pagespeed for apache - PHP-Ubuntu-Youtube-dl simple script for converting and downloading youtube video or mp3
- Ubuntu SSH tunnel via proxy - PHP while loop with every row with a different color
- Install GoAccess Apache Log Analyzer Tool on Ubuntu 17.10 - PHP use while loop in function
- SSHFS and map folder with a proxy - PHP List Files And Folders As links
- How to connect to SSH server with a proxy - PHP Extract Text From String
➥ Grant all privileges to root@localhost for mariadb or mysql on ubuntu 16.04 to use phpmyadmin
Added by sonik on 18-07-2017 and keywords: grant, root, login, phpmyadmin, localhost, mariadb, mysql, ubuntu, 16.04 [ Print Article ]
If you have ever had a problem to login to phpmyadmin with root you will need to add the rights.
login to mariadb/mysql:
mysql -uroot -p

check if user is added:
SELECT User, Host FROM mysql.user WHERE Host <> 'localhost';

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

Now add the root user:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'YOUR PASSWORD' WITH GRANT OPTION;

And now flush:
flush privileges;

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

@All rights reserved with Copyright Webleit.info 2018 by Sonik_Blast [ Site Map ] [ RSS ] [ YouTube Mp3 Downloader and converter ]