backup_database_from_remote_server
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
backup_database_from_remote_server [2016/12/13 21:28] – external edit 127.0.0.1 | backup_database_from_remote_server [2023/03/09 22:35] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 9: | Line 9: | ||
\\ | \\ | ||
\\ | \\ | ||
- | 1. Your user must have the rights (normally user accounts are localhost limited) I created a user with global rights ' | + | 1. Your user must have the rights (normally user accounts are localhost limited) I created a user with global rights ' |
\\ | \\ | ||
- | Comment these lines in / | + | \\ |
- | skip-networking\\ | + | < |
- | bind-address = 127.0.0.1\\ | + | CREATE USER ' |
+ | |||
+ | EG: CREATE USER ' | ||
+ | |||
+ | Once created, the user requires permissions | ||
+ | |||
+ | GRANT ALL PRIVILEGES ON * . * TO ' | ||
+ | |||
+ | If you want to be able to access the server from anywhere, replace localhost with % | ||
+ | |||
+ | GRANT ALL PRIVILEGES ON * . * TO ' | ||
+ | </ | ||
+ | \\ | ||
+ | \\ | ||
+ | <color red> SUPER IMPORTANT</ | ||
+ | \\ | ||
+ | \\ | ||
+ | skip-networking\\ | ||
+ | bind-address = 127.0.0.1\\ | ||
\\ | \\ | ||
2. You must have rights to write to the target directory (easily overlooked)\\ | 2. You must have rights to write to the target directory (easily overlooked)\\ |
backup_database_from_remote_server.1481664529.txt.gz · Last modified: 2023/03/09 22:35 (external edit)