• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Unable to Change MySQL User/Password - mysql 5.1

Hi,

Update: Our infra
---------------------------------------------------------------
PRODUCT - Parallel plesk Panel for Windows
VERSION, 11.5.30
VERSION OF MICROUPDATE - Update #45
OPERATING SYSTEM - Microsoft Windows Server 2012
ARCHITECTURE - Parallel Plesk for Windows and dedicate MySQL Database Server

[PROBLEM DESCRIPTION]
I don't sure that you guy have this problem or not,
But we setup Plesk 11.5 with mySQL root User.
and once, we need to change both User and Password but we got error

[STEPS TO REPRODUCE]
1. Logon to PPC
2. Go to Tools & Settings
3. Go to Database Servers (Applications & Databases)
4. Select Database Server (at Hostname)
5. Go to Settings
6. In Authentication, I change Administrative's Username and Administrator's password

ACTUAL RESULT
I got error during changing the Database Information
Code:
Error: Test connection to the database server has failed because the supplied account does not possess administrative privileges:
Access denied for user 'pleskadm'@'10.10.16.1' (using password: YES)


EXPECTED RESULT
I can change Database Login information (Both User and Password)

[ANY ADDITIONAL INFORMATION]

I try to checking to access from Plesk Server
Code:
C:\Program Files (x86)\Parallels\Plesk\MySQL\bin>mysql -h 10.10.16.156 -u pleskadm -p
Enter password: ************
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 286487
Server version: 5.1.69 Source distribution

Copyright (c) 2000, 2013, 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.

and its privileges is correct
Code:
| 10.10.16% | pleskadm | *C4A1C51F3444A7CD1A5FE0F4A56EAE868D4D26CF | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y |    |    |    |    |  0 |  0 |  0 | 0 |


--------------------------------------------------------------
 
Last edited:
Back
Top