MysqlAdmins¶

Synopsis¶

This module assists in installing and as well as managing the admin users for mysql without using root user. By using this, the users can manage their administrative functions.

Help Command¶

The Help command guides the users regarding the command used for installing the mysql admins, and also its advantages. The command used for help option under this mysql admins is shown below.

cleopatra MysqlAdmins help

The screen shot as given below can lead the user in handling the help command for mysql admins.

kevells@corp:/# cleopatra MysqlAdmins help
******************************


 This command allows you to install admin users for MySQL so that MySQL can
 be managed without using the Root User.

 MysqlAdmins, mysql-admins, mysqladmins

       - install
       Installs Mysql Admin Users.
       example: cleopatra mysql-admins install

------------------------------
End Help
******************************

Installation¶

Installing mysql admins to your machine facilitates the users to specify and manage their administrative actions. The command used for installing mysql admins is marked below.

cleopatra MysqlAdmins install

In addition, the following operations shown in a tabular format occurs.

If the user proceed the installation process, they can frame their administrative functions by specifying the following constraints. * MySQL Root User * MySQL Root Pass * MySQL New Admin User * MySQL New Admin Pass

If the user wish to process installation of mysql admins in a remote system they can specify:

• MySQL Host.

The following screenshot gives you an pictorial representation about the process of installation as described above.

kevells@corp:/# cleopatra mysql-admins install
Install Admin User for MySQL? (Y/N)
y
*******************************
*        Pharaoh Tools        *
*         MySQL Admins!        *
*******************************
Enter MySQL Root User:
root
Enter MySQL Root Pass:
root123
Enter MySQL New Admin User:
kevells
Enter MySQL New Admin Pass:
kevells123
Enter MySQL Host: Enter nothing for 127.0.0.1

Creating /tmp/cleopatra-temp-script-74285705785.sh
chmod 755 /tmp/cleopatra-temp-script-74285705785.sh 2>/dev/null
Changing /tmp/cleopatra-temp-script-74285705785.sh Permissions
Executing /tmp/cleopatra-temp-script-74285705785.sh
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Temp File /tmp/cleopatra-temp-script-74285705785.sh Removed
... All done!
*******************************
Thanks for installing , visit www.pharaohtools.com for more
******************************


Single App Installer:
--------------------------------------------
MysqlAdmins: Success
------------------------------
Installer Finished
******************************

Benefits¶

• In case of mysql admins is already installed in the users machine, then an message will be appearing to inform the users as it is already installed.
• By using this module the administrators can manage their administrative actions as per the requirements.
• They can perform the installation process even in a remote system.
• Without using the root users, the users can install the mysql admins.