linux下如何使用yum源安裝mysql
更新時間：2022年12月16日 10:06:14 作者：科技論文精講
這篇文章主要介紹了linux下如何使用yum源安裝mysql問題，具有很好的參考價值，希望對大家有所幫助。如有錯誤或未考慮完全的地方，望不吝賜教
使用網(wǎng)絡yum源安裝mysql
（1）檢查
（2）查看
（3）安裝
（4）啟動服務
（5）自啟動
（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> 總結
以上為個人經(jīng)驗，希望能給大家一個參考，也希望大家多多支持腳本之家。
相關文章
最近在深入學習hibernate,在進行批量操作時,發(fā)現(xiàn)hibernate批量操作性能非常低.于是就想找一個性能較高的方法,在對jdbc、jdbcTemplate、hibernate進行測試后,發(fā)現(xiàn)jdbc的執(zhí)行效率是最高的,jdbcTemplate也很相近,hibernate就不考慮了,慘不忍睹啊2012-08-08
本文主要搜集總結了一些和mysql主鍵相關的sql語句，包括增加主鍵或者更改表的列為主鍵之類的sql語句，希望對大家能有所幫助2014-08-08
MySQL安裝出現(xiàn)starting the server報錯的解決方案
如果電腦是第一次安裝MySQL,一般不會出現(xiàn)這樣的報錯,如下圖所示,本文主要介紹了MySQL安裝出現(xiàn)starting the server報錯的解決方案,感興趣的可以了解一下2024-07-07
這篇文章主要介紹了MySQL 慢查詢的相關資料，文中講解非常細致，幫助大家更好的理解和學習MySQL，感興趣的朋友可以了解下2020-07-07
Centos 7 安裝mysql5.7.24二進制 版本的方法及解決辦法
這篇文章主要介紹了Centos 7 安裝mysql5.7.24二進制 版本的方法 及遇到問題解決辦法,本文給大家介紹的非常詳細，具有一定的參考借鑒價值，需要的朋友可以參考下2018-11-11
MySQL的MaxIdleConns不合理，會變成短連接的原因
這篇文章主要介紹了MySQL的MaxIdleConns不合理，會變成短連接的原因，幫助大家更好的理解和使用MySQL數(shù)據(jù)庫，感興趣的朋友可以了解下2021-01-01
本文主要介紹了MySQL嵌套查詢實現(xiàn)子查詢的方法，文中通過示例代碼介紹的非常詳細，具有一定的參考價值，感興趣的小伙伴們可以參考一下2022-02-02
mysql中如何用varchar字符串按照數(shù)字排序
這篇文章主要介紹了mysql中用varchar字符串按照數(shù)字排序方式,具有很好的參考價值,希望對大家有所幫助,如有錯誤或未考慮完全的地方,望不吝賜教2023-08-08
這篇文章主要介紹了Mysql中正則表達式Regexp常見用法，MySql REGEXP運算符匹配字符串，mysql正則REGEXP學習練習筆記,需要的朋友可以參考下2020-02-02
如何安裝MySQL Community Server 5.6.39
這篇文章主要為大家詳細介紹了MySQL Community Server 5.6.39安裝配置方法圖文教程，具有一定的參考價值，感興趣的小伙伴們可以參考一下2018-09-09