Ajax software     Free javascripts 
↑


Main Page

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

c01.qxd:c01 10:38 12

Ajax software     Free javascripts 
→ R7