New to MYSql please be kind

[cambridge]

hi

im running win xp pro with apache server 1.3.20, PHP 4.1.1 and MYSQL 3.23.39

im using them to learn php/mysql so that i can create better sites. so im running localhost.

i have got apache and php4 running happily (ie when i run a phpinfo() i get the info page) and MYSQL seems to be happy, despite having not wirtten a my.cnf file anywhere!!

the phpinfo says there is mysql 3.23.39 support but when i try to use mysql in php scripts i get errors
Warning: MySQL Connection Failed: Can't connect to MySQL server on 'localhost' (10061) in
and
Warning: Supplied argument is not a valid MySQL-Link resource in

any help on how to get it all running nicely together would be much appreciated

[ffeingol]

Can you just log directly into mysql? You should be able to open a dos box and execute the msql command line tool (i.e. mysql -u user-id -p). The mysql command line tool should be somewhere in the directories where mysql was installed (sorry, I'm not that familar with the Windows version of mysql).

Frank

[peanuts]

Are you using apache or IIS???

Usually (at least at my pc ) there is a program called winmysqladmin.exe (or something simular) and with it you can make a table and see the status of the mysql database!!

Try to find it...

Greets,

Peanuts

[miithilesh]

please check once your connecting port no in php.ini filefor mysql .It should be 3306, If you are using the IIS.

[seanf]

Check your private messages, I did reply

Sean

[Brad]

Make sure that you created the database and assigned a username and password to it. Easiest method is by using the winmysqladmin.exe program.