PHP :: Connection With MySQL. Navicat - CANNOT CONNECT TO MYSQL SERVER ON LOCALHOST

Cannot Connect To MySQL Server Using PHP On Localhost
I have set up MySQL on my home computer, and I am writing a PHP enabled web
site to run queries on this database.

I have created a database called 'weather' on mysql that I want to access
via my website.

I have also created a user with a password (this isn't the real one, but
I'll use this to illustrate my point)
User: carlotam
Password: blah
Host: localhost

To which user I have granted all on database weather.

Using a PHP call: I try:

$username="carlotam";
$password="blah";
$database="weather";
$host="localhost";

$var = $_POST['topic'];

echo "<center><h1>ESCape Database Query</h1></center>";
echo "You have queried $var ";
echo "Your database is: $database. ";
echo "Your username is: $username. ";

mysql_connect($host, $username, $password);
@mysql_select_db($database) or die("Unable to select database
$database on $host.");
mysql_close();

And I keep getting the message "Unable to select database weather on
localhost."

Is there something wrong with the above, or is there something wrong with my
MySQL server configuration? My server is up and running, so I was wondering
if anybody can help with this problem?

If this information helps: I am running MySQL 5.0.15 server on a PowerMac G4
laptop. And yes, I did check to see if the server was running before I
checked the code.

Myphpadmin - Can't Connect To MySQL Server On 'localhost'
MySQL said:

#2003 - Can't connect to MySQL server on 'localhost' (10061)

I try to config it on my server because I don't wanna use phpdev
so can any help?

Can't Connect To MySQL Server On 'localhost' (10061)
I get the following error when I trie to connect to mysql with mysqlgui.exe

Warning: MySQL Connection Failed: Can't Connect to MySQL server on 'localhost' (10061)

But mysql server is running (using mysqld.exe) on my win98 machine (The green light of WinMysqlAdmin is) and I can ping localhost. Code:

Connection Failure (Can't Connect To MySQL Server Through Socket) (111)
I am receiving the message WARNING MySQL Connection failed: Can't connect to MySQL server through socket '/var/lib/mysql/mysql.sock' (111).

I have been following the script 'Setting Up Database Driven Websites' by Ying Zhang posted on this website and all was well up to the point of executing the index.php3. That is, MySQL is working and the <? echo "Hello World"; ?> script to verify that PHP is functional worked.

I did a global search on 'mysql.sock' and found only 1 which is in /tmp/mysql.sock. Based upon the date/timestamp it was either created or touched by the 'Hello World' script mentioned above. Software: Mandrake 6.0 (RedHat 6.0), MySQL 3.23.2, PHP 3.0.8, Apache 1.3.6.

I only installed MySQL, as PHP3 was already in Apache. After checking all the conf and ini files of which I am aware, I am at a loss as to a remedy.

How To Connect Remote Site - Can't Connect To MySQL Server
Lets say, i have two php sites named Site-A and Site-B. I want to use MySql
Datbase of Site-B for Site-A.

Generally i use :

$Host="localhost";
$User="username";
$Pass="password";
$DB="databse";
mysql_connect($Host,$User,$Pass);
mysql_select_bd($DB);

When i connect to Site-B database from Site-A what will be the $Host name?
I have tried with: $Host="www.mysite.com";

but it shows the warning:
Warning: mysql_connect(): Can't connect to MySQL server on....

Warning: MySQL Connection Failed: Access Denied For User: 'root@localhost'
I am new in MySql & PHP3. I have downloaded php3 and extracted it. Not sure what to do with the config.inc.php3 file. I get the following error:

Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' (Using password: NO) in lib.inc.php3 on line 255

Warning: MySQL Connection Failed: Access Denied For User: 'username@localhost'
I just installed the latest versions of apache, mysql, and php, and I have a script i made to just connect to the database, but I get an error such as:

Warning: Access denied for user: 'username@localhost' (Using password: YES) in c:pathofapachehtdocsmysqlconn.php on line 7

Warning: MySQL Connection Failed: Access denied for user: 'username@localhost' (Using password: YES) in c:pathofapachehtdocsmysqlconn.php on line 7
Unable to connect to database

This error is driving me insane. I've tried everything I've found possible answer too. I am a newbie and I am just learning, but I KNOW this should work. Here is my connection script. PHP Code:

Unknown MySQL Server Host 'localhost '
I'm rather new to both MySQL and PHP. I've been trying to use PHP to
write to a MySQL database. I call mysql_pconnect to get a database
connection, but then when I call mysql_db_select, I get the following
error :

Unknown MySQL Server Host 'localhost '

I can connect to the database via the command line ok. Where can I
look to find the source of this problem?

Using PHP To Connect To MYSQL Server
I am new to PHP and MYSQL. I recently installed both PHP and MYSQL (the community edition) on my computer and I have been trying to use PHP to connect to and access MYSQL (instead of using the MYSQL command line).

I used the mysql_connect() function on a test script but I am getting the following error message when I test the script.

Warning: mysql_connect() [function.mysql-connect]: Access denied for user ' '@'localhost' (using password: YES) in filename on line 10.

I understand that I am being denied access because I have not submitted the right credentials. However, I am testing this code on my local computer where I have full privileges. What might be the reasons I am getting this message? What are the possible solutions? Do I need to configure mysql such that it recognizes that I am using it on a local computer?

Can't Connect To Remote MySQL Server Using PHP
i am trying to connect to a remote mysql server through php. Here's the
code:

mysql_connect("my.hostname.edu", "username", "password") or die
(mysql_error());
mysql_select_db("db_name") or die ("unable to select
db".mysql_error());
$r1 = mysql_query('SELECT * FROM table') ;

Using the mysql prompt on the remote server, the mysql -h -u -p works
just fine with the parameters i've specified here. According to the
user table I have the proper permissions. I just can't figure out what
could be preventing the connection here, although I am no expert...can
anyone help?!

BTW, I am using PHP 4.4.1 and mysql 5.0.

Connect To Remote MySQL Server
I have a fully functional page hosted on my PC that uses PHP and
connects to MySQL on my PC to generate it's code.

I now have some web hosting available which includes both PHP and MySQL
support, however the webhost is still in the process of getting the
MySQL support activated and functional.

I therefore have uploaded my webpage to the host and edited the webpage
code to access the MySQL server on my home PC - once the host gets
MySQL working then the webpage will of course use the MySQL that my
host will provide.

The original code in my webpage to connect to MySQL is:

$panorama_database=mysql_connect(localhost,$userna me,$password) or
mysql_fail("Unable to connect to MySQL database.");

I have edited this to:

$panorama_database=mysql_connect(ï.207.???.???: 3306',$username,$password)
or mysql_fail("Unable to connect to MySQL database.");

(My IP masked by ?).
And it's works no problems - however i have a dynamic IP address and
wish to replace the hardcoded IP address with an alias from
www.no-ip.com.

So i tried both:

$panorama_database=mysql_connect('http://mynoipalias.no-ip.org:3306',$username,$password)
or mysql_fail("Unable to connect to MySQL database.");

and (with no port specified):

$panorama_database=mysql_connect('http://mynoipalias.no-ip.org',$username,$password)
or mysql_fail("Unable to connect to MySQL database.");

Both attempts to use my www.no-ip.com alias fail and i'm not sure where
to look for logs to debug the problem.

Cannot Connect To Remote MySQL Server
Ok, I have done this MANY times before without a problem - so I don't know WHY this isn't working!

I am in the process of moving to a new server - so I am updating my mysql_connect statement to use our NEW server instead of the current one (@ localhost).

I went into MySQL on the NEW server an added two new users - same username - one for the domain name of our current/old server and one for the IP address of our current/old server ... and gave the users the appropriate rights. I then updated my "mysql_connect" statement to point to the NEW server... but I get the following error:

Connect To Mysql Through Proxy Server
How exactly would I set up a connecton to mysql in php, but through a proxy server and a port #.

proxy.shr.secureserver.net on port 3128

I have no idea where to start, so Here's my code:

Can't Connect To Local MySQL Server Through Socket
I created a test web form, that successfully input the data into my test database. However, today I created a second form, added the layout code, putting the layout and mysql connection details into a php include code.

These are the only changes I have made, apart from field names etc, but today, I get the following error message:

QuoteWarning: mysql_query(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/fhlinux177/f/further-flight.co.uk/user/htdocs/napsters/enter.php on line 50

Warning: mysql_query(): A link to the server could not be established in /home/fhlinux177/f/further-flight.co.uk/user/htdocs/napsters/enter.php on line 50

Your nap has been added to the database. Good Luck!
I checked, but the nap hasn't been added to the database.

I use the code I found on phpmac.com. It currently looks like this: Code:

Can't Connect To Local MySQL Server Through Socke
What does this mean. The code below is where its occuring:

Error retrieving records adam: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Code:

MySQL Server Sometimes Refusing Connection
My site is setup on two servers. One to serve apache and the other is a database server.

However, if you keep refreshing the site, sometimes it gives a mySQL server connection error, sometimes it connects fine.

Our chief technologist is away right now so I'm stuck...does anyone have any ideas?

Lost Connection To MySQL Server During Query
I have php4/mysql/apache installed and working together in solaris 2.7. When ever I try to send a query to the MySql database it gives the following error "Lost connection to MySQL server during query"

I can do other stuff like create tables and databases and but sending a query is giving me problems. I searched through a forum and found someone else who encountered the same problem. he said that it was caused by the gcc version that was used to compile Php4. he said that gcc 2.8.1 is causing this error and the solution is to use gcc 2.91.x

Before I ask my sysadmin to update gcc I want make sure that this the solution to the problem. If you know of any other way that the above error can be resolved.

Lost Connection To MySQL Server During Query
i am haveing an issue connecting to a mysql database i get the following error

Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server during query in /home/cutencud/public_html/testing.php on line 1

now testing.php only has one line and it looks like this

<?php mysql_connect("66.97.165.60", "root", "") ?>
anyone know what would cause that? (and i removed the password before posting

Cannot Make Connection To Local MySQL Server From Within Dreamweaver.
I am using OS X and Dreamweaver MX. I am trying to make a connection
to the MySQL Server from within Dreamweaver using the Applications
panel and clicking on the "+". A window opens asking for:
Connection Name: Apress
MySQL Server: localhost
User Name: apress
Password: xxxxxx
Database (Select):
When I click select so the Dreamweaver can browse to the databases in
MySQL the connection is not being made because Dreamweaver cannot find
the MySQL Server. I think that "localhost" is wrong even though I am
using the APRESS book: PHP Dreamweaver MX 2004 and it says to use
localhost. MySQL and PHP are on my local machine. I am NOT using a
remote machine. I used phpMyAdmin to create the databases.

ERROR 2013: Lost Connection To MySQL Server During Query
I periodically recieve the following error from my MySQL server. "ERROR 2013: Lost connection to MySQL server during query" The server load is always very low (0.06). I can't figure out why I am getting these errors. Here is an extened status report from MySQL.
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 5 |
| Aborted_connects | 340 |
| Created_tmp_tables | 2 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 25306 |
| Handler_read_first | 23 |
| Handler_read_key | 60061392 |
| Handler_read_next | 40329034 |
| Handler_read_rnd | 3588071416 |
| Handler_update | 33411189 |
| Handler_write | 433799 |
| Key_blocks_used | 7822 |
| Key_read_requests | 485870614 |
| Key_reads | 5508 |
| Key_write_requests | 536763 |
| Key_writes | 103759 |
| Max_used_connections | 152 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 125 |
| Open_files | 84 |
| Open_streams | 0 |
| Opened_tables | 287 |
| Questions | 76301760 |
| Running_threads | 87 |
| Slow_queries | 55 |
| Uptime | 2499787 |
+--------------------------+------------+

Cannot Connect To Localhost Using GoDaddy
I'm (trying) to help a friend setup a MySQL db and use some simple
scripts on a site hosted with GoDaddy. I note that GoDaddy appears to
use Microsoft. I have done this:

$connection = mysql_connect("localhost","mydatabase","password")
or die ("Couldn't connect to server.");
$sql = mysql_query("SELECT * FROM dummy");
$row = mysql_fetch_array($sql);
echo $row['name'];
?>

on several Apache servers and it always seems to work. I created the
MySQL database using the GoDaddy control panel (which is very confusing
and poor IMO). I dove into phpAdmin and was able to do stuff. But I
can't get php to connect.

Accessing Mysql Localhost(like With Telnet)
I have just successfuly installed php 4.0.4pl1 , apache 1_3_14, mysql-shareware-3.22.34
onto my computer running under windows ME.

Everything works fine..well so far that is. I have only done small simple tests so far. My question is how do i get access to mysql on my localhost the way i access mysql through telnet on my remote server. I think it's one of the many mysql.exe programmes in the mysql bin folder. But I dont want to mess where i'm not sure about.

Changing Localhost IP Address For MySQL
I am moving a bunch of my database sites to a new server. I have to keep the databases hot durring the switch. Is there a way to change the IP address of 'localhost' to another IP address when you connect in PHP to MySQL? That way I wouldn't have to change 'localhost' to the new IP address on every script.

SMTP Failed To Connect To Mailserver At Localhost Port 25
I dont know what I did but now I get this message Failed to connect to
mailserver at "localhost" port 25, verify your "SMTP"...

Connection Issues + Slowing Down Of Localhost Or Website
I recently developed a simple CMS. Its being working well for a few weeks while testing and developing. But recently my localhost is taking a long time to display the page. Code:

Warning: Mail(): Failed To Connect To Mailserver At Localhost Port
I have windows xp pc and i have installed apache as a web server and
php also working fine, but when i am sending mail, its giving me
following error

when upload same to linux live server its working, please help me what
do i have to do for this

Warning: mail(): Failed to connect to mailserver at "localhost" port
25, verify your "SMTP" and "smtp_port" setting in php.ini or use
ini_set() in C:SafrasWebHosting....

Php/mysql - How To See If They Can Connect?
I have installed php and mysql but i am not sure the 2 are able to talk to
each other.

i have created a database in mysql called test / user: test / pw: test and
given the user select privelges. The table has one field column called test.
Can anyone tell me a simple php script to try to see if a connection can be...

Connect To MySQL
PHP 4.3.4 installed manually from package *.zip and Apache 2. I have a
problem with this simple code:

<?php
$link = mysql_connect("127.0.0.1","","")
or die("Could not connect: " . mysql_error());
echo "Connected successfully";
mysql_close($link);
?>

And this error occurs:

Warning: mysql_connect(): Can't connect to MySQL server on ïv.0.0.1'
(10061) in C:usrApache2htdocsfriko.plindex.html on line 18
Could not connect: Can't connect to MySQL server on 'localhost' (10061)

The settings are:

Active Persistent Links 0
Active Links 0
Client API version 3.23.49

Directive Local Value Master Value
mysql.allow_persistent On/On
mysql.connect_timeout 60/60
mysql.default_host localhost/localhost
mysql.default_password no value/no value
mysql.default_port no value/no value
mysql.default_socket no value/no value
mysql.default_user no value/no value
mysql.max_links Unlimited/Unlimited
mysql.max_persistent Unlimited/Unlimited
mysql.trace_mode Off/Off

Connect To The Mysql Already?
Hope you guys can help me out~~ I have a config.php file. I want to
conncet to my own mysql version. When i run the config.php file as
below, i get all successful message. However, when i take a look the
database information in doc environment, I don't see any database or
table created.

<html>
<head><title>Create Database and table</title></head>
<body>
<?php

//connect to the database, write, and execute the query
$linkID = mysql_connect("localhost", "", "") or die ('I cannot connect
to the
database because: ' . mysql_error());

if (!$_GET['linkID'])

{
print("The connection to the server was made successfully. ");
}
else
{
print("The connection to the server failed. ");
}

mysql_close($_GET['linkID']);

$DBName="Krista";
$TableName = "Employee";

//connect to the database, write, and execute the query
$Link = mysql_connect("localhost","","");

mysql_select_db("Krista", $_GET['Link']);

$resultID = mysql_query ("CREATE table Employee(EmployeeID INT
UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
Employee_Name TEXT",$_GET['Link']);

if(!$_GET['resultID']){
print("The query was successfully executed! 
");
}
else{
print("The query could not be executed! 
");
}

mysql_close($_GET['Link']);

?>
</body>
</html>

In addition, i change the global_register to on. However, I still need
to use $_GET['username'] like this. I want to use $username instead of
$_GET['xxx'].

How Do I Connect To MySQL In A Url
I am building a website which is using a database which will give users access to dynamic information. Once the user has enter user and password, what is the best way of connecting to other pages with MySQL? If I want to use url links to other pages with MySQL how do I parse varibles to other pages including connection to MySQL.

Connect To Mysql?
I have a question. I have installed php and mysql on an apache-server on
windows and I can't connect to the server.

I tried to create a database (since I am trying to learn howto). My manual
said I should write this at the shell:
c:mysqlin>mysqladmin -u root creare mindb

I did this and got this error:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

I then tried to use -p and wrote this instead:
c:mysqlin>mysqladmin -p -u root creare mindb

The database was created!

Then I tried to write mysql in cmd at c:mysqlin but I get this error:
Access denied for user 'ODBC'@'localhost' (using password: No)

Why?

I have used earlier versions of mysql and php and got it to work. In earlier
versions "my.ini" looks very different and user and password were written
there, but not anymore. Why, or is it me who have done something wrong? When
I log in to phpmyadmin I have to root-accounts there, one with
host=localhost and one the host=%.

All I want, is to make mysql work, so I can test things and to learn!

My configuration

Windows XP pro

Netgear router (I have opened port 3306)

ADSL

no-ip (For my domain, www.kamrate.se)

Apache 2.2.2

The exe-files are in c:apache2in

(All I did was to fill in domain=localhost, servername=localhost and my
email)

PHP 5.1.4

The exe-files are in c:php

(I used the zip package)

httpd.conf

At the row below "#LoadModule ssl_module modules/mod_ssl.so" I wrote:

LoadModule php5_module "c:/php/php5apache2_2.dll

At the row below "AddType application/x-gzip .gz .tgz" I wrote:

AddType application/x-httpd-php .php

At the row below "DocumentRoot" I wrote:

PHPIniDir "C:/php"

At the row below "DocumentRoot" I wrote:

PHPIniDir "C:/php"

At the row "DirectoryIndex index.html" I wrote:

DirectoryIndex index.htm index.html index.php

My Php Can't Connect The Mysql
A question : why my php can't connect the mysql.

my php version is 5.014 and my mysql version is also 5.0,
but i run them on the windows xp system.
who knows the real problem?

I searched this at google,but I still haven't got the way to deal with
my problem.

Can't Connect To Mysql From Php
I can connect in the php by using 'root' and the root pw. But when I
tried adding a user ( sarah ) with GRANT I cannot connect from php. The
php is simple, what am I overlooking? Again putting the root user name
and pw it'll work in php but not for sarah:

the php....
mysql_pconnect("localhost","sarah","camera")
or die("ERROR: Could not connect to database!");
mysql_select_db("howto");

*But* on the command line the sarah user works OK:

C:Documents and SettingsAdministrator>mysql -u sarah -p
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 19 to server version: 4.1.3a-beta-nt-max

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql> select * from howto.page;
+---------+-----------------------------+
| page_id | page_url |
+---------+-----------------------------+
| 1 | http://www.lg.netfarms.org |
+---------+-----------------------------+
1 row in set (0.00 sec)

mysql> show grants for sarah@localhost;
+-----------------------------------------------------------------------------------------------------------------------+
| Grants for sarah@localhost
|
+-----------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'sarah'@'localhost' IDENTIFIED BY
PASSWORD '*6043233C67ADBE7E9242089D718763C3C5E1A1E2' |
+-----------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql>

Cannot Connect To Mysql
I hope you guys can help me out~~~
when I run it localhost/config.php, it cannot display any message such
as connect successfully or failed. Do u guys have any idea?

config.php
<html>
<head><title>Create Database and table</title></head>
<body>

<?php

$linkID = mysql_connect("localhost","","");
print ("hello"); <---can print
Hello

if($linkID != "FALSE") <--i think
fail here
{
print("The connection to the server was made successfully.)";
}
else
{
print("The connection to the server failed");
}

mysql_close($linkID);

?>
</body>
</html>

am I right? do i need to put username and password in
mysql_connect("localhost","","")? i dont know where i can find it, or
how can I find it in mysql.

How Can I Connect Php To Mysql?
im a beginner and student. i want to learn how to connect php to mysql?
just a basic tutorial.

Can I Connect To Two MySQL Databases At Once?
Hi!

Quick question, there wouldn't be any conflicting issues if I connect to two databases at once? Just as long as I use different variables, and field names, right? Thanks lots.

Why My PHP And My MySQL Can't Connect In Different Machine
I'm working with PHP and MySQL on a RedHat7.0 machine.
It's work well, but When I install apache in my WIN2000 and place the PHP code under here, it can't connect the RedHat's MySQL?

<html>
<body>
<?php
$db = mysql_connect("192.168.1.100:3306", "root","password");
mysql_select_db("mydb",$db);
$result = mysql_query("SELECT * FROM employees",$db);
printf("First Name: %s ", mysql_result($result,0,"first"));
printf("Last Name: %s ", mysql_result($result,0,"last"));
printf("Address: %s ", mysql_result($result,0,"address"));
printf("Position: %s ", mysql_result($result,0,"position"));
?>
</body>
</html>

ERROR MESSAGE:

Cant Connect To Mysql Database
I'm having a problem connecting to a database, when i use the following script to connect to a database (all the login details are correct) it connects to mysql but says it can't connect to the database any body got any suggestions...

Connect Two Tables (mysql)
I have 2 tables in a database: 'artists' and 'albums'. I want to display the albums on a webpage like this:

Artist #1
Album #1
Album #2
Album #3
Artist #2
Album #4
Album #5

The table 'artists' contains the fields 'artist_id' and 'artist_name'. The table 'albums' contains 'album_id', 'artist_id' and 'album_name'. Now I want to 'connect' both tables using the 'artist_id' fields. PHP Code:

MySQL Connect Failure
I have the following code

$Host = "localhost";
$User = "Fred";
$Database = "house";
$Password = "mypw"

echo "before mysqli Host: " . $Host . " " . $User . " " .
$Database;

@ $db = new mysqli($Host, $User, $Password);

echo "Connection is " . mysqli_connect_errno();

The first echo is executed but the second is not. I have ran the very same
parameters from the command line using:

mysql -h localhost -u Fred -p

Then

use house

and I connect to the house database.

I tried this in both IE 7 and Firefox with the same results.

How Often Do I Need To Connect To MySQL Database?
At present at the top of each of my php pages I reconnect to my
database

mysql_connect(...);

is that actually necessary/good practice. Isn't there something about
persistent connections.

Connect To MySQL Database Using PHP
I am trying to connect to a MySQL Database using PHP on a
local machine using locahost. I am using the following code

<?php
$dbhost = 'localhost'
$dbuser = 'root'
$dbpass = 'password'

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or
die ('Error connecting to mysql');

$dbname = 'pmoneytest'
mysql_select_db($dbname);
?>

When I view the page it then comes up with an error that says
PHP Fatal error: Call to undefined function mysql_connect() in C:
InetpubwwwrootPHPTestconnection.php on line 6. I can't see what
the problem is as I got the code from the Internet and it seems to be
the same on all the different website that I look at.

How To Connect Web Pages To MySQL In PHP
ew to this. I'm having a few days of nightmare in connecting Dreamweaver to MySQL database. I'm pretty sure that I have the correct MySQL Server name, user-id & password,... I keep receiving the message "an unidentified error has occured", not so intuitive.

I'm wondering if there is a way around this, say, doing it directly in PHP with a few lines of code,... I'm open to all possible solutions.

MySQL Connect Not Working
mysql_connect("localhost","---myUsername---","---myPassword---");And yet, it won't let me connect and gives me errors. I don't think it's my username or password that is messing this up, I think it might be the localhost part. I don't know which port to use, or what to put there. So, I would appreciate it if somebody could tell me how to find out what to put, or what to put.

Also, I am using PHPMyAdmin, so if this does not work with mysql queries then please tell me and I will try to figure out how to download a new MySQL database.

Cant Connect To Remote Mysql Db
I have a db on Server A.

Server B is on the same network, different IP. Server B connects to the db correctly through my php script.

Server C is on a totally different network. Using the same script as was used on Server B, I'm unable to connect to Server A's database.

Access hosts on Server A has been configured as % to allow connections from anywhere.

I can connect to the db from my local computer using SQLyog just fine.

Both Server B & C are running php 4.4

Any ideas as to why the script will not connect on Server C?

PHP SSH And Mysql Connection
For a long time I've been trying to connect to mysql through a SSH tunnel. Although that si possible by setting up the tunnel manually (with 'ssh -L ...'), I'd like it to be done by PHP itself.

Now, with the SSH2 extension (http://www.php.net/manual/en/ref.ssh2.php) it is possible to issue a 'ssh2_connect' and then a 'ssh2_tunnel' command.
That returns a socket resource to the destination server.
So far, all fine.

Problem:
How can I force that socket onto 'mysql_connect'?
I mean, what I have is:
$tunnel = ssh2_tunnel($connection, ཆ.0.0.101', 12345);

But $tunnel is a PHP resource, and not in the format ':/path/to/socket' that mysql_connect expects...

Is this possible at all?