Last active
March 29, 2022 16:32
-
-
Save samayo/acbfa6ccafc3c0c1bea97c902b11f70f to your computer and use it in GitHub Desktop.
Revisions
-
samayo revised this gist
Mar 29, 2022 . 1 changed file with 1 addition and 1 deletion.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -7,6 +7,6 @@ mysql -u username -p database_name < file.sql ``` ## SCP ```shell scp SOMETHING.zip [email protected]:/var/ ``` -
samayo revised this gist
Mar 29, 2022 . 1 changed file with 6 additions and 1 deletion.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -4,4 +4,9 @@ GRANT ALL PRIVILEGES ON website_com.* To 'user_website_com'@'localhost' IDENTIFIED BY 'XXXXXXXX'; CREATE USER 'user_website_com'@'localhost' IDENTIFIED BY 'XXXXXXXX'; mysql -u username -p database_name < file.sql ``` ## SCP ```bash scp SOMETHING.zip [email protected]:/var/ ``` -
samayo created this gist
Mar 29, 2022 .There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1,7 @@ #### MYSQL ```sql # give access to user GRANT ALL PRIVILEGES ON website_com.* To 'user_website_com'@'localhost' IDENTIFIED BY 'XXXXXXXX'; CREATE USER 'user_website_com'@'localhost' IDENTIFIED BY 'XXXXXXXX'; mysql -u username -p database_name < file.sql ```