tunnling mysql over ssh


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting tunnling mysql over ssh
# 1  
Old 04-22-2009
tunnling mysql over ssh

hello all

i want connect to mysql db which have host name localhost.

with normal connection it wouldnt connect
but i know there was tunnling for mysql connection over ssh connection and i did that with toad.

but i need help to do that with php?

regards
Login or Register to Ask a Question

Previous Thread | Next Thread

6 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help Required - facing error when trying to connect to a mysql by ssh to another server

Hi i am new to unix shell scripting i have the below requirement connect to server B and then connect to mysql in the server B and query for a particular record and capture that value but when i perform this i am facing an error can u guys help me on this:confused::confused: ... (2 Replies)
Discussion started by: Hamdul
2 Replies

2. Shell Programming and Scripting

Dumping mysql through ssh tunnel

Hello wise scripters This is my first post and I am glad to join this community. I am trying to make work a mysqldump via ssh tunnel in a shell script. The problem is that running this sequence of commands manually works fine, but when I put these in a bash script they give me the following... (8 Replies)
Discussion started by: Solidus
8 Replies

3. UNIX for Dummies Questions & Answers

SSH import mysql database

Hi all, I am trying to import a database in putty with the syntax: mysql –u database_username –p database_name < filename.mysql As you can see in the screenshot it asks me for the database password - which suggests that the syntax is correct - but then after I enter the password it gives... (2 Replies)
Discussion started by: Juc1
2 Replies

4. 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

5. Shell Programming and Scripting

Mysql command after a SSH connection (Script)

Hi all, Im new at scripting and i need to run a few commands at work every hours so i decide to make a script but on 1 of the steps i have a the follwoing problem: The command i do is this: #!/bin/bash ssh root@asdasd001 'mysql -h A-db-1 -uroot -password --execute "show slave status"'... (3 Replies)
Discussion started by: Aparicio
3 Replies

6. UNIX for Advanced & Expert Users

Editing MySQL config through ssh ?

I need a smal "how to" regarding editing mysql configuration on a unix server. Thanks in advance. (2 Replies)
Discussion started by: Denis.R
2 Replies
Login or Register to Ask a Question
MYSQLND_UH_CONVERT_TO_MYSQLND(3)					 1					  MYSQLND_UH_CONVERT_TO_MYSQLND(3)

mysqlnd_uh_convert_to_mysqlnd - Converts a MySQL connection handle into a mysqlnd connection handle

SYNOPSIS
resource mysqlnd_uh_convert_to_mysqlnd (mysqli &$mysql_connection) DESCRIPTION
Converts a MySQL connection handle into a mysqlnd connection handle. After conversion you can execute mysqlnd library calls on the connec- tion handle. This can be used to access mysqlnd functionality not made available through user space API calls. The function can be disabled with mysqlnd_uh.enable. If mysqlnd_uh.enable is set to FALSE the function will not install the proxy and always return TRUE. Additionally, an error of the type E_WARNING may be emitted. The error message may read like PHP Warning: mysqlnd_uh_convert_to_mysqlnd(): (Mysqlnd User Handler) The plugin has been disabled by setting the configuration parameter mysqlnd_uh.enable = false. You are not allowed to call this function [...]. PARAMETERS
o $MySQL connection handle - A MySQL connection handle of type mysql, mysqli or PDO_MySQL. RETURN VALUES
A mysqlnd connection handle. CHANGELOG
+--------+---------------------------------------------------+ |Version | | | | | | | Description | | | | +--------+---------------------------------------------------+ | 5.4.0 | | | | | | | The $mysql_connection parameter can now be of | | | type mysql, PDO_MySQL, or mysqli. Before, only | | | the mysqli type was allowed. | | | | +--------+---------------------------------------------------+ EXAMPLES
Example #1 mysqlnd_uh_convert_to_mysqlnd(3) example <?php /* PDO user API gives no access to connection thread id */ $mysql_connection = new PDO("mysql:host=localhost;dbname=test", "root", ""); /* Convert PDO MySQL handle to mysqlnd handle */ $mysqlnd = mysqlnd_uh_convert_to_mysqlnd($mysql_connection); /* Create Proxy to call mysqlnd connection class methods */ $obj = new MySQLndUHConnection(); /* Call mysqlnd_conn::get_thread_id */ var_dump($obj->getThreadId($mysqlnd)); /* Use SQL to fetch connection thread id */ var_dump($mysql_connection->query("SELECT CONNECTION_ID()")->fetchAll()); ?> The above example will output: int(27054) array(1) { [0]=> array(2) { ["CONNECTION_ID()"]=> string(5) "27054" [0]=> string(5) "27054" } } SEE ALSO
mysqlnd_uh.enable. PHP Documentation Group MYSQLND_UH_CONVERT_TO_MYSQLND(3)