November 25, 2024, 05:20:58 AM

News : LinuxSolved.com Linux Help Community Forum..

 

« previous next »
Pages: [1]

Author Topic: MySql database error  (Read 6346 times)

Offline deven_01

  • Linux Learner
  • ***
  • Posts: 143
MySql database error
« 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
Logged

Offline Ricky

  • LST CareTaker
  • Specially Skilled
  • *****
  • Posts: 2381
MySql database error
« Reply #1 on: July 27, 2006, 11:28:55 AM »
This is permission error. Kindly look the persmission structure of datadir.
Logged

Offline gauravbajaj

  • LST CareTaker
  • Experienced
  • *****
  • Posts: 658
MySql database error
« Reply #2 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
Logged
Pages: [1]
« previous next »