Information about the error message: The database is not shared/accessible externally.
Please have a look at the article about sharing the database externally.
Information about the error message: The user has no rights to connect to this DB.
Please see the post on the topic of creating database users.
Information about the error message: This error occurs when importing databases that are either too large or the connection is too slow for the upload.
Troubleshooting:
First opens the file my.cnf
.
You can find it in the following places:
The following variables must now be adjusted in this file.wait_timeout=60
Here you enter the desired timeout in seconds - if this is still too low, you can simply increase it further.max_allowed_packet=100M
This variable determines the maximum packet size of the upload. Now set the value of this variable upwards so that it is higher than the file size of the database to be imported.
Last but not least, the MySQL server must be restarted and the error should now no longer occur.
Important:
On live systems, the changed variables should be reset to their default value afterwards, as they could possibly represent a security hole for attackers.