Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
What Happens If You No CREATE Privilege in a Database
What Happens If You No CREATE Privilege in a Database? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements
✍: 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.
2007-05-11, 4882👍, 0💬
Popular Posts:
How To Increment Dates by 1? - Oracle DBA FAQ - Understanding SQL Basics If you have a date, and you...
Write out a function that prints out all the permutations of a string. For example, abc would give y...
What is the difference between "printf(...)" and "sprintf(...)"? sprintf(...) writes data to the cha...
Which bit wise operator is suitable for turning on a particular bit in a number? The bitwise OR oper...
What are shared (VB.NET)/Static(C#) variables? Static/Shared classes are used when a class provides ...