| Logon: | mysql -u root -p
| List mysql.user info | desc mysql.user;
| | List certain attribs: | SELECT user,host FROM mysql.user;
| | List usr,pw,host: | select host,user,password from user;
| | List user auth: | SELECT User, Host, authentication_string FROM mysql.user;
| | List logged-in usrs: | SELECT user, host,db, command FROM
information_schema.processlist;
| | Access as Root: | sudo mysql --user=root mysql -p
PERMISSIONS
| | grant perms: | GRANT SELECT ON *.* TO ;
| | list perms: | SHOW GRANTS FOR @;
| | grant all privileges on *.* to 'shadow'@'%' identified by password
'*825958ACBF93C15527606F2D0AB343394D67F090';
| |