手机
当前位置:查字典教程网 >编程开发 >mysql数据库 >CentOS7使用rpm包安装mysql 5.7.18
CentOS7使用rpm包安装mysql 5.7.18
摘要:1、#yuminstalllibaio//MySQL依赖包2、#rpm-ivhmysql-community-libs-5.7.17-1.e...

1、# yum install libaio //MySQL依赖包

2、# rpm -ivh mysql-community-libs-5.7.17-1.el6.x86_64.rpm mysql-community-client-5.7.17-1.el6.x86_64.rpm mysql-community-common-5.7.17-1.el6.x86_64.rpm mysql-community-server-5.7.17-1.el6.x86_64.rpm //安装mysql

3、#/etc/init.d/mysqld start //开启mysql

Starting mysqld (via systemctl): [ OK ]//开启成功

4、#cat /var/log/mysqld.log //查看mysql的初始密码

2017-04-12T08:08:09.129189Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2017-04-12T08:08:10.300168Z 0 [Warning] InnoDB: New log files created, LSN=45790

2017-04-12T08:08:10.376838Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.

2017-04-12T08:08:10.394301Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 2b1bbadd-1f57-11e7-a13b-f23c91bcd804.

2017-04-12T08:08:10.395575Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.

2017-04-12T08:08:10.397081Z 1 [Note] A temporary password is generated for root@localhost:VIsoqx.z:4!L(密码)

2017-04-12T08:08:12.994015Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

5、#mysql -u root -p VIsoqx.z:4!L //登录mysql

6、ALTER USER 'root'@'localhost' IDENTIFIED BY 'your_new_password';

至此,mysql安装配置成功 CentOS7使用rpm包安装mysql 5.7.18

以下命令是开启mysql的远程访问:

UPDATE user SET HOST = '%' WHERE USER ='root';

FLUSH PRIVILEGES;

【CentOS7使用rpm包安装mysql 5.7.18】相关文章:

如何配置MySQL主从复制

mysql中You can’t specify target table for update in FROM clau

mytop 使用介绍 mysql实时监控工具

mysql show processlist 显示mysql查询进程

日期相加的查询SQL语句

mysql中用于数据迁移存储过程分享

MySQL易学易用之MYSQL不为人知的特性

Debian 6.02 (squeeze)下编译安装 MySQL 5.5的方法

CentOS 5.5下安装MySQL 5.5全过程分享

mysql免安装制作使用说明

精品推荐
分类导航