Programming Forums > Web Development and Design > PHP

Eric the Red · Apr 17th, 2007, 2:38 PM

I'm trying to get mysql to work using this sheet as a guideline:

http://home.cogeco.ca/~ebelec/mysql.jpg

However, at STEP 4, of that guide (going to http://localhost/phpmyadmin/index.php) I get the following error.

Quote:

Welcome to phpMyAdmin 2.5.6

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.

Error

MySQL said:

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

[Documentation]

okay, easy right? I need to match the password and usernames. However, I went to the file "config.inc" and added a username and password:

(Toggle Plain Text)

$cfg['SQLValidator']['username'] = 'root';      // If you have a custom username, specify it here (defaults to anonymous)
$cfg['SQLValidator']['password'] = '-------';      // Password for username

Is there something else that I have to change so that I don't get the error above?

I really need help on configuring this. Any help would be greatly appreciated.

Eric the Red · Apr 17th, 2007, 4:05 PM

when I go to the command prompt in 'Win Xp Pro'. I typed

'mysqladmin status'

and the command isn't recognized. However, I installed mysql so how could this be explained?

Infinite Recursion · Apr 17th, 2007, 4:59 PM

mysqladmin is probably not in your path, so the command is not known.

Try using absolute paths or modify your path to include mysql's bin directory and make sure your MySql service is running.

On a side note, why IIS and not Apache? Just curious.

Eric the Red · Apr 17th, 2007, 5:08 PM

IIS Server was the first thing that came to my mind when I thought about windows, that's all.

EDIT***

Had to reinstall and it worked. Must have been me messing around with the my.cnf files.

Thanks anyways.

Infinite Recursion · Apr 18th, 2007, 8:45 AM

Glad you got it working.

If you later find that you don't like IIS, then you can try Apache for windows via this file: http://mirrors.sirium.net/pub/apache...x86-no_ssl.msi

tAK · Apr 18th, 2007, 10:35 PM

Geez.. some guide you have there.. here:
http://www.peterguy.com/php/install_IIS6.html <- to get PHP5 running on IIS

http://www.tanguay.info/wamp/installPhp5.php5?step=13 <- setting up mysql 4.1 (though works just fine for mysql 5)

I am constantly amazed at what some companies will publish, especially when there are people that have way better guides online that are free to access.

Apr 17th, 2007, 4:59 PM	#3
Infinite Recursion Programming Guru Join Date: Jul 2004 Location: United States Posts: 3,467 Rep Power: 8	mysqladmin is probably not in your path, so the command is not known. Try using absolute paths or modify your path to include mysql's bin directory and make sure your MySql service is running. On a side note, why IIS and not Apache? Just curious. __________________ http://jasonpowers.net "There are a thousand hacking at the branches of evil to one who is striking at the root."

Apr 17th, 2007, 5:08 PM	#4
Eric the Red Hobbyist Programmer Join Date: Feb 2006 Posts: 214 Rep Power: 0	IIS Server was the first thing that came to my mind when I thought about windows, that's all. EDIT*** Had to reinstall and it worked. Must have been me messing around with the my.cnf files. Thanks anyways. __________________ Death smiles at us all. All a man can do is smile back. Last edited by Eric the Red; Apr 17th, 2007 at 6:08 PM.

Apr 18th, 2007, 8:45 AM	#5
Infinite Recursion Programming Guru Join Date: Jul 2004 Location: United States Posts: 3,467 Rep Power: 8	Glad you got it working. If you later find that you don't like IIS, then you can try Apache for windows via this file: http://mirrors.sirium.net/pub/apache...x86-no_ssl.msi __________________ http://jasonpowers.net "There are a thousand hacking at the branches of evil to one who is striking at the root."

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Apr 17th, 2007, 4:05 PM	#2
Eric the Red Hobbyist Programmer Join Date: Feb 2006 Posts: 214 Rep Power: 0	when I go to the command prompt in 'Win Xp Pro'. I typed 'mysqladmin status' and the command isn't recognized. However, I installed mysql so how could this be explained? __________________ Death smiles at us all. All a man can do is smile back.

Apr 18th, 2007, 10:35 PM	#6
tAK Programmer Join Date: Mar 2007 Posts: 33 Rep Power: 0	Geez.. some guide you have there.. here: http://www.peterguy.com/php/install_IIS6.html <- to get PHP5 running on IIS http://www.tanguay.info/wamp/installPhp5.php5?step=13 <- setting up mysql 4.1 (though works just fine for mysql 5) I am constantly amazed at what some companies will publish, especially when there are people that have way better guides online that are free to access.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Programming Forums > Web Development and Design > PHP

Mysql and IIS server