Tengo esta fraccion de codigo en PHP para conectarme a MySQL
//MYSQL
$servername = “localhost”;
$username = “xxx”;
$password = “xxx”;
$db_name = “xxx”;
$conn = new mysqli($servername, $username, $password);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
echo “Connected successfully”;
echo “
”;
$sql = “INSERT INTO dtu2(id, dolar, fecha) VALUES (’”.$dv."’, ‘".$fv."’)";
if (mysqli_multi_query($conn, $sql)) {
echo “New records created successfully”;
} else {
echo "Error: " . $sql . “
” . mysqli_error($conn);
}
mysqli_close($conn);
y tengo esta respuesta de vuelta
Connected successfully
Error: INSERT INTO dtu2(id, dolar, fecha) VALUES (‘2951374.61’, ‘2018/06/24 23:21:00’)
Access denied for user ‘id6272691_dtu2’@’%’ to database ‘information_schema’
Alquien podria ayudarme.
Muchas gracias