如何在线安装Mysql

一、 检查系统中是否已安装了mysql服务或开发包依赖等

[bigdata@bigdata-pro02~]$rpm-qa|grepmysql
mysql-libs-5.1.73-3.el6_5.x86_64

如果检查存在一些安装包，则使用 rpm -e --nodeps [安装包1] [安装包2] [...] 将已有的安装包卸载。
这里需要切换到root用户

[root@bigdata-pro02~]#rpm-e--nodepsmysql-libs-5.1.73-3.el6_5.x86_64
[root@bigdata-pro02~]#

二、检查yum源上可以使用的安装包（如果对mysql版本有要求，可以修改yum源的配置）

使用yum list | grep mysql 来检查可以使用的安装包

[root@bigdata-pro02~]#yumlist|grepmysql-server
mysql-server.x86_645.1.73-8.el6_8@base

三、安装mysql-server ，使用yum install 命令，安装过程中会自动把所有依赖的包自动下载和安装

[root@bigdata-pro02~]#yuminstallmysql-server.x86_64-y
Loadedplugins:fastestmirror,refresh-packagekit,security
SettingupInstallProcess
Loadingmirrorspeedsfromcachedhostfile
epel/metalink|4.9kB00:00
*base:mirrors.163.com
*epel:mirrors.ustc.edu.cn
*extras:mirrors.163.com
*updates:mirrors.163.com
base|3.7kB00:00
epel|3.2kB00:00
epel/primary|3.2MB00:01
epel12521/12521
extras|3.4kB00:00
updates|3.4kB00:00
updates/primary_db|1.2MB00:00
ResolvingDependencies
-->Runningtransactioncheck
--->Packagemysql-server.x86_640:5.1.73-8.el6_8willbeinstalled
-->ProcessingDependency:mysql=5.1.73-8.el6_8forpackage:mysql-server-5.1.73-8.el6_8.x86_64
-->ProcessingDependency:perl-DBIforpackage:mysql-server-5.1.73-8.el6_8.x86_64
-->ProcessingDependency:perl-DBD-MySQLforpackage:mysql-server-5.1.73-8.el6_8.x86_64
-->ProcessingDependency:perl(DBI)forpackage:mysql-server-5.1.73-8.el6_8.x86_64
-->ProcessingDependency:libmysqlclient_r.so.16(libmysqlclient_16)(64bit)forpackage:mysql-server-5.1.73-8.el6_8.x86_64
-->ProcessingDependency:libmysqlclient.so.16(libmysqlclient_16)(64bit)forpackage:mysql-server-5.1.73-8.el6_8.x86_64
-->ProcessingDependency:libmysqlclient_r.so.16()(64bit)forpackage:mysql-server-5.1.73-8.el6_8.x86_64
-->ProcessingDependency:libmysqlclient.so.16()(64bit)forpackage:mysql-server-5.1.73-8.el6_8.x86_64
-->Runningtransactioncheck
--->Packagemysql.x86_640:5.1.73-8.el6_8willbeinstalled
--->Packagemysql-libs.x86_640:5.1.73-8.el6_8willbeinstalled
--->Packageperl-DBD-MySQL.x86_640:4.013-3.el6willbeinstalled
--->Packageperl-DBI.x86_640:1.609-4.el6willbeinstalled
-->FinishedDependencyResolution

DependenciesResolved

====================================================================================================================
PackageArchVersionRepositorySize
====================================================================================================================
Installing:
mysql-serverx86_645.1.73-8.el6_8base8.6M
Installingfordependencies:
mysqlx86_645.1.73-8.el6_8base895k
mysql-libsx86_645.1.73-8.el6_8base1.2M
perl-DBD-MySQLx86_644.013-3.el6base134k
perl-DBIx86_641.609-4.el6base705k

TransactionSummary
====================================================================================================================
Install5Package(s)

Totaldownloadsize:12M
Installedsize:33M
Isthisok[y/N]:y
DownloadingPackages:
(1/5):mysql-5.1.73-8.el6_8.x86_64.rpm|895kB00:00
(2/5):mysql-libs-5.1.73-8.el6_8.x86_64.rpm|1.2MB00:00
(3/5):mysql-server-5.1.73-8.el6_8.x86_64.rpm|8.6MB00:03
(4/5):perl-DBD-MySQL-4.013-3.el6.x86_64.rpm|134kB00:00
(5/5):perl-DBI-1.609-4.el6.x86_64.rpm|705kB00:00
--------------------------------------------------------------------------------------------------------------------
Total2.4MB/s|12MB00:04
Runningrpm_check_debug
RunningTransactionTest
TransactionTestSucceeded
RunningTransaction
Warning:RPMDBalteredoutsideofyum.
**Found3pre-existingrpmdbproblem(s),'yumcheck'outputfollows:
2:postfix-2.6.6-6.el6_5.x86_64hasmissingrequiresoflibmysqlclient.so.16()(64bit)
2:postfix-2.6.6-6.el6_5.x86_64hasmissingrequiresoflibmysqlclient.so.16(libmysqlclient_16)(64bit)
2:postfix-2.6.6-6.el6_5.x86_64hasmissingrequiresofmysql-libs
Installing:mysql-libs-5.1.73-8.el6_8.x86_641/5
Installing:perl-DBI-1.609-4.el6.x86_642/5
Installing:perl-DBD-MySQL-4.013-3.el6.x86_643/5
Installing:mysql-5.1.73-8.el6_8.x86_644/5
Installing:mysql-server-5.1.73-8.el6_8.x86_645/5
Verifying:perl-DBD-MySQL-4.013-3.el6.x86_641/5
Verifying:mysql-libs-5.1.73-8.el6_8.x86_642/5
Verifying:mysql-server-5.1.73-8.el6_8.x86_643/5
Verifying:mysql-5.1.73-8.el6_8.x86_644/5
Verifying:perl-DBI-1.609-4.el6.x86_645/5

Installed:
mysql-server.x86_640:5.1.73-8.el6_8

DependencyInstalled:
mysql.x86_640:5.1.73-8.el6_8mysql-libs.x86_640:5.1.73-8.el6_8perl-DBD-MySQL.x86_640:4.013-3.el6
perl-DBI.x86_640:1.609-4.el6

Complete!

检查系统中是否安装mysql

[root@bigdata-pro02~]#rpm-qa|grepmysql
mysql-5.1.73-8.el6_8.x86_64
mysql-libs-5.1.73-8.el6_8.x86_64
mysql-server-5.1.73-8.el6_8.x86_64

检查mysql命令所在位置

[root@bigdata-pro02~]#whichmysql
/usr/bin/mysql

四、启动mysqld服务

[root@bigdata-pro02~]#servicemysqldstatus
mysqldisstopped
[root@bigdata-pro02~]#servicemysqldstart
InitializingMySQLdatabase:InstallingMySQLsystemtables...
OK
Fillinghelptables...
OK

Tostartmysqldatboottimeyouhavetocopy
support-files/mysql.servertotherightplaceforyoursystem

PLEASEREMEMBERTOSETAPASSWORDFORTHEMySQLrootUSER!
Todoso,starttheserver,thenissuethefollowingcommands:

/usr/bin/mysqladmin-urootpassword'new-password'
/usr/bin/mysqladmin-uroot-hbigdata-pro02.mars.compassword'new-password'
**#以上为两种新建root用户并设置密码的方式**

Alternativelyyoucanrun:
/usr/bin/mysql_secure_installation

whichwillalsogiveyoutheoptionofremovingthetest
databasesandanonymoususercreatedbydefault.Thisis
stronglyrecommendedforproductionservers.

Seethemanualformoreinstructions.

YoucanstarttheMySQLdaemonwith:
cd/usr;/usr/bin/mysqld_safe&

YoucantesttheMySQLdaemonwithmysql-test-run.pl
cd/usr/mysql-test;perlmysql-test-run.pl

Pleasereportanyproblemswiththe/usr/bin/mysqlbugscript!

[OK]
Startingmysqld:[OK]

五、使用mysql数据库

添加root用户并设置密码

[root@bigdata-pro02~]#/usr/bin/mysqladmin-urootpassword'123456'

登录mysql数据库

[root@bigdata-pro02~]#mysql-uroot-p123456
WelcometotheMySQLmonitor.Commandsendwith;or\g.
YourMySQLconnectionidis7
Serverversion:5.1.73Sourcedistribution

Copyright(c)2000,2013,Oracleand/oritsaffiliates.Allrightsreserved.

OracleisaregisteredtrademarkofOracleCorporationand/orits
affiliates.Othernamesmaybetrademarksoftheirrespective
owners.

Type'help;'or'\h'forhelp.Type'\c'toclearthecurrentinputstatement.

mysql>showdatabases;
+--------------------+
|Database|
+--------------------+
|information_schema|
|mysql|
|test|
+--------------------+
3rowsinset(0.00sec)

mysql>usetest;
Databasechanged
mysql>showtables;
Emptyset(0.01sec)

mysql>createtabletest1(idint(10),namevarchar(20));
QueryOK,0rowsaffected(0.00sec)

mysql>showtables;
+----------------+
|Tables_in_test|
+----------------+
|test1|
+----------------+
1rowinset(0.00sec)