[RESOLVED] Database Connection Issue

OmegaB

I have a file called db_config.php, which reads like this :

<?php
	$db_host = "localhost";
	$db_user = "root";
	$db_password = "f00";
	$db_name = "buzzdb";
?>

and another one called temp_con.php, which reads like this :

<?php
	require("db_config.php")
	$connection = mysql_connect($db_host, $db_user, $db_password, $db_name) or die("error connecting");
	echo "connection made";
?>

The thing I want to do is make temp_con.php read the db_config.php, setting the variables and then using those variables to login to my database.
However I get this error,

Parse error: syntax error, unexpected T_VARIABLE in C:\XAMPP\htdocs\temp_con.php on line 3

What's wrong? Thanks for helping 🙂

dagon

missing semi colon on line 2

OmegaB

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in C:\XAMPP\htdocs\temp_con.php on line 3
error connecting

I do have a record of
Host : localhost
User : root
Password : f00

In the table 'users' , which is in the database 'mysql',
and the database 'buzzdb' does exist,
yet it still won't connect, using the same code as above with the added semicolon on line 2.

bradgrafelman

Can you use the same credentials and successfully connect using MySQL's CLI utility (mysql.exe on Windows)?

OmegaB

I am using XAMPP, and it includes MYSQL and Apache...but
when I go to C:\XAMPP\mysql\bin and type in command prompt 'mysql' to open mysql
it gives me this error,

ERROR 1405 <28000>: Access denied for user 'ODBC'@'localhost' <using password: NO>

Should I just reinstall the whole thing again or just download MYSQL and Apache seperately?

bradgrafelman

You didn't specify the user and password parameters, so it's going to attempt to use the default (ODBC with a blank password, as shown in the error message).

Try doing something like "mysql.exe --user=root --password=f00" instead. If that doesn't work, then apparently you've got the wrong password.

OmegaB

Thanks that worked, but root did not work. I think that's reserved to be default without password only or something.

I created another user as php and password as f00 and that worked.

But back to the second problem:

Changing '$db_user = root' to '$db_user = php'
In db_config.php still does not fix the problem.
When $db_user is specified as 'php'
This error still pops up

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in C:\XAMPP\htdocs\temp_con.php on line 3
error connecting

even though I'm not trying to login with 'root'.

And there is a record for
Host : localhost
User : php
Password : f00

In the table 'users' which is in the database 'mysql'.

bradgrafelman

Well PHP doesn't lie, and since the default username is 'ODBC' then you must be specifying 'root' somewhere. Are you sure you edited and saved the correct file? Do you define $db_user anywhere else?

OmegaB

No I can't find anywhere that defines $db_user

However, when I replace all the variables ($db_user, $db_host,$db_password)
with just strings (php, localhost,f00) respectively, then I can login. The connection is made.

sneakyimp

Just creating a mysql user does not mean that user has privileges to work with a given table.

I am a total noob at using MySQL Grant Syntax because I usually have a tool like phpMyAdmin installed. You may need to grant some privileges on this particular table or database to your new mysql user.

The trick here is that in order to grant privileges, you need to be able to login as someone who has grant privileges.

Not sure this is your problem but it looks to me like your users are connecting and just don't have the right privileges.

OmegaB

Yes I gave the user I'm trying to login as privileges.

http://img411.imageshack.us/i/help1s.jpg/

This is my user table setup.

And my php files..

dbconfig.php:

<?php
	$db_host = "localhost";
	$db_user = "******";
	$db_password = "*****";
	$db_name = "mysql";
?>

and temp_con.php:

<?php
	require("db_config.php");
	$connection = mysql_connect($db_host, $db_user, $db_password, $db_name) or die("error connecting");
	echo "connection made";
?>

Someone help? I really don't see what's wrong.
The hosts match up, the users match up, the password matches up and the user to use as login has privileges.

This error appears:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user '******'@'localhost' (using password: YES) in C:\XAMPP\htdocs\temp_con.php on line 3
error connecting

bradgrafelman

MySQL doesn't store passwords in plain-text - it hashes/encrypts them using the built-in PASSWORD() function.

Either use the 'mysqladmin' utility to change passwords properly, or store the result of the PASSWORD() function in the users table rather than the plain-text password itself.

sneakyimp

Yes NEVER go editing the mysql database directly or you can be sure to get unexpected results.

If you can access phpMyAdmin as root, click on the little house icon in the top left panel. That'll take you to the home page where there should be a link for privileges and you'll see some user-friendly forms where you can edit user permissions and grant table-level permissions rather than global ones.

OmegaB

So I took out the record with omegab in the 'user' table in the mysql database.
Then following your instructions...

After clicking on the Privileges button and then clicking on Add New User I do this:
http://img337.imageshack.us/i/helpbefore.jpg/

But then I get this error:
http://img42.imageshack.us/f/helpafter.jpg/

Help please don't know what I'm doing wrong 🙁

sneakyimp

Like I said, you should NEVER EVER edit any tables in the mysql database directly so removing the record might be the problem -- unless you were the one who created it in the first place.

Are you logged into phpMyAdmin as root user? If not, you won't have privileges to create a user.

Also, READ THE TEXT IN PHPMYADMIN CAREFULLY. You are creating a user with complete global privileges which you should not be doing because this makes them privileges for every table in every database. Create the user first with NO global privileges and then add privileges for the table in question.

I'd recommend creating a new user with an entirely different name. There may be vestigial records or garbage in your table that is causing problems.

bradgrafelman

If you removed the record from the users table, then you probably need to issue a FLUSH PRIVILEGES command before attempting to create another user with the same name.

EDIT: @: There's nothing wrong with editing the mysql tables directly (even the MySQL manual lists doing that as one of the possible ways to manipulate user accounts)... it's just not the preferred way since you have to understand the table structure and how MySQL works.

OmegaB

Yeah so...
The steps to solve this were...
FLUSH privileges in the mysql database
create an account using the Add a New User button in the Privileges tab
Then the connection could be made by defining variables and sending them to the server.
Thanks! Problem resolved.