Skip to content

Instantly share code, notes, and snippets.

@ryanjbonnell
ryanjbonnell / mysql-reset-root-password.sh
Created August 5, 2014 05:55
MySQL - Reset Root Password
$ sudo /usr/local/mysql/support-files/mysql.server stop
$ sudo /usr/local/mysql/bin/mysqld_safe --skip-grant-tables --skip-networking &
mysql> UPDATE mysql.user SET Password=PASSWORD('') WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> exit
$ mysql -h localhost -u root
mysql> set password=password('');
mysql> exit
@ryanjbonnell
ryanjbonnell / gist:b78002efbe6662703fa6
Created June 4, 2014 16:19
WordPress - MySQL Update Admin Email Address
UPDATE
wp_options
SET
option_value = 'username@example.com'
WHERE
option_name = 'admin_email';
@ryanjbonnell
ryanjbonnell / facebook-like-box.html
Created May 30, 2014 20:42
Load the Facebook JavaScript SDK Asynchronously
<div class="fb-like-box"
data-href="https://www.facebook.com/FacebookDevelopers"
data-colorscheme="light"
data-show-faces="true"
data-header="true"
data-stream="false"
data-show-border="true"
data-height="212">
</div>