If you are managing a multi-user MySQL database you may want to get back a list of MySQL user along with privileges on each user. To uncover all MySQL users plus authorizations given to each user, sign in to your MySQL server, and run the examples below. Sign in to MySQL and get the list of users: mysql -u root -p password : Enter your MySQL root password.
Remote access control to MySQL databases is turn off on the majority of application for security purpose. Then again, sometime you might want to easy access from remote location for other reasons. Connect remotely to a database allows you to control it using software like MySQL Workbench. This article will show you how you can create a user account and gain access to a mysql database server from another location on a Debian L