Re: problem

[vinita vigine Murugiah]

HI
    You may NOT have create privileges.

check your privileges by doing show grants for <username>@<host>;

You can give CREATE privileges for databases & tables

GRANT CREATE ON *.* To <username> IDENTIFIED BY '<passwd>'

Refer to http://www.mysql.com/doc/en/GRANT.html

Phung Huu Phu wrote:

>Dear Sir or Madam:
>I have installed MySQL database to Sun Enterperise 250 with Solaris 8
>OS.
>I can run database server and query but I can't create database.
>Please tell me know how can I correct it ?
>Thank in advance.
>Phu
>
>
>---------------------------------------------------------------------
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/           (the list archive)
>
>To request this thread, e-mail <mysql-thread121570@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-vinita=cs.mu.oz.au@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>