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';
| |