next »

[deven_01]

Dear Friends
 recently I installed mysql server
 When I was given following command on mysql> prompt I got following error

 mysql> create database my_db
ERROR 1006 (HY000): Can't create database 'my_db' (errno: 28)

 pls try to solve it ASAP
 Regards
 Devendra

[Ricky]

This is permission error. Kindly look the persmission structure of datadir.

[gauravbajaj]

It seems that the user doesn't have appropriate permissions

You should give permissions to that user first..

Login  to mysql and give

#GRANT ALL PRIVILEGES ON *.* TO username@'localhost' {..where locahost is your machine name where mysql is running.., you can give also ipaddress in place of that }

Gaurav

   Recommend LS
   Linux User Around