Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
In order to make the coding of our exercise files consistent, I'm going to show you how to create a database user that has access to the MySQL database server, and we'll use the credentials for that user throughout the course. In phpMyAdmin go to the home-screen, from there click on the Users tab, depending on how you installed MySQL and what software bundle you used, you might see a variety of user identities in this list. Minimally, you should see one named root, which is the super user or administrator of the entire database server.
It's typically a good idea to create your own database users. So on this screen I'll click Add user. I'll set my username and password to some very simple easy to remember values. I'll set the User name to dbuser, all lowercase. For the Host, I'll pull down the list and choose Local, and that sets the host to localhost. I'll click into the Password, and I'll type a simple string of dbpassword, again, all lowercase, and I'll type it twice to make sure I got it right.
Now I'll scroll a little further down, and I'll click the Check All link, and that adds all privileges to this user. dbuser will be able to access all databases on the server and do anything that the database server allows. I'll go down to the bottom of the screen and click Add user, and I should see that my database user has been created. So that's the user identity that I'll use throughout all of these exercises. If you have any trouble connecting, you might try deleting the user and then re-creating it again and make sure that you type in the password carefully so that it's something you'll easily remember.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 97472 Viewers
61 Video lessons · 84700 Viewers
71 Video lessons · 68900 Viewers
56 Video lessons · 101346 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.