PHP wont connect to MySQL!

[Tuskin]

Alright I hope to make this very easy to follow and easy to answer... rofl! ha! I have now idea what's going on and I'm a little annoyed at it!

First I didnt have the extensions directory stated correctly... so it wasnt loading the php_mysql extension... that's all cleared up and php sees mysql. (I didnt put a / AFTER the directory!)

I had that problem before and i couldnt figure it out so i updated everything. I got the newest php the newest apache and the newest mysql (newest recommended not betas).

The old MySQL was like 4.01 or something like that, it was a while ago and it didnt remove the windows service so i had to reinstall it and remove it from cmd... it was a process (trial and error and luck)

I have no redundant services and both apache and mysql are running all the time and mysql is "ready for connections" but php wont connect.

I'm using win 2k fyi.

I'll just try to immitate my code - on a different computer right now

<?
mysql_connect("localhost", "root", "root"); //yeah yeah it's *insecure*
mysql_select_db("gallery");
$query = "select * from news";
$results = mysql_query($query);
echo $results;
?>

I have a or die statement after the connect and after the select db... and it wont connect to the db... so it doesnt go any further.

I think I gave you all the info you need... yep

oh and php is running as a module if that matters.

[HTRegz]

Hey Hey..

Go into your mysql\bin directory and run this command.... mysql -u root -p and enter the password of root and make sure it connects... if it doesn't then you know where your problem lies...

Peace,
HT

[chsh]

If HTRegz' test works, you might also try the following:
- Double check your password really is "root" as you have specified.
- Ensure that "root" is allowed to log in on your MySQL installation.

It might also be helpful to take a gander at the installation/configuration instructions for MySQL: http://dev.mysql.com/doc/

[sec_ware]

Hi

/EDIT: I should have read your post more carefully,
but I don't get the exact point where the error
appears...
...
You may check whether you have a firewall or so,
not allowing a connection to ..err.. 3306 (tcp),
even if local login.

PHP

A snippet of my code (should look similar to yours):

  #---------------------------------------------
  #SETTINGS
  $connector = "localhost";
  $login= "root";
  $password= "root";
  $dbname= "gallery";
  #---------------------------------------------

$db = mysql_connect($connector,$login,$password);

  if ($db == false){
      print "<p>myERROR: Connection to MySQL-Server failed.</p>\n";
      exit;
  }

  #CONNECT TO DB

  $result = mysql_select_db($dbname,$db); 
  if ($result == false){
      print "<p>myERROR: $dbname does not exist.</p>\n";
      exit;
  }

Note the "bolded" line. It may help to add the connector to the
mysql_select_db command. By default, mysql_select_db should take
the latest link, but it never hurts to add some extra information.

If this does not work, try

Mysql

#general db test
> mysql -u root -p #as suggested
> use mysql;
> select * from user;

also try there

#specific db test
> show databases; #does gallery exist at all?
> use gallery;
> show tables;

If this command works, then it's a PHP issue for almost certain.
And since the mysql_connect seems to work ...
Otherwise, check, as also suggest, whether root really has permission
to gallery - which would be strange if not using a default installation.

Cheers!