Solid-State Society

Tag: MySQL

Reset WordPress password using MySQL / phpMyAdmin

UPDATE `wp_users` SET `user_pass`= MD5('yourpassword') WHERE `user_login`='yourusername';

Upgrading MySQL 5.1 to 5.6 service failed to start

After upgrading from MySQL 5.1 to 5.6 , mysql service failed to start.InnoDB: auto-extending data file ./ibdata1 is of a different size 640 pages (rounded down to MB) than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages!

Source: Upgrading MySQL 5.1 to 5.6 service failed to start

January 1, 2016
MySQL of MAMP on OS X
在 Terminal 中输入
```
cd /Applications/MAMP/db/
mv mysql mysql.bak
ln -s ~/Sites/.mysql/ mysql
```
每次全新安装 MAMP 时都需要执行一遍此命令（待验证）
April 11, 2012