MySQL Enterprise Manager Installation on RHEL/OEL/CentOS 6.X


Assalamu’alaikum ..
I want to share my experience about installation MySQL Enterprise Manager on Linux, actually Oracle Enterprise Linux 6.5, ya it is similar with Redhat and CentOS on same version. If you used to Oracle DB, of course you are familiar with Oracle Enterprise Manager cloud control, express, and dbconsole. Ya this MySQL Enterprise Manager look like them. So, here we go ..

It is a simple installation, just chmod +x and execute the binary file.

[root@virtual-100 mem]# ./mysqlmonitor-4.0.2.5168-linux-x86_64-installer.bin

Specify the installation directory or just press enter if you want to default place.

Choose system size, in this case I choose small system because the installation is inside the VM which have only 1GB RAM. Just press enter to following the default port and user account.

Choose database installation. Choose option 1 if you want to install separate DB for MySQL EM repository from your own MySQL DB. Better you choose 1.

Specify password for repository username and you have to remember it. In this case, I type MySQL5.7 for my password. Also just press enter if you want to following default username and database name. And then type Y to continue the installation.

At the end of installation, it will show prompt the address of MySQL EM. So, open it in web browser.

Open MySQLEM in web browser and then configure users for manager and agent role. In this case I type username admin and password admin for manager role and username agent and password agent for agent role. You can also configure the data retention settings. And then click Complete Setup.

Setting the timezone and locale.

Now you have to add instance to monitor the database. Click Configuration ==> Instances ==> Add MySQL Instance. Type instance address, port, admin user, and admin password. I choose No to Auto-Create Less Privileged Users.

Instance added.

You can explore deeper about MySQL Enterprise Manager from here 🙂 ..

Wassalamu’alaikum 🙂 ..

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s