A couple quick MySQL questions

[Destian]

All right, I'm trying to set up a testing environment on my WinXP system. (Apache, PHP, MySQL) I have a couple quick questions.

1) Where can I find a good beginners guide to setting up mysql. I've found some threads with similar questions, but most of the links show how to use MySQL if your webhost supports it... not how to set it up.

2) Should the MySQL directory be inside my Apache2 directory (same for php)?

Right now, I have x:/Server/Apache2 x:/Server/PHP x:/Server/MySQL

PHP seems to be working properly, but what would the ideal setup be? I do have the my.cnf at the root of C linking to the MySQL directory

3) Errr... what is my MySQL username? The my.cnf has a remmed out password, but I can't find a username anywhere. (I know, I'm pathetic)

4) How would I create a database for IPB?

I want to learn how to do this stuff, so I'm not looking for a preconfig like Triad, etc.

Thank you.

[cobain81]

  Destian said:

All right, I'm trying to set up a testing environment on my WinXP system. (Apache, PHP, MySQL) I have a couple quick questions.

1) Where can I find a good beginners guide to setting up mysql. I've found some threads with similar questions, but most of the links show how to use MySQL if your webhost supports it... not how to set it up.

2) Should the MySQL directory be inside my Apache2 directory (same for php)?

Right now, I have x:/Server/Apache2  x:/Server/PHP  x:/Server/MySQL

PHP seems to be working properly, but what would the ideal setup be? I do have the my.cnf at the root of C linking to the MySQL directory

3) Errr... what is my MySQL username? The my.cnf has a remmed out password, but I can't find a username anywhere. (I know, I'm pathetic)

4) How would I create a database for IPB?

I want to learn how to do this stuff, so I'm not looking for a preconfig like Triad, etc.

Thank you.

1) Read README and INSTALL txt files in installers...there is everything you should know to install. Follow up this order: APACHE, PHP, MYSQL.

2) No, I use these directories: C:\Program files\ApacheC:\Program files\Php, C:\Program files\Mysql

3) Default username / password: "root" / "" (none).

4) Forums have their installer script (something like /forum/install directory). Run it and it will create database and tables.

[Tim Dorr Veteran]

The specific file for installing IPB is sm_install.php, but it looks like that's a while off from where you'd at right now :D

[Destian]

I ended up using the winmysqladmin.exe that came with the download and that seemed to... work... i... think?

Strange thing is, I randomly decided to try ipb install with leaving the mysql pw blank, and it actually went through. It still won't work with the password though, which I really don't understand.

Oh, well, still lots to learn I guess. Setting up IPB is actually pretty fun though.

Thanks again.

[Tim Dorr Veteran]

By default, the mysql login is "root" without a password. I'd recomment getting MySQLFront or installing PHPMyAdmin so you can have a frontend to MySQL and work with it that way :)

[Destian]

Yeah, I probably should. What would you recommend? I seem to see PHPMyAdmin come up quite a bit, so I'll probably go with that, but I'd like to know what you think.

Also... I love you.

Thanks.