Running mysql in chroot

mysql linux ubuntu chroot
Neo picture Neo · Feb 20, 2011 · Viewed 9.2k times · Source

I've got a chroot environment working on my 10.04 ubuntu box. I'm trying to run mysql inside this chroot environment, but I get this error.

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Basically I used debootstrap along with schroot to create the chroot. Then I installed "ubuntu-minimal" and mysql-server inside this chroot environment. If you are interested here are all the steps that I followed https://help.ubuntu.com/community/DebootstrapChroot . But mysql does not work inside the chroot. /var/log/mysql.log and /var/log/mysql.err files are empty and mysqld server is running. Any pointers?

Answer

Neo picture Neo · Feb 23, 2011

It is a bug with schroot. mysqld escapes chroot and interacts with systems's mysqld.

http://ubuntuforums.org/showthread.php?t=1625863 https://bugs.launchpad.net/ubuntu/+source/upstart/+bug/430224

Related questions

error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' -- Missing /var/run/mysqld/mysqld.sock

My problem started off with me not being able to log in as root any more on my mysql install. I was attempting to run mysql without passwords turned on... but whenever I ran the command # mysqld_safe --skip-grant-tables & …

Read More
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

I am an electrical engineer who mainly plays around with power systems instead of programming. Recently, I have been following a manual to install a software suite on Ubuntu. I have no knowledge of mySQL at all, actually. I have …

Read More
How to test which port MySQL is running on and whether it can be connected to?

I have installed MySQL and even logged in there as a user. But when I try to connect like this: http://localhost:3306 mysql://localhost:3306 Neither works. Not sure if both are supposed to work, but at least one of them …

Read More