WSN Knowledge Base https://scripts.webmastersite.net/wsnkb/manual en-us phpMyAdmin phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the WWW. https://scripts.webmastersite.net/wsnkb/manual/introductory-topics/helpful-software-and-sites/phpmyadmin-109.html Thu, 20 Nov 2003 01:37:48 GMT https://scripts.webmastersite.net/wsnkb/manual/introductory-topics/helpful-software-and-sites/phpmyadmin-109.html phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the WWW. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges,export data into various formats and is available in 46 languages.

Here's a beginner's guide to using phpmyadmin: http://www.siteground.com/tutorials/phpmyadmin/

Note that almost all web hosts already have phpmyadmin installed for your use. In CPanel it's frequently beneath the "MySQL" area. In the rare event that your host doesn't have it you may want to install it yourself.

The phpMyAdmin project

]]> Installing a web server with XAMPP Instantly install apache, php and mysql on any computer. https://scripts.webmastersite.net/wsnkb/manual/introductory-topics/helpful-software-and-sites/installing-a-web-server-with-xampp-108.html Wed, 19 Nov 2003 01:46:11 GMT https://scripts.webmastersite.net/wsnkb/manual/introductory-topics/helpful-software-and-sites/installing-a-web-server-with-xampp-108.html Xampp will let you run just one simple automatic setup file to properly configure apache, php and mysql for your computer. This is especially useful for the Microsoft Windows platform, which doesn't have any package management tools and thus normally leaves the installation process complicated. Note that Xampp is available for Windows, Mac and Linux.

With this installed, you'll be able to use your own computer just like a web site. Copy your WSN autosetup.php into the /htdocs/ subdirectory of where you installed xampp, and you'll be able to install WSN on your computer by typing http://localhost/autosetup.php in your favorite web browser. This lets you test on your own computer, instead of on a live website. You can even contruct your whole site on your own computer and then just backup the database and files and restore it to your server (though if you do that you'll need to edit your config.php to set the proper directory url and file path after moving to the remote host).

To create the database for your install you should find phpmyadmin at http://locahost/phpmyadmin . Your mysql user and password will default to root with no password.]]>