Connect to MySQL instance manager and create user accounts

Use the MySQL client-server protocol to handle communication with the MySQL instance manager. You cannot use the standard MySQL client program and the MySQL C API to connect to IM. IM supports the MySQL client-server protocol version used for libraries that are distributed by client tools and mysql-4.1 or later versions.

Im saves the user information to the password file. The default location for the password file is/etc/mysqlmanager.passwd.

The password should look like this:

petr:*35110DC9B4D8140F5DE667E28C72DD2597B5C848

To generate a password, call Im with the--PASSWD option. The output can be redirected to the/etc/mysqlmanager.passwd file to add new users. The following is an example command.

./mysqlmanager --passwd >> /etc/mysqlmanager.passwd
Creating record for new user.
Enter user name: mike
Enter password: <password>
Re-type password: <password>

The following row is added to the/ETC/MYSQLMANAGER.PASSWD:

mike:*00A51F3F48415C7D4E8908980D443C29C69B60C9

If this bar is not in the/etc/mysqlmanager.passwd file, Im cannot be connected.