• 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!
  • 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.

Issue plesk bin database cli not syncing with Mysql

linuxman1

Basic Pleskian
I had some issues using some plesk bin database commands and seems it isn't syncing changes to Mysql and I want to do something like flush privileges for it so it syncs with Mysql.
For example,
plesk bin database --create-dbuser adminnn -passwd password -domain example.com -type mysql -any-database says,
Unable to add database user: A database user with the name "adminnn" already exists.
Although I removed that user and did some flush privileges and Plesk still consider the account is still existent!
Another cli like,
plesk bin database --update-dbuser adminn -domain example.com -type mysql -any-database
The database user was successfully updated.
Although I checked on Mysql and on Phpmyadmin and the command didn't affect like it wasn't executed.
Would some one help? how to sync changes between Mysql and Plesk bin database commands?
 
  1. Connect to Plesk server via RDP;
  2. Open command prompt as Administrator
  3. Back up client database:
    C:\> "%plesk_dir%"MySQL\bin\mysqldump -uadmin -p -P3306 client_base > client_base.dump
    where:
    3306 - port for MySQL server;
    client_base - database name;
    client_base.dump - name of database backup.
    Note: MySQL admin password will be asked during the commands execution. In case it is not known, it can be safely changed at Tools & Settings > Database Servers > localhost (default for MySQL) on port 3306.
 
johnpowell1.
Why this is may be related to the issue I have, have you read my post?
Please Plesk team, recommend any fix, changes are not syncing between the actual Mysql installed by Plesk and plesk bin database command like described above?
 
Back
Top