MySQL创建GBK字符集数据库:
123
GBK: create database `test` DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;UTF8: CREATE DATABASE `test` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
MySQL修改root密码
用SET PASSWORD命令
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('mynewpassword');
用mysqladmin
mysqladmin -u root password "mynewpassword"
如果root已经设置过密码,采用如下方法
`mysqladmin -u root password oldpass "mynewpassword"`
用UPDATE直接编辑user表
12345mysql> use mysql;mysql> UPDATE user SET Password = PASSWORD('mynewpassword') WHERE user = 'root';mysql> FLUSH PRIVILEGES;如果root密码丢失,可以这样:
使用下面的方法,重启mysqlmysqld_safe --skip-grant-tables&
然后登录mysql
mysql -u root mysql mysql> UPDATE user SET password=PASSWORD("mynewpassword") WHERE user='root'; mysql> FLUSH PRIVILEGES;
MySQL中取Group By后的Top N问题
比如取group by后每个分组的Top 3
|
|