Mysql/PHP Access Denied

Swaggots · Jan 30, 2015

So i'm working on this thing. I got this php code :

Code:

<html>

<head>

</head>

<body>

<?php
    $con = mysql_connect("xxxhostxxx","xxxuserxxxx","xxxpassxxx");
    if (!$con) {
        die("Cannot connect: " . mysql_error());
    }

    if(mysql_query("CREATE DATABASE snippets", $con)) {
        echo "Database created";
    }
    else
        echo "Error: " . mysql_error();

    mysql_close($con);
?>


</body>

</html>

but when i'm checking the page out online, it gives me the following error:

Error: Access denied for user 'xxxxx'@'10.1.1.27' to database 'snippets'

Thanks for the help guys

Ecko · Jan 30, 2015

Which user are you logging in with? Since the database is created right there in the script, it probably doesn't have privileges to that database.

Unidentified · Feb 3, 2015

Make sure you set the MySQL IP address to a wildcard connection (if it's hosted on web hosting) or try and use local host if it is on your local host

Balls · Feb 7, 2015

If you are trying to create a database through php:

PHP:

<?php

try{
    $con = new PDO('mysql:host=localhost','root','password');
   
    $con->exec("CREATE DATABASE snippets;");
               
}catch (PDOException $e) {
    die("Error: ". $e->getMessage());
}
?>

Mysql/PHP Access Denied

Swaggots

Member

Ecko

23:37 [autobots] -!- eckostylez [[email protected]]

Unidentified

Living the Developer Life...

Balls

Member

Users who are viewing this thread

Latest posts

Connect with us

Newest members