Finding when MySQL event last ran
This information is available through events in INFORMATION_SCHEMA. See LAST_EXECUTED column: SELECT * FROM INFORMATION_SCHEMA.events; You can also use SHOW CREATE EVENT yourevent to see what it does.
mysqlcommand
Show the current username in MySQL?
Try to run either SELECT USER(); or SELECT CURRENT_USER(); It can sometimes be different, USER() will return by which login you attempted to authenticate and CURRENT_USER() will return how you were actually allowed to authenticate.
How to select a MySQL database through CLI?
Use USE. This will enable you to select the database. USE photogallery; 12.8.4: USE Syntax You can also specify the database you want when connecting: $ mysql -u user -p photogallery