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 ?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
mysql --port=3308 // not work
mysql --socket=/tmp/mysql2.sock // work fine
cordially
thierry