I have tried this:
PHP Code:
$forge = \Config\Database::forge();
$forge->createDatabase('test_1002');
and this:
PHP Code:
$dbName = 'test_1002';
$sql = "CREATE DATABASE {$dbName}";
$query = $this->db->query($sql);
and I get:
PHP Code:
CRITICAL - 2025-05-06 03:35:45 --> [Caused by] mysqli_sql_exception: Access denied for user 'development'@'%' to database 'test_1002'
The server is Liquid Web Alma Linux, Maria DB, Plesk... the db user has full access to all functions and all databases.
I can create a db over ssh but it doesn't show up to Plesk, because Plesk only tracks it's own databases.
Does anyone know how to get past this, and create Plesk visible databases with CI4?
