How To Install Your Own Web Server – MySQL Database Management

Unfortunately I haven’t seen any good web hosting control panel for Apache on Windows (if you know some, leave a comment!). So that’s why we’re going to need something else to manage the MySQL server.

MySQL provides a set of GUI tools that allows you to perform such tasks as managing databases, managing database users, configuring the MySQL server, perform SQL queries, etc.

If you’ve followed the previous posts on How To Install Your Own Web Server, then you should now have a running WAMP installation (Windows-Apache-MySQL-PHP).

In part 4 of this tutorial, we’re going to install the MySQL GUI tools, create a new MySQL database and add a user account.

How To Create A MySQL Database

1. Grab yourself a copy of the MySQL GUI Tools here. It’s a MSI file so you just need to execute it and leave all default settings.
2. Execute the MySQL Administrator application (Start => Programs => MySQL => MySQL Administrator). You will be prompted to enter the administrator account (usually root) and password (the one you specified during MySQL installation).
3. Click on Catalogs from the left column icons. This is where you will find all databases hosted on your server.
4. You can drop the test database if you want to. Select it and right-click on it and select Drop Schema from the contextual menu. This is optional.
5. To create a new database, right-click in the area where you see the list of databases and select Create New Schema.
   
6. You will be prompted to enter a name for the new database (or schema as they call it). Let’s name it “mydatabase”. Hit OK.
7. Now we’ve got a database but we can’t use it until we’ve got an account to access it (you could use the root account but this is NOT a good idea).
8. From the left column icons, click on User Administration.
9. Right-click the bottom left panel and select Add New User.
10. From the User Information tab, fill the MySQL User, Password and Confirm Password fields. Do not click on Apply Changes yet.
11. Select the Schema Privileges tab and select mydatabase from the Schemata column.
12. Click on the double arrow pointing to the left to assign all privileges to the user.
13. Click on Apply Changes and you’re done.

In my next post, I will show you how to create a virtual web host using Apache HTTP Server. We will then use this virtual host to install phpMyAdmin.

Click here to subscribe in a RSS reader or to receive email updates.