Overview
On DreamHost Shared MySQL and MySQL VPS servers, some of the SQL commands are not available for scripting nor in phpMyAdmin. Their functionality is available instead through the DreamHost control panel. These include:
- CREATE DATABASE
- GRANT
- REVOKE
Additionally, some SQL objects are not available or supported on DreamHost Shared MySQL servers. These include:
- Functions
- Triggers
Functions and triggers are available on MySQL VPS servers. They're also available on Dedicated servers with MySQL running locally.
MySQL privileges table
The following table summarizes available DreamHost MySQL user privileges.
The following table relates to Shared MySQL as well as MySQL VPS servers. It does NOT apply if you upgrade to a Dedicated server, where the MySQL database is on the local machine.
| Privilege | Meaning | Availability |
|---|---|---|
| ALL [PRIVILEGES] | Grant all privileges at specified access level except GRANT OPTION | NO |
| ALTER | Enable use of ALTER TABLE | YES |
| ALTER ROUTINE | Enable stored routines to be altered or dropped (Only if you are the user@host DEFINER that created the routine) | YES |
| CREATE | Enable database and table creation (Only tables can be created, Databases must be created in the control panel) | YES |
| CREATE ROUTINE | Enable stored routine creation (Cannot set DEFINER as non-root user, please remove DEFINER='user'@'host' combo to create routines) | YES |
| CREATE TEMPORARY TABLES | Enable use of CREATE TEMPORARY TABLE | YES |
| CREATE USER | Enable use of CREATE USER, DROP USER, RENAME USER, and REVOKE ALL PRIVILEGES | NO |
| CREATE VIEW | Enable views to be created or altered | YES |
| DELETE | Enable use of DELETE | YES |
| DROP | Enable databases, tables, and views to be dropped | YES |
| EVENT | Enable use of events for the Event Scheduler | NO |
| EXECUTE | Enable the user to execute stored routines | YES |
| FILE | Enable the user to cause the server to read or write files (unnecessary, if you get this error you are likely using "LOAD DATA INFILE" and should use "LOAD DATA LOCAL INFILE" instead) | NO |
| GRANT OPTION | Enable privileges to be granted to or removed from other accounts | NO |
| INDEX | Enable indexes to be created or dropped | YES |
| INSERT | Enable use of INSERT | YES |
| LOCK TABLES | Enable use of LOCK TABLES on tables for which you have the SELECT privilege | YES |
| PROCESS | Enable the user to see all processes with SHOW PROCESSLIST (shows only your specific MySQL user's processes) | YES |
| REFERENCES | Not implemented | NO |
| RELOAD | Enable use of FLUSH operations | NO |
| REPLICATION CLIENT | Enable the user to ask where master or slave servers are | NO |
| REPLICATION SLAVE | Enable replication slaves to read binary log events from the master | NO |
| SELECT | Enable use of SELECT | YES |
| SHOW DATABASES | Enable SHOW DATABASES to show all databases (Only shows those databases you have access to) | NO |
| SHOW VIEW | Enable use of SHOW CREATE VIEW | YES |
| SHUTDOWN | Enable use of mysqladmin shutdown | NO |
| SUPER | Enable use of CHANGE MASTER TO, KILL, PURGE BINARY LOGS, and SET GLOBAL statements, the mysqladmin debug command; allows you to connect (once) even if max_connections is reached | NO |
| TRIGGER | Shared: Allow existing triggers to be used (creating of new triggers is not supported) MySQL VPS: Enable triggers to be created or dropped (cannot set DEFINER as non-root user; remove DEFINER='user'@'host' combo to create trigger instead) |
YES |
| UPDATE | Enable use of UPDATE | YES |
| USAGE | Synonym for “no privileges” | NO |
