Collections:
CREATE Command Denied Error in MySQL
What Happens If You No CREATE Privilege in a Database in MySQL?
✍: FYIcenter.com
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.
⇒ Show All Tables in a Database in MySQL
⇐ CREATE TABLE Statement in MySQL
2018-03-10, 2298🔥, 0💬
Popular Posts:
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...