MySQL Forums
Forum List  »  Security

Re: !!! Problem with grant PROXY USER - mysql 5.6.17 !!!
Posted by: Bartosz Rumiak
Date: November 27, 2014 02:24AM

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 |
+---------------+-----------------+-------------+-------------+-------------+-------------+-------------+-----------+------------+------------+------------+--------------+------------------+

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: !!! Problem with grant PROXY USER - mysql 5.6.17 !!!
1887
November 27, 2014 02:24AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.