Mysql Databases






To get Mariadb password hash:
	SELECT PASSWORD('notagoodpwd'); 

To Change password for user:
	SET PASSWORD FOR 'bob'@'%.loc.gov' = PASSWORD('newpass');
Operationsql
Logon: mysql -u root -p
List mysql.user infodesc 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';