CentOS 6、7下mysql 5.7 详细安装教程

做开发总得用到数据吧，Linux作为服务器，总得有一个数据库来存储测试用的数据，所以呢，这里附上CentOS6、7安装MySQL5.7的教程。

用到的工具：CentOs6、7；Mysql依赖包

Step1. 查看已安装的mysql：

# yum list installed | grep mysqlmysql-libs.x86_64    5.1.71-1.el6  @anaconda-CentOS-201311272149.x86_64/6.5

# yum -y remove mysql-libs.x86_64

先到这里下载，根据自己Linux版本来选择，比如本人是Centos6.5，故选择第二个，依次类推:

将下载的mysql80-community-release-el6-1.noarch.rpm文件上传到Linux服务器中

Step3. 安装依赖：

使用以下命令，注意此命令需要在mysql80-community-release-el6-1.noarch.rpm文件的所在目录下执行。

执行过程中会出现Is this ok [y/N]: ，输入y就行了。

# yum localinstall mysql80-community-release-el6-1.noarch.rpm

# ls /etc/yum.repos.dmysql-community.repo    mysql-community-source.repo

如果运行的结果如下：

# yum repolist enabled | grep mysqlmysql-connectors-community      MySQL Connectors Community       59mysql-tools-community        MySQL Tools Community          65mysql80-community          MySQL 8.0 Community Server       29

vim /etc/yum.repos.d/mysql-community.repo

......# Enable to use MySQL 5.7[mysql57-community]name=MySQL 5.7 Community Serverbaseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/6/$basearch/enabled=1gpgcheck=1gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql ......[mysql80-community]name=MySQL 8.0 Community Serverbaseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/6/$basearch/enabled=0gpgcheck=1gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

# yum repolist enabled | grep mysqlmysql-connectors-community      MySQL Connectors Community       59mysql-tools-community        MySQL Tools Community          65mysql57-community          MySQL 5.7 Community Server       273

# yum install mysql-community-server

Step6. 安装完成后，启动mysql服务（可能第一次会出错，那就再运行一次~）：

# service mysqld startInitializing MySQL database: [FAILED]# service mysqld startStarting mysqld: [ OK ]

# cat /var/log/mysqld.log | grep root@localhost2018-08-29T03:11:26.560863Z 1 [Note] A temporary password is generated for root@localhost: DJ#erA*-p6&?

Step8. 使用mysql -uroot -p命令登录，需要输入上一步中的密码。

进入之后进行任何操作都会提示ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.这时需要重置密码：

mysql> show databases;ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.mysql> set password=password('new_password');Query OK, 0 rows affected, 1 warning (0.01 sec) mysql> alter user 'root'@'localhost' password expire never;Query OK, 0 rows affected (0.00 sec) mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)

更多相关文章

随机推荐