如果您想了解Linux使用YUM安装mysql的知识，那么本篇文章将是您的不二之选。同时我们将深入剖析CentOS6.9安装MySQL5.6（使用yum安装）、CentOS7.0下使用yum安装MyS
如果您想了解Linux 使用YUM安装mysql的知识，那么本篇文章将是您的不二之选。同时我们将深入剖析CentOS 6.9安装MySQL 5.6 （使用yum安装）、CentOS 7.0下使用yum安装MySQL、CentOS 7使用yum安装MYSQL、CentOS Linux下用yum 安装MySQL的各个方面，并给出实际的案例分析，希望能帮助到您！
本文目录一览：- Linux 使用YUM安装mysql
- CentOS 6.9安装MySQL 5.6 （使用yum安装）
- CentOS 7.0下使用yum安装MySQL
- CentOS 7使用yum安装MYSQL
- CentOS Linux下用yum 安装MySQL
Linux 使用YUM安装mysql
<prejquery1318763320447="9"><span>
<prejquery1318763320447="9"><div>
yum install MysqLyum install MysqL-serveryum install MysqL-develchgrp -R MysqL /var/lib/MysqLchmod -R 770 /var/lib/MysqL
service MysqLd start MysqLSET PASSWORD FOR 'root'@'localhost' = PASSWORD('secret_password');
CentOS 6.9安装MySQL 5.6 （使用yum安装）
本文记录一次在CentOS上安装MysqL的步骤，采用yum安裝的方式~
移除CentOS默认的MysqL-libs
[root@test01 srv]# whereis MysqL MysqL: /usr/lib64/MysqL /usr/share/MysqL [root@test01 srv]#
为了避免冲突，先移除CenttOS上默认的MysqL-libs，使用yum remove MysqL-libs完成，如：
[root@test01 srv]# yum remove MysqL-libs Loaded plugins: fastestmirror Setting up Remove Process Resolving Dependencies --> Running transaction check ---> Package MysqL-libs.x86_64 0:5.1.73-8.el6_8 will be erased --> Processing Dependency: libMysqLclient.so.16()(64bit) for package: 2:postfix-2.6.6-8.el6.x86_64 --> Processing Dependency: libMysqLclient.so.16(libMysqLclient_16)(64bit) for package: 2:postfix-2.6.6-8.el6.x86_64 --> Processing Dependency: MysqL-libs for package: 2:postfix-2.6.6-8.el6.x86_64 --> Running transaction check ---> Package postfix.x86_64 2:2.6.6-8.el6 will be erased --> Processing Dependency: /usr/sbin/sendmail for package: cronie-1.4.4-16.el6_8.2.x86_64 --> Running transaction check ---> Package cronie.x86_64 0:1.4.4-16.el6_8.2 will be erased --> Processing Dependency: cronie = 1.4.4-16.el6_8.2 for package: cronie-anacron-1.4.4-16.el6_8.2.x86_64 --> Running transaction check ---> Package cronie-anacron.x86_64 0:1.4.4-16.el6_8.2 will be erased --> Processing Dependency: /etc/cron.d for package: sysstat-9.0.4-33.el6.x86_64 --> Processing Dependency: /etc/cron.d for package: crontabs-1.10-33.el6.noarch --> Restarting Dependency Resolution with new changes. --> Running transaction check ---> Package crontabs.noarch 0:1.10-33.el6 will be erased ---> Package sysstat.x86_64 0:9.0.4-33.el6 will be erased --> Finished Dependency Resolution Dependencies Resolved ============================================================================================================================================================================================================================================================================== Package Arch Version Repository Size ============================================================================================================================================================================================================================================================================== Removing: MysqL-libs x86_64 5.1.73-8.el6_8 @anaconda-CentOS-201703281317.x86_64/6.9 4.0 M Removing for dependencies: cronie x86_64 1.4.4-16.el6_8.2 @anaconda-CentOS-201703281317.x86_64/6.9 174 k cronie-anacron x86_64 1.4.4-16.el6_8.2 @anaconda-CentOS-201703281317.x86_64/6.9 43 k crontabs noarch 1.10-33.el6 @anaconda-CentOS-201703281317.x86_64/6.9 2.4 k postfix x86_64 2:2.6.6-8.el6 @anaconda-CentOS-201703281317.x86_64/6.9 9.7 M sysstat x86_64 9.0.4-33.el6 @ISO 826 k Transaction Summary ============================================================================================================================================================================================================================================================================== Remove 6 Package(s) Installed size: 15 M Is this ok [y/N]:
输入y
Is this ok [y/N]: y Downloading Packages: Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction Erasing : sysstat-9.0.4-33.el6.x86_64 1/6 Erasing : cronie-1.4.4-16.el6_8.2.x86_64 2/6 Erasing : cronie-anacron-1.4.4-16.el6_8.2.x86_64 3/6 Erasing : crontabs-1.10-33.el6.noarch 4/6 Erasing : 2:postfix-2.6.6-8.el6.x86_64 5/6 Erasing : MysqL-libs-5.1.73-8.el6_8.x86_64 6/6 Verifying : cronie-anacron-1.4.4-16.el6_8.2.x86_64 1/6 Verifying : cronie-1.4.4-16.el6_8.2.x86_64 2/6 Verifying : 2:postfix-2.6.6-8.el6.x86_64 3/6 Verifying : crontabs-1.10-33.el6.noarch 4/6 Verifying : sysstat-9.0.4-33.el6.x86_64 5/6 Verifying : MysqL-libs-5.1.73-8.el6_8.x86_64 6/6 Removed: MysqL-libs.x86_64 0:5.1.73-8.el6_8 Dependency Removed: cronie.x86_64 0:1.4.4-16.el6_8.2 cronie-anacron.x86_64 0:1.4.4-16.el6_8.2 crontabs.noarch 0:1.10-33.el6 postfix.x86_64 2:2.6.6-8.el6 sysstat.x86_64 0:9.0.4-33.el6 Complete! [root@test01 srv]#
清空dbcache
然后，使用yum clean dbcache清空db缓存，如
[root@test01 srv]# yum clean dbcache Loaded plugins: fastestmirror Cleaning repos: ISO 3 sqlite files removed
下载MysqL rpm安装包
下载MysqL rpm安装包
wget http://repo.MysqL.com/MysqL-community-release-el6-5.noarch.rpm
如
[root@test01 srv]# wget http://repo.MysqL.com/MysqL-community-release-el6-5.noarch.rpm --2017-05-08 10:40:29-- http://repo.MysqL.com/MysqL-community-release-el6-5.noarch.rpm Resolving repo.MysqL.com... 223.119.236.209 Connecting to repo.MysqL.com|223.119.236.209|:80... connected. HTTP request sent,awaiting response... 200 OK Length: 5824 (5.7K) [application/x-redhat-package-manager] Saving to: “MysqL-community-release-el6-5.noarch.rpm” 100%[====================================================================================================================================================================================================================================>] 5,824 --.-K/s in 0s 2017-05-08 10:40:29 (298 MB/s) - “MysqL-community-release-el6-5.noarch.rpm” saved [5824/5824] [root@test01 srv]#
安装下载好的rpm文件
使用rpm -ivh MysqL-community-release-el6-5.noarch.rpm安装下载的rpm文件~
[root@test01 srv]# rpm -ivh MysqL-community-release-el6-5.noarch.rpm Preparing... ########################################### [100%] 1:MysqL-community-release########################################### [100%] [root@test01 srv]#
yum安装MysqL-community-server
使用yum install MysqL-community-server安装MysqL server。
[root@test01 srv]# yum install MysqL-community-server Loaded plugins: fastestmirror Setting up Install Process Loading mirror speeds from cached hostfile mysql-connectors-community | 2.5 kB 00:00 mysql-connectors-community/primary_db | 15 kB 00:00 MysqL-tools-community | 2.5 kB 00:00 MysqL-tools-community/primary_db | 35 kB 00:00 MysqL56-community | 2.5 kB 00:00 MysqL56-community/primary_db | 183 kB 00:00 Resolving Dependencies --> Running transaction check ---> Package MysqL-community-server.x86_64 0:5.6.36-2.el6 will be installed --> Processing Dependency: MysqL-community-common(x86-64) = 5.6.36-2.el6 for package: MysqL-community-server-5.6.36-2.el6.x86_64 --> Processing Dependency: MysqL-community-client(x86-64) >= 5.6.10 for package: MysqL-community-server-5.6.36-2.el6.x86_64 --> Processing Dependency: perl(warnings) for package: MysqL-community-server-5.6.36-2.el6.x86_64 --> Processing Dependency: perl(strict) for package: MysqL-community-server-5.6.36-2.el6.x86_64 --> Processing Dependency: perl(if) for package: MysqL-community-server-5.6.36-2.el6.x86_64 --> Processing Dependency: perl(Sys::Hostname) for package: MysqL-community-server-5.6.36-2.el6.x86_64 --> Processing Dependency: perl(POSIX) for package: MysqL-community-server-5.6.36-2.el6.x86_64 --> Processing Dependency: perl(Getopt::Long) for package: MysqL-community-server-5.6.36-2.el6.x86_64 --> Processing Dependency: perl(File::Temp) for package: MysqL-community-server-5.6.36-2.el6.x86_64 --> Processing Dependency: perl(File::Spec) for package: MysqL-community-server-5.6.36-2.el6.x86_64 --> Processing Dependency: perl(File::Path) for package: MysqL-community-server-5.6.36-2.el6.x86_64 --> Processing Dependency: perl(File::copy) for package: MysqL-community-server-5.6.36-2.el6.x86_64 --> Processing Dependency: perl(File::Basename) for package: MysqL-community-server-5.6.36-2.el6.x86_64 --> Processing Dependency: perl(Fcntl) for package: MysqL-community-server-5.6.36-2.el6.x86_64 --> Processing Dependency: perl(Data::Dumper) for package: MysqL-community-server-5.6.36-2.el6.x86_64 --> Processing Dependency: perl(DBI) for package: MysqL-community-server-5.6.36-2.el6.x86_64 --> Processing Dependency: libnuma.so.1(libnuma_1.2)(64bit) for package: MysqL-community-server-5.6.36-2.el6.x86_64 --> Processing Dependency: libnuma.so.1(libnuma_1.1)(64bit) for package: MysqL-community-server-5.6.36-2.el6.x86_64 --> Processing Dependency: /usr/bin/perl for package: MysqL-community-server-5.6.36-2.el6.x86_64 --> Processing Dependency: libnuma.so.1()(64bit) for package: MysqL-community-server-5.6.36-2.el6.x86_64 --> Running transaction check ---> Package MysqL-community-client.x86_64 0:5.6.36-2.el6 will be installed --> Processing Dependency: MysqL-community-libs(x86-64) >= 5.6.10 for package: MysqL-community-client-5.6.36-2.el6.x86_64 ---> Package MysqL-community-common.x86_64 0:5.6.36-2.el6 will be installed ---> Package numactl.x86_64 0:2.0.9-2.el6 will be installed ---> Package perl.x86_64 4:5.10.1-144.el6 will be installed --> Processing Dependency: perl-libs = 4:5.10.1-144.el6 for package: 4:perl-5.10.1-144.el6.x86_64 --> Processing Dependency: perl-libs for package: 4:perl-5.10.1-144.el6.x86_64 --> Processing Dependency: perl(version) for package: 4:perl-5.10.1-144.el6.x86_64 --> Processing Dependency: perl(Pod::Simple) for package: 4:perl-5.10.1-144.el6.x86_64 --> Processing Dependency: perl(Module::Pluggable) for package: 4:perl-5.10.1-144.el6.x86_64 --> Processing Dependency: libperl.so()(64bit) for package: 4:perl-5.10.1-144.el6.x86_64 ---> Package perl-DBI.x86_64 0:1.609-4.el6 will be installed --> Running transaction check ---> Package MysqL-community-libs.x86_64 0:5.6.36-2.el6 will be installed ---> Package perl-Module-Pluggable.x86_64 1:3.90-144.el6 will be installed ---> Package perl-Pod-Simple.x86_64 1:3.13-144.el6 will be installed --> Processing Dependency: perl(Pod::Escapes) >= 1.04 for package: 1:perl-Pod-Simple-3.13-144.el6.x86_64 ---> Package perl-libs.x86_64 4:5.10.1-144.el6 will be installed ---> Package perl-version.x86_64 3:0.77-144.el6 will be installed --> Running transaction check ---> Package perl-Pod-Escapes.x86_64 1:1.04-144.el6 will be installed --> Finished Dependency Resolution Dependencies Resolved ============================================================================================================================================================================================================================================================================== Package Arch Version Repository Size ============================================================================================================================================================================================================================================================================== Installing: MysqL-community-server x86_64 5.6.36-2.el6 MysqL56-community 55 M Installing for dependencies: MysqL-community-client x86_64 5.6.36-2.el6 MysqL56-community 18 M MysqL-community-common x86_64 5.6.36-2.el6 MysqL56-community 308 k MysqL-community-libs x86_64 5.6.36-2.el6 MysqL56-community 1.9 M numactl x86_64 2.0.9-2.el6 ISO 74 k perl x86_64 4:5.10.1-144.el6 ISO 10 M perl-DBI x86_64 1.609-4.el6 ISO 705 k perl-Module-Pluggable x86_64 1:3.90-144.el6 ISO 41 k perl-Pod-Escapes x86_64 1:1.04-144.el6 ISO 33 k perl-Pod-Simple x86_64 1:3.13-144.el6 ISO 213 k perl-libs x86_64 4:5.10.1-144.el6 ISO 579 k perl-version x86_64 3:0.77-144.el6 ISO 52 k Transaction Summary ============================================================================================================================================================================================================================================================================== Install 12 Package(s) Total download size: 87 M Installed size: 373 M Is this ok [y/N]:
选择y
Is this ok [y/N]: y Downloading Packages: (1/12): MysqL-community-client-5.6.36-2.el6.x86_64.rpm | 18 MB 00:01 (2/12): MysqL-community-common-5.6.36-2.el6.x86_64.rpm | 308 kB 00:00 (3/12): MysqL-community-libs-5.6.36-2.el6.x86_64.rpm | 1.9 MB 00:00 (4/12): MysqL-community-server-5.6.36-2.el6.x86_64.rpm | 55 MB 00:03 (5/12): numactl-2.0.9-2.el6.x86_64.rpm | 74 kB 00:00 (6/12): perl-5.10.1-144.el6.x86_64.rpm | 10 MB 00:00 (7/12): perl-DBI-1.609-4.el6.x86_64.rpm | 705 kB 00:00 (8/12): perl-Module-Pluggable-3.90-144.el6.x86_64.rpm | 41 kB 00:00 (9/12): perl-Pod-Escapes-1.04-144.el6.x86_64.rpm | 33 kB 00:00 (10/12): perl-Pod-Simple-3.13-144.el6.x86_64.rpm | 213 kB 00:00 (11/12): perl-libs-5.10.1-144.el6.x86_64.rpm | 579 kB 00:00 (12/12): perl-version-0.77-144.el6.x86_64.rpm | 52 kB 00:00 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Total 14 MB/s | 87 MB 00:06 warning: rpmts_HdrFromFdno: Header V3 DSA/SHA1 Signature,key ID 5072e1f5: NOKEY Retrieving key from file:/etc/pki/rpm-gpg/RPM-GPG-KEY-MysqL Importing GPG key 0x5072E1F5: Userid : MysqL Release Engineering <MysqL-build@oss.oracle.com> Package: MysqL-community-release-el6-5.noarch (installed) From : file:/etc/pki/rpm-gpg/RPM-GPG-KEY-MysqL Is this ok [y/N]:
选择y
Is this ok [y/N]: y Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction Warning: RPMDB altered outside of yum. Installing : MysqL-community-common-5.6.36-2.el6.x86_64 1/12 Installing : MysqL-community-libs-5.6.36-2.el6.x86_64 2/12 Installing : 1:perl-Pod-Escapes-1.04-144.el6.x86_64 3/12 Installing : 4:perl-libs-5.10.1-144.el6.x86_64 4/12 Installing : 1:perl-Module-Pluggable-3.90-144.el6.x86_64 5/12 Installing : 1:perl-Pod-Simple-3.13-144.el6.x86_64 6/12 Installing : 3:perl-version-0.77-144.el6.x86_64 7/12 Installing : 4:perl-5.10.1-144.el6.x86_64 8/12 Installing : perl-DBI-1.609-4.el6.x86_64 9/12 Installing : MysqL-community-client-5.6.36-2.el6.x86_64 10/12 Installing : numactl-2.0.9-2.el6.x86_64 11/12 Installing : MysqL-community-server-5.6.36-2.el6.x86_64 12/12 Verifying : 3:perl-version-0.77-144.el6.x86_64 1/12 Verifying : 4:perl-libs-5.10.1-144.el6.x86_64 2/12 Verifying : 4:perl-5.10.1-144.el6.x86_64 3/12 Verifying : numactl-2.0.9-2.el6.x86_64 4/12 Verifying : MysqL-community-common-5.6.36-2.el6.x86_64 5/12 Verifying : perl-DBI-1.609-4.el6.x86_64 6/12 Verifying : MysqL-community-server-5.6.36-2.el6.x86_64 7/12 Verifying : MysqL-community-libs-5.6.36-2.el6.x86_64 8/12 Verifying : MysqL-community-client-5.6.36-2.el6.x86_64 9/12 Verifying : 1:perl-Module-Pluggable-3.90-144.el6.x86_64 10/12 Verifying : 1:perl-Pod-Simple-3.13-144.el6.x86_64 11/12 Verifying : 1:perl-Pod-Escapes-1.04-144.el6.x86_64 12/12 Installed: MysqL-community-server.x86_64 0:5.6.36-2.el6 Dependency Installed: MysqL-community-client.x86_64 0:5.6.36-2.el6 MysqL-community-common.x86_64 0:5.6.36-2.el6 MysqL-community-libs.x86_64 0:5.6.36-2.el6 numactl.x86_64 0:2.0.9-2.el6 perl.x86_64 4:5.10.1-144.el6 perl-DBI.x86_64 0:1.609-4.el6 perl-Module-Pluggable.x86_64 1:3.90-144.el6 perl-Pod-Escapes.x86_64 1:1.04-144.el6 perl-Pod-Simple.x86_64 1:3.13-144.el6 perl-libs.x86_64 4:5.10.1-144.el6 perl-version.x86_64 3:0.77-144.el6 Complete! [root@test01 srv]#
启动服务
service MysqLd start
[root@test01 srv]# service MysqLd start
Initializing MysqL database: 2017-05-08 11:06:09 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-05-08 11:06:09 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
2017-05-08 11:06:09 0 [Note] /usr/sbin/MysqLd (MysqLd 5.6.36) starting as process 926 ...
2017-05-08 11:06:09 926 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-05-08 11:06:09 926 [Note] InnoDB: The InnoDB memory heap is disabled
2017-05-08 11:06:09 926 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-05-08 11:06:09 926 [Note] InnoDB: Memory barrier is not used
2017-05-08 11:06:09 926 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-05-08 11:06:09 926 [Note] InnoDB: Using Linux native AIO
2017-05-08 11:06:09 926 [Note] InnoDB: Not using cpu crc32 instructions
2017-05-08 11:06:09 926 [Note] InnoDB: Initializing buffer pool,size = 128.0M
2017-05-08 11:06:09 926 [Note] InnoDB: Completed initialization of buffer pool
2017-05-08 11:06:09 926 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2017-05-08 11:06:09 926 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2017-05-08 11:06:09 926 [Note] InnoDB: Database physically writes the file full: wait...
2017-05-08 11:06:09 926 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2017-05-08 11:06:09 926 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2017-05-08 11:06:09 926 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2017-05-08 11:06:09 926 [Warning] InnoDB: New log files created,LSN=45781
2017-05-08 11:06:09 926 [Note] InnoDB: Doublewrite buffer not found: creating new
2017-05-08 11:06:09 926 [Note] InnoDB: Doublewrite buffer created
2017-05-08 11:06:09 926 [Note] InnoDB: 128 rollback segment(s) are active.
2017-05-08 11:06:09 926 [Warning] InnoDB: Creating foreign key constraint system tables.
2017-05-08 11:06:09 926 [Note] InnoDB: Foreign key constraint system tables created
2017-05-08 11:06:09 926 [Note] InnoDB: Creating tablespace and datafile system tables.
2017-05-08 11:06:09 926 [Note] InnoDB: Tablespace and datafile system tables created.
2017-05-08 11:06:09 926 [Note] InnoDB: Waiting for purge to start
2017-05-08 11:06:09 926 [Note] InnoDB: 5.6.36 started; log sequence number 0
2017-05-08 11:06:09 926 [Note] binlog end
2017-05-08 11:06:09 926 [Note] InnoDB: FTS optimize thread exiting.
2017-05-08 11:06:09 926 [Note] InnoDB: Starting shutdown...
2017-05-08 11:06:11 926 [Note] InnoDB: Shutdown completed; log sequence number 1625977
2017-05-08 11:06:11 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-05-08 11:06:11 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
2017-05-08 11:06:11 0 [Note] /usr/sbin/MysqLd (MysqLd 5.6.36) starting as process 948 ...
2017-05-08 11:06:11 948 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-05-08 11:06:11 948 [Note] InnoDB: The InnoDB memory heap is disabled
2017-05-08 11:06:11 948 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-05-08 11:06:11 948 [Note] InnoDB: Memory barrier is not used
2017-05-08 11:06:11 948 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-05-08 11:06:11 948 [Note] InnoDB: Using Linux native AIO
2017-05-08 11:06:11 948 [Note] InnoDB: Not using cpu crc32 instructions
2017-05-08 11:06:11 948 [Note] InnoDB: Initializing buffer pool,size = 128.0M
2017-05-08 11:06:11 948 [Note] InnoDB: Completed initialization of buffer pool
2017-05-08 11:06:11 948 [Note] InnoDB: Highest supported file format is Barracuda.
2017-05-08 11:06:11 948 [Note] InnoDB: 128 rollback segment(s) are active.
2017-05-08 11:06:11 948 [Note] InnoDB: Waiting for purge to start
2017-05-08 11:06:11 948 [Note] InnoDB: 5.6.36 started; log sequence number 1625977
2017-05-08 11:06:11 948 [Note] binlog end
2017-05-08 11:06:11 948 [Note] InnoDB: FTS optimize thread exiting.
2017-05-08 11:06:11 948 [Note] InnoDB: Starting shutdown...
2017-05-08 11:06:13 948 [Note] InnoDB: Shutdown completed; log sequence number 1625987
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 test01.znyj.interconnect 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.
Please report any problems at http://bugs.MysqL.com/
The latest information about MysqL is available on the web at
http://www.MysqL.com
Support MysqL by buying support/licenses at http://shop.MysqL.com
Note: new default config file not created.
Please make sure your config file is current
WARNING: Default config file /etc/my.cnf exists on the system
This file will be read by default by the MysqL server
If you do not want to use this,either remove it,or use the
--defaults-file argument to MysqLd_safe when starting the server
[ OK ]
Starting MysqLd: [ OK ]
[root@test01 srv]#
修改密码
默认密码是空的~使用MysqL -uroot进入~
[root@test01 srv]# MysqL -uroot Welcome to the MysqL monitor. Commands end with ; or \g. Your MysqL connection id is 2 Server version: 5.6.36 MysqL Community Server (GPL) copyright (c) 2000,2017,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>
修改密码~
使用update user set password=PASSWORD("YOUR_PASSWORD") where user='root'；修改root账号密码~
MysqL> use MysqL;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MysqL> update user set password=PASSWORD("YOUR_PASSWORD") where user='root'
-> ;
Query OK,4 rows affected (0.00 sec)
Rows matched: 4 Changed: 4 Warnings: 0
MysqL> flush privileges;
Query OK,0 rows affected (0.00 sec)
MysqL>
密码验证
重新登录MysqL服务，验证修改后的密码~
MysqL> quit Bye [root@test01 srv]# MysqL -uroot ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) [root@test01 srv]# MysqL -uroot -p Enter password: Welcome to the MysqL monitor. Commands end with ; or \g. Your MysqL connection id is 4 Server version: 5.6.36 MysqL Community Server (GPL) copyright (c) 2000,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>
至此，MysqL安装完毕~
CentOS 7.0下使用yum安装MySQL
CentOS 7.0下使用yum安装MysqL
CentOS7安装wget 及配置
yum -y install wget
yum -y install setup
yum -y install perl
MysqL依赖libaio，所以要先安装libaio
# yum search libaio 检索相关信息
# yum install libaio 安装依赖包
CentOS7默认数据库是mariadb,配置等用着不习惯,因此决定改成MysqL,但是CentOS7的yum源中默认好像是没有MysqL的。为了解决这个问题，我们要先下载MysqL的repo源。
1.下载MysqL的repo源
$ wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
2.安装MysqL-community-release-el7-5.noarch.rpm包
$ sudo rpm -ivh MysqL-community-release-el7-5.noarch.rpm
安装这个包后，会获得两个MysqL的yum repo源：/etc/yum.repos.d/MysqL-community.repo，/etc/yum.repos.d/MysqL-community-source.repo。
3.安装MysqL
$ sudo yum install MysqL-server
根据提示安装就可以了,不过安装完成后没有密码,需要重置密码
4.重置MysqL密码
$ MysqL -u root
登录时有可能报这样的错：ERROR 2002 (HY000): Can‘t connect to local MysqL server through socket ‘/var/lib/MysqL/MysqL.sock‘ (2)，原因是/var/lib/MysqL的访问权限问题。下面的命令把/var/lib/MysqL的拥有者改为当前用户：
$ sudo chown -R root:root /var/lib/MysqL
重启MysqL服务
$ service MysqLd restart
接下来登录重置密码：
$ MysqL -u root //直接回车进入MysqL控制台 MysqL > use MysqL; MysqL > update user set password=password(‘123456’) where user=’root’; MysqL > exit;
CentOS 7使用yum安装MYSQL
在此记录一下CentOS 7.2使用yum安装MysqL 5.7.18的步骤，以便查看
查看Linux发行版本
[root@iZ2zed763hlan3sl19tze0Z opt]# cat /etc/redhat-release CentOS Linux release 7.2.1511 (Core)
下载MysqL官方的Yum Repository
根据Linux发行版本（CentOS、Fedora都属于红帽系），从MysqL官方（http://dev.mysql.com/downloads/repo/yum/）获取Yum Repository。
这里选取最新的MysqL57-community-release-el7-11.noarch.rpm下载；
下载地址可以点击链接查看，或自己按照规则拼接：
wget https://dev.MysqL.com/get/MysqL57-community-release-el7-11.noarch.rpm
完成后可以检测下md5是否与页面上的一致：
md5sum MysqL57-community-release-el7-11.noarch.rpm
安装MysqL的Yum Repository
安装完MysqL的Yum Repository，每次执行yum update都会检查MysqL是否更新。
rpm -ivh MysqL57-community-release-el7-11.noarch.rpm
安装MysqL数据库的服务器版本
yum -y install MysqL-server
启动数据库：
systemctl start MysqLd
MysqL数据库的其他常用命令
systemctl start MysqLd #启动MysqL systemctl stop MysqLd #关闭MysqL systemctl restart MysqLd #重启MysqL systemctl status MysqLd #查看MysqL运行状态 systemctl enable MysqLd #设置开机启动 systemctl disable MysqLd #关闭开机启动
然后使用命令systemctl status MysqLd查看MysqL数据库启动后的服务状态：
获取初始密码
使用YUM安装并启动MysqL服务后，MysqL进程会自动在进程日志中打印root用户的初始密码,使用grep来过滤出密码信息：
grep "password" /var/log/MysqLd.log
修改root用户密码
使用上一步中获取的root用户的初始密码，连上数据库，然后进行修改：
[root@iZ2zed763hlan3sl19tze0Z ~]# MysqL -uroot -p Enter password: #######输入默认的root密码后回车 Welcome to the MysqL monitor. Commands end with ; or \g. Your MysqL connection id is 4 Server version: 5.7.18 MysqL Community Server (GPL) copyright (c) 2000,2017,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> ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password'; Query OK,0 rows affected (0.00 sec) MysqL> exit Bye
删除MysqL的Repository
因为小节3中安装了MysqL的Yum Repository，所以以后每次执行yum操作时，都会去检查更新。如果想要去掉这种自动检查操作的话，可以使用如下命令卸载MysqL的Repository即可。
[root@iZ2zed763hlan3sl19tze0Z ~]# yum -y remove -community-release-el7-11.noarch.rpm
安装完毕
至此，使用在CentOS7中使用YUM方法安装MysqL5.7.18数据库完毕。可以使用新的root密码登陆MysqL了
至此，在本地连接MysqL数据库是没有问题的，如果想要异地远程连接数据库，则需要进行另外一些配置,传送门： 解决mysql本地可访问，远程无法访问的问题 Host is not allowed to connect to this MySQL server
文章首次发表于吾勇士的博客http://wuyongshi.top/articles/2017/05/13/1494680227092.html
CentOS Linux下用yum 安装MySQL
注意：CentOS Linux系统下用yum 安装MySQL，必须在网络环境下进行安装；关于Linux系统下如何连接网络，前一篇文章有介绍，请参考
注意：centos linux系统下用yum 安装mysql，必须在网络环境下进行安装；关于linux系统下如何连接网络，前一篇文章有介绍，请参考 ！
第一篇：安装和配置MySQL
第一步：安装MySQL
[root@192 local]# yum -y install mysql-server ← 安装MySQL
[root@192 local]# yum -y install php-mysql ← 安装php-mysql
第二步：配置MySQL
[root@192 local] #vim /etc/my.cnf ← 编辑MySQL的配置文件
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1 ← 找到这一行，，在这一行的下面添加新的规则，让MySQL的默认编码为UTF-8
default-character-set = utf8 ← 添加这一行
然后在配置文件的文尾填加如下语句：
[mysql]
default-character-set = utf8
今天关于Linux 使用YUM安装mysql的分享就到这里，希望大家有所收获，若想了解更多关于CentOS 6.9安装MySQL 5.6 （使用yum安装）、CentOS 7.0下使用yum安装MySQL、CentOS 7使用yum安装MYSQL、CentOS Linux下用yum 安装MySQL等相关知识，可以在本站进行查询。
本文标签：
![[转帖]Ubuntu 安装 Wine方法（ubuntu如何安装wine）](https://www.gvkun.com/zb_users/cache/thumbs/4c83df0e2303284d68480d1b1378581d-180-120-1.jpg)
