void CInnoDBStatus::refresh() { clear(); CMySQLQuery *qry = new CMySQLQuery(mysql->mysql()); qry->setEmitMessages(false); qry->setEmitErrors(false); if (qry->exec("SHOW INNODB STATUS")) { qry->next(); setText(qry->row(0)); } delete qry; }
bool CUserAdminItem::displayUsers() { #ifdef DEBUG qDebug("CUserAdminItem::displayUsers()"); #endif //TODO: This needs to be modified to NOT use mysql.user for the users list. SHOW GRANTS FOR % is needed in the server. while (this->childCount() > 0) deleteChilds(); bool hasAccess = false; CMySQLQuery *q = new CMySQLQuery(mysql()->mysql()); q->setEmitMessages(false); q->setEmitErrors(false); if (q->exec("SELECT User, Host FROM mysql.user ORDER BY User")) { hasAccess = true; while (q->next()) new CUserItem(this, mysql(), q->row(0), q->row(1), userIcon); } delete q; return hasAccess; }