mysql --host=host --user=user -p database (as root, connected to mysql database) select host, user, password from user; show databases; show tables; describe table;Debugging "access denied" errors: http://dev.mysql.com/doc/refman/5.1/en/access-denied.html Replication troubleshooting: http://dev.mysql.com/doc/refman/5.0/en/replication-problems.html
show master status; show slave status \G;Mac OSX
/Library/StartupItems/MySQLCOM/MySQLCOM
Installs into /usr/local/mysql
by default.
Deadlocks
You'll get lots of them: http://dev.mysql.com/doc/refman/5.0/en/innodb-deadlocks.html
Maatkit
http://www.maatkit.org/ - need to look into these tools, they look useful.
OurDelta
An alternative distro with some useful patches applied: http://ourdelta.org/