It can be useful to know how to set a root password in MySQL, as well as how to add it to the PATH. Setting a root password is good practice for security, while adding MySQL to the PATH will allow you to access your MySQL database from the command line. Learn more about configuring MySQL in this PHP with MySQL online tutorial.
In this video, we're going to do some configuration to MySQL. …Specifically, I want us to set a root password, MySQL, because by default, …MySQL comes with no default password for the root user. …Root user being the most powerful user on the system. …The one with the most privileges inside MySQL. …And it's just a good security practice to always have a default password set, so …that only someone who knows that password can get access to the data that's in the database. …Now you may think, well, I'm not going to be sharing this data with anyone.…
It's only on my personal laptop. I'm the only one who uses it. …But it is a good practice, because you may end up importing some data from a …production database, at some point, onto your development machine. …And if someone were to come and find your laptop, or if you were to lose it, they …could get access to all of the data that was on there. …So I want us to go ahead and follow this best practice and set a root password for MySQL. …Now the tool that we need in order to update the MySQL password is MySQL Admin, …
- What is PHP?
- Installing and configuring PHP and MySQL
- Exploring data types
- Controlling code with logical expressions and loops
- Using PHP's built-in functions
- Writing custom functions
- Building dynamic webpages
- Working with forms and form data
- Using cookies and sessions to store data
- Connecting to MySQL with PHP
- Creating and editing database records
- Building a content management system
- Adding user authentication
Skill Level Beginner
Q: This course was revised on 6/4/2013. What changed?
A: The old version of this course was 6 years old and it was time for a complete revision, using PHP 5.4. (The tutorials will work with any version of PHP and covers any differences you might encounter). The author has also added updated installation instructions for Mac OS X Mountain Lion and Windows 8. The topics and end project are the same, but the code is slightly different. It also addresses frequently asked questions from the previous version.
Q: This course was updated on 5/20/2015. What changed?
A: We added one movie called "Changing the document root in Yosemite," which helps the Mac installation run more smoothly.
1. PHP Overview
2. Mac Installation
3. Windows Installation
4. First Steps
5. Exploring Data Types
6. Control Structures: Logical Expressions
7. Control Structures: Loops
8. User-Defined Functions
10. Building Web Pages with PHP
11. Working with Forms and Form Data
12. Working with Cookies and Sessions
13. MySQL Basics
14. Using PHP to Access MySQL
15. Building a Content Management System (CMS)
16. Using Site Navigation to Choose Content
17. Application CRUD
18. Building the Public Area
19. Regulating Page Access
Next steps2m 4s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.