Datasheet

3. Start the MySQL console application using the following command (this loads an executable file
named
mysql.exe located in the directory you have just browsed to):
mysql -u root
If you have a password set for the root account, you should also add the -p option, which will have the
tool ask you for the password. By default, after installing XAMPP, the
root user doesn’t have a pass-
word. Needless to say, you may want to change this for security reasons.
4. Create the seophp database by typing this at the MySQL console:
CREATE DATABASE seophp;
MySQL commands, such as CREATE DATABASE, are not case sensitive. If you like, you can type cre-
ate database
instead of CREATE DATABASE. However, database objects, such as the seophp data-
base, may or may not be case sensitive, depending on the server settings and operating system. For this
reason, it’s important to always use consistent casing. (This book uses uppercase for MySQL commands,
and lowercase for object names.)
5. Switch context to the seophp database.
USE seophp;
6. Create a database user with full access to the new seophp database:
GRANT ALL PRIVILEGES ON seophp.*
TO seouser@localhost IDENTIFIED BY “seomaster”;
7. Make sure all commands executed successfully, as shown in Figure 1-7.
8. Exit the console by typing:
exit;
Figure 1-7
Summary
Congratulations! You will soon be ready to write some code and delve into more advanced SEO
concepts! The next chapter takes you through a quick SEO tutorial, and builds the foundation for
the chapters to come.
12
Chapter 1: You: Programmer and Search Engine Marketer
00929c01.qxd:00929c01 3/13/07 10:38 AM Page 12