https://yeasy.gitbooks.io/docker_practice
docker run -d -p 3306:3306 --name=mysql-server --env="MYSQL_ROOT_PASSWORD=root" mysql/mysql-serverdocker exec -it 30941d303f05 bashmysql -uroot -p分配用户:
mysql> select host,user from mysql.user;
mysql> create user 'bohe'@'localhost' identified by 'bohe';
mysql> create user 'bohe'@'%' identified by 'bohe …记得之前版本在安装mysql-server的时候会出现图形界面要求配置mysql以及密码，但是新安装的并没有让配置。试过一下几种方法
sudo mysqld_safe --skip-grant-tables & 。这个问题是一直启动不了参考了这篇文章，步骤为
sudo mysqluse mysqlSELECT user, host, plugin, authentication_string FROM user;UPDATE user SET plugin="mysql_native_password", authentication_string=PASSWORD("123456") WHERE user="root";FLUSH PRIVILEGES;新建用户并赋database权限
mysql> create user 'newtable'@'localhost' identified by 'newpassword';
Query …选出最近九十天的点赞用户数量以及日期
mysql:
select count(*) as cnt, d from (select date_format(create_time,'%%Y/%%m/%%d') as d,user_id from note_digg where create_time between curdate() - interval 90 day and curdate() group by d, user_id) q group by d order by d