Q about MySQL/PHP admin on my system

[Leon]

OK, I've discussed this a bit on here before, but the basica prob is that when I tried to install and configure PHP/MySQL on my system, it refused to work. I followed the instructions perfectly 3 times, but it wasn't communicating with MySQL and I couldn't work out where the root dir of localhost was meant to be.

I think the prob is that I have C and D drives along with partion E on D (this is the temp files partition).

C is program files, D is data files - this is the way I like things. But it doesn't seem to mould with PHP/MySQL interaction that well.

If I set up a partition on either C or D and confined everything about PHP/MySQL to that partition, all the dev. files and everything, would that stand a better chance of working out?
Or were my previous problems probably not the result of having 3 separate HDD storages?

[Keith_C]

MySQL

Install the product from the setup file to c:\mysql (custom – no benchmark/libs)
Copy my-medium.cnf to c:\my.cnf
Add set-variable = max_connections=2000
Uncomment basedir and datadir
change basedir=c:/mysql/
change datadir=d:/mysql_db/
Create d:\mysql_db and move c:\mysql\data\* to it
Remove c:\mysql\data
From the bin directory.. Mysqld-nt –install
Start the service
mysql –u root
use mysql ;
delete from user where host=’localhost’ and user=’’ ;
delete from user where host=’%’ ;
update user set host=’%’ ;
update user set password=password(‘specify root password here’);
mysqladmin reload
Restart service, remove test database.

PHP

Unzip to c:\
rename the PHP unzipped directory (php-4.3.0-Win32) to c:\PHP
Open up IIS edit the WWW service, Home Directory..Application configuration button
Add in .php with c:\php\php.exe "%s" %s for all types. Check if file exists.
Copy php.ini-dist to c:\winnt\php.ini
Under [PHP] add cgi.force_redirect=0
Change extension_dir to c:\php
Change SMTP to a valid SMTP server (localhost if mailserver installed)
Change sendmail_from to xxx@xxx.com

[Leon]

pardon?

I take it those are setup instructions to bridge the C/D drives?

[Keith_C]

Setup instructions on how to install MySQL and PHP :)

Neither product actually gives a toss where it stores things, at work we run program files on e: and data on g:.

[Leon]

Setup instructions on how to install MySQL and PHP :)

Neither product actually gives a toss where it stores things, at work we run program files on e: and data on g:.

ok thanks Keith.
I'll try to decipher all that tomorrow when I'm a little less grumpy :D

[Leon]

do I need Apache as well?

[Leon]

MySQL

Install the product from the setup file to c:\mysql (custom – no benchmark/libs)
Copy my-medium.cnf to c:\my.cnf
Add set-variable = max_connections=2000
Uncomment basedir and datadir
change basedir=c:/mysql/
change datadir=d:/mysql_db/
Create d:\mysql_db and move c:\mysql\data\* to it
Remove c:\mysql\data
From the bin directory.. Mysqld-nt –install
Start the service
mysql –u root
use mysql ;
delete from user where host=’localhost’ and user=’’ ;
delete from user where host=’%’ ;
update user set host=’%’ ;
update user set password=password(‘specify root password here’);
mysqladmin reload
Restart service, remove test database.


Don't shout at me, please :(

Where do I go to do all the above? I have no ini files as I thought i did and my-medium all I have is a speeddial thing...
:confused:

I've used the windows installer version from the For Dummies disk...

oh and I don't seem to have a PHP management console either

[Keith_C]

Just download the latest versions from:

www.mysql.com

and

www.php.org

I was assuming you were using IIS - apache is just another headache at this stage.

[Leon]

Just download the latest versions from:

www.mysql.com

and

www.php.org

I was assuming you were using IIS - apache is just another headache at this stage.

erm... probably???
I don't know. I just installed MySQL and PHP from the disk and then found I couldn't do what I wanted with the MySQL setup...

the version i'm trying to use is mysql-3.23.49-win

Thanks for all your help so far :)

[Keith_C]

Eh? Get rid of that - the latest is 4.0.18 or something.