[RESOLVED] can't run mysql

[michaewlewis]

Using WinXP Pro, apache2, php5, mysql5.
When I try to run mysql command line I get this error:

 D:\Program Files\MySQL\MySQL Server 4.1\bin>mysql -u root -p

Enter password: ******
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

I tried the advice in the manual, changing the port numbers and whatnot, and am running out of ideas.
I have also opened port 3306 in windows firewall, but that didn't help either.
I am assuming that when I finally get mysql to run, it will work with apache and php. When I call mysql_connect() in php I get this:

 Warning: mysql_connect() [function.mysql-connect]: Unknown MySQL server host 'root' (11001) in D:\Program Files\Apache Group\Apache2\htdocs\index.php on line 5

I have tried uninstalling and reinstalling mysql several times and each time didn't work. I have noticed that the mysql_create_db file is missing from any dirs and not sure if I really need it.

Any help will be appreciated. Let me know if you need more info for a diagnosis

[Houdini]

My standard answer for these problems is to get XAMPP or WAMP and be done with it, you either have an incomplete install or a corrupted install. The link to XAMPP Home Page and to WAMP Home Page will solve your problem with a download and install. XAMPP includes Perl but WAMP does not other than a whole lot of other features like a mailserver and an FTP server and sqlite,

[michaewlewis]

uggh.
After about a month of fooling around with it, I finally figured out that I was just missing a couple of stupid quotes.
Sometimes I just really hate programming :mad: