The MySQL Grant Tables
One of the most powerful aspects of the MySQL server is the amazing amount of control the administrator has over each user's intended behavior. This control can restrict user privileges over a general part of the server, such as limited access to an entire database, but can also be as specific as limiting privileges for a specific table or even column.
| Name: |
rdj |
| Subject: |
Re: Grant table does not work |
| Date: |
07-08-1999 03:20PM |
Yeah, first you have to store the password in encrypted format, not plain text. Second, depending on how your host's domain name service is set up, you may need to have two entries, one for host='localhost' and one for host=whatever_your_hostname_is. I haven't figured out the latter but did get things working by adding two rows for each user.
To get the encrypted password, use the password() function. For example:
update user set password=password('mypassword') where user='myuser';
-rdj
|
Other posts in this thread:
Reply to this post:
|
 |
Visit the MySQL Forum!
New On DevShed:
Hot Forum Topics:
|
