Peter Brawley Wrote:
-------------------------------------------------------
> You have a mysql.user row with blank username &
> password? Terrible idea.
its not my idea :)
it is third point in 6.3.8.5.2.3 Unix Password Authentication with Proxy Users and Group Mapping in
http://dev.mysql.com/doc/refman/5.6/en/pam-authentication-plugin.html
> Did you try ...TO ''@'%'?
No i will try.
> Are there multiple mysql.user rows for root?
Yes
+---------------+-----------------+-------------+-------------+-------------+-------------+-------------+-----------+------------+------------+------------+--------------+------------------+
| Host | User | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | Alter_priv | Super_priv | Execute_priv | Create_user_priv |
+---------------+-----------------+-------------+-------------+-------------+-------------+-------------+-----------+------------+------------+------------+--------------+------------------+
| localhost | root | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y |
| xxxx-xxxxx02 | root | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y |
| 127.0.0.1 | root | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y |
| localhost | | N | N | N | N | N | N | N | N | N | N | N |
| xxxx-xxxxx02 | | N | N | N | N | N | N | N | N | N | N | N |
| % | root | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y |
| % | slave | N | N | N | N | N | N | N | N | N | N | N |
| xxxx.xxxxx.xx | nagios | Y | N | N | N | N | N | N | N | Y | N | N |
| % | mysqlimport2run | N | N | N | N | N | N | N | N | N | N | N |
| % | glpi | N | N | N | N | N | N | N | N | Y | N | N |
| % | tradcacti | N | N | N | N | N | N | N | N | Y | N | N |
| % | logmgmt | N | N | N | N | N | N | N | N | N | N | N |
| % | proftpd | N | N | N | N | N | N | N | N | N | N | N |
| % | nagios | N | N | N | N | N | N | N | N | N | N | N |
| % | ImportUser | N | N | N | N | N | N | N | N | N | N | N |
| localhost | dbadm | N | N | N | N | N | N | N | N | N | N | N |
| localhost | reg | N | N | N | N | N | N | N | N | N | N | N |
| localhost | employee | N | N | N | N | N | N | N | N | N | N | N |
| | | N | N | N | N | N | N | N | N | N | N | N |
| % | fred | N | N | N | N | N | N | N | N | N | N | N |
| xxxx-xxxxx02 | glpi | N | N | N | N | N | N | N | N | N | N | N |
+---------------+-----------------+-------------+-------------+-------------+-------------+-------------+-----------+------------+------------+------------+--------------+------------------+