MySQL Process

To view the complete process of MySQL server which includes;
- How many users currently login to mysqld
- State
- Query

mysql> SHOW FULL PROCESSLIST;

Add User

mysql> GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost'
mysql> IDENTIFIED BY 'userpassword' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO 'user'@'%'
mysql> IDENTIFIED BY 'userpassword' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;