I am having trouble connecting to a MySQL database for a PHP script

Namadoor

Okay, here is the problem. I have made a database for my site called Site. I have made two tables, and a few colums in each table, to store data on members for my site. The script is suppost to connect to MySQL database, and place the data in the correct tables and colums. I have set up a user for for this script. The user is siteuser identified by the password siteuser (I will change this later).

This is what the user's privlegies are, for that entire database...
(I got this using the show frants for siteuser; command)

It says:
GRANT USAGE ON . TO 'siteuser'@'%' IDENTIFIED BY PASSWORD '04d0daa20a38e6fe'

GREANT SELECT, INSERT, UPDATE ON Site.* TO 'siteuser'@'%'

Then I have this PHP code to connect to the database:

	$Iconnection = mysql_pconnect("192.168.1.250","siteuser","siteuser");
	if (!$Iconnection)	{
		echo "<b>ERROR:</b> Cannot connect to the database<br>";
	}

I always get an error:
Warning: Access denied for user: 'siteuser@localhost' (Using password: YES) in /home/mark/public_html/functions.php on line 5

And then my own error:
ERROR: Cannot connect to the database

Why is this happining?

mykg4orce

Do you have the proper access to the DB? Can you connect to it from phpMyAdmin?

Namadoor

I don't quit understand what you mean. How do you set acsess for the database or something?

mykg4orce

in your post you said, that you made the database, well how did you make it? Did you use shell or did you use phpMyAdmin?

Because your error code tells me that either, the username and password or the database name is incorrect. Thats why it can't connect.

Namadoor

Well, I used MySQL from the command line to create it...

That username, the password, and the database all excist. I am getting an Access denied error, I tried making another user with the same privliges, and tried connecting him, but I still got the Access denied error.

mykg4orce

ok you might try to add mysql_select_db like here:

//config
$dbuser = "gmoney";
$dbpassword = "moneypile";
$dbname = "thebank";

$dbconn = mysql_connect("localhost", "$dbuser", "$dbpassword")
	or die("Could not connect");
$result = mysql_select_db("$dbname", $dbconn)
 or die("Could not connect");
$query = "Do your query";
$result = mysql_db_query("$dbname", $query);			
if ($result) {
//statements
	}

other reference:

http://www.php.net/manual/en/ref.mysql.php

Namadoor

I still get Access denied. 🙁

mykg4orce

i suggest you try to get phpMyAdmin and administer your database that way. It will also clear up if its a access problem or something else...

Namadoor

So where do you get that?

Namadoor

Is there anyone who knows why this is happeneing, and how to fix it without usgin PHPmyAdmin?

When I try to log that user in from the command line I get Access denied aswell.

duckman

Did your reload MySQL. Any new, updated or deleted privileges won't be active until your actively reload the MySQL-server. From commandline: start mysql and do a "FLUSH PRIVILEGES;". In PhpMyAdmin you can use "Reload MySQL" on the first page.

Jasper

Namadoor

Okay, I got around that problem, I tried useing a wild card (ex siteuser@% instead of siteuser@localhost), but now the quires are failing.

I have this PHP code:

	$query = "select * from where username = '$username' ";
	$result = mysql_query($query);
	if (!$result)	{
		echo "<b>ERROR:</b> Could not get query...<br>";
		return false;

But I get the error that I set, ERROR: Could not get query...

jasper

Seems like the tablename is missing between 'from' and 'where'

Namadoor

How could I be so stupid?
Okay, everything works now 😃, thanks for your help.