国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 學院 > 開發設計 > 正文

centos7.2下安裝mysql5.7,使用rpm包安裝

2019-11-09 13:40:51
字體:
來源:轉載
供稿:網友
0、環境本文操作系統: CentOS 7.2.1511 x86_64MySQL 版本: 5.7.161、卸載系統自帶的 mariadb-lib[root@centos-linux ~]# rpm -qa|grep mariadb mariadb-libs-5.5.44-2.el7.centos.x86_64 [root@centos-linux ~]# rpm -e mariadb-libs-5.5.44-2.el7.centos.x86_64 --nodeps2、下載mysql5.7.16 rpm安裝包,官網最新的mysql安裝包是mysql-5.7.16-1.el7.x86_64.rpm-bundle.tar下載地址[root@centos-linux ~]# wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.16-1.el7.x86_64.rpm-bundle.tar然后解壓 [root@linux_node_1 src]# tar -xvf mysql-5.7.16-1.el7.x86_64.rpm-bundle.tar   mysql-community-libs-compat-5.7.16-1.el7.x86_64.rpm  mysql-community-devel-5.7.16-1.el7.x86_64.rpm  mysql-community-minimal-debuginfo-5.7.16-1.el7.x86_64.rpm  mysql-community-libs-5.7.16-1.el7.x86_64.rpm  mysql-community-common-5.7.16-1.el7.x86_64.rpm  mysql-community-embedded-compat-5.7.16-1.el7.x86_64.rpm  mysql-community-test-5.7.16-1.el7.x86_64.rpm  mysql-community-embedded-devel-5.7.16-1.el7.x86_64.rpm  mysql-community-server-minimal-5.7.16-1.el7.x86_64.rpm  mysql-community-server-5.7.16-1.el7.x86_64.rpm  mysql-community-client-5.7.16-1.el7.x86_64.rpm  mysql-community-embedded-5.7.16-1.el7.x86_64.rpm3、安裝依次執行(幾個包有依賴關系,所以執行有先后)下面命令安裝[root@centos-linux ~]# rpm -ivh mysql-community-common-5.7.16-1.el7.x86_64.rpm [root@centos-linux ~]# rpm -ivh mysql-community-libs-5.7.16-1.el7.x86_64.rpm[root@centos-linux ~]# rpm -ivh mysql-community-client-5.7.16-1.el7.x86_64.rpm [root@centos-linux ~]# rpm -ivh mysql-community-server-5.7.16-1.el7.x86_64.rpm在安裝rpm -ivh mysql-community-server-5.7.16-1.el7.x86_64.rpm的時候報錯如下:  [root@linux_node_1 src]# rpm -ivh mysql-community-server-5.7.16-1.el7.x86_64.rpm   warning: mysql-community-server-5.7.16-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY  error: Failed dependencies:  libaio.so.1()(64bit) is needed by mysql-community-server-5.7.16-1.el7.x86_64  libaio.so.1(LIBAIO_0.1)(64bit) is needed by mysql-community-server-5.7.16-1.el7.x86_64  libaio.so.1(LIBAIO_0.4)(64bit) is needed by mysql-community-server-5.7.16-1.el7.x86_64  net-tools is needed by mysql-community-server-5.7.16-1.el7.x86_64  這個報錯的意思是需要安裝libaio包和net-tools包:可以yum安裝一下,
少perl和libaio軟件包yum install perlyum install libaio然后yum安裝net-tools   yum install net-tools  完成之后就可以順利安裝4、數據庫初始化為了保證數據庫目錄為與文件的所有者為 mysql 登陸用戶,如果你是以 root 身份運行 mysql 服務,需要執行下面的命令初始化mysqld --initialize --user=mysql  如果是以 mysql 身份運行,則可以去掉 --user 選項。  另外 --initialize 選項默認以“安全”模式來初始化,則會為 root 用戶生成一個密碼并將該密碼標記為過期,登陸后你需要設置一個新的密碼,而使用 --initialize-insecure 命令則不使用安全模式,則不會為 root 用戶生成一個密碼。  這里演示使用的 --initialize 初始化的,會生成一個 root 賬戶密碼,密碼在log文件里,紅色區域的就是自動生成的密碼  [root@linux_node_1 src]# cat /var/log/mysqld.log   2016-12-07T04:41:58.028558Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is dePRecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).  2016-12-07T04:41:58.315188Z 0 [Warning] InnoDB: New log files created, LSN=45790  2016-12-07T04:41:58.355114Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.  2016-12-07T04:41:58.418448Z 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: 7cc98831-bc37-11e6-a263-000c29f902dc.  2016-12-07T04:41:58.419935Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.  2016-12-07T04:41:58.420558Z 1 [Note] A temporary passWord is generated for root@localhost: )1r3gi,hjgQa  現在啟動mysql數據庫systemctl start mysqld.service  [root@linux_node_1 src]# systemctl start mysqld.service  [root@linux_node_1 src]# mysql -uroot -p  Enter password:   Welcome to the MySQL monitor.  Commands end with ; or /g.  Your MySQL connection id is 2  Server version: 5.7.16  Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.  Oracle is a registered trademark of Oracle Corporation and/or its  affiliates. Other names may be trademarks of their respective  owners.  Type 'help;' or '/h' for help. Type '/c' to clear the current input statement.  mysql>   5、修改密碼   該密碼被標記為過期了,如果想正常使用還需要修改密碼 mysql> show databases;ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.   以前的 password()函數將會被拋棄,官方建議使用下面的命令來修改密碼 mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';   同時,如果你設置的密碼過于簡單也會報錯。 mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123';ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
主站蜘蛛池模板: 习水县| 西青区| 合肥市| 宜宾县| 望江县| 勃利县| 嘉兴市| 革吉县| 郑州市| 巴青县| 连平县| 西乡县| 视频| 平陆县| 溧水县| 巩义市| 宜春市| 周宁县| 海盐县| 西畴县| 白城市| 平原县| 阜平县| 昭苏县| 华容县| 慈溪市| 烟台市| 高碑店市| 荥阳市| 蓬安县| 宜川县| 鞍山市| 渑池县| 麻江县| 正安县| 宿迁市| 黄平县| 塔河县| 丹凤县| 甘泉县| 南康市|