As an exercise for both using phpMyAdmin and working with MySQL, let’s create a database called
ajax, and create a MySQL user with full privileges to this database. You’ll use this database and this user for all the exercises in this book. Follow these steps:
http://localhost/phpMyAdminin your web browser. If the configuration data you wrote in
config.inc.phpwas correct, you should see something like this:
ajaxin the Create a new database box, and then click the Create button.
phpMyAdmin doesn’t have the visual tools to create new users, so you’ll need to write some SQL code now. You need to create a user with full access to the
ajaxdatabase, which will be used in all the case studies throughout the book. This user will be called (surprise!) ajaxuser, and its password will be practical. To add this user, click the SQL tab at the top of the page, and write this code in it:
GRANT ALL PRIVILEGES ON ajax.* TO ajaxuser@localhost IDENTIFIED BY “practical”
Click the Go button.
Congratulations, you’re all set for your journey through this book. Have fun learning AJAX!