On 6/9/06, Dilipkumar <[EMAIL PROTECTED]> wrote:
Hi,
Please check the data directory where u have started your mysql has
permission ( mysql:mysql )
U would have started your ur mysql ar root user and when u create a
database which has
no permission as (mysql) in data directory.
This might help you out.
Kaushal Shriyan wrote:
> Hi ALL
>
> I am faced with a issue of creating database , The issue is I am able
> to enter to the MySQL Server with the password, but when i try to
> create database I get Access Denied
>
> Below are the details
>
> [EMAIL PROTECTED] root]# mysql -u root -p
> Enter password:
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 17 to server version: 3.23.54
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> exit
> Bye
> [EMAIL PROTECTED] root]# mysqladmin -u root -p create kaushal
> Enter password:
> mysqladmin: CREATE DATABASE failed; error: 'Access denied for user:
> '[EMAIL PROTECTED]' to database 'kaushal''
>
> Any Clue will be really appreciated
>
> Thanks
>
> Kaushal
>
--
Thanks & Regards,
Dilipkumar
DBA Support
********** DISCLAIMER **********
Information contained and transmitted by this E-MAIL is proprietary to
Sify Limited and is intended for use only by the individual or entity to
which it is addressed, and may contain information that is privileged,
confidential or exempt from disclosure under applicable law. If this is a
forwarded message, the content of this E-MAIL may not have been sent with
the authority of the Company. If you are not the intended recipient, an
agent of the intended recipient or a person responsible for delivering the
information to the named recipient, you are notified that any use,
distribution, transmission, printing, copying or dissemination of this
information in any way or in any manner is strictly prohibited. If you have
received this communication in error, please delete this mail & notify us
immediately at [EMAIL PROTECTED]
Watch India vs. England LIVE, Hot videos and more only on Sify Max! Click Here.
www.sifymax.com
Get to see what's happening in your favourite City on Bangalore Live!
www.bangalorelive.in
Hi Dilip
Below are the permissions
[EMAIL PROTECTED] mysql]# pwd
/var/lib/mysql
[EMAIL PROTECTED] mysql]# ll
total 16
drwx------ 2 mysql mysql 8192 Jun 8 21:29 drupal
drwx------ 2 mysql mysql 4096 Jun 7 19:51 mysql
srwxrwxrwx 1 mysql mysql 0 Jun 9 12:49 mysql.sock
drwx------ 2 mysql mysql 4096 Jun 7 19:51 test
[EMAIL PROTECTED] mysql]#
I have the same set up in other linux box its working there perfectly
Any Clues
Kaushal
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
