Jump to content

[SOLVED] 'Access Denied' to MySQL database - a simple problem for an expert

codequirks

By codequirks
in MySQL Help

Recommended Posts

codequirks Newbie

codequirks

Posted
Posted

Hi there

 

I am a little new to php having been working in the dark world of databases for many years. I am in the process of creating my first website but whilst the php and the database stuff work great I cannot get the two to talk. The error is: DB connection failed: Access denied for user 'phpaccess'@'localhost' (using password: YES). I think this is likely just a small config or privilege tweak - can any of you experts help? The user is  'phpaccess'@'%' and only has select privilege on db_mydatabase - nothing else

 

As always thanks for your time in advance and code below, php 5.2, MySQL 5.1:

 

----Test PHP File
<HEAD><TITLE>HTML, PHP, MySQL Test Page</TITLE></HEAD>
<BODY>
<?PHP
//Run phpinfo to make sure MySQL is loaded and working
    phpinfo();
    
//Set up database connection parameters
    $myServer = "127.0.0.1";
    $myUser = "phpaccess";
    $myPass = "phppassw0rd";
    $myDB = "db_mydatabase";
        
//Open mySQL connection with all errors reported
    ini_set('display_errors', 1);
    error_reporting(E_ALL);
    $connection = mysql_connect($myServer, $myUser, $myPass);
    if (!$connection)
    {
       die("DB connection failed: " . mysql_error());
    }

//Activate database and then query the table
    $activedb = mysql_select_db($myDB, $connection) or die ("Couldn't open database");
    $query = mssql_init("SELECT * FROM `tb_users`", $connection);
    $result = mssql_execute($query);
    echo "success";

    mysql_close($connection);
?>

codequirks Newbie

codequirks

Posted
  • Author
Posted

Ok - We have a solution:

 

Thanks Mr Bolson - I did have to change the server to localhost but also had to change the users login from 'phpaccess'@'%' to 'phpaccess'@'localhost'

 

And then it all suddenly worked!

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.