OEL7.6源碼安裝MYSQL5.7的教程
首先官網(wǎng)下載安裝包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]#
然后創(chuàng)建mysql用戶和組以及數(shù)據(jù)目錄
[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]#
然后初始化數(shù)據(jù)并記錄臨時(shí)密碼
[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目錄并啟動(dòng)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,并登陸數(shù)據(jù)庫(kù)并重設(shè)密碼
[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!
總結(jié)
以上所述是小編給大家介紹的OEL7.6源碼安裝MYSQL5.7的教程,希望對(duì)大家有所幫助,如果大家有任何疑問請(qǐng)給我留言,小編會(huì)及時(shí)回復(fù)大家的。在此也非常感謝大家對(duì)腳本之家網(wǎng)站的支持!
如果你覺得本文對(duì)你有幫助,歡迎轉(zhuǎn)載,煩請(qǐng)注明出處,謝謝!
相關(guān)文章
- 本文我們主要介紹了MySQL性能分析以及explain的使用,包括:組合索引、慢查詢分析、MYISAM和INNODB的鎖定、MYSQL的事務(wù)配置項(xiàng)等,希望能夠?qū)δ兴鶐椭?/div> 2011-08-08
MySQL主從復(fù)制的原理及配置方法(比較詳細(xì))
MySQL 的數(shù)據(jù)庫(kù)的高可用性的架構(gòu)大概有以下幾種:集群,讀寫分離,主備。而后面兩種都是通過復(fù)制來實(shí)現(xiàn)的。下面將簡(jiǎn)單介紹復(fù)制的原理及配置,以及一些常見的問題2014-05-05安裝Mysql時(shí)可能會(huì)遇到的一些疑難雜癥
這篇文章主要給大家介紹了關(guān)于安裝Mysql時(shí)可能會(huì)遇到的一些疑難雜癥,文中通過示例代碼介紹的非常詳細(xì),對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值,需要的朋友們下面隨著小編來一起學(xué)習(xí)學(xué)習(xí)吧2021-01-01簡(jiǎn)單了解mysql語(yǔ)句書寫和執(zhí)行順序
這篇文章主要介紹了簡(jiǎn)單了解mysql語(yǔ)句書寫和執(zhí)行順序,文中通過示例代碼介紹的非常詳細(xì),對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值,需要的朋友可以參考下2020-03-03Redhat7.3安裝MySQL8.0.22的詳細(xì)教程(二進(jìn)制安裝)
這篇文章主要介紹了Redhat7.3安裝MySQL8.0.22(二進(jìn)制安裝),本文給大家介紹的非常詳細(xì),對(duì)大家的學(xué)習(xí)或工作具有一定的參考借鑒價(jià)值,需要的朋友可以參考下2021-01-01MySql批量插入時(shí)如何不重復(fù)插入數(shù)據(jù)
Mysql插入不重復(fù)的數(shù)據(jù),當(dāng)大數(shù)據(jù)量的數(shù)據(jù)需要插入值時(shí),要判斷插入是否重復(fù),然后再插入,那么如何提高效率,本文就詳細(xì)的介紹一下,感興趣的可以了解一下2021-06-06mysql ERROR 1045 (28000)問題的解決方法
這篇文章主要介紹了mysql ERROR 1045 (28000)問題的解決方法,文中步驟介紹的非常詳細(xì),具有一定的參考價(jià)值,感興趣的小伙伴們可以參考一下2019-10-10最新評(píng)論