--env cat /etc/*release DISTRIB_ID=Ubuntu DISTRIB_RELEASE=18.04 DISTRIB_CODENAME=bionic DISTRIB_DESCRIPTION="Ubuntu 18.04.3 LTS" NAME="Ubuntu" VERSION="18.04.3 LTS (Bionic Beaver)" ID=ubuntu ID_LIKE=debian PRETTY_NAME="Ubuntu 18.04.3 LTS" VERSION_ID="18.04" HOME_URL="https://www.ubuntu.com/" SUPPORT_URL="https://help.ubuntu.com/" BUG_REPORT_URL="https://bugs.launchpad.net/ubuntu/" PRIVACY_POLICY_URL="https://www.ubuntu.com/legal/terms-and-policies/privacy-policy" VERSION_CODENAME=bionic UBUNTU_CODENAME=bionic - https://dev.mysql.com/downloads/shell/ - pulled Linux - Generic (glibc 2.12) (x86, 64-bit), Compressed TAR Archive 8.0.20 32.9M Download (mysql-shell-8.0.20-linux-glibc2.12-x86-64bit.tar.gz) md5sum mysql-shell-8.0.20-linux-glibc2.12-x86-64bit.tar.gz dec07d4a5f700801f1f0986a3005f530 mysql-shell-8.0.20-linux-glibc2.12-x86-64bit.tar.gz root@UbuntuBB:/home/ushastry# wget https://github.com/sysown/proxysql/releases/download/v2.0.12/proxysql_2.0.12-ubuntu18_amd64.deb --2020-05-29 12:52:33-- https://github.com/sysown/proxysql/releases/download/v2.0.12/proxysql_2.0.12-ubuntu18_amd64.deb Resolving www-proxy.us.oracle.com (www-proxy.us.oracle.com)... 148.87.19.20 Connecting to www-proxy.us.oracle.com (www-proxy.us.oracle.com)|148.87.19.20|:80... connected. Proxy request sent, awaiting response... 302 Found Location: https://github-production-release-asset-2e65be.s3.amazonaws.com/27358084/45c07f00-98b4-11ea-8f8e-0c6dfb894096?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAIWNJYAX4CSVEH53A%2F20200529%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20200529T072234Z&X-Amz-Expires=300&X-Amz-Signature=cdd8ca2f1b8e8f4d9bd278547231aaa4bc1e4b28ab34a36fdd6326484ead5376&X-Amz-SignedHeaders=host&actor_id=0&repo_id=27358084&response-content-disposition=attachment%3B%20filename%3Dproxysql_2.0.12-ubuntu18_amd64.deb&response-content-type=application%2Foctet-stream [following] --2020-05-29 12:52:34-- https://github-production-release-asset-2e65be.s3.amazonaws.com/27358084/45c07f00-98b4-11ea-8f8e-0c6dfb894096?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAIWNJYAX4CSVEH53A%2F20200529%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20200529T072234Z&X-Amz-Expires=300&X-Amz-Signature=cdd8ca2f1b8e8f4d9bd278547231aaa4bc1e4b28ab34a36fdd6326484ead5376&X-Amz-SignedHeaders=host&actor_id=0&repo_id=27358084&response-content-disposition=attachment%3B%20filename%3Dproxysql_2.0.12-ubuntu18_amd64.deb&response-content-type=application%2Foctet-stream Connecting to www-proxy.us.oracle.com (www-proxy.us.oracle.com)|148.87.19.20|:80... connected. Proxy request sent, awaiting response... 200 OK Length: 10434180 (10.0M) [application/octet-stream] Saving to: ‘proxysql_2.0.12-ubuntu18_amd64.deb’ proxysql_2.0.12-ubuntu18_amd64.deb 100%[================================================================================================================>] 9.95M 323KB/s in 32s 2020-05-29 12:53:07 (319 KB/s) - ‘proxysql_2.0.12-ubuntu18_amd64.deb’ saved [10434180/10434180] root@UbuntuBB:/home/ushastry# dpkg -i proxysql_2.0.12-ubuntu18_amd64.deb Selecting previously unselected package proxysql. (Reading database ... 270792 files and directories currently installed.) Preparing to unpack proxysql_2.0.12-ubuntu18_amd64.deb ... Unpacking proxysql (2.0.12) ... Setting up proxysql (2.0.12) ... Created symlink /etc/systemd/system/multi-user.target.wants/proxysql.service → /lib/systemd/system/proxysql.service. root@UbuntuBB:/home/ushastry# mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) root@UbuntuBB:/home/ushastry# mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9 Server version: 8.0.19 MySQL Community Server - GPL Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> \q Bye root@UbuntuBB:/home/ushastry# service proxysql start root@UbuntuBB:/home/ushastry# ps aux|grep proxysql proxysql 12364 0.0 0.0 67900 3972 ? S 12:56 0:00 /usr/bin/proxysql --idle-threads -c /etc/proxysql.cnf proxysql 12365 0.8 0.1 165420 15984 ? Sl 12:56 0:00 /usr/bin/proxysql --idle-threads -c /etc/proxysql.cnf root 12391 0.0 0.0 21532 1008 pts/0 S+ 12:56 0:00 grep --color=auto proxysql root@UbuntuBB:/home/ushastry# mysql -u admin -padmin -h 127.0.0.1 -P6032 --prompt='Admin> ' mysql: [Warning] Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.5.30 (ProxySQL Admin Module) Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. Admin> show databases; +-----+---------------+-------------------------------------+ | seq | name | file | +-----+---------------+-------------------------------------+ | 0 | main | | | 2 | disk | /var/lib/proxysql/proxysql.db | | 3 | stats | | | 4 | monitor | | | 5 | stats_history | /var/lib/proxysql/proxysql_stats.db | +-----+---------------+-------------------------------------+ 5 rows in set (0.00 sec) Admin> \q Bye root@UbuntuBB:/home/ushastry# cd Downloads/ root@UbuntuBB:/home/ushastry/Downloads# ls -l total 753184 drwxr-xr-x 3 ushastry ushastry 4096 Nov 27 2019 boost -rw-rw-r-- 1 ushastry ushastry 116000903 Nov 27 2019 boost_1_70_0.tar.gz drwxr-xr-x 37 ushastry ushastry 4096 Nov 28 2019 fb-mysql-8.0.17 drwxr-xr-x 3 ushastry ushastry 4096 Nov 28 2019 mysql drwxr-xr-x 36 ushastry ushastry 4096 Nov 28 2019 mysql-5.6 drwxr-xr-x 14 ushastry ushastry 4096 Jan 2 12:01 mysql-5.6.46 -rw-rw-r-- 1 ushastry ushastry 403177622 Dec 19 18:07 mysql-5.6.46-linux-glibc2.12-x86_64.tar.gz drwxr-xr-x 34 ushastry ushastry 4096 Dec 3 11:25 mysql-8.0.18 -rw-rw-r-- 1 ushastry ushastry 35532 Feb 28 17:44 mysql-apt-config_0.8.15-1_all.deb -rw-rw-r-- 1 ushastry ushastry 194953221 Dec 3 11:15 mysql-boost-8.0.18.tar.gz -rw-rw-r-- 1 ushastry ushastry 34520328 May 29 13:00 mysql-shell-8.0.20-linux-glibc2.12-x86-64bit.tar.gz -rw-rw-r-- 1 ushastry ushastry 22523692 Mar 8 13:02 mysql-workbench-community_8.0.19-1ubuntu18.04_amd64.deb root@UbuntuBB:/home/ushastry/Downloads# root@UbuntuBB:/home/ushastry/Downloads# mv mysql-shell-8.0.20-linux-glibc2.12-x86-64bit mysql-shell root@UbuntuBB:/home/ushastry/Downloads# cd mysql-shell root@UbuntuBB:/home/ushastry/Downloads/mysql-shell# ls -l total 12 drwxr-xr-x 2 7161 31415 4096 Mar 11 20:07 bin drwxr-xr-x 3 7161 31415 4096 Mar 11 20:08 lib drwxr-xr-x 3 7161 31415 4096 Mar 11 20:08 share root@UbuntuBB:/home/ushastry/Downloads/mysql-shell# bin/mysqlsh MySQL Shell 8.0.20 Copyright (c) 2016, 2020, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type '\help' or '\?' for help; '\quit' to exit. MySQL JS > \c admin@127.0.0.1:6032 Creating a session to 'admin@127.0.0.1:6032' Please provide the password for 'admin@127.0.0.1:6032': ***** Save password for 'admin@127.0.0.1:6032'? [Y]es/[N]o/Ne[v]er (default No): Fetching schema names for autocompletion... Press ^C to stop. MySQL Error 1045 (28000): ProxySQL Admin Error: unrecognized token: "@" MySQL 127.0.0.1:6032 JS > MySQL 127.0.0.1:6032 JS > \sql Switching to SQL mode... Commands end with ; Error during auto-completion cache update: ClassicSession.runSql: ProxySQL Admin Error: no such function: schema MySQL 127.0.0.1:6032 SQL > show databases Segmentation fault (core dumped) root@UbuntuBB:/home/ushastry/Downloads/mysql-shell# ###### root@UbuntuBB:/home/ushastry/Downloads/mysql-shell# dpkg -l |grep mysql ii libmysqlclient20:amd64 5.7.30-0ubuntu0.18.04.1 amd64 MySQL database client library ii libmysqlcppconn7v5:amd64 1.1.9-1 amd64 MySQL Connector for C++ (library) ii mysql-apt-config 0.8.15-1 all Auto configuration for MySQL APT Repo. ii mysql-client 8.0.19-1ubuntu18.04 amd64 MySQL Client meta package depending on latest version ii mysql-common 8.0.19-1ubuntu18.04 amd64 Common files shared between packages ii mysql-community-client 8.0.19-1ubuntu18.04 amd64 MySQL Client ii mysql-community-client-core 8.0.19-1ubuntu18.04 amd64 MySQL Client Core Binaries ii mysql-community-server 8.0.19-1ubuntu18.04 amd64 MySQL Server ii mysql-community-server-core 8.0.19-1ubuntu18.04 amd64 MySQL Server Core Binaires ii mysql-server 8.0.19-1ubuntu18.04 amd64 MySQL Server meta package depending on latest version ii mysql-utilities 1.6.4-1 all collection of scripts for managing MySQL servers ii mysql-workbench-community 8.0.19-1ubuntu18.04 amd64 MySQL Workbench ii mysql-workbench-data 6.3.8+dfsg-1build3 all MySQL Workbench -- architecture independent data ii python-mysql.connector 2.1.6-1 all pure Python implementation of MySQL Client/Server protocol root@UbuntuBB:/home/ushastry/Downloads/mysql-shell# dpkg -l |grep -i proxysql ii proxysql 2.0.12 amd64 High performance MySQL proxy root@UbuntuBB:/home/ushastry/Downloads/mysql-shell#