Overview
The following describes how to manage MySQL users, allowable hosts, and privileges in the DreamHost panel.
Managing user settings
Navigate to the MySQL Databases page and click the username to the right of the database to view its settings.
The user settings page opens where you can manage the following:
Delete a username
Click the Delete button at the top to remove this MySQL user's access to the database. When a MySQL user is deleted from all databases, the user ceases to exist and is considered fully deleted.
What may <USERNAME> do to tables in these databases?
This section allows you to add or remove specific user privileges, affecting its access to read, write, or change data, as well as administrating the database contents. Check each box to grant the ability for the following:
- Select — read rows from tables.
- Insert — add new rows to tables.
- Update — modify existing rows in tables.
- Delete — remove rows in tables.
- Create — create new tables. This does not allow the creation of new databases on the command line.
- Drop — remove tables and views.
- Index — add or remove indexes from existing tables.
- Alter — change the structure of tables.
Edit the Allowable Hosts field
The Allowable Hosts field displays a list of hosts that are allowed to user this MySQL user to log in.
- For security reasons, the default is %.dreamhost.com, which restricts connections outside the DreamHost network, even if a correct username and password are 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 make MySQL inaccessible for DreamHost-hosted websites.
View and change a user password
Under the Do you need to know <USERNAME's> password? section, click the Show button to display this MySQL user's password.
To change it, enter a new password and click the Modify exampleuser now! button to save. It may then take up to 5 minutes to update.
Please keep in mind that all sites using this MySQL user will immediately stop functioning until all configuration files are updated to the new password.
Review your software's help documentation for information about this file.