MySQL password chan...
 
Notifications
Clear all

MySQL password change and Backup issues

2 Posts
1 Users
0 Reactions
777 Views
Posts: 29
Topic starter
(@msaragnoli)
Eminent Member
Joined: 7 years ago

Hi,

I am having some troubles with MySQL password change and backups, if someone could help I would really appreciate.

Server: Windows Server 2012 R2
SolidCP: 1.4.4
MySQL: 5.7

1 - If I try to change the MySQL Password in System Settings, I get an error:
Access denied for user '`root`'@'192.168.X.X'

I tryed to upgrade the dll: SolidCP.Providers.Database.MySQL.dll using the file downloaded at ' http://installer.solidcp.com/Files/1.4.4/SQLProvider-Fix.zip ' no luck.

Then I read the mesage error with more attention and I noticed that the SolidCP is trying to connect to MySQL using the user: `root` (with quotation mark) instead of root, as a temporary solution I created a new user in my MySQL called `root` and then I was able to change the password in System Settings.

2 - All Backups from the customers return a file like this (just an example part of the file), without the command create tables or insert datas, it seems it is generating only the Header of the backup file:

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;...

I am not sure what is happening, because it doesn't generate any error. The file is wrong generated when using the manual Backup Tool from the Panel or using the scheduled service.

Thank you for any help.

1 Reply
Posts: 29
Topic starter
(@msaragnoli)
Eminent Member
Joined: 7 years ago

Hi,

Problem solved!

I was using the MySQL Connector 6.10.9, which I have downloaded and installed outside from MySql Installer.

I uninstalled it and installed the connector version 6.9.9 from MySQL Installer:

I have NO IDEA why...but now everything is working again.

Thank you.

Reply
Share: