Can't create database

Lpin · #1 (**permalink**) 02-16-05, 22:02

hi....
i have a problem using mysql on linux fedora.
i can't create database. when i try to create one, an error ocurred:
Can't create database 'databasename'

can anyone help me, pliz..

thx in advance

guelphdad · #2 (**permalink**) 02-16-05, 23:36

on your own computer?
are you logged into mysql as root?
if a user other than root does that user have permissions to create a table?

Lpin · #3 (**permalink**) 02-17-05, 01:25

yup, the mysql is on my comp. and i logged into mysql as root.
no other user except root on mysql.

msueper · #4 (**permalink**) 02-17-05, 13:32

Is "databasename" a valid name for an os folder?
Since mysql stores databases as folders this is necessary.
You also need write permission on datadir.

Internet Services

Web Development

Digital Marketing

Consumer Tech