# Mind Candy

Monday, August 21, 2006

reminders to self:

/usr/local/bin/mysql --password=p@ssw0rd -e "SHOW GRANTS FOR magenta@company.com"

/usr/local/bin/mysql --password=p@ssw0rd -e "SHOW GRANTS FOR sguil@magenta.company.com"


/usr/local/bin/mysql --password=p@ssw0rd -e "GRANT ALL PRIVILEGES ON *.* to sguil@magenta.company.com WITH GRANT OPTION"

/usr/local/bin/mysql --password=p@ssw0rd -e "GRANT ALL PRIVILEGES ON *.* to sguil@localhost WITH GRANT OPTION"


/usr/local/bin/myisamchk --silent --force */*.MYI

/usr/local/bin/myisamchk --password=p@ssw0rd --silent --force */*.MYI

/usr/local/bin/mysqladmin --password=p@ssw0rd -e "shutdown"
/usr/local/bin/mysqladmin --password=p@ssw0rd shutdown

/usr/local/bin/mysql --password=p@ssw0rd -e "SHOW VARIABLES" | more
vi /var/db/mysql/riffraff.company.com.log
/usr/local/bin/mysqladmin --password=p@ssw0rd -u root processlist
/usr/local/bin/mysqladmin --password=p@ssw0rd version

vi /var/db/mysql/H13.company.com.err