Db connection error?

[cdevl3749]

Good evening,

I receive this error message (see print screen).
I think the connection line is correct? I created the db in phpAdmin.

Do you have an idea ?

<?php
// Debugging
ini_set('error_reporting', E_ALL);

// DATABASE INFORMATION
define('DATABASE_HOST', getenv('IP'));
define('DATABASE_NAME', 'invoicemgsys');
define('DATABASE_USER', 'root');
define('DATABASE_PASS', '');

// CONNECT TO THE DATABASE
$mysqli = new mysqli(DATABASE_HOST, DATABASE_USER, DATABASE_PASS, DATABASE_NAME);
?>

[Martyr2]

I think it is pretty explanatory, you are not using the right credentials. Are you sure root with an empty password is going to log you in? Have you tried using localhost instead of getenv('IP')?

The error basically tells you the credentials are wrong. So try some others.

[m_hutley]

@Martyr2

The error basically tells you the credentials are wrong. So try some others.

Better yet, make some others. Dont use root to access your database.

[cdevl3749]

Good morning,

I changed user with a password and I still get an error message

Do you have an idea ?

// DATABASE INFORMATION
define('DATABASE_HOST', getenv('localhost'));
define('DATABASE_NAME', 'invoicemgsys');
define('DATABASE_USER', 'cdevl');
define('DATABASE_PASS', '12kirsi5');

// CONNECT TO THE DATABASE
$mysqli = new mysqli(DATABASE_HOST, DATABASE_USER, DATABASE_PASS, DATABASE_NAME);

[m_hutley]

@cdevl3749

define('DATABASE_HOST', getenv('localhost'));

define('DATABASE_HOST', 'localhost');

(Assuming your database is running on localhost…)

[cdevl3749]

@m_hutley

Assuming your database is running on localhost…)

I still have the same error message.

I do this well: define(‘DATABASE_HOST’, ‘localhost’);

and it’s on localhost

[Thallius]

Try “127.0.0.1” instead of localhost.

[m_hutley]

Have you changed the port number? Why does your PHPMyAdmin register that it’s connected to 3308? The default should be 3306.
Have you got multiple instances of MariaDB/MySQL running?

[cdevl3749]

@m_hutley

Have you changed the port number? Why does your PHPMyAdmin register that it’s connected to 3308? The default should be 3306.
Have you got multiple instances of MariaDB/MySQL running?

yes I had a problem and I had to change port.

Should I change a few things?

[m_hutley]

$mysqli = new mysqli(DATABASE_HOST, DATABASE_USER, DATABASE_PASS, DATABASE_NAME);
=>
$mysqli = new mysqli(DATABASE_HOST, DATABASE_USER, DATABASE_PASS, DATABASE_NAME, 3308);

(obviously, if you want to define a constant for it, you could)

[cdevl3749]

great thank you, it works like that.

Does it pose a problem afterwards when I want to transfer everything to my host?

[m_hutley]

If your host is running on the default port, obviously you’ll have to change the port back. If you leave the port variable empty (like you did for the original line), PHP will assume 3306 as a default.

[cdevl3749]

ok thank you very much for your help.

Good Sunday

[sibertius]

@cdevl3749

Do you have an idea ?

I am used to add DATABASE_PORT also. But DATABASE_HOST may contain the database port?