All posts in MySQL

Cannot connect to MySQL when running Symfony2 commands

If you get the following error when running a Symfony command through the command line (like doctrine:schema:update): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ Try configuring app/config/parameters.yml with the server hostname where your account resides (ie. sg112.servergrove.com) instead of localhost. This will force the ORM to connect through . . . Read more

Install phpMyAdmin on a VPS

ServerGrove has made very simple to install phpMyAdmin in your own VPS, using our own repositories. The steps are simple: To access phpMyAdmin via the web, go to your Control Panel, select “Databases” from the list of applications, then click on “PhpMyAdmin” on the left-side menu. Use any of your . . . Read more

Managing MySQL databases with the Control Panel

Log into your Control Panel, then select the server you would like to manage, by clicking on it then selecting “Applications”, and then select the MySQL app. On the left side of the screen, click “Databases”. To add a new database On the center of the screen, right below the . . . Read more

Managing MySQL users with the Control Panel

Log into your Control Panel, the select the server you would like to manage, by clicking on it then selecting “Applications”, and then select the MySQL app. On the left side of the screen, click “Users”. To add a new user On the center of the screen, right below the . . . Read more

Using MySQL with the VPS Control Panel

First, log into the Control Panel, then click on the server you want to manage, then click “Applications” Next, click the “Manage” button in the MySQL app, where you see the MySQL logo. If you don’t see the MySQL app, try clicking on the “Sync Apps” link on the left . . . Read more

How Do I Enable Remote Access To MySQL Database Server?

By default remote access is disabled to your MySQL database server. However, sometimes you need to provide remote access to a database for some reason or another. This is a tutorial provides a quick overview how to easily enable remote access to your MySQL server on your ServerGrove VPS. Step . . . Read more

How do I backup MySQL databases?

For VPS Users: Even though we backup VPS files, it is not recommended to rely on file backups for MySQL backups and you are responsible for making your own backups. Restoring a database from file backups can result in corruption. We recommend to use mysqldump to create a MySQL dump . . . Read more

Cannot connect to MySQL from command line (shared hosting)

If you get the following error: "Can’t connect to local MySql server through socket ‘/var/lib/mysql/mysql.sock’ (2)" when trying to connect to MySQL server from your shell account, it means that the mysql.sock file is not available inside the chroot environment. To connect to MySQL, use the server hostname instead, ie.: . . . Read more