linux下如何使用yum源安裝mysql
更新時間：2022年12月16日 10:06:14 作者：科技論文精講
這篇文章主要介紹了linux下如何使用yum源安裝mysql問題，具有很好的參考價值，希望對大家有所幫助。如有錯誤或未考慮完全的地方，望不吝賜教
使用網(wǎng)絡(luò)yum源安裝mysql
（1）檢查
（2）查看
（3）安裝
（4）啟動服務(wù)
（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> 總結(jié)
以上為個人經(jīng)驗，希望能給大家一個參考，也希望大家多多支持腳本之家。
相關(guān)文章
MySQL學(xué)習(xí)必備條件查詢數(shù)據(jù)
這篇文章主要介紹了MySQL學(xué)習(xí)必備條件查詢數(shù)據(jù)，首先通過利用where語句可以對數(shù)據(jù)進行篩選展開主題相關(guān)內(nèi)容，具有一定的參考價值，需要的小伙伴可以參考一下，希望對你有所幫助2022-03-03
正則表達式的作用是匹配文本,將一個正則表達式與一個文本串進行比較,下面這篇文章主要給大家介紹了關(guān)于SQL如何使用正則表達式對數(shù)據(jù)進行過濾的相關(guān)資料,文中通過實例代碼介紹的非常詳細,需要的朋友可以參考下2022-09-09
MySQL插入不了中文數(shù)據(jù)問題的原因及解決
最近發(fā)現(xiàn)新安裝的MySQL數(shù)據(jù)庫不能插入中文字段,所以下面這篇文章主要給大家介紹了關(guān)于MySQL插入不了中文數(shù)據(jù)問題的原因及解決方法,文中通過實例代碼介紹的非常詳細,需要的朋友可以參考下2023-05-05
mysql連接器之mysql-connector-java問題
這篇文章主要介紹了mysql連接器之mysql-connector-java問題,具有很好的參考價值,希望對大家有所幫助,如有錯誤或未考慮完全的地方,望不吝賜教2023-12-12
mysql 獲取當(dāng)前日期函數(shù)及時間格式化參數(shù)詳解
這篇文章主要介紹了mysql 獲取當(dāng)前日期函數(shù)now()及時間格式化DATE_FROMAT函數(shù)以及參數(shù)詳細介紹,需要的朋友可以參考下2014-08-08
MYSQL插入數(shù)據(jù)時檢查字段值是否重復(fù)的方法詳解
這篇文章主要給大家介紹了關(guān)于MYSQL插入數(shù)據(jù)時檢查字段值是否重復(fù)的相關(guān)資料,文中通過實例代碼介紹的非常詳細,對大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價值,需要的朋友可以參考下2022-01-01
Mysql在使用過程中經(jīng)常遇到錯誤,都是本人在實際應(yīng)用中處理檢驗過的,本文對常見錯誤出現(xiàn)的代碼進行詳細分析,下面這篇文章主要給大家介紹了關(guān)于MySQL查詢出現(xiàn)1055錯誤的原因及解決方法,需要的朋友可以參考下2023-05-05
MySQL數(shù)據(jù)庫的root密碼忘記，怎么辦？修改root密碼的三種方式你知道嗎？下面就為大家提供詳細的解決方案，需要的朋友可以參考下2016-04-04
這篇文章主要給大家介紹了關(guān)于MySQL聚合查詢與聯(lián)合查詢操作的相關(guān)資料,文中通過實例代碼介紹的非常詳細,對大家學(xué)習(xí)或者使用MySQL具有一定的參考學(xué)習(xí)價值,需要的朋友可以參考下2022-02-02
Mysql定時數(shù)據(jù)庫備份實現(xiàn)的保姆級教程
數(shù)據(jù)備份本身主要是為了預(yù)防一些意外,例如服務(wù)器或者個人電腦的硬件故障、人為的錯誤操作等情況,這篇文章主要給大家介紹了Mysql定時數(shù)據(jù)庫備份實現(xiàn)的保姆級教程,需要的朋友可以參考下2024-12-12