apt - How to insall mysql-proxy in ubuntu 16.04? - Ask Ubuntu


i have tried installing using sudo apt-get below got error

majid@k53sc:~$ sudo apt-get install mysql-proxy reading package lists... done building dependency tree        reading state information... done e: unable locate package mysql-proxy 

tried download linux-genereic (https://downloads.mysql.com/archives/proxy/) , extract , run; mysql client can't connect server via proxy:

terminal 1:

$ mysql-proxy --proxy-address=127.0.0.1:4040 --proxy-backend-addresses=localhost:3306 --proxy-lua-script=/home/majid/documents/first_example.lua --plugins=proxy 2016-11-01 20:34:20: (critical) plugin proxy 0.8.5 started got normal query: select @@version_comment limit 1 

terminal 2:

majid@k53sc:~$ mysql -h 127.0.0.1 -p4040 -u root -ppassword mysql: [warning] using password on command line interface can insecure. welcome mysql monitor.  commands end ; or \g. 

and stays there; nothing happens.

so correct way install , use mysql-proxy in ubuntu 16.04?

regards

edit:

as per david foerster's comment have downloaded deb package trusty, , installed. below:

terminal 1:

$ mysql-proxy --proxy-address=127.0.0.1:4040 --proxy-backend-addresses=localhost:3306 --proxy-lua-script=/home/majid/documents/first_example.lua --plugins=proxy 

terminal 2:

$ mysql -h 127.0.0.1 -p4040 -u root -ppassword mysql: [warning] using password on command line interface can insecure. error 1043 (08s01): bad handshake 

the mysql-proxy project seems abandoned since on 2 years reason removal xenial repositories. it's incompatible newer mysql releases.

the 3-years-old install notice recommends version 5.1.x while the xenial repositories include mysql 5.7 , no older release.


Comments

Popular posts from this blog

download - Firefox cannot save files (most of the time), how to solve? - Super User

windows - "-2146893807 NTE_NOT_FOUND" when repair certificate store - Super User

sql server - "Configuration file does not exist", Event ID 274 - Super User