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, 4725👍, 0💬
Popular Posts:
How was XML handled during COM times? During COM it was done by using MSXML 4.0. So old languages li...
What are the five levels in CMMI? There are five levels of the CMM. According to the SEI, Level 1 – ...
How do we host a WCF service in IIS? Note: - The best to know how to host a WCF in IIS is by doing a...
What will the following piece of code do? int f(unsigned int x) { int i; for (i=0; x!=0; x>&a...
How To Use "IN OUT" Parameter Properly? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and F...