Testing further i think i Just got the root of the problem, indeed there is something wrong with the file connect_db_mysqli.inc as gnurob mentioned, when you use a password on the user database that is 21 or more characters long this script fail in the setup, a password less than 21 character will connect successfully go to next steps and install the application.
I could prove that is the script failing and not the database, because i also test hardcoding the password in the line 205 of the file connect_db_mysqli.inc, If you hardcode the password and run the setup no matter if password is 21 o more characters long it will succeed.
I change this line
$db = mysqli_connect($connection["host"], $connection["dbuser"], $connection["dbpassword"], "",
!empty($connection["port"]) ? $connection["port"] : 3306); // default port in mysql is 3306
For this line
$db = mysqli_connect($connection["host"], $connection["dbuser"], "your_hard_code_pass_here", "",
!empty($connection["port"]) ? $connection["port"] : 3306); // default port in mysql is 3306
So in conclusion:
- There is something wrong in the logic of the code on the file connect_db_mysqli.inc at line 205 (db_create_db function), that is not passing the correct password to the database if password is 21 characters or more.
Workaround:
- Use a password less than 21 characters for the database user.
Hope this is could help, and some of the developers can test, confirm and fix this issue