Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorial - CREATE Command Denied Error

By: FYIcenter.com

(Continued from previous topic...)

What Happens If You No CREATE Privilege in a Database?

In order to create tables in a database, your user account must have the CREATE privilege for that database. Otherwise you will get an error as shown in the following tutorial exercise:

>cd \mysql\bin
>mysql -u guest -ppub

mysql> use fyi;
Database changed

mysql> CREATE TABLE test (id integer);
ERROR 1142 (42000): CREATE command denied to user 
   'guest'@'localhost' for table 'test'

If you get this error, you need to see the DBA to obtain the CREATE privilege.

(Continued on next topic...)

1. What Are DDL Statements?
2. How To Create a New Table?
3. What Happens If You No CREATE Privilege in a Database?
4. How To Get a List of All Tables in a Database?
5. How To Get a List of Columns in an Existing Table?
6. How To See the CREATE TABLE Statement of an Existing Table?
7. How To Create a New Table by Selecting Rows from Another Table?
8. How To Add a New Column to an Existing Table?
9. How To Delete an Existing Column in a Table?
10. How To Rename an Existing Column in a Table?
11. How To Rename an Existing Table?
12. How To Drop an Existing Table?
13. How To Create an Index for a Given Table?
14. How To Get a List of Indexes of a Given Table?
15. How To Drop an Existing Index?
16. How To Create a New View?
17. How To Drop an Existing View?