JavaScript Editor 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


JavaScript Editor Ajax software     Free javascripts 
Bitcoin Gambling Site