RPM安装MySQL5.7-zenge
1、下载MySQL RPM包下载地址：http://dev.mysql.com/downloads/mysql/5.7.html#downloads
下载的RPM包
# ls
mysql-community-client-5.7.11-1.el6.x86_64.rpm
mysql-community-common-5.7.11-1.el6.x86_64.rpm
mysql-community-libs-5.7.11-1.el6.x86_64.rpm
mysql-community-libs-compat-5.7.11-1.el6.x86_64.rpm
mysql-community-server-5.7.11-1.el6.x86_64.rpm
2、安装依赖
yum install numactl -y
yum install libaio -y
yum install perl -y
3、安装MySQL
rpm -ivh mysql-community-common-5.7.11-1.el6.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.11-1.el6.x86_64.rpm
rpm -ivh mysql-community-client-5.7.11-1.el6.x86_64.rpm
rpm -ivh mysql-community-libs-compat-5.7.11-1.el6.x86_64.rpm
rpm -ivh mysql-community-server-5.7.11-1.el6.x86_64.rpm
拷贝配置文件：
cp /usr/share/mysql/my-default.cnf /etc/my.cnf 4、初始化MySQL
mysqld --initialize-insecure --user=mysql 如果用上面这个命令来初始化mysql，则不会生成密码，我们可以用
mysql -u root --skip-password 直接登录MySQL
如果使用下面的命令来初始化mysql
mysqld --initialize --user=mysql 则会生成密码，查看密码可以用一下命令
#cat /var/log/mysqld.log | grep 'temporary password'
2016-09-02T02:13:42.106877Z 1 A temporary password is generated for root@localhost: w(5yOu*h&yhL
这种情况下登录MySQL使用：
# mysql -u root -p
Enter password:
输入log文件中查询到的密码即可
5、启动mysql
/etc/init.d/mysqld start 6、更改MySQL默认密码
更改密码的方式有3种，这里只介绍一种
SET PASSWORD FOR root@localhost=PASSWORD('Pass123qwe');
mysql>FLUSHPRIVILEGES;//刷新生效
例如：
mysql>SET PASSWORD FOR root@localhost=PASSWORD(‘123456’);
mysql>FLUSHPRIVILEGES;
注意：在更新密码过程中，经常会遇到提示密码不符合负责性要求，要么设置复杂的密码要么解决这个问题。
页:
[1]