Is there a command that will output all mysql details. eg. host name, port etc?
Cheers
Paul
Is there a command that will output all mysql details. eg. host name, port etc?
Cheers
Paul
You have:
Get status information from the server.
mysql> \s
SHOW STATUS provides server status information. This information also
can be obtained using the mysqladmin extended-status command. The LIKE
clause, if present, indicates which variable names to match. The WHERE
clause can be given to select rows using more general conditions, as
discussed in MySQL :: MySQL 5.5 Reference Manual :: 19.28 Extensions to SHOW Statements
mysql> show status
Returning to your specific question:
mysql> show variables where variable_name in ('hostname', 'port');