Differences

This shows you the differences between two versions of the page.

--- backup_database_from_remote_server [2016/08/03 08:52] – walkeradmin
+++ backup_database_from_remote_server [2023/03/09 22:35] (current) – external edit 127.0.0.1
@@ Line 9: / Line 9: @@
 \\
 \\
-. Your user must have the rights (normally user accounts are localhost limited) I created a user with global rights '%'\\
+. Your user must have the rights (normally user accounts are localhost limited) I created a user with global rights '%'
 \\
-Comment these lines in my.cnf\\
+\\
-skip-networking\\
+<file>
-bind-address = 127.0.0.1\\
+CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
+  EG: CREATE USER 'admin'@'%' IDENTIFIED BY 'password';
+Once created, the user requires permissions
+  GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
+If you want to be able to access the server from anywhere, replace localhost with %
+  GRANT ALL PRIVILEGES ON * . * TO 'admin'@'%';
+</file>
+\\
+\\
+<color red> SUPER IMPORTANT</color> Comment these lines in /etc/mysql/my.cnf\\ <>OR SQL WILL ONLY ACCEPT LOCAL CONNECTIONS</color>
+\\
+\\
+    skip-networking\\
+    bind-address = 127.0.0.1\\
 \\
 . You must have rights to write to the target directory (easily overlooked)\\
 . The backup might take a few minutes, be prepared to wait.\\
 \\
+    Now we can execute the following command:
+    mysqldump --host ipaddress -P port -u user -pPassword databasename > savename.sql
+    mysqldump --host 10.0.0.1 -P 3306 -u root -pRootPassword gallery > gallery.sql
+\\
+\\