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, 2402🔥, 0💬
Popular Posts:
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...