Already established a connection to MySQL from PHP page thanks to Kevin Yank.

However, now wish to use "Thatware" on web server as a learning exercise.

PC in question is running RHL 7.3, Apache, MySQL 3.23.51 and PHP 4.1.2.

It seems logical to me that I need to establish a non root account in MySQL and grant privileges. Perhaps I have this wrong but is it smart to continue using a connection that calls localhost/root/password from any PHP page on the web server?

What is the correct sequence of commands at the "msql" prompt to create a new database for this use. Also, what commands are needed to create a new user account if required.

Lastly if the grey matter is still on tap, is "Thatware" a suitable candidate for my setup.