Login or Register to Ask a Question and Join Our Community


SuSE

my SQL Info command

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Operating Systems Linux SuSE my SQL Info command
# 1  
Old 06-28-2011
my SQL Info command
Is there a command that will output all mysql details. eg. host name, port etc?

Cheers
Paul
# 2  
Old 06-28-2011
You have:

Get status information from the server.

Code:
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
Code:
mysql> show status

Returning to your specific question:

Code:
mysql> show variables where variable_name in ('hostname', 'port');

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Storing multiple sql queries output into variable by running sql command only once

Hi All, I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise. Eg : Select 'Query 1 output' from dual; Select 'Query 2 output' from dual; I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies

2. UNIX and Linux Applications

SQL - how to alter info of a cell in table

Hello, I am newbie on mysql and trying to edit my database from terminal under linux. What I need to do is to change the information written in a cell in table. Let me explain what I tried: $ mysql -u mysqluser -p $ show databases; $ USE catalogue; $ show tables ; $ select * from... (2 Replies)
Discussion started by: baris35
2 Replies

3. Shell Programming and Scripting

Printing more info than find command gives out

Hi, I am trying to find files that are more than a gig with this command find . -size +1073741823c and it just gives me the names of the files. How do i get it to give me the actual size of the files too? ---------- Post updated at 09:41 AM ---------- Previous update was at 09:37 AM... (2 Replies)
Discussion started by: LilyClaro
2 Replies

4. UNIX for Dummies Questions & Answers

Extracting specific info finger command

how to extract user machine name for current terminal using finger command below command gives machinename for all session , is it possible to filter it to only currernt terminal ? finger -b -p $LOGNAME | grep from (12 Replies)
Discussion started by: lalitpct
12 Replies

5. UNIX for Advanced & Expert Users

Unable to display directory info with ps command

Hello, I start an adapter using the following command - nohup ./start_embargoAdapter >/dev/null 2>&1 & and when I do the following, I can see: /export/home/xxxxx> ps -ef | grep embargo xxxxx 28086 20761 0 23:23:29 pts/7 0:00 grep embargo xxxxx 8866 1 0 Oct 06 ? 0:00... (2 Replies)
Discussion started by: samjna
2 Replies

6. Shell Programming and Scripting

Generic command for CPU info

Dear all, Is there any generic command working on all Unix listing the CPU of a server? I found different command line per OS but I am looking for a more generic one. Thanks for your answer. (5 Replies)
Discussion started by: sgoiffon
5 Replies

7. UNIX for Dummies Questions & Answers

Passing info from other file into command

I created file called "tape_name" which contains tape_mon_A="TAPE_MON_A" tape_tue_A="TAPE_TUE_A" tape_wed_A="TAPE_WED_A" tape_thr_A="TAPE_THR_A" tape_mon_B="TAPE_MON_B" tape_tue_B="TAPE_TUE_B" tape_wed_B="TAPE_WED_B" tape_thr_B="TAPE_THR_B" I created test script as follow ... (4 Replies)
Discussion started by: Paul.S
4 Replies

8. UNIX for Dummies Questions & Answers

Info about ps command

Hi all, When a process is hung in unix and when we list the process using "ps" command, then does the elapsed timeELAPSED column time display the time elapsed since the process started to the time till the "ps"command was called. Or does the elapsed time column display only the time since the... (4 Replies)
Discussion started by: aixjadoo
4 Replies

9. UNIX for Dummies Questions & Answers

Info about col command

Hello every1. Can any1 help me with the col command. Wat is a reverse line feed. Which kind of files u need to use the col command. (2 Replies)
Discussion started by: rahulrathod
2 Replies

10. Solaris

Command to require OS info

Hi, I am new to UNIX environment. Can anybody tell me how can I check whether my OS is 32bit or 64bit? Regards, Malay Mary (4 Replies)
Discussion started by: malaymaru
4 Replies
Login or Register to Ask a Question