Using XAMPP

Getting started

For use on your PC:  Download and install (see the main page for the class for a link).  You may need to run as administrator.  The program to run is XAMPP Control Panel.

If you get a firewall warning, Allow access.

XAMPP windowUse Config to tell it to always start Apache and MySQL.  You may need to start them this time, too.

To see your web pages, take your brower to http://localhost, or click Admin to the right of Apache.

 You should see any folders you put into c:\xampp\htdocs, or whatever the path we've got set up for you is.

Don't like using c:\xampp\htdocs?  Then change where localhost directs.

If Apache won't start on your machine, it may be a port conflict for Apache.  If you have a MySQL port problem, go to Config, Server and Port Settings, MySQL tab, and change it to some new number (just guess); and replace the old port number with the new in MySQL config, m.ini.

Currently I am typing localhost:81 to get there, but lab machine setup will be different.

To get into MySQL, click on Shell, then type in the mysql command, mysql -u root.

Changing the root password

You may want to do this for compatibility with the lab machines, while doing development.  Definitely change the root password before deploying your web site, on mintaka or elsewhere.

Log into your PC as administrator (which you surely are on your home computer).  Turn off MySQL (I used Task Manager, Processes, Show processes from all users).  This will also work: 

mysqladmin -u root shutdown.  

mysqladmin is in the same folder as mysql.

Save this as a text file, perhaps C:\users\you\desktop\mysql-change-password.txt

UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES;

Apply it thus:

mysql --init-file=C:\users\you\desktop\mysql-change-password.txt

Then restart MySQL (kill it again, and start EasyPHP from the System tools tray).

Source.

Note that this does not require you to have an account on MySQL to use it -- but it does allow you to log in as root with the password you want.