Feed on
Posts
Comments

A few days ago I wrote a post on using Easy PHP to web applications such as blogs, E-commerce and CMS on your PC. The advantage of running these applications on your PC is that you can hack them to pieces without affecting your live site!

Before you can use the the applications though, you will need to create a database. If you have installed Easy PHP or something similar, you will already have MySQL installed on your PC.

The easiest way to use MySQL on your PC is to install the free admin tools available from the MySQL website.

There are two tools of particular value, MySQL Query Browser, which allows you to browse tables and run SQL statements, and MySQL administrator, which allows you to create users and databases.

Installation scripts for common web applications require a database name and a user, so MySQL administrator is the application you will need first.

After downloading and installing it, you will need to log onto your MySQL instance. By default, you will log on using the username “root” with no password:

sqladmin.png

You will also need to set “localhost” as the server (indicating you are connecting to MySQL on your local PC as opposed to a network machine).

Once logged on you will be able to click the “Catalogs” icon. Right clicking in the window below will allow you to create a new database schema:

sqladmincat.png

Once you have created your new database (schema), you need to create a user. Click on the “Users” icon in the left hand menu and, within the right hand window click “Add New User”. You will then be able to enter the name of the new user, and their password:

sqladmin2.png

Once you have created a new users, you need to assign privileges for this use on your new schema. Click on the “Schema Privileges” tab. In the left hand pane, select the database schema for which you would like to assign privileges. In the right hand window you will see all available privileges. Highlight the privileges you wish to assign and click the arrow pointing left. If you are assigning multiple privileges, you will need to use the “double arrow” As shown below:

sqladmin3.png

You will see the requested privileges move from the right pane to the left, confirming privileges are assigned. In the screen shot above I have assigned all privileges on the schema named “test”.

I can now install a web application using the database “test” and the user “sitelogic” on the server “localhost”.

Related Posts

  • Easy PHP on Windows
  • Run a Blog On Your Local PC
  • Dont WAMP it LAMP it!!
  • WordPress Mobile Phone Comparison Site
  • RSS feed

    2 Comments

    Comment by James

    I like mySql a lot too. It is also very useful for using Ruby on Rails or other development tools:)

    (Comments wont nest below this level)
    Comment by SiteLogic

    I have never used ROR, but have heard good things about it…. to be honest I don’t think I am likely to take the time to learn it, I still have a lot to learn about PHP…

     
     

    Sorry, the comment form is closed at this time.