Article ID: 112036, created on Aug 23, 2011, last review on Aug 12, 2014

  • Applies to:
  • Plesk 10.1 for Linux/Unix
  • Plesk 10.0.x for Linux/Unix
  • Plesk 9.5 for Linux/Unix

Symptoms

When you execute ch_admin_password utility, it leaves two mysql instances: one is running with a --skip-grant-tables option and makes it impossible to use MySQL 
 
root@CT63:~# PSA_PASSWORD=ednjmgikqst LANG=C /usr/local/psa/admin/sbin/ch_admin_passwd
root@CT63:~# echo $?
0

root@CT63:~# ps auxwwff | grep mys
root 17408 0.0 0.0 6152 668 pts/0 S+ 12:56 0:00 \_ grep --color=auto mys
root 15729 0.0 0.0 4088 656 pts/0 S 12:55 0:00 /bin/sh /usr/bin/mysqld_safe --skip-grant-tables --skip-networking
mysql 15886 0.0 0.0 84796 10324 pts/0 Sl 12:55 0:00 \_ /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --skip-grant-tables --skip-networking --pid-file=/var/lib/mysql/CT63.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
mysql 15912 2.0 0.0 88424 14000 ? Ssl 12:55 0:00 /usr/sbin/mysqld --pid-file=/var/run/mysqld/mysqld.pid
 
Trying to change the password fails again with this error:
 
root@CT63:~# PSA_PASSWORD=ednjmgikqst LANG=C /usr/local/psa/admin/sbin/ch_admin_passwd
ch_admin_passwd: /usr/bin/mysql execution failed:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
ch_admin_passwd: /usr/bin/mysql execution failed:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
ch_admin_passwd: Can't change MySQL password
ch_admin_passwd: Can't change MySQL password
 

If Parallels Plesk Panel is registered in POA or PBAS, you could see the following error message after password changing:
"1023 : Can`t change password. Error: MySQL query failed: The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement"
 

Resolution

The issue has been fixed in Parallels Plesk Panel since 9.5.4 MU#12 and 10.1.1 MU#13. It's strongly recommenced that you install the latest microupdate if you are still running those versions. You may install it from the command line:

# /usr/local/psa/admin/sbin/autoinstaller --select-release-current --reinstall-patch --install-component base

Workaround

Download and replace ch_admin_passwd with a fixed version for Ubuntu 10.04 x64. 

You may also use the Plesk Mass Password Reset Script for changing the admin password (use --admin option).

Attachments

b21de1858ad3ec50d5613195a77434ab a914db3fdc7a53ddcfd1b2db8f5a1b9c 29d1e90fd304f01e6420fbe60f66f838 dd0611b6086474193d9bf78e2b293040 60d3e722783ac7177a2b4b4c13af4062 6ef0db7f1685482449634a455d77d3f4 def31538ba607bde27398f48ab5956be 56797cefb1efc9130f7c48a7d1db0f0c

Email subscription for changes to this article
Save as PDF