linux下如何使用yum源安裝mysql
更新時(shí)間：2022年12月16日 10:06:14 作者：科技論文精講
這篇文章主要介紹了linux下如何使用yum源安裝mysql問(wèn)題，具有很好的參考價(jià)值，希望對(duì)大家有所幫助。如有錯(cuò)誤或未考慮完全的地方，望不吝賜教
使用網(wǎng)絡(luò)yum源安裝mysql
（1）檢查
（2）查看
（3）安裝
（4）啟動(dòng)服務(wù)
（5）自啟動(dòng)
（6）創(chuàng)建管理員
（7）登錄
[root@雨ゆこ ~]# yum -y install mysql-devel
Loaded plugins: fastestmirror
Setting up Install Process
Loading mirror speeds from cached hostfile
Resolving Dependencies
--> Running transaction check
---> Package mysql-devel.x86_64 0:5.1.73-8.el6_8 will be installed
--> Processing Dependency: openssl-devel for package: mysql-devel-5.1.73-8.el6_8.x86_64
--> Running transaction check
---> Package openssl-devel.x86_64 0:1.0.1e-57.el6 will be installed
--> Processing Dependency: zlib-devel for package: openssl-devel-1.0.1e-57.el6.x86_64
--> Processing Dependency: krb5-devel for package: openssl-devel-1.0.1e-57.el6.x86_64
--> Running transaction check
---> Package krb5-devel.x86_64 0:1.10.3-65.el6 will be installed
--> Processing Dependency: libkadm5(x86-64) = 1.10.3-65.el6 for package: krb5-devel-1.10.3-65.el6.x86_64
--> Processing Dependency: libselinux-devel for package: krb5-devel-1.10.3-65.el6.x86_64
--> Processing Dependency: libcom_err-devel for package: krb5-devel-1.10.3-65.el6.x86_64
--> Processing Dependency: keyutils-libs-devel for package: krb5-devel-1.10.3-65.el6.x86_64
---> Package zlib-devel.x86_64 0:1.2.3-29.el6 will be installed
--> Running transaction check
---> Package keyutils-libs-devel.x86_64 0:1.4-5.el6 will be installed
---> Package libcom_err-devel.x86_64 0:1.41.12-23.el6 will be installed
---> Package libkadm5.x86_64 0:1.10.3-65.el6 will be installed
---> Package libselinux-devel.x86_64 0:2.0.94-7.el6 will be installed
--> Processing Dependency: libsepol-devel >= 2.0.32-1 for package: libselinux-devel-2.0.94-7.el6.x86_64
--> Processing Dependency: pkgconfig(libsepol) for package: libselinux-devel-2.0.94-7.el6.x86_64
--> Running transaction check
---> Package libsepol-devel.x86_64 0:2.0.41-4.el6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
==============================================================================================================
Package Arch Version Repository Size
==============================================================================================================
Installing:
mysql-devel x86_64 5.1.73-8.el6_8 base 130 k
Installing for dependencies:
keyutils-libs-devel x86_64 1.4-5.el6 base 29 k
krb5-devel x86_64 1.10.3-65.el6 base 504 k
libcom_err-devel x86_64 1.41.12-23.el6 base 33 k
libkadm5 x86_64 1.10.3-65.el6 base 143 k
libselinux-devel x86_64 2.0.94-7.el6 base 137 k
libsepol-devel x86_64 2.0.41-4.el6 base 64 k
openssl-devel x86_64 1.0.1e-57.el6 base 1.2 M
zlib-devel x86_64 1.2.3-29.el6 base 44 k
Transaction Summary
==============================================================================================================
Install 9 Package(s)
Total download size: 2.2 M
Installed size: 5.5 M
Downloading Packages:
(1/9): keyutils-libs-devel-1.4-5.el6.x86_64.rpm | 29 kB 00:00
(2/9): krb5-devel-1.10.3-65.el6.x86_64.rpm | 504 kB 00:00
(3/9): libcom_err-devel-1.41.12-23.el6.x86_64.rpm | 33 kB 00:00
(4/9): libkadm5-1.10.3-65.el6.x86_64.rpm | 143 kB 00:00
(5/9): libselinux-devel-2.0.94-7.el6.x86_64.rpm | 137 kB 00:00
(6/9): libsepol-devel-2.0.41-4.el6.x86_64.rpm | 64 kB 00:00
(7/9): mysql-devel-5.1.73-8.el6_8.x86_64.rpm | 130 kB 00:00
(8/9): openssl-devel-1.0.1e-57.el6.x86_64.rpm | 1.2 MB 00:00
(9/9): zlib-devel-1.2.3-29.el6.x86_64.rpm | 44 kB 00:00
--------------------------------------------------------------------------------------------------------------
Total 17 MB/s | 2.2 MB 00:00
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : zlib-devel-1.2.3-29.el6.x86_64 1/9
Installing : libcom_err-devel-1.41.12-23.el6.x86_64 2/9
Installing : libkadm5-1.10.3-65.el6.x86_64 3/9
Installing : libsepol-devel-2.0.41-4.el6.x86_64 4/9
Installing : libselinux-devel-2.0.94-7.el6.x86_64 5/9
Installing : keyutils-libs-devel-1.4-5.el6.x86_64 6/9
Installing : krb5-devel-1.10.3-65.el6.x86_64 7/9
Installing : openssl-devel-1.0.1e-57.el6.x86_64 8/9
Installing : mysql-devel-5.1.73-8.el6_8.x86_64 9/9
Verifying : keyutils-libs-devel-1.4-5.el6.x86_64 1/9
Verifying : libsepol-devel-2.0.41-4.el6.x86_64 2/9
Verifying : openssl-devel-1.0.1e-57.el6.x86_64 3/9
Verifying : krb5-devel-1.10.3-65.el6.x86_64 4/9
Verifying : libkadm5-1.10.3-65.el6.x86_64 5/9
Verifying : libcom_err-devel-1.41.12-23.el6.x86_64 6/9
Verifying : libselinux-devel-2.0.94-7.el6.x86_64 7/9
Verifying : mysql-devel-5.1.73-8.el6_8.x86_64 8/9
Verifying : zlib-devel-1.2.3-29.el6.x86_64 9/9
Installed:
mysql-devel.x86_64 0:5.1.73-8.el6_8
Dependency Installed:
keyutils-libs-devel.x86_64 0:1.4-5.el6 krb5-devel.x86_64 0:1.10.3-65.el6
libcom_err-devel.x86_64 0:1.41.12-23.el6 libkadm5.x86_64 0:1.10.3-65.el6
libselinux-devel.x86_64 0:2.0.94-7.el6 libsepol-devel.x86_64 0:2.0.41-4.el6
openssl-devel.x86_64 0:1.0.1e-57.el6 zlib-devel.x86_64 0:1.2.3-29.el6
Complete!
[root@雨ゆこ ~]# service mysqle start
mysqle: unrecognized service
[root@雨ゆこ ~]# service mysqld start
Initializing MySQL database: WARNING: The host '雨ゆこ' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MySQL privileges !
Installing MySQL system tables...
OK
Filling help tables...
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h 雨ゆこ password 'new-password'
Alternatively you can run:
/usr/bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the manual for more instructions.
You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &
You can test the MySQL daemon with mysql-test-run.pl
cd /usr/mysql-test ; perl mysql-test-run.pl
Please report any problems with the /usr/bin/mysqlbug script!
[ OK ]
Starting mysqld: [ OK ]
[root@雨ゆこ ~]# chkconfig --level 2345 mysqld on
[root@雨ゆこ ~]# chkconfig --list|grep mysql*
mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off
[root@雨ゆこ ~]# mysqladmin -u root password 289178199
[root@雨ゆこ ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.1.73 Source distribution
Copyright (c) 2000, 2013, 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 |
| test |
+--------------------+
3 rows in set (0.00 sec)
mysql> 總結(jié)
以上為個(gè)人經(jīng)驗(yàn)，希望能給大家一個(gè)參考，也希望大家多多支持腳本之家。
相關(guān)文章
最近在深入學(xué)習(xí)hibernate,在進(jìn)行批量操作時(shí),發(fā)現(xiàn)hibernate批量操作性能非常低.于是就想找一個(gè)性能較高的方法,在對(duì)jdbc、jdbcTemplate、hibernate進(jìn)行測(cè)試后,發(fā)現(xiàn)jdbc的執(zhí)行效率是最高的,jdbcTemplate也很相近,hibernate就不考慮了,慘不忍睹啊2012-08-08
本文主要搜集總結(jié)了一些和mysql主鍵相關(guān)的sql語(yǔ)句，包括增加主鍵或者更改表的列為主鍵之類(lèi)的sql語(yǔ)句，希望對(duì)大家能有所幫助2014-08-08
MySQL安裝出現(xiàn)starting the server報(bào)錯(cuò)的解決方案
如果電腦是第一次安裝MySQL,一般不會(huì)出現(xiàn)這樣的報(bào)錯(cuò),如下圖所示,本文主要介紹了MySQL安裝出現(xiàn)starting the server報(bào)錯(cuò)的解決方案,感興趣的可以了解一下2024-07-07
這篇文章主要介紹了MySQL 慢查詢(xún)的相關(guān)資料，文中講解非常細(xì)致，幫助大家更好的理解和學(xué)習(xí)MySQL，感興趣的朋友可以了解下2020-07-07
Centos 7 安裝mysql5.7.24二進(jìn)制 版本的方法及解決辦法
這篇文章主要介紹了Centos 7 安裝mysql5.7.24二進(jìn)制 版本的方法 及遇到問(wèn)題解決辦法,本文給大家介紹的非常詳細(xì)，具有一定的參考借鑒價(jià)值，需要的朋友可以參考下2018-11-11
MySQL的MaxIdleConns不合理，會(huì)變成短連接的原因
這篇文章主要介紹了MySQL的MaxIdleConns不合理，會(huì)變成短連接的原因，幫助大家更好的理解和使用MySQL數(shù)據(jù)庫(kù)，感興趣的朋友可以了解下2021-01-01
MySQL嵌套查詢(xún)實(shí)現(xiàn)子查詢(xún)的方法
本文主要介紹了MySQL嵌套查詢(xún)實(shí)現(xiàn)子查詢(xún)的方法，文中通過(guò)示例代碼介紹的非常詳細(xì)，具有一定的參考價(jià)值，感興趣的小伙伴們可以參考一下2022-02-02
mysql中如何用varchar字符串按照數(shù)字排序
這篇文章主要介紹了mysql中用varchar字符串按照數(shù)字排序方式,具有很好的參考價(jià)值,希望對(duì)大家有所幫助,如有錯(cuò)誤或未考慮完全的地方,望不吝賜教2023-08-08
Mysql中正則表達(dá)式Regexp常見(jiàn)用法
這篇文章主要介紹了Mysql中正則表達(dá)式Regexp常見(jiàn)用法，MySql REGEXP運(yùn)算符匹配字符串，mysql正則REGEXP學(xué)習(xí)練習(xí)筆記,需要的朋友可以參考下2020-02-02
如何安裝MySQL Community Server 5.6.39
這篇文章主要為大家詳細(xì)介紹了MySQL Community Server 5.6.39安裝配置方法圖文教程，具有一定的參考價(jià)值，感興趣的小伙伴們可以參考一下2018-09-09