How to get protocol, characterset, mysql info?

Login or Register to Ask a Question and Join Our Community

How to get protocol, characterset, mysql info?

Login to Discuss or Reply to this Discussion in Our Community

Top Forums Web Development MySQL DevZone RSS How to get protocol, characterset, mysql info?

02-25-2010

Registered User

52, 0

Join Date: Dec 2008

Last Activity: 25 February 2010, 3:53 AM EST

Posts: 52

Thanks Given: 0

Thanked 0 Times in 0 Posts

How to get protocol, characterset, mysql info?

Hi,

I know the API to get protocol version, character set etc. If I want to find out the current protocol version, current user character set, mysql info, mysql server info wihtout using these API -
mysql_get_server_info()
mysql_info()
mysql_get_proto_info()
mysql_character_set_name()
mysql_get_client_info().

Is there any other way to get these information without using API?

I don't want to use API instead Shall I get these information from Infomrmation_schema?

Can I fetch these information directly accessing enviornment variable if possible?

---------- Post updated 02-25-10 at 12:53 AM ---------- Previous update was 02-24-10 at 11:49 PM ----------

I find out the value of protocol, version, character set, host name using

select @@hostname
select @@version
select @@protocol_version
select @@character_server_set.

But couldn't find out the how to get values of

mysql_get_client_info()
mysql_info()
mysql_stat()
mysql_thread_safe()
without using it in the same manner used for protocol,character set etc.

amit_27

View Public Profile for amit_27

Find all posts by amit_27

Login or Register to Ask a Question

Previous Thread | Next Thread

5 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Characterset conversion problem using iconv command

Hi Friends, I am not able to conver character set from UTF-8 to IBM-284 throwing an error "cannot open convertor" . Could you please help me how to get out of this error. Below command is working fine iconv -f ISO8859-15 -t UTF-8 fromfile.txt > tofile.txt But the below command is...

2. UNIX and Linux Applications

MySQL Daemon failed to start - no mysql.sock file

After doing a yum install mysql mysql-server on Fedora 14 I wasn't able to fully install the packages correctly. It installed MySQL 5.1. I was getting the following error when running the: mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)...

3. Shell Programming and Scripting

decimal value for particular characterset

Hi, I need some help to get decimal value of some particluar character set for e.g. in windows-1251 characterset ж --> 230 Please help and suggest way to achive same.

4. UNIX for Advanced & Expert Users

mysql would not start: missing mysql.sock

I recently installed mysql-standard-5.0.21-solaris9-sparc-64bit.pkg on a Solaris 9 machine (SunOS 5.9 Generic_118558-19 sun4u sparc SUNW,Ultra-250). The package installation went very smooth, however, starting mysql is a different story. I get the message below everytime I try to start mysql: #...

5. UNIX for Advanced & Expert Users

MySQL problem >> missing mysql.sock

MySQL on my server is down.... I figured out that the mysqld process isn't running. When I try to run it, it says it can't find mysql.sock Any suggestions? Here's what I can't do: can't be root don't have physical access (do stuff via SSH) reinstall MySQL (need to keep the current MySQL...

Login or Register to Ask a Question

LEARN ABOUT DEBIAN

cvm-mysql

cvm-mysql(8)						      System Manager's Manual						      cvm-mysql(8)

NAME

       cvm-mysql - MySQL module

SYNOPSIS

       cvm-mysql

CREDENTIALS

       Pass phrase

DESCRIPTION

       This module queries a MySQL database for the account name, compares the stored pass phrase with the given one using crypt(3).

CONFIGURATION VARIABLES

       CVM_MYSQL_DEFAULT_FILE
	      The  full  path of the defaults file to read if the following variable is set.  If not set, the file $HOME/.my.cnf will be read (the
	      MySQL default).

       CVM_MYSQL_DEFAULT_GROUP
	      If set, the module will read connection default options from the named group in the defaults file as above

       CVM_MYSQL_HOST
	      The hostname or IP of the MySQL server.  If not set, a connection to the local host is assumed.

       CVM_MYSQL_USER
	      The MySQL login ID to connect as.  If not set, the invoking user is assumed.

       CVM_MYSQL_PASS
	      The password for the above user.

       CVM_MYSQL_DB
	      The database name, must be set.

       CVM_MYSQL_PORT
	      The port number for the TCP/IP connection (only used if the server is not local).

       CVM_MYSQL_POSTQ (optional)
	      The SQL query to execute after the credentials have been validated, see cvm-sql(7).

       CVM_MYSQL_PWCMP (optional)
	      The password comparison module to use.

       CVM_MYSQL_SOCKET
	      The path to the socket that should be used for connections to a local server.

       CVM_MYSQL_QUERY (optional)
	      The SQL query to issue to retrieve the row containing the account information from the database, see cvm-sql(7).

SEE ALSO

       cvm-sql(7), cvm-pgsql(8), cvm-pwfile(8), cvm-qmail(8), cvm-unix(8), cvm-vmailmgr(8),  cvm-benchclient(8),  cvm-checkpassword(8),  cvm-test-
       client(8)

	http://untroubled.org/pwcmp/pwcmp.html
	http://untroubled.org/cvm/cvm.html

																      cvm-mysql(8)