12 June 2005
Well, I hope I don’t need to do that again.
Because I installed different packages, and in a different order, than my last Debian system, I wound up with the problem of some users having been created in a different order, thus creating some knotty permissions problems. I fixed these in /var/log/mysql, /var/run/mysql, and for the new stuff in /var/lib/mysql. This solved the reported problem:
Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (111)
Fine, on to the next problem. Because I rsynced over my old databases, including my root db password, I’d nuked the grant for the debian sysadmin script. I should note that I hadn’t had this problem before because the last time, I’d also rsynced most of /etc as well. After a brief hunt through google, I found that the location for the password is in /etc/mysql/debian.cnf, so I just granted the privileges to ‘debian-sys-maint@localhost’.
After stopping and restarting mysql, I verified that it was all happy again. Blogs for everyone.