• 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
  • Inviting everyone to the UX test of a new security feature in the WP Toolkit
    For WordPress site owners, threats posed by hackers are ever-present. Because of this, we are developing a new security feature for the WP Toolkit. If the topic of WordPress website security is relevant to you, we would be grateful if you could share your experience and help us test the usability of this feature. We invite you to join us for a 1-hour online session via Google Meet. Select a convenient meeting time with our friendly UX staff here.

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