Error while conecting to mysql

[osmellr]

Hello, i am triying to conect to mysql whith MySQL hostname:sql212.epizy.com,

MySQL username:epiz_29864924 and my password, i cannot connect and receive this error:
conexion fallida: Access denied for user ‘epiz_29864924’@‘192.168.2.193’ (using password: YES)

(other information and details relevant to your question)

[wackyblackie]

Can you share the code you use to connect? Remember to remove the password and any other sensitive informations.

[osmellr]

<?php $mysqli = new mysqli("sql212.epizy.com", "epiz_29864924", "MyDBpass", "epiz_29864924_loto"); /* comprueba la conexión */ if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } /* devuelve el nombre de la base de datos actualmente seleccionada */ if ($result = $mysqli->query("SELECT DATABASE()")) { $row = $result->fetch_row(); printf("Default database is %s.\n", $row[0]); $result->close(); } /* cambia de test bd a world bd */ $mysqli->select_db("world"); /* devuelve el nombre de la base de datos actualmente seleccionadae */ if ($result = $mysqli->query("SELECT DATABASE()")) { $row = $result->fetch_row(); printf("Default database is %s.\n", $row[0]); $result->close(); } $mysqli->close(); ?>

it is only a conection test…

[wackyblackie]

Your code has errors:

Sorry, I removed the comments.

[osmellr]

just conecting to database with:

$mysqli = new mysqli(“sql212.epizy.com”, “epiz_29864924”, “3jm9f8z2”,
“epiz_29864924_loto”);
/* comprueba la conexión */
if (mysqli_connect_errno()) {
printf(“Connect failed: %s\n”, mysqli_connect_error());
exit();
} else {echo “connection ok”;}
$mysqli->close();

get the same error: Warning : mysqli::__construct(): (HY000/1045): Access denied for user ‘epiz_29864924’@‘192.168.2.193’ (using password: YES) in /home/vol12_2/epizy.com/epiz_29864924/htdocs/parser/prueba.php on line 5

[osmellr]

Fixed… just eliminated database and create new one… thanksss