• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • We are looking for U.S.-based freelancer or agency working with SEO or WordPress for a quick 30-min interviews to gather feedback on XOVI, a successful German SEO tool we’re looking to launch in the U.S.
    If you qualify and participate, you’ll receive a $30 Amazon gift card as a thank-you. Please apply here. Thanks for helping shape a better SEO product for agencies!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

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