With the checkbox selected and the database/table selected, the privileges options displayed apply only to the selected database/table. SET PASSWORD FOR 'jeffrey''localhost' 'authstring' With no FOR user clause, the statement sets the password for the current user: SET PASSWORD 'authstring' Any client who connects to the server using a nonanonymous account can change the password for that account. To provide specific privileges limited to a single database or table, click on the checkbox next to that database or table in the Privileges Scope list.Privileges set when this item is selected apply to all databases and tables where no overrides are selected. To universally apply a set of privileges to all database, tables, columns, etc, select the “Global Privileges” item from the “Privileges Scope” list.This will change the password the user needs to connect from only that selected host, leaving the passwords for all other hosts unchanged. Click on a host for a user in the Users list, and click on the button in the Password section with the label matching the selected host.Select the user and reveal the list of allowed hosts for that user.This will change the password needed to connect from any of the allowed hosts for the selected user.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |