Thread: Mysql problem
View Single Post
  #6  
Old 18th December 2012, 14:28
lollollollol lollollollol is offline
Member
 
Join Date: Nov 2011
Location: Madagascar
Posts: 44
Thanks: 7
Thanked 6 Times in 5 Posts
Default

Hi,
Of course you are right (as usual) !
As you can see below, I have "too much" root user...

Code:
select host, user from mysql.user;
+-------------------+------------------+
| host              | user             |
+-------------------+------------------+
| 127.0.0.1         | root             |
| ::1               | root             |
| localhost         |                  |
etc.
| localhost         | root             |
| mail.karmaweb.biz |                  |
| mail.karmaweb.biz | root             |
+-------------------+------------------+
21 rows in set (0.00 sec)
One for localhost, and one for 127.0.0.1...
root@127.0.0.1 have all privileges, not root@localhost.

I messed up my mysql configuration.
It's now corrected.

By the way: Thanks for the fantastic job on ispconfig!
This is a must.
Reply With Quote