Login or Register to Ask a Question and Join Our Community


MySQL DevZone RSS

How to get protocol, characterset, mysql info?

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Web Development MySQL DevZone RSS How to get protocol, characterset, mysql info?
# 1  
Old 02-25-2010
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.
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 Replies)
Discussion started by: sivakumarl
2 Replies

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 Replies)
Discussion started by: jastanle84
3 Replies

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. (7 Replies)
Discussion started by: peeyushgehlot
7 Replies

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: #... (2 Replies)
Discussion started by: xnightcrawl
2 Replies

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... (8 Replies)
Discussion started by: _hp_
8 Replies
Login or Register to Ask a Question

LEARN ABOUT DEBIAN

dbix::searchbuilder::handle::mysql

DBIx::SearchBuilder::Handle::mysql(3pm) 		User Contributed Perl Documentation		   DBIx::SearchBuilder::Handle::mysql(3pm)

NAME

	 DBIx::SearchBuilder::Handle::mysql - A mysql specific Handle object

SYNOPSIS

DESCRIPTION

       This module provides a subclass of DBIx::SearchBuilder::Handle that compensates for some of the idiosyncrasies of MySQL.

METHODS

   Insert
       Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted.

       If the insert succeeds, returns the id of the insert, otherwise, returns a Class::ReturnValue object with the error reported.

   SimpleUpdateFromSelect
       Customization of "SimpleUpdateFromSelect" in DBIx::SearchBuilder::Handle.  Mysql doesn't support update with subqueries when those fetch
       data from the table that is updated.

   DatabaseVersion
       Returns the mysql version, trimming off any -foo identifier

   CaseSensitive
       Returns undef, since mysql's searches are not case sensitive by default

   SimpleDateTimeFunctions
       Returns hash reference with specific date time functions of this database for "DateTimeFunction" in DBIx::SearchBuilder::Handle.

   ConvertTimezoneFunction
       Custom implementation of "ConvertTimezoneFunction" in DBIx::SearchBuilder::Handle.

       Use the following query to get list of timezones:

	   SELECT Name FROM mysql.time_zone_name;

       Read docs about keeping timezone data up to date:

	   http://dev.mysql.com/doc/refman/5.5/en/time-zone-upgrades.html

AUTHOR

       Jesse Vincent, jesse@fsck.com

SEE ALSO

       DBIx::SearchBuilder, DBIx::SearchBuilder::Handle

perl v5.14.2							    2011-09-21				   DBIx::SearchBuilder::Handle::mysql(3pm)