Managing MySQL users, allowable hosts, and privileges
The following is a description of the page displayed when clicking on an existing MySQL username in the "Users with Access" column.
- The MySQL User page appears.
The red text in the items below indicate possible destructive commands. Please be careful when using these commands.
|Button Number||Button Name||Action and Description|
|Delete||Clicking the Delete button removes this MySQL users access to the database listed at the top of the page. When a MySQL user is deleted from all databases, the MySQL user ceases to exist and is considered fully deleted.|
|What may USERNAME do to tables in these databases?||This section allows adding or removing specific privileges of the MySQL user, affecting its access to read, write or change data, as well as administrate the database contents.
|Allowable Hosts||A list of hosts that are allowed to login to this MySQL user. For security reasons, the default is %.dreamhost.com which restricts connections from outside the DreamHost network, even is a correct username and password is provided. Additional IP addresses or wildcards can be added on new lines to allow access to an outside network. Modifying or removing %.dreamhost.com may result in MySQL inaccessibility for DreamHost hosted websites.|
|Current Password||Click the Show button to be displayed the password for this MySQL user.|
|New Password||Enter a new password here to change the users password. Please keep in mind that all sites using this MySQL user stops functioning within minutes, until all configuration files are updated to the new password.|
|New Password Again||Confirm the new password by entering it again here.|
When all desired changes have been made, click Modify USERNAME now! to confirm.
Changes made may take up to 5 minutes to take affect.
- MySQL overview
- phpMyAdmin overview
- How do I backup and restore my database?
- How do I connect to my database via SSH?
- How do I connect to my database using a third-party program?
- How do I connect to my database using SQLyog?
- Troubleshooting your MySQL database
- MySQL limitations due to shared hosting
- Finding your database login credentials