Software Development:
Individual Programming

Solution

In a Bitpalace Small Enterprise Server you can create as many additional databases as you like (only limited by the available disk space). You could login as "root" on phpMyAdmin. The root user has all privileges to create new databases and logins.

Experienced users often prefer the Linux console. While the graphical gimmicks are missing, it is much faster and easier to create a new database on it. This is how it works:

1. Log-in to your server by SSH.

2. Start the MySQL console:

mysql -u root -p

3. Create a new database:

create database [Datenbankname];

4. Create a login name and a password for the new database. The following example shows how you can create a user account that can only access the database from localhost:

grant all privileges on [databasename].* to [loginname]@localhost identified by [password]

Instead of [databasename], [loginname] and [password] enter values of your choice.

5. Activate the new login credentials:

flush privileges;

6. Exit the MySQL console:

exit;

Overview of frequently asked questions