Default MySQL database name

Question

I'm trying to install mybb on a server but the admin is taking too long to respond. I have all the information I need except the database name. Is there a default name for mysql on a linux server?

score 22 · Accepted Answer · answered Aug 09 '11 at 19:54

22

There is no default database.

A fresh MySQL server install will have 0 databases. The install script will run mysql_install_db after the server is running to create a mysql database, which MySQL uses to store users and privileges. Don't put your data there.

You can create your own databases by issuing CREATE DATABASE [name] queries if your user has permission.

answered Aug 09 '11 at 19:54

Dan Grossman

51,866
10
112
101

0 databases, with the exception of information_schema, of course. – djdy Aug 09 '11 at 21:03
7

Let me put it this way - A fresh MySQL server and MySQL shell install will have the following 4 databases: (Version 5.5.42): 1. information_schema 2. mysql 3. performance_schema 4. test – StackOverFlow User Jul 15 '15 at 08:45

score 3 · Answer 2 · answered Aug 09 '11 at 19:55

3

No there is not...............

answered Aug 09 '11 at 19:55

Mchl

61,444
9
118
120

score 1 · Answer 3 · edited Jul 12 '18 at 14:23

1

Do you have full database access? Then just add a database with a name of your choice:
```
CREATE DATABSE rob_bb;
```
If you only have a normal user access, the database name is often the same as the username.
Or you can run the query
```
SHOW DATABASES;
```

to see what databases exist (which you are allowed to see).

edited Jul 12 '18 at 14:23

TRiG

10,148
7
57
107

answered Aug 09 '11 at 20:10

Puggan Se

5,738
2
22
48

1

where would i enter these commands? right now i have ftp access, and (i think) ssh – Rob Aug 09 '11 at 20:15
1

if you ssh in, you can use the command "mysql -p" to login to mysql. if you only have ftp, you can add a script file, for example php: – Puggan Se Aug 10 '11 at 06:48

score 0 · Answer 4 · answered Aug 09 '11 at 21:00

0

There are no default databases. If you were asking about default users 'root' would be it.

answered Aug 09 '11 at 21:00

Falcata

679
1
15
23

Basil Bourque · Answer 5 · 2023-08-14T01:25:13.553

No default database in MySQL

MySQL does not create a database by default for you. If connecting to a fresh MySQL server, you will find four databases existing, described below.

4 databases in MySQL

When first connecting to a new MySQL 8.1 server on a terminal, like this:

mysql -u root -p -h localhost

… at the prompt you can issue this SQL command to see all existing databases:

SHOW DATABASES ;

You will find four databases:

+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

The first is required by the SQL standard: information_schema. See Wikipedia. See doc.
performance_schema is a feature for monitoring MySQL Server execution at a low level. See doc.
sys is a set of objects that helps DBAs and developers interpret data collected by the Performance Schema. See doc.

We can then create a database for our own purposes.

CREATE DATABASE bogus_ ;

Default MySQL database name

5 Answers5

No default database in MySQL

4 databases in MySQL

Linked