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.
Troubleshooting MySQL
- [Instructor] MySQL is a rock-solid, battle-hardened service. It can also bring a site down to its knees if it's misconfigured or overwhelmed. The Ubuntu Server Guide about MySQL at help.ubuntu.com is a good resource for learning how to manage the service itself. The very first troubleshooting step is to make sure that the port is forwarded. From the virtual box manager, select Sandbox then Settings, Network, Advanced, and Port Forwarding. MySQL should be there, with the host port of 9306 and a guest port of 3306. If not, either add the row by clicking the plus or edit the individual ports so they match. When you're ready, click OK. Then OK again. Let's check to see if the MySQL service is running. From a terminal or your favorite SSH client, connect to the server. Ssh sandbox.dev. Then, we use process snapshot with aux to see if MySQL is running. We're going to pipe it to grep and we're going to look for mysql. If it's not running, try restarting it. Sudo service mysql restart…
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.