- Change ROOT username:
use mysql; update user set user='admin' where user='root'; flush privileges;
- Allow root user to remotely access the database with full rights:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mypass WITH GRANT OPTION;
- Delete user access permissions from a specific location:
DROP USER 'jeffrey'@'localhost';
The mysql logs can be found in /var/log.