Skip to content

Instantly share code, notes, and snippets.

View stephanie56's full-sized avatar

Stephanie Zeng stephanie56

View GitHub Profile
@stephanie56
stephanie56 / fix-mysql-root-password
Last active June 18, 2020 17:50
Fix mysql access denied for user 'admin'@'localhost' (using password: yes)
- Stop Mysql server
- Run `sudo mysqld_safe --skip-grant-tables`
- Enter password
- Keep the previous terminal open, start a new terminal window
- Run `mysql -u root` to log in to mysql
- Run `flush privileges;`
- Run `ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'new_password';`
- Run `flush privileges;`
- Run `\q` to quit
- Turn off both terminals, open a new terminal to login to mysql with new password `mysql -uroot -p`
@stephanie56
stephanie56 / PDFCreator_EmailAllResponses
Created February 20, 2020 17:47 — forked from andrewroberts/PDFCreator_EmailAllResponses
Google Apps Script to create a PDF from each of the rows in a Google Sheet
/*
PDF Creator - Email all responses
=================================
When you click "Create PDF > Create a PDF for each row" this script
constructs a PDF for each row in the attached GSheet. The value in the
"File Name" column is used to name the file and - if there is a
value - it is emailed to the recipient in the "Email" column.