linux下安装mysql的步骤,记录一下
linux版本:Red Hat Enterprise Linux Server release 6.6 (Santiago)
mysql版本:mysql-community-server-5.7.9
- 到官网下载rpm包
http://dev.mysql.com/downloads/mysql/ - 检查是否安装过
rpm -qa|grep mysql
有则先删除
rpm -e - 使用yum安装,会自动识别依赖
yum install mysql-community-{server,client,common,libs-compat,libs}-* - 启动mysql
service mysqld start - 查看初始密码
grep 'temporary password' /var/log/mysqld.log
[Note] A temporary password is generated for root@localhost: B-loGAsAk5&A - 修改密码:
mysqladmin -u root -p password "newpassword"
Enter password:
输入原来密码即可
5.6以后默认启动密码校验插件,密码不能太简单,可以关闭
mysql> use mysql;
mysql> UNINSTALL PLUGIN validate_password; - 连上mysql mysql -u root -p
- 如果找不到初始密码,可以先用如下方式启动mysql
service mysqld stop
mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
在另外一个终端连上mysql ,这时不需要密码
mysql -u root
UPDATE user SET authentication_string=PASSWORD('newpassword') where USER='root';
service mysqld restart