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

Configuring the MySQL database server

From the course: Linux for PHP Developers

Start my 1-month free trial

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…

Contents