这篇文章主要为大家介绍了 centOS 安装 mysql5.7 详细教程, 具有一定的参考价值, 感兴趣的小伙伴们可以参考一下
第一步:
第一句检测系统是否自带安装 mysql, 若有执行第二句删除系统自带的 mysql 及其依赖
- yum list installed | grep mysql
- yum -y remove mysql-libs.x86_64
第二步:
给 CentOS 添加 rpm 源, 并且选择较新的源, 下面代码逐句执行
- wget dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
- yum localinstall mysql-community-release-el6-5.noarch.rpm
- yum repolist all | grep mysql
- yum-config-manager --disable mysql55-community
- yum-config-manager --disable mysql56-community
- yum-config-manager --enable mysql57-community-dmr
- yum repolist enabled | grep mysql
第三步:
安装 mysql 服务器
yum install mysql-community-server
第四步:
service mysqld start
第五步:
查看 mysql 是否自启动, 并且设置开启自启动
- chkconfig --list | grep mysqld
- chkconfig mysqld on
第六步:
这一步很重要!!!
不知道从 mysql 哪个版本开始, mysql 的 root 默认密码就不为空了, 在安装的过程中默认密码保存在安装日志中了我们要通过安装日志找到默认密码, 用默认密码登陆 mysql 成功后会强行让你修改密码, 修改的密码还要够复杂 (复合 mysql 默认的密码策略) 才能修改成功, 一般带大小写字母特殊字符和数字超过 8 个字符就可以
首先找到安装日志
find / -name mysqld.log
然后发现该日志文件路径在 /var/log/mysqld.log 然后用下面命令打开, 按 i'键上翻
vim /var/log/mysqld.log
上图红色地方就是 root 密码所在地
第七步:
mysql 安全设置
mysql_secure_installation
输入上面命令进行下面步骤
- SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
- In order to log into MySQL to secure it, we'll need the current
- password for the root user. If you've just installed MySQL, and
- you haven't set the root password yet, the password will be blank,
- so you should just press enter here.
Enter current password for root (enter for none):<初次运行, 输入刚刚找到的初始密码, 会强制你先修改密码才能进行下去
- OK, successfully used password, moving on
- Setting the root password ensures that nobody can log into the MySQL
- root user without the proper authorisation.
Set root password? [Y/n] < 是否设置 root 用户密码, 输入 y 并回车或直接回车
New password: < 设置 root 用户的密码
Re-enter new password: < 再输入一次你设置的密码
- Password updated successfully!
- Reloading privilege tables..
- Success!
- By default, a MySQL installation has an anonymous user, allowing anyone
- to log into MySQL without having to have a user account created for
- them. This is intended only for testing, and to make the installation
- go a bit smoother. You should remove them before moving into a
- production environment.
Remove anonymous users? [Y/n] < 是否删除匿名用户, 生产环境建议删除, 所以直接回车
- Success!
- Normally, root should only be allowed to connect from 'localhost'. This
- ensures that someone cannot guess at the root password from the network.
Disallow root login remotely? [Y/n] <是否禁止 root 远程登录, 根据自己的需求选择 Y/n 并回车, 建议禁止
- Success!
- By default, MySQL comes with a database named 'test' that anyone can
- access. This is also intended only for testing, and should be removed
- before moving into a production environment.
Remove test database and access to it? [Y/n] < 是否删除 test 数据库, 直接回车
- - Dropping test database
- Success!
- - Removing privileges on test database
- Success!
- Reloading the privilege tables will ensure that all changes made so far
- will take effect immediately.
Reload privilege tables now? [Y/n] < 是否重新加载权限表, 直接回车
- Success!
- Cleaning up
- All done! If you've completed all of the above steps, your MySQL
- installation should now be secure.
- Thanks for using MySQL!
- [root@server1 ~]#
第八步:
可选步骤, 原来 Linux 下的 MySQL 默认是区分表名大小写的, 通过如下设置, 可以让 MySQL 不区分表名大小写:
1 用 root 登录, 修改 /etc/my.cnf;
2 在 [mysqld] 节点下, 加入一行: lower_case_table_names=1
3 重启 MySQL 即可; service mysqld restart
来源: http://www.phperz.com/article/18/0222/361392.html