Finding MySQL server operating parameters

If you have a MySQL server listening on a given port number, you can use the following command to find out what operating parameters it is using for several important configurable variables, including the base directory and Unix socket file name:

# mysqladmin –host=host_name –port=port_number variables

With the information displayed by that command, you can tell what option values not to use when configuring an additional server.

Trackback URI | Comments RSS

Leave a Reply

You must be logged in to post a comment.