MySQL Permissions

You can specify wild cards in the hostname. For example, user@"%.loc.gov" applies to user for any host in the loc.gov domain, and user@"144.155.166.%" applies to user for any host in the 144.155.166 class C subnet. Or user@"%" from anywhere. NOTE: If you allow anonymous users to connect to the MySQL server (which is the default), you should also add all local users as user@localhost because otherwise the anonymous user entry for the local host in the mysql.user table will be used when the user tries to log into the MySQL server from the local machine! Anonymous users are defined by inserting entries with User='' into the mysql.user table. You can verify if this applies to you by executing this query:
Related Scribbles:
  • Rotate MySQL binlog
  • MySQL Notes


  • ID: 158
    Author:
    Len
    Date Updated:
    2003-12-23 00:22:55
    Date Created:
    2001-10-20 10:54:48

    Edit

    Comments?
     >> Leonard Chan's Homepage  >> Scribble Web  >> MySQL Permissions
    leonard.lotus-land.ca is hosted by Perceptus Solutions Inc.