3. Now add a new user to the database. Our data tier access code will access the TShirtShop database using
this user??™s credentials. You??™ll create a user named tshirtshopadmin (with the password tshirtshopadmin),
who will have full access inside the TShirtShop database but not to any other database. You have more
alternatives to achieve the same results, and for more details, see the MySQL documentation at http://
dev.mysql.com/doc/refman/5.1/en/account-management-sql.html.
Now, click the SQL tab, and type the SQL query shown in Figure 3-13.
Figure 3-13. Creating a new database user
4. After entering the SQL query as shown, click the Go button. You should be informed that the SQL query has
been executed successfully (see Figure 3-14).
CHAPTER 3 ?– STARTING THE TSHIRTSHOP PROJECT 60
Figure 3-14. The new user has been successfully created in the database.
Downloading the Code
You can find the latest code downloads and a link to an online version of TShirtShop at the
authors??™ web sites at http://www.cristiandarie.ro or http://www.emilianbalanescu.ro or in
the Source Code/Download section of the Apress web site at http://www.apress.com. It should
be easy to read through this book and build your solution as you go; however, if you want to
check something from our working version, you can. Instructions on loading the chapters are
available in the welcome.
Pages:
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131