Link to home
Start Free TrialLog in
Avatar of thierry91
thierry91

asked on

how to by shell connect to 2 mysql server in same server

I have 2 mysql start in same server.
one to port 3306 and socket /tmp/mysql.sock
one to port 3308 and socket /tmp/mysql2.sock

I want can connect with script shell to mysql1 or mysql2

how to by shell connect to 2 mysql in same server ?
ASKER CERTIFIED SOLUTION
Avatar of Roger Baklund
Roger Baklund
Flag of Norway image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of thierry91
thierry91

ASKER

thank you,
mysql --port=3308   // not work

mysql --socket=/tmp/mysql2.sock   // work fine

cordially
thierry