I had two MySQL servers running (127.0.0.1:3306 and 127.0.0.1:3307). Now I get this strange error:
mysql_connect(): Lost connection to MySQL server at 'reading initial communication packet' I can connect with
localhost:3307, but there aren't any tables/databases. I'm fairly sure
/etc/my.cnf is right:
[mysqld_multi] mysqld = /usr/bin/mysqld_safe mysqladmin = /usr/bin/mysqladmin user = root password = *** [mysqld] port = 3306 socket = /var/run/mysql/mysql.sock [mysqld2] port = 3307 socket = /var/run/mysql/mysql2.sock
What can I do now? How can I sanely restart the MySQL server?
Perhaps more importantly:
How can I make sure all the tables still exist?