PHP + MySQL Error

thekidscareya

I have this code:

<?php
include "mysql.php";

$link = mysql_connect($db_host, $db_user, $db_pass) or die("CONNECT ERROR".mysql_error());
mysql_select_db($db, $link) or die("SELECT DB ERROR".mysql_error());


$sql = "SELECT * FROM `tbl_html` WHERE `id` = '5' LIMIT 1";
$query = mysql_query($sql) or die("QUERY ERROR ".mysql_error());
$row = mysql_fetch_array($query);
echo $row['html'];

?>

When I execute the script I get:

QUERY ERROR Access denied for user: 'user@localhost' to database 'db'

What's wrong?

nemonoman

You haven't set values for these variables,
($db_host, $db_user, $db_pass)

they don't provide access to the database.

You can do all the MySQL db management from within PHP, but simpler is to use an admin program like phpMyAdmin to get started.

Use phpMyAdmin to create the databases, and to create a username and password that you will use for accessing the database via mysql_connect.

thekidscareya

I have values set for those variables in the mysql.php file. When I do a test echo of those variables, it shows my mysql details.

EDIT: I think I misunderstood you. I don't have PHPmyadmin...and nor do I have root access. How would I grant priveledges to let $db_user access $db?

thanks

nemonoman

the file may have those values, but your MySQL database hasn't been set up to accept them.

You need to make sure that the database exists, and that the user exists, and the user has access for the host, and that the user has access privileges to the database.

This is SLIGHTLY complicated, so I recommended creating the user privileges, etc., using phpMyAdmin.

Then you need to make sure that the values stored in mySQL exactly match the values stored in:
"mysql.php";

thekidscareya

What if i were able to execute a query while logged in as root in mysql...how would I grant all priveledges?

GRANT ALL PRIVELEDGES TO user@localhost

is that it?

btw, i know the database and username exists

nemonoman

You would probably want to spell 'privileges' correctly, for starters.

If you are connecting to a server where some admin has given you access to mysql, then you will need to connect using the username and password given you by the admin.

Some admins prefer using '127.0.0.1' as the host rather than 'localhost'.

The admin probably sent some information about this to you.

You need to rewrite the settings in your setup file to match exactly the username, password, host, and db names given to you by the admin.

thekidscareya

Is this correct:

GRANT ALL PRIVILEGES ON <database>.* to '<username>'@'localhost' IDENTIFIED BY '<password>'