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, 2314🔥, 0💬
Popular Posts:
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...