How to make a new database?

[koju]

Hi!
I'm a new serverbeach member and I got a problem with adding a new database in my phpMyAdmin... While adding a new one directly from phpMyAdmin I only get an error like this:
---------
Database mybase running on localhost
Error

SQL-query :

CREATE DATABASE `mybase`

MySQL said:


Can't create database 'mybase'. (errno: 13)
---------
Maybe I should add it in other way - not from phpMyAdmin?
If someone could help me...

BK

[QT]

What user are you logging in to phpmyadmin with? You need to be logged in as root or a user with root priviledges.

[koju]

Well... I am a root... That is why I don't know what's going one? I can add new users with all privileges and add everything to existing bases... but a new one? no! hymmm...

[Tino Didriksen]

Maybe the MySQL DB dir is not chmod'ed to allow MySQL to create new dirs...unlikely, but worth checking.

[koju]

Heheh...
You know that this is it? Hym... Thanks! :D :p

[dhigbee]

koju,

You should note. If you create a database in any other means other than Plesk, the existence of the database will not show up under the domains databases tab, nor will it be documented in the psa database.

If you are setting up a database that is owned by a Plesk user, I suggest you first create it with Plesk than use phpMyAdmin to set up your tables.

Don