All posts tagged 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

How do I set MySQL to listen on localhost only?

To set MySQL so it listens on localhost only, effecttively closing port 3306 on your public IP, add the following line to your /etc/my.cnf in the mysqld section: bind-address = 127.0.0.1 Then restart MySQL in the control panel or by running service mysql restart.

How can I manage MySQL?

In order to manage your VPS MySQL installation, you can use phpMyAdmin. This will be accessible with the following URL: http://www.example.com/vps/mysql_admin/

Cannot connect to MySQL when running symfony 1.x tasks

If you get the following error when running a symfony task through the command line (like insert-sql): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ Try configuring config/propel.ini with the server hostname where your account resides (ie. sg112.servergrove.com) instead of localhost. This will force propel to connect through TCP/IP . . . 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