[Resolved] can't connect to DB

Spames

Here's my code

<?php
$host="130.11.81.112";
$user="web";
$password="";
$database="publications";

$connection= mysql_connect($host, $user, $password)
 or die (mysql_error());
$db=mysql_select_db($database, $connection)
 or die (mysql_error());
?>

Here's what I get in return:

Access denied for user: 'julrich@localhost' (Using password: NO)

WHY! WHY! WHY!!! :mad:

But if I use a command prompt, and log in as "web", I can do what I need to do.

Any ideas?

Spames

Well, I've stupmed you all.. I'm amazed 😃

lanjoky

in you $host variable ... put "localhost" instead of the IP you have there .... see if that doesnt help!!

HTH

Spames

localhost isn't the database I want to connect to though...

stolzyboy

well then you need to allow remote connections to mysql from the ip you are connecting to

stolzyboy

Check this out for a full explanation http://www.mysql.com/documentation/mysql/bychapter/manual_Privilege_system.html

GRANT ALL PRIVILEGES on databasename.* to username@%;

The above allows "username" to have all privileges to "databasename" from "%"(anywhere).

Spames

Well, it's still not working...

It appears that the username I am specifying "web" is mysteriously being replaced by my username "julrich" for no apparent reason.

Spames

Well, it appers I have an apache/php config problem... Don't know where to start, but I can't connect to any mysql database..... hmmmm...

no matter what DB server I try to connect to, this is the error I get, and I'm entering a different username and password...:

Access denied for user: 'julrich@localhost' (Using password: NO)

fox_m

But if I use a command prompt, and log in as "web", I can do what I need to do.

When you have a command prompt are you connecting localy or remote?

Also when you login trough the command and you do an
select * from user in the mysql db what do you see for the user
web? then specially the host is important.
if it says "%" you can connect from anywhere but if it says localhost you cant connect remotely using that username.

Hope this helps

Fox_m

Spames

when I connect through command prompt, I'm connecting from the web server, so it doesn't appear that there is a network issue blocking the port.

when doing the select * from user where user = "web";

I get:

4 entries...

one blank for host
one with a % for host
one with web server name for host
one with web server IP address for host

and they all have a YES for SELECT.

What's really bothering me is that no matter what name I put in the connect script for user name, it comes up with cannot connect julrich@localhost... I can't get it to change that no matter what I do... very annoying...

I just put in a false database server name, and it's still giving me no access for julrich@localhost... This has to be a config problem.... anybody have any ideas???

fox_m

Check if there is an file called my.cnf somewhere in you path or env. Those are the default setting for mysql to login.

but without looking at the server and php settings i am just as lost as you.

Spames

They mysql_connect function is not using my supplied database, username, and password. It's using the username of the owner of the script file.

I chown'ed my script file to someone else, and their name is now coming up as being denied access.

Does that make sense?

Why are my variables being ignored, and mysql_connect using the filename owner, and localhost for a database?

Spames

Got it figured out!

--Thanks guys.

fox_m

Originally posted by Spames
Got it figured out!

--Thanks guys.

What was you solution? I would like to know and mabey it helps others here 🙂

Thnx

Spames

There was an option in php.ini for mysql safe mode or something... I think you set this to "no"