From the course: Linux for PHP Developers
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Configuring the MySQL database server
From the course: Linux for PHP Developers
Configuring the MySQL database server
- [Instructor] Database Administration is a rich topic, and could be a course unto itself. In this chapter I'm going to focus on the practical essentials that will keep you productive and give context for troubleshooting. We'll start by configuring the MySQL server to have some logical development friendly defaults. Then, we'll explore how MySQL permissions work and configure the database to allow remote connections. Once that's ready, we'll connect to the server with MySQL Workbench and opensource utility for managing databases. Finally, we'll create databases and users needed in the next chapter. The MySQL server comes with working defaults, but we'll need to make a couple configuration changes to make it more development friendly. Similar to a patchy nphp, the configuration is in et cetera in the MySQL sub directory. Let's edit the MySQL configuration. From the terminal, use sudoedit to modify etc/mysql/mysql.cnf press escape then / to move the cursor to the end. If we scroll…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.