TheLinker wrote
First, I have not used this guide when I installed MySQL a long time ago... but it seems to cover the basic installation parts. I do have some comments to this guide, if you don't mind... :-)
The install directory for MySQL should not be inside some other programs main directory. MySQL can be used by other programs than CGI applications in Abyss. Also if the user for some reason decide to uninstall Abyss and use some other web server, it will make their Program Files directory more 'clean' because the Abyss directory now can be removed (after backing up those html, php files of course). If there is some other programs installed inside this directory, it can not be removed... and the user can by a mistake manually remove the rest. I've seen this happend, and it's not a pretty sight. 8O
So I recommend choosing either X:\MySQL or X:\Program Files\MySQL as the target dir for the installation.
I also think you should have a section here explaining the first important steps on setting up the default root account, just to get people started. It's been awhile since I did this, but I think it goes something like this:
After starting up the winmysqladmin and you have green lights, access the database for the first time from your command prompt:
c:\mysql\bin> mysql -u root mysql
From inside the mysql prompt, switch to the mysql database where the user accounts are located:
mysql> use mysql;
Set the password for the root account:
mysql> UPDATE user SET Password=PASSWORD('new_password') WHERE user='root';
mysql> FLUSH PRIVILEGES;
Remove the blank user accounts:
mysql> DELETE FROM user WHERE user=’’;
I also delete the root account where the host field is set to '%'.
mysql> DELETE FROM user WHERE user=’root’ AND host='%';
Now the database only have one account,
root, with the default host field set to localhost, and with a fresh password. There are still many security issues, so users installing MySQL should be somewhat familiar with
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#Privilege_system .
The End... 8)