MySQL - cllu/.rc GitHub Wiki

Snippets

Create new user/database

CREATE DATABASE new_database;
CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON new_database.* TO 'user'@'localhost';
FLUSH PRIVILEGES;

Change root password

$ mysqladmin -u root -p password

PHP中文插入后显示？？

jiangyiqun.cn使用Stray Random Quotes插件不能输入中文，是对应表的encoding问题：

ALTER TABLE wp_stray_quotes CONVERT TO CHARACTER SET utf8;