MySQL 5.1 Reference Manual :: 4 MySQL Programs :: 4.6 MySQL Administrative and Utility Programs :: 4.6.10 mysqlmanager — The MySQL Instance Manager :: 4.6.10.6 Connecting to MySQL Instance Manager
Section Navigation [Toggle]
- 4.6.10 mysqlmanager — The MySQL Instance Manager
- 4.6.10.1 MySQL Instance Manager Command Options
- 4.6.10.2 MySQL Instance Manager Configuration Files
- 4.6.10.3 Starting the MySQL Server with MySQL Instance Manager
- 4.6.10.4 Instance Manager User and Password Management
- 4.6.10.5 MySQL Server Instance Status Monitoring
- 4.6.10.6 Connecting to MySQL Instance Manager
- 4.6.10.7 MySQL Instance Manager Commands
Important
MySQL Instance Manager has been deprecated and is removed in MySQL 5.4.
After you set up a password file for the MySQL Instance Manager and Instance Manager is running, you can connect to it. The MySQL client-server protocol is used to communicate with the Instance Manager. For example, you can connect to it using the standard mysql client program:
shell> mysql --port=2273 --host=im.example.org --user=mysql --password
Instance Manager supports the version of the MySQL client-server protocol used by the client tools and libraries distributed with MySQL 4.1 or later, so other programs that use the MySQL C API also can connect to it.
User Comments
To securely create the mysqlmanager.passwd file, run:
% omask=`umask`
% umask 0177
% touch /etc/mysqlmanager.passwd
% umask $omask
This will prevent anyone on the server from seeing the contents of that file.
If you've already created the file, the permissions should be 600, which can be set with the command:
% chmod 600 /etc/mysqlmanager.passwd
If you have safe-updates set in the [mysql] section of your my.cnf file you will not be able to log into the instance manager.
Add your own comment.