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

Troubleshooting MySQL

From the course: Linux for PHP Developers

Start my 1-month free trial

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…

Contents