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-126.96.36.19968-linux-x86_64-installer.bin
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.
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.
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.
You can explore deeper about MySQL Enterprise Manager from here 🙂 ..
Wassalamu’alaikum 🙂 ..