I think I found a glitch in the transfer process from cPanel.
I'm moving accounts to a new server. This new server doesn't run MySQL, but MySQL Proxy which 'redirects' MySQL connections to a different server. This means clients can still connect to "localhost" while in fact MySQL is running on a remote server. For this reason, I added the IP address of the webserver (running MySQL Proxy) to the "Additional MySQL Access Hosts" section in WHM. When a new MySQL account is created via cPanel, it will automatically grant access from my webserver IP. Which is nice!
However, this isn't the case when accounts are transfered using the "Copy multiple accounts/packages from another server" feature. The MySQL users are restored, however they don't have access from the webserver, causing all PHP scripts to break after the transfer. Only the main MySQL user (ie: foobar) has the correct privileges, but any other MySQL user (ie: foobar_db1) hasn't.
I tried the "mysqlupdateall" script (as suggested in the "Additional MySQL Access Hosts" section) but that doesn't resolve the issue.
Any idea how I would resolve this problem as quick as possible?
Thanks
I'm moving accounts to a new server. This new server doesn't run MySQL, but MySQL Proxy which 'redirects' MySQL connections to a different server. This means clients can still connect to "localhost" while in fact MySQL is running on a remote server. For this reason, I added the IP address of the webserver (running MySQL Proxy) to the "Additional MySQL Access Hosts" section in WHM. When a new MySQL account is created via cPanel, it will automatically grant access from my webserver IP. Which is nice!
However, this isn't the case when accounts are transfered using the "Copy multiple accounts/packages from another server" feature. The MySQL users are restored, however they don't have access from the webserver, causing all PHP scripts to break after the transfer. Only the main MySQL user (ie: foobar) has the correct privileges, but any other MySQL user (ie: foobar_db1) hasn't.
I tried the "mysqlupdateall" script (as suggested in the "Additional MySQL Access Hosts" section) but that doesn't resolve the issue.
Any idea how I would resolve this problem as quick as possible?
Thanks
Last edited: