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, 2848🔥, 0💬
Popular Posts:
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
Where Is the Export Dump File Located in Oracle? If you are not specifying the dump directory and fi...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...