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 PHP

udm_find

UDM_FIND(3)								 1							       UDM_FIND(3)

udm_find - Perform search

SYNOPSIS

       resource udm_find (resource  $agent, string  $query)

DESCRIPTION

	Performs a search.

	The search itself. The first argument - session, the next one - query itself. To find something just type words you want to find and press
       SUBMIT button. For example, "mysql odbc". You should not use quotes " in query, they are written here only to divide  a	query  from  other
       text.  mnoGoSearch  will find all documents that contain word "mysql" and/or word "odbc". Best documents having bigger weights will be dis-
       played first. If you use search mode ALL, search will return documents that contain both (or more) words you entered. In case you use  mode
       ANY,  the  search  will	return	list of documents that contain any of the words you entered. If you want more advanced results you may use
       query language. You should select "bool" match mode in the search from.

PARAMETERS

	      o $agent
		- A link to Agent, received after call to udm_alloc_agent(3).

	      o $query
		- mnoGoSearch understands the following boolean operators:  & - logical AND. For example, "mysql & odbc".  mnoGoSearch	will  find
		any  URLs  that  contain  both "mysql" and "odbc".  | - logical OR. For example "mysql|odbc". mnoGoSearch will find any URLs, that
		contain word "mysql" or word "odbc".  ~ - logical NOT. For example "mysql & ~odbc". mnoGoSearch will find URLs that  contain  word
		"mysql"  and  do  not  contain word "odbc" at the same time. Note that ~ just excludes given word from results. Query "~odbc" will
		find nothing!  () - group command to compose more complex queries. For example "(mysql | msql) &  ~postgres".  Query  language	is
		simple and powerful at the same time. Just consider query as usual boolean expression.

RETURN VALUES

	Returns a result link identifier on success or FALSE on failure.

PHP Documentation Group 													       UDM_FIND(3)