View MySQL server information

With the server up and running:

$ mysqladmin variables -u root -p
Enter password:
+----------------------------+----------------------------+
| Variable_name              | Value                      |
+----------------------------+----------------------------+
| auto_increment_increment   | 1                          |
| auto_increment_offset      | 1                          |
| autocommit                 | ON                         |
| automatic_sp_privileges    | ON                         |
| back_log                   | 50                         |
| basedir                    | /opt/local                 |
| big_tables                 | OFF                        |
| binlog_cache_size          | 32768                      |
...
| version_compile_machine    | x86_64                     |
| version_compile_os         | osx10.9                    |
| wait_timeout               | 28800                      |
+----------------------------+----------------------------+

Or with the server stopped:

$ mysqld --verbose --help
/opt/local/bin/mysqld  Ver 5.5.38 for osx10.9 on x86_64 (Source distribution)
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Starts the MySQL database server.

Usage: /opt/local/bin/mysqld [OPTIONS]
...
tmpdir                                            /var/folders/xb/fgxzg4gn/T/
transaction-alloc-block-size                      8192
transaction-isolation                             REPEATABLE-READ
transaction-prealloc-size                         4096
updatable-views-with-limit                        YES
verbose                                           TRUE
wait-timeout                                      28800

To see what values a running MySQL server is using, type
'mysqladmin variables' instead of 'mysqld --verbose --help'.

Ref: http://stackoverflow.com/questions/580331/mysql-how-to-determine-which-config-file-is-being-used

You might also like

Change root password in MySQL
In GNU/Linux:$ sudo mysqld_safe --skip-grant-tables & $ mysql -u root -p #press enter to use a...

Can’t change user options in MySQL Administrator
May be you installed MySQL 5 and you are not able to change user information, schema privileges and resources...

Can’t change user options in MySQL Administrator
May be you installed MySQL 5 and you are not able to change user information, schema privileges and resources...

Send email with SMTP and Plain Auth via telnet
First connect to the server. It's usualy on port 25 but this can change from server to server:telnet...

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.