Installing MySQL Administrator

Download and Installation

Download the installer for MySQL Administrator from www.mysql.com. While you are there, download the installer for Query Browser too. Installation is merely a click-and-run affair.

Running MySQL Administrator:

ma-login: MySQL Administrator log in
Double click MySQL Administrator icon on your Desktop

Leave Connection blank

Key in root as Username

Leave Password blank if you are connecting for the first time or have not set root password. Otherwise, key in root password.

Key in localhost as Hostname

Click OK to connect.


Changing root password

ma-useradm-root: Changing root password
Warning: Do not rename root. MySQL server expects to see that account.

Click User Administration

Select root

Click User Information tab, change your password.

Click Apply Changes to effect the change. You might have to log in again.


Server information

ma-svrinfo: MySQL server information
Click Server Information to get to know your MySQL server. Yes, you have been told.



Creating MySQL Users

Creating MySQL Backups