<div>
Try to give the IP address instead of &quot;localhost&quot;
</div>

<div>
Here is the quickest solution... 
 
use XAMPP 
<a href="http://www.apachefriends.org/en/xampp-windows.html" rel="ugc">http://www.apachefriends.org/en/xampp-windows.html</a> 
 
comes with Apache, PHP, MYSQL already configured ..... 
 

</div>

<div>
Have you configured php.ini with mysql? 
</div>

<div>
Firstborn, 
 
Create a php script called phpinfo and paste the attached. Run it from your server and then scroll through the results and see if the MySQL extension is in fact loading within PHP. Also check the extension's directory to make sure that the extension is available. 
 
Also check the MySQL installation to make sure that it is installed and running on localhost. 
 
Also maybe look at a out of the box solution. Wamp server is a great option and is free and simple to install. 
 
<a href="http://www.wampserver.com/en/" rel="ugc">http://www.wampserver.com/en/</a> 
 
 

<pre><code class="code-1 nolinks" id="code-124872">&lt;?php phpinfo(); ?&gt;
</code></pre>
</div>

<div>
I have a feeling that MySQL is being read correctly from PHP otherwise it wouldn't recognize the function. But you need to make sure that it is connecting to the MySQL install.
</div>

<div>
Thanks everyone for your responses. 
 
Dear byronrode, 
How do I make sure that it is connecting to the MySQL install? 
I will check out the wampserver program later on today, thanks! 
Also, Yes, phpinfo(); is displaying mySQL on the list... 
 
Any Ideas? 
 
Thanks! 
 
Dear inspector_mills, 
Thanks. 
Yes, as mentioned in the opening Q: 
&quot;I've attempted to use both (and either of the two) for the php.ini file: 
extension=php_mysql.dll 
extension=php_mysqli.dll 
... and have stopped and restarted Apache during EVERY Change.&quot; 
 
Am I missing something else? 
 
Dear cdbeste, 
Awesome! 
Thanks! 
I'll try this out later on today. 
 
Dear logudotcom, 
Thanks. 
As mentioned in the opening Q: 
&quot;Yes, I've attempted to change hosts and usernames that are in the 
user table with all permissions... 
 
I've attempted to use 127.0.0.1 (and similar as mentioned on different EE Articles 
for this issue.)&quot; 
 
-------------------------------------------- 
 
Thank You everyone for Your help! 
 
Thanks, 
FirstBorn 

</div>

<div>
FirstBorn, can you please try the following for me: 
 
open your browser of choice and enter the following URL: <a href="http://localhost:3306" rel="ugc">http://localhost:3306</a>&nbsp;and let me know what happens. 
 
It should open a download box. 
 
Thanks. 
B
</div>

<div>
FirstBorn 
 
Actually, can you please attach the my.ini file that is located in the MySQL install folder. I have a feeling it is not connecting to the right port number. 
 
Thanks 
Byron
</div>

<div>
FirstBorn, 
 
Sorry for the multiple posts here. Racking my brains helped a little. I had a similar problem when I upgraded MySQL a year or so back. 
 
This problem is generally specific to the INNODB setup being incorrect. This can either be from a buggy my.ini file or if you have installed a newer version of MySQL over an existing MySQL instance and windows is reading the wrong version of the file. 
 
There are 2 ways we can attempt to solve this. 
 
1) In your my.ini file, check for the following. 
&nbsp; &nbsp; [mysqld] 
&nbsp; &nbsp; port=3306 
 
If the port number is different or the above text is not available. Paste it in and restart Apache and MySQL. 
 
2) If INNODB is not important to you then in the my.ini file change the following line from: 
&nbsp; &nbsp; default-storage-engine=INNODB 
to 
&nbsp; &nbsp; default-storage-engine=MyISAM 
 
and then restart Apache and MySQL. 
 
Also make sure that your firewall or Anti-Virus isn't blocking port 3306. 
 
Hope this helps. 
Byron 

</div>

<div>
10061 is an error that means the server is actively refusing the connection, 
 
is your php file on the same server as your mysql server? 
 
users in mysql use connection based restrictions, 
so root may be able to connect from one machine but not another. 
 
I saw someone say trying using the ip address of the server, 127.0.0.1 is still localhost, trying using the actual IP of the server, like the one attached to a NIC card.
</div>

<div>
Hi Byron, 
 
Thanks for helping. 
 
k, I changed the line from INNODB to MyISAM 
The ports are listed as 3308 in two spots: 
===================== 
# CLIENT SECTION 
# ---------------------------------------------------------------------- 
# 
# The following options will be read by MySQL client applications. 
# Note that only client applications shipped by MySQL are guaranteed 
# to read this section. If you want your own MySQL client program to 
# honor these values, you need to specify it as an option during the 
# MySQL client library initialization. 
# 
[client] 
 
port=3308 
 
[mysql] 
 
default-character-set=latin1 
 
 
# SERVER SECTION 
# ---------------------------------------------------------------------- 
# 
# The following options will be read by the MySQL Server. Make sure that 
# you have installed the server correctly (see above) so it reads this 
# file. 
# 
[mysqld] 
 
# The TCP/IP Port the MySQL Server will listen on 
port=3308 
========================================= 
Also, when going to localhost:3308 (AND 3306) 
it shows &quot;Page cannot be displayed&quot; 
BUT Apache works... <a href="http://localhost/" rel="ugc">http://localhost/</a>&nbsp;shows the page 
that it's supposed to show... 
 
Only have Spy-Bot S&amp;D on this PC... 
Even with that Disabled, I still get the &quot;Page cannot be displayed&quot; 
as shown above. 
 
I've attached the my.ini file as per Your request. 
 
Any Ideas? 
 
Thanks, 
FirstBorn 
 
 

<pre><code class="code-100 nolinks" id="code-125056"># MySQL Server Instance Configuration File
# ----------------------------------------------------------------------
# Generated by the MySQL Server Instance Configuration Wizard
#
#
# Installation Instructions
# ----------------------------------------------------------------------
#
# On Linux you can copy this file to /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options
# (@localstatedir@ for this installation) or to
# ~/.my.cnf to set user-specific options.
#
# On Windows you should keep this file in the installation directory 
# of your server (e.g. C:\Program Files\MySQL\MySQL Server X.Y). To
# make sure the server reads the config file use the startup option 
# &quot;--defaults-file&quot;. 
#
# To run run the server from the command line, execute this in a 
# command line shell, e.g.
# mysqld --defaults-file=&quot;C:\Program Files\MySQL\MySQL Server X.Y\my.ini&quot;
#
# To install the server as a Windows service manually, execute this in a 
# command line shell, e.g.
# mysqld --install MySQLXY --defaults-file=&quot;C:\Program Files\MySQL\MySQL Server X.Y\my.ini&quot;
#
# And then execute this in a command line shell to start the server, e.g.
# net start MySQLXY
#
#
# Guildlines for editing this file
# ----------------------------------------------------------------------
#
# In this file, you can use all long options that the program supports.
# If you want to know the options a program supports, start the program
# with the &quot;--help&quot; option.
#
# More detailed information about the individual options can also be
# found in the manual.
#
#
# CLIENT SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by MySQL client applications.
# Note that only client applications shipped by MySQL are guaranteed
# to read this section. If you want your own MySQL client program to
# honor these values, you need to specify it as an option during the
# MySQL client library initialization.
#
[client]
 
port=3308
 
[mysql]
 
default-character-set=latin1
 
 
# SERVER SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by the MySQL Server. Make sure that
# you have installed the server correctly (see above) so it reads this 
# file.
#
[mysqld]
 
# The TCP/IP Port the MySQL Server will listen on
port=3308
 
 
#Path to installation directory. All paths are usually resolved relative to this.
basedir=&quot;C:/Program Files/MySQL/MySQL Server 5.0/&quot;
 
#Path to the database root
datadir=&quot;C:/Program Files/MySQL/MySQL Server 5.0/Data/&quot;
 
# The default character set that will be used when a new schema or table is
# created and no character set is defined
default-character-set=latin1
 
# The default storage engine that will be used when create new tables when
# default-storage-engine=INNODB
default-storage-engine=MyISAM
 
# Set the SQL mode to strict
sql-mode=&quot;STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION&quot;
 
# The maximum amount of concurrent sessions the MySQL server will
# allow. One of these connections will be reserved for a user with
# SUPER privileges to allow the administrator to login even if the
# connection limit has been reached.
max_connections=100
 
# Query cache is used to cache SELECT results and later return them
# without actual executing the same query once again. Having the query
# cache enabled may result in significant speed improvements, if your
# have a lot of identical queries and rarely changing tables. See the
# &quot;Qcache_lowmem_prunes&quot; status variable to check if the current value
# is high enough for your load.
# Note: In case your tables change very often or if your queries are
# textually different every time, the query cache may result in a
# slowdown instead of a performance improvement.
query_cache_size=0
 
# The number of open tables for all threads. Increasing this value
# increases the number of file descriptors that mysqld requires.
# Therefore you have to make sure to set the amount of open files
# allowed to at least 4096 in the variable &quot;open-files-limit&quot; in
# section [mysqld_safe]
table_cache=256
 
# Maximum size for internal (in-memory) temporary tables. If a table
# grows larger than this value, it is automatically converted to disk
# based table This limitation is for a single table. There can be many
# of them.
tmp_table_size=8M
 
 
# How many threads we should keep in a cache for reuse. When a client
# disconnects, the client's threads are put in the cache if there aren't
# more than thread_cache_size threads from before. This greatly reduces
# the amount of thread creations needed if you have a lot of new
# connections. (Normally this doesn't give a notable performance
# improvement if you have a good thread implementation.)
thread_cache_size=8
 
#*** MyISAM Specific options
 
# The maximum size of the temporary file MySQL is allowed to use while
# recreating the index (during REPAIR, ALTER TABLE or LOAD DATA INFILE.
# If the file-size would be bigger than this, the index will be created
# through the key cache (which is slower).
myisam_max_sort_file_size=100G
 
# If the temporary file used for fast index creation would be bigger
# than using the key cache by the amount specified here, then prefer the
# key cache method. This is mainly used to force long character keys in
# large tables to use the slower key cache method to create the index.
myisam_max_extra_sort_file_size=100G
 
# If the temporary file used for fast index creation would be bigger
# than using the key cache by the amount specified here, then prefer the
# key cache method. This is mainly used to force long character keys in
# large tables to use the slower key cache method to create the index.
myisam_sort_buffer_size=16M
 
# Size of the Key Buffer, used to cache index blocks for MyISAM tables.
# Do not set it larger than 30% of your available memory, as some memory
# is also required by the OS to cache rows. Even if you're not using
# MyISAM tables, you should still set it to 8-64M as it will also be
# used for internal temporary disk tables.
key_buffer_size=10M
 
# Size of the buffer used for doing full table scans of MyISAM tables.
# Allocated per thread, if a full scan is needed.
read_buffer_size=64K
read_rnd_buffer_size=256K
 
# This buffer is allocated when MySQL needs to rebuild the index in
# REPAIR, OPTIMZE, ALTER table statements as well as in LOAD DATA INFILE
# into an empty table. It is allocated per thread so be careful with
# large settings.
sort_buffer_size=256K
 
 
#*** INNODB Specific options ***
 
 
# Use this option if you have a MySQL server with InnoDB support enabled
# but you do not plan to use it. This will save memory and disk space
# and speed up some things.
#skip-innodb
 
# Additional memory pool that is used by InnoDB to store metadata
# information. If InnoDB requires more memory for this purpose it will
# start to allocate it from the OS. As this is fast enough on most
# recent operating systems, you normally do not need to change this
# value. SHOW INNODB STATUS will display the current amount used.
innodb_additional_mem_pool_size=2M
 
# If set to 1, InnoDB will flush (fsync) the transaction logs to the
# disk at each commit, which offers full ACID behavior. If you are
# willing to compromise this safety, and you are running small
# transactions, you may set this to 0 or 2 to reduce disk I/O to the
# logs. Value 0 means that the log is only written to the log file and
# the log file flushed to disk approximately once per second. Value 2
# means the log is written to the log file at each commit, but the log
# file is only flushed to disk approximately once per second.
innodb_flush_log_at_trx_commit=1
 
# The size of the buffer InnoDB uses for buffering log data. As soon as
# it is full, InnoDB will have to flush it to disk. As it is flushed
# once per second anyway, it does not make sense to have it very large
# (even with long transactions).
innodb_log_buffer_size=1M
 
# InnoDB, unlike MyISAM, uses a buffer pool to cache both indexes and
# row data. The bigger you set this the less disk I/O is needed to
# access data in tables. On a dedicated database server you may set this
# parameter up to 80% of the machine physical memory size. Do not set it
# too large, though, because competition of the physical memory may
# cause paging in the operating system. Note that on 32bit systems you
# might be limited to 2-3.5G of user level memory per process, so do not
# set it too high.
innodb_buffer_pool_size=16M
 
# Size of each log file in a log group. You should set the combined size
# of log files to about 25%-100% of your buffer pool size to avoid
# unneeded buffer pool flush activity on log file overwrite. However,
# note that a larger logfile size will increase the time needed for the
# recovery process.
innodb_log_file_size=10M
 
# Number of threads allowed inside the InnoDB kernel. The optimal value
# depends highly on the application, hardware as well as the OS
# scheduler properties. A too high value may lead to thread thrashing.
innodb_thread_concurrency=8
</code></pre>
</div>

<div>
Hi nplib, 
 
Thanks for helping. 
 
Yes, I'm on an XP PC (wife's PC) trying to set things up on this box. 
I've got it set up easily on My Mandriva 2008.1 box in the other room. 
(My Development Machine...) 
 
&quot;trying using the actual IP of the server, like the one attached to a NIC card.&quot; 
 
I'm using DHCP... 
My ISP (Verizon FiOS) gives Me a Dynamic IP, so I can't use a Static IP. 
Are You talking about the internal IP assigned from the Router? 
192.168.x.x didn't do the trick, either. 
 
Any Ideas? 
 
Thanks, 
FirstBorn 

</div>

<div>
create a &quot;FAKE&quot; nic card, give it an IP Address, Bind your MYSQL server to that IP address, then try that.
</div>

<div>
Hi Byron, 
 
Thanks! 
I am not getting the 10061 error. 
 
Now, it's changed to the following error: 
--------------------------------------------------------- 
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\mysql_test1.php on line 15 
----------------------------------------------------------- 
 
I'll attach the code here, even though it's in the starting post of this Q. 
 
Any Ideas? 
 
Thanks, 
FirstBorn 
 
PS. &nbsp;Thanks, nplib, don't think that I need that now... 
Seems to be connecting properly... 

</div>

<div>
Thank You VERY Much for Your Help! 
Now, I've got to figure out why port 8080 isn't pulling up My Wife's Page when it did before... 
Again, Thank You VERY Much! 
Thanks, 
Christopher
</div>

<div>
Pleasure to be of assistance. :) Glad that it is working, 
With regards to port 8080. Did you you set that up via Virtual Host or are you just accessing the website via localhost. Apache's default port is 80. 
 
The PHP error you are getting is because the SQL statement seems to be incorrect. It doesnt make sense though because the statement doesnt seem incorrect at all. 
 
If you log into MySQL from the command line are you able to run that query?
</div>

<div>
Hi Byron, 
 
Thanks. 
 
Actually, I had to change the &quot;Listen&quot; to port 8080 and fixed it... 
 
The SQL statement was wrong because I wrote: 
&quot;SELECT * FROM test&quot; 
when it should have read: 
&quot;SELECT * FROM names&quot; 
 
So, it's ALL Fixed. 
 
Again, I REALLY Appreciate Your Help! 
 
Thanks, 
FirstBorn 

</div>

<div>
Hi FirstBorn 
 
Yeah Apache sets the default port to 80. Not sure why it reset if it was working before that. 
 
Hahaha.. I see that now. I was a little tired when I replied last night and didn't in fact see you where trying to select the table and not the table. 
 
Glad its all working and that you can continue now. 
 
Have a great weekend. 
 
Byron
</div>

<div>
Hi Byron, 
 
Actually, I had reinstalled Apache for two reasons: 
1. &nbsp;I had changed some of the settings in the Virtual Hosting conf file and 
it 'messed up' accessing the index page, even though I thought that I put it 
back together again how it used to be, 
and 
2. &nbsp;There were a few articles that instructed to uninstall Apache, and 
mySQL to get rid of the error in the beginning of this Q. 
Evidently, it didn't work, hence, this Q... 
 
The Script that I was having errors with came from here: 
<a href="http://www.bicubica.com/apache-php-mysql/index" rel="ugc">http://www.bicubica.com/apache-php-mysql/index</a> 
... and since I couldn't access phpmyadmin, I knew that 
there was something wrong with mySQL (besides the error...) 
 
I figured out that there was something wrong with the SQL statement 
by typing it into the mySQL Command Line Client and having it spit back 
the error that there was no table test.test... 
 
Either way, I don't mind getting errors if it means that I can resolve 
bigger issues in the mean time... 
 
Have an Excellent Weekend and I really appreciate Your help. 
 
Thanks, 
FirstBorn 

</div>

<div>
Ooops... 
That URL in the previous post should be this: 
<a href="http://www.bicubica.com/apache-php-mysql/index.php" rel="ugc">http://www.bicubica.com/apache-php-mysql/index.php</a> 
 
The person/people that wrote that page did a great job 
for the Tutorial on setting Up Apache-PHP-MySQL- and 
phpMyAdmin. 
 
Thanks, 
FirstBorn
</div>

<div>
<div class="content wysiwyg-content">
Hi, 
 
Thanks for your help. 
 
I am currently on an XP box with the following software specs: 
Apache/2.2.9 (Win32) PHP/5.2.6 and mySQL 5.0.51a/phpMyAdmin 2.11.7.1 
I've uninstalled Apache/PHP/mySQL/phpmyadmin 
and reinstalled it... No good. 
 
I've SCRUBBED Google and this forum and other forums and none of the 
articles worked... 
 
The mySQL Command Line Client works GREAT! 
So, mySQL is UP and RUNNING... 
 
Attached is the code that is generating the following error: 
&lt;code&gt; 
Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'localhost' (10061) in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\mysql_test1.php on line 9 
Can't connect to MySQL server on 'localhost' (10061) 
&lt;/code&gt; 
 
Yes, I've attempted to change hosts and usernames that are in the 
user table with all permissions... 
 
I've attempted to use 127.0.0.1 (and similar as mentioned on different EE Articles 
for this issue.) 
 
No Firewalls enabled (that I know of...) 
Have disabled any type of security setting that I can think of that might block 
any connections to the database, as well... 
 
I've created a table called 'test' using the MySQL Command Line Client. 
Inside, there is a user - John (as found in a bicubica apache-php-mysql install website.) 
It SHOULD be displayed by the script attached to this Q. 
I can access the info using the MySQL Command Line Client. 
 
I've attempted to use both (and either of the two) for the php.ini file: 
extension=php_mysql.dll 
extension=php_mysqli.dll 
... and have stopped and restarted Apache during EVERY Change. 
 
Any Ideas? 
 
Thank you in advance for helping in resolving this issue. 
 
Thanks, 
FirstBorn 
 

<pre><code class="code-10 nolinks" id="code-124804">&lt;?php
 
# Define MySQL Settings
define(&quot;MYSQL_HOST&quot;, &quot;localhost&quot;);
define(&quot;MYSQL_USER&quot;, &quot;firstborn&quot;);
define(&quot;MYSQL_PASS&quot;, &quot;secret_password&quot;);
define(&quot;MYSQL_DB&quot;, &quot;test&quot;);
 
$conn = mysql_connect(&quot;&quot;.MYSQL_HOST.&quot;&quot;, &quot;&quot;.MYSQL_USER.&quot;&quot;, &quot;&quot;.MYSQL_PASS.&quot;&quot;) or die(mysql_error());
mysql_select_db(&quot;&quot;.MYSQL_DB.&quot;&quot;,$conn) or die(mysql_error());
 
$sql = &quot;SELECT * FROM test&quot;;
$res = mysql_query($sql);
 
while ($field = mysql_fetch_array($res))
{
$id = $field['id'];
$name = $field['name'];
 
echo 'ID: ' . $field['id'] . '&lt;br /&gt;';
echo 'Name: ' . $field['name'] . '&lt;br /&gt;&lt;br /&gt;';
}
 
?&gt;
</code></pre>
</div>
</div>

Hi,

Thanks for your help.

I am currently on an XP box with the following software specs:
Apache/2.2.9 (Win32) PHP/5.2.6 and mySQL 5.0.51a/phpMyAdmin 2.11.7.1
I've uninstalled Apache/PHP/mySQL/phpmyadmin
and reinstalled it... No good.

I've SCRUBBED Google and this forum and other forums and none of the 
articles worked...

The mySQL Command Line Client works GREAT!
So, mySQL is UP and RUNNING...

Attached is the code that is generating the following error:
<code>
Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'localhost' (10061) in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\mysql_test1.php on line 9
Can't connect to MySQL server on 'localhost' (10061)
</code>

Yes, I've attempted to change hosts and usernames that are in the
user table with all permissions...

I've attempted to use 127.0.0.1 (and similar as mentioned on different EE Articles 
for this issue.)

No Firewalls enabled (that I know of...)
Have disabled any type of security setting that I can think of that might block 
any connections to the database, as well...

I've created a table called 'test' using the MySQL Command Line Client.
Inside, there is a user - John (as found in a bicubica apache-php-mysql install website.)
It SHOULD be displayed by the script attached to this Q.
I can access the info using the MySQL Command Line Client.

I've attempted to use both (and either of the two) for the php.ini file:
extension=php_mysql.dll
extension=php_mysqli.dll
... and have stopped and restarted Apache during EVERY Change.

Any Ideas?

Thank you in advance for helping in resolving this issue.

Thanks,
FirstBorn

mysql_connect error Can't connect to MySQL server on 'localhost' (10061)  and phpmyadmin #2003 - The server is not responding

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.