you can’t tail -f a mysqlbinlog, but something like this give the same result ๐
# watch "mysqlbinlog /var/log/mysql/mysql-bin.004436 | tail"
MySQL
Verifying limits
I’m tuning a mysql server which is under high load and serving A LOT og db’s. I wanted to verify the limits I set after restarting the mysql service. Su or sudo didn’t work, but cat’ing /proc/[ mysql process id ]/limits worked like a charm.
Importing information_schema from an other mysql server
While investigating some mysql stuff at work I imported the whole mysql dump from our production system into my localhost installation. Among the 2000 or so databases was also information_schema, and I ended up with problems like :
root@pluto:~# /etc/init.d/mysql status /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)' *
The solution was to reset password fr debian-sys-maint user in mysql.
GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
Where ‘password’ is found in /etc/mysql/debian.cnf ๐
I got this one from ubuntuforums.org.