Cannot connect to mysql db...

I have recently intalled apache, php and sql to a WinMe box. Everything seems to be installed OK until I start the mysqladmin.exe

After this, the PC gradually slows until a near seizure, and my php test page is unable to connect to the database. Script as follows...



<?php

$result = mysql_create_db ("test_database");
if ($result == false)
echo mysql_errno() . ": " . mysql_error() . "<BR>";

?>

I have followed Bens article on setting up WinMe in this fashion. Do not know where it may have gone wrong.
Have previously tried to install PWS (unsuccessful) and Sambar Server (successful).

Thank you for any help in advance.

how much ram on your computer do you have and how much space do you have on your harddrive? it sounds like you have no space on your computer at all. also i looked at your conf file and i have to ask is this site you are using a registered site. like a site already with it's on host and what not?

I had trouble installing Apache and everything else so I went to EasyPHP.net and grabbed EasyPHP. The site is French but documentation is in English. Works great.

Ben's article was helpful but I could never get it to work and got tired to messing with it. I understand the conf. file better now.

EasyPHP loads Apache, php, mysql, and phpmyadmin all at once and .

Wow!! We just had a huge earth quake!!!! The whole house shook around, rolled through. Trees shook! What you get for livin' in Alaska!

Anyway, my computer didn't crash. : )

EasyPHP was the easiest and fastest way I know to get all you need up and running. It gives you the conf. file to modify and a one app. to run when you want Apache, and mysql to run, right from your desktop!

The only thing I worry about is when I need to update php, will it be as easy?

what kind of computer are you running it on littleblackdog?


also when you guys go to download apache what version are you using? the same question about php?

I'm running:
Apache 1.3.27 and
PHP 4.2.3.

I have 128MB RAM and 24.1 GB free on a 40GB HD.

The site is not already registered with own host, but rather I am setting it up now locally and need to test the server side scripting and database connectivity (which was originally to be mainly asp but if I can get this server up and running may yet be php) before ftping to a clients webspace.

Also,
I went to www.easyphp.net but I can only find there "newsys" application for download, not one called 'easyphp'. Am I looking for the wrong thing?

so do you have the apache web server and php 4.2.3 already working? also what is easyphp?

Seem to be...

I can start Apache from the Start Menu.
A DOS-window launches with the opening line...

"Apache/1.3.27 (Win32) PHP/4.2.3 running..."

so it appears to be in order. I have connected to the a test page which displays the 'php_info()' script with the purple table showing my php properties and the server properties.

you should have installed apache to where it would run as a service so you don't have to keep seeing that ms-dos screen all time. don't do that now since we have apache working fine and dandy. so have you tried re installing mysql?

Try www.Easyphp.org

I'm running several machines. one is a mac with virtual PC and Easyphp loaded. Others are Win2000 and 98. It loads version... ( since I loaded, version 1.6 of Easyphp may be different )

Apache - 1.3.24
PHP- 4.2.0
MySQL- 3.23.49
phpMyAdmin - 2.2.6

Easyphp loaded everything for me.

http://www.easyphp.org

I took the easy way

I just don't know about updating to newer versions...

Thanks ASP Man - LittleBlackDog.
Uninstalled everything and installed EasyPHP in about 5 mins.
Although....
When running the same test script I receive this error, and the page is not written. The test script is attached as txt.

-------------------------------------------------------------------------
Warning: Access denied for user: 'ODBC@localhost' (Using password: NO) in c:\program files\easyphp\www\testmysql2.php on line 4

Warning: MySQL Connection Failed: Access denied for user: 'ODBC@localhost' (Using password: NO) in c:\program files\easyphp\www\testmysql2.php on line 4
----------------------------------------------------------------------------

I then went into EasyPHP admin tool and gave 'anyuser' with 'anypassword' from 'anyhost' access to the database named "test" (which the script attached seemed to have created, but not shown.

Otherwise MySQL once again looks to be installed correctly (within the EasyPHP folder now) as do Apache and PHP. I say this as there is a second db available through the admin tool that is called mysql (with 6 entries) as well as the "test" db mentioned earlier.

I am also not getting the slowdown at all

I am only running Easyphp on local machines, so localhost, root, "" no password. Plus the conf. ini file needs to point to your root folder.

Umm, the text thing... got that too. I was using wordpad and it was writing .txt at the end of all my .php.txt and it just didn't work

So I grabbed a free text editor, Crimson Editor, off web and it will save as .php.
Try that.

Before you get your self into a mess, you have missed soemthign something.

The code you have provided is trying to create a database, you dont show it trying to connect to it. lol

try adding the following line of code.

mysql_connect("localhost","root");

before you try to create the database,

Yeehah grandma!

Shout outs to Ben, ASP Man and LittleBlackDog for perserverance...

Ben, the line was in the script, I needed only add the user "root" and the NULL password and the script is writiing John Tester with each reload to the sql_connect line.

Prepare for many more newbie questions as I learn php...

Once again - thanks all.
Theres a slab of beer 'in the mail' for each of you!!


NB LittleBlackDog - I spun out when EasyPHP started spitting back mysqol errors (or php errors) in French but this was easily rectified through the EasyPHP "myadmin", setting default to English.
This is an excellent app for anyone setting up Apache with php/mysql on a WinMe machine.
Other than last nights post the entire install (less download of 10Mb over dial-up ) was complete in under 5 mins.

I'm still in a huge learning curve with php and the rest. I lucked upon Easyphp after trying to load it all solo and not having luck. Sometimes things work themselves out.

I am trying to learn how to query my db. On the look out for easy, basic, and well written tutorials on mid. to advanced queries.

If you want to check out some more php/mysql freebies:

Claroline.org ( or .net ) - an online classroom module.
ExCalendar (forgot the name) @ http://realize.be/swentel - a great calendar.

I look for these free php/mysql programs. It's easy to study the code ; ).

Good luck.