root@srv01:~# bash --version
GNU bash, version 4.2.37(1)-release (x86_64-pc-linux-gnu)
Regards,
V.
------
> Date: Tue, 21 Jul 2015 06:34:56 +0000
> From: <email address hidden>
> To: <email address hidden>
> Subject: [Bug 1474547] Re: Cannot enter the password on pt-mysql-summary
>
> Hi,
>
> I don't know why you are giving -- two times in command line, before user information.
> Can you try to run like this and check?
>
> pt-mysql-summary --user=root --password=<yourpassword>
>
> If you don't want to give password in command line then you can create
> .my.cnf in your home folder and then run direct pt-mysql-summary
> command. i.e
>
> nilnandan@desktop:~$ cat .my.cnf
> [client]
> user=root
> password=root
> nilnandan@desktop:~$
> nilnandan@desktop:~$ pt-mysql-summary
> # Percona Toolkit MySQL Summary Report #######################
> System time | 2015-07-21 06:33:51 UTC (local TZ: IST +0530)
> # Instances ##################################################
> Port Data Directory Nice OOM Socket
> ===== ========================== ==== === ======
> 3306 /var/lib/mysql 0 0 /var/run/mysqld/mysqld.sock
> # MySQL Executable ###########################################
> Path to executable | /usr/sbin/mysqld
> Has symbols | No
> ...
>
>
> ** Changed in: percona-toolkit
> Status: New => Incomplete
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/1474547
>
> Title:
> Cannot enter the password on pt-mysql-summary
>
> Status in Percona Toolkit:
> Incomplete
>
> Bug description:
> Hi,
> when I try to use pt-mysql-summary, I enter my root password then I digit the password and press ENTER. However, I continue get the request "Enter password:". I suspect a problem with an "escape" character: my password contains a underscore and a bang.
> If I try to connect to mysql in this way:
> mysql -u root -p
> I enter the password and I get the prompt.
>
>
> Complete command‐line used to run the tool:
> pt-mysql-summary -- --user=root -p
> Tool version:
> 2.2.14 (installed from percona-toolkit_2.2.14_all.deb)
> MySQL version of all servers involved:
> 5.5.40-0+wheezy1-log
> Output from the tool including STDERR:
> root@srv01:~# pt-mysql-summary -- --user=root -p
> Enter password:
> Enter password:
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/percona-toolkit/+bug/1474547/+subscriptions
Hi,
This is the command:
root@srv01:~# pt-mysql-summary --user=root --password= vkY!_93mbfZGPH
-bash: !_93mbfZGPH: event not found
root@srv01:~#
If I create the file .my.cnf with the same password, it works.
My distro is:
root@srv01:~# cat /etc/*ase DESCRIPTION= www.debian. org/" www.debian. org/support/" bugs.debian. org/"
DISTRIB_ID=Debian
DISTRIB_RELEASE=7
DISTRIB_CODENAME=
DISTRIB_
PRETTY_NAME="Debian GNU/Linux 7 (wheezy)"
NAME="Debian GNU/Linux"
VERSION_ID="7"
VERSION="7 (wheezy)"
ID=debian
ANSI_COLOR="1;31"
HOME_URL="http://
SUPPORT_URL="http://
BUG_REPORT_URL="http://
root@srv01:~# bash --version pc-linux- gnu)
GNU bash, version 4.2.37(1)-release (x86_64-
Regards,
V.
------ <yourpassword> desktop: ~$ cat .my.cnf desktop: ~$ desktop: ~$ pt-mysql-summary ####### ####### ## ####### ####### ####### ####### ####### ####### # ======= ======= ===== ==== === ====== mysqld/ mysqld. sock ####### ####### ####### ####### ####### # /bugs.launchpad .net/bugs/ 1474547 toolkit_ 2.2.14_ all.deb) 0+wheezy1- log /bugs.launchpad .net/percona- toolkit/ +bug/1474547/ +subscriptions
> Date: Tue, 21 Jul 2015 06:34:56 +0000
> From: <email address hidden>
> To: <email address hidden>
> Subject: [Bug 1474547] Re: Cannot enter the password on pt-mysql-summary
>
> Hi,
>
> I don't know why you are giving -- two times in command line, before user information.
> Can you try to run like this and check?
>
> pt-mysql-summary --user=root --password=
>
> If you don't want to give password in command line then you can create
> .my.cnf in your home folder and then run direct pt-mysql-summary
> command. i.e
>
> nilnandan@
> [client]
> user=root
> password=root
> nilnandan@
> nilnandan@
> # Percona Toolkit MySQL Summary Report #######
> System time | 2015-07-21 06:33:51 UTC (local TZ: IST +0530)
> # Instances #######
> Port Data Directory Nice OOM Socket
> ===== =======
> 3306 /var/lib/mysql 0 0 /var/run/
> # MySQL Executable #######
> Path to executable | /usr/sbin/mysqld
> Has symbols | No
> ...
>
>
> ** Changed in: percona-toolkit
> Status: New => Incomplete
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https:/
>
> Title:
> Cannot enter the password on pt-mysql-summary
>
> Status in Percona Toolkit:
> Incomplete
>
> Bug description:
> Hi,
> when I try to use pt-mysql-summary, I enter my root password then I digit the password and press ENTER. However, I continue get the request "Enter password:". I suspect a problem with an "escape" character: my password contains a underscore and a bang.
> If I try to connect to mysql in this way:
> mysql -u root -p
> I enter the password and I get the prompt.
>
>
> Complete command‐line used to run the tool:
> pt-mysql-summary -- --user=root -p
> Tool version:
> 2.2.14 (installed from percona-
> MySQL version of all servers involved:
> 5.5.40-
> Output from the tool including STDERR:
> root@srv01:~# pt-mysql-summary -- --user=root -p
> Enter password:
> Enter password:
>
> To manage notifications about this bug go to:
> https:/