Hi there,
Glad you've been enjoying the articles and sorry for the slight delay in replying!
There are two main ways of running MySQL queries, such as the one I provided in the article:
1. Use the mysql / mysqladmin tools.
In Windows, open the command prompt (start->run->
cmd) Navigate to the MySQL folder, e.g.
cd c:\mysql
Now you can create the database, with the command:
Code:
mysqladmin create databasename
Where
databasename is what you wish to call the database, e.g. intranet or content etc
Then, you need to run the MySQL code I provided in the article to insert some tables into this database. To do this, run:
mysql -u username -p
(You'll next be asked for the password)
Finally, copy and paste the mysql code from the article (changing `databasename` to whatever you just called it), and you're done! Note that because it's on multiple lines in the article, you may have to copy it bit by bit. You don't have to worry about that if you use this method:
2. Use a third party tool. This should be quite a bit easier than the other method.
You state you have MySQL Query Browser, I recommend this tool to everyone - it's very good (
http://dev.mysql.com/downloads/query-browser/). Use it to connect to your MySQL server (by entering the username, password etc), and create the database by typing into the query box at the top:
Code:
create database databasename
And click execute. You can then copy and paste my code into the same box, click execute, and presto! The table is created.
I hope that helps!
Peter.
Creating a PHP-Based Content Management System
Linear Mode
