MySQL installs with no password set for the root user -- the ultimate admin. This means that anyone with access can make wholesale changes, unless you make some configuration changes. Configuring MySQL for password control is not entirely intuitive. Learn how with this online tutorial and get a step-by-step guide.
- View Offline
- Exercise Files
Now that we have MySQL installed, and this week we're going to look at how we …can configure MySQL. Specifically, there's two changes I want …us to make. The first of those is I want us to add …MySQL to our PATH. That's going to allow us to access MySQL …from the command line inside Unix. We'll talk about what the PATH is and how …to work with it in just a moment. The second change that I want us to make …is I want us to set a root password for MySQL. …By default, there is no password required to log into MySQL as the root user, that …is the user with the most access privileges so its wide open by default.…
That's not a great security measure to have. …Even though we're just on our local machine it's still a good idea to always …go ahead and set a root password. To make sure that your database is locked …down and only someone with that password has access to the data that's inside of them. …So we're going to take care of those two things, and we can do those from the …command line. So I'm going to open up terminal. …
- 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
PHP with MySQL Beyond the Basicswith Kevin Skoglund10h 26m Intermediate
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.