Pull Request for Issue # .

Summary of Changes

When installing Joomla using a database user who has the privilege to create a database on the specified database server and specifying a database name for which no database exists, the installation should create that database.

This currently might work with MySQLi, but not with MySQL (PDO) or PosgreSQL (PDO).

This Pull Request (PR) fixes that.

At least for PosgreSQL (PDO) I think it never has been working, except maybe for very old versions, because all information I found says that it is not possible to connect to a PostgreSQL server without specifying a database. So this PR here uses the 'postgres' database which is installed with a default PostgreSQL installation.

Testing Instructions

Requirements

1. A database which fulfills the minimum server version requirements as they are

• MySql: 5.6
• MariaDB: 10.1
• PostgreSQL: 11.0

2. A database user who has the privilege to create a database on that server with that kind of connection, e.g. on a standard installation of

• MySql: user 'root' on host 'localhost'
• MariaDB: no idea
• PostgreSQL: user 'postgres'

3. This PR has to be tested with the PDO drivers, i.e. database type MySQL (PDO) or PosgreSQL (PDO). Of course if you have a MySQL or MariaDB database, you can test in addition if this PR doesn't break anything when using the MySQLi driver.

Instructions

Start a new Joomla 4 installation without the patch of this PR applied, using a database server and user combination which allows to create a new database, and a database name for which no database exists on that server.

Result: See section "Actual result" below.

Do the same with the patch of this PR applied.

Result: See section "Expected result" below.

Expected result

A new database with the specified name is created on the specified server, and the installation finishs with successs, if everything else is right.

Actual result

With MySQL (PDO):

With PostgreSQL (PDO):

Documentation Changes Required

Maybe somewhere is written that installing a new database doesn't work when using PostgreSQL (PDO)? If so, this has to be changed.

Additional information

This PR doesn't fix the fact that a database will also be created with MySQL (PDO) or PosgreSQL (PDO) when the server doesn't fulfill the minimum version requirement because that check is done after database creation. This issue I plan to fix with another, future PR.