Linux Forums - Linux Help,Advice & support community:LinuxSolved.com

Network Troublshooting => Linux Servers Support => Topic started by: deven_01 on July 27, 2006, 09:37:31 AM

Title: MySql database error
Post by: deven_01 on July 27, 2006, 09:37:31 AM

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

Title: MySql database error
Post by: Ricky on July 27, 2006, 11:28:55 AM

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

Title: MySql database error
Post by: gauravbajaj on July 31, 2006, 01:50:53 AM

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