婷婷综合国产,91蜜桃婷婷狠狠久久综合9色 ,九九九九九精品,国产综合av

主頁 > 知識庫 > OEL7.6源碼安裝MYSQL5.7的教程

OEL7.6源碼安裝MYSQL5.7的教程

熱門標簽:怎么在地圖標注位置生成圖片 銅陵防封電銷卡 福建外呼系統定制化 電銷卡外呼系統供應商 美國反騷擾電話機器人 真人語音電話機器人 騰訊地圖標注提升 悟空科技電話機器人 400電話可以免費申請嗎

首先官網下載安裝包https://dev.mysql.com/downloads/mysql/5.7.html#downloads

然后上傳解壓至/usr/local目錄

[root@localhost db]# tar -xf mysql-5.7.26-linux-glibc2.12-x86_64.tar 
[root@localhost db]# tar -xzf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz 
[root@localhost db]# mv mysql-5.7.26-linux-glibc2.12-x86_64 /usr/local/mysql
[root@localhost db]# 

然后創建mysql用戶和組以及數據目錄

[root@localhost db]# mv mysql-5.7.26-linux-glibc2.12-x86_64 /usr/local/mysql
[root@localhost db]# groupadd mysql
[root@localhost db]# useradd mysql -g mysql
[root@localhost db]# cd /usr/local/mysql
[root@localhost mysql]# mkdir data
[root@localhost mysql]# chown mysql: -R /usr/local/mysql/
[root@localhost mysql]# 

然后初始化數據并記錄臨時密碼

[root@localhost mysql]# bin/mysqld --initialize --user=mysql --datadir /usr/local/mysql/data
2019-07-26T01:34:24.479757Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-07-26T01:34:24.682695Z 0 [Warning] InnoDB: New log files created, LSN=45790
2019-07-26T01:34:24.717419Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2019-07-26T01:34:24.723157Z 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: 8009a802-af45-11e9-839c-000c29984aae.
2019-07-26T01:34:24.723996Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2019-07-26T01:34:24.724629Z 1 [Note] A temporary password is generated for root@localhost: ucZ5w5ZkSq;1
[root@localhost mysql]#

然后修改/etc/my.cnf配置文件中datadir為/usr/local/mysql/data 

[root@localhost mysql]# cat /etc/my.cnf
[mysqld]
datadir=/usr/local/mysql/data
[root@localhost mysql]# 

然后將mysql加入init.d目錄并啟動mysql

[root@localhost mysql]# cp support-files/mysql.server /etc/init.d/mysqld
[root@localhost mysql]# /etc/init.d/mysqld start
Starting MySQL.Logging to '/usr/local/mysql/data/localhost.localdomain.err'.
 SUCCESS! 
[root@localhost mysql]# ps -ef|grep mysql
root   12957   1 0 09:37 pts/0  00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/localhost.localdomain.pid
mysql  13057 12957 4 09:37 pts/0  00:00:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=localhost.localdomain.err --pid-file=/usr/local/mysql/data/localhost.localdomain.pid
root   13092 10198 0 09:37 pts/0  00:00:00 grep --color=auto mysql
[root@localhost mysql]# 

最后mysql/bin加入path,并登陸數據庫并重設密碼

[root@localhost bin]# ./mysql -u root -p
Enter password: 
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.26
Copyright (c) 2000, 2019, 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> set password=password('mysql');
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> exit
Bye
[root@localhost bin]# ./mysql -u root -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[root@localhost bin]# ./mysql -u root -p
Enter password: 
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.26 MySQL Community Server (GPL)
Copyright (c) 2000, 2019, 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> show databases;
+--------------------+
| Database      |
+--------------------+
| information_schema |
| mysql       |
| performance_schema |
| sys        |
+--------------------+
4 rows in set (0.01 sec)
mysql> 

ojbk,then have fun!

總結

以上所述是小編給大家介紹的OEL7.6源碼安裝MYSQL5.7的教程,希望對大家有所幫助,如果大家有任何疑問請給我留言,小編會及時回復大家的。在此也非常感謝大家對腳本之家網站的支持!
如果你覺得本文對你有幫助,歡迎轉載,煩請注明出處,謝謝!

標簽:武威 湖南 湖北 臨汾 聊城 白銀 烏海 云浮

巨人網絡通訊聲明:本文標題《OEL7.6源碼安裝MYSQL5.7的教程》,本文關鍵詞  OEL7.6,源碼,安裝,MYSQL5.7,;如發現本文內容存在版權問題,煩請提供相關信息告之我們,我們將及時溝通與處理。本站內容系統采集于網絡,涉及言論、版權與本站無關。
  • 相關文章
  • 下面列出與本文章《OEL7.6源碼安裝MYSQL5.7的教程》相關的同類信息!
  • 本頁收集關于OEL7.6源碼安裝MYSQL5.7的教程的相關信息資訊供網民參考!
  • 推薦文章
    主站蜘蛛池模板: 海晏县| 沙坪坝区| 松滋市| 平谷区| 镇原县| 施秉县| 清水县| 大厂| 定远县| 河南省| 黄龙县| 睢宁县| 岐山县| 万盛区| 房产| 桃园市| 棋牌| 绥江县| 哈尔滨市| 东乌珠穆沁旗| 马公市| 揭西县| 吉林市| 南阳市| 勃利县| 桂东县| 宕昌县| 九台市| 宁波市| 台东县| 江源县| 岳阳县| 桂阳县| 澄城县| 宁陕县| 隆德县| 紫阳县| 玛曲县| 潮州市| 邮箱| 瑞丽市|