CREATE Command Denied Error in MySQL
What Happens If You No CREATE Privilege in a Database in MySQL?
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
⇑ CREATE, ALTER and DROP Statements in MySQL
2018-03-10, 1378👍, 0💬
How To Recreate an Existing Index in SQL Server? If you want to change the definition of an existing...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
Where to find answers to frequently asked questions on Using INSERT, UPDATE and DELETE Statements in...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...