Geeksww Forums - Administration

Re: how to find innodb plugin version in mysql??

sherry — Wed, 21 Dec 2011 15:21:37 +0000

here is a query that you can use to get detailed info

 SELECT * FROM Plugins WHERE PLUGIN_NAME LIKE '%innodb%' AND PLUGIN_TYPE LIKE 'STORAGE ENGINE';

you can also do the following to get full version no. (or look at the error log where Innodb stores full version no.)

SELECT @@innodb_version;

how to find innodb plugin version in mysql??

Shay — Wed, 21 Dec 2011 15:00:22 +0000

how do I find Innodb Plugin version number in MySQL.

Re: mysql error on linux

shahryar — Tue, 04 Jan 2011 13:40:36 +0000

when you use localhost in MySQL parameters list you are automatically connected through the socket file, so an easier way to connect through TCP/IP (ie avoiding socket file) is to connect to the local MySQL server through 127.0.0.1
OR
find out what socket file MySQL server is using (ask your sysadmin or hosting company) and connect using that socket file if you have to connect through the socket file (ie. in cases when MySQL server is running with skip-networking enables). I have also seen people solving this problem by creating symlinks to the actual socket file and using the symlink instead.

mysql error on linux

Shay — Sun, 02 Jan 2011 22:12:09 +0000

getting the following error on linux server, the error is:

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

the line it has pointed out to on page is line where i gave MySQL paramaters ... any help would be appreciated.