这篇文章主要为大家展示了“如何在线安装Mysql”,内容简而易懂,条理清晰,希望能够帮助大家解决疑惑,下面让小编带领大家一起研究并学习一下“如何在线安装Mysql”这篇文章吧。

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

[bigdata@bigdata-pro02~]$rpm-qa|grepmysqlmysql-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-servermysql-server.x86_645.1.73-8.el6_8@base三、安装mysql-server ,使用yum install 命令,安装过程中会自动把所有依赖的包自动下载和安装

[root@bigdata-pro02~]#yuminstallmysql-server.x86_64-yLoadedplugins:fastestmirror,refresh-packagekit,securitySettingupInstallProcessLoadingmirrorspeedsfromcachedhostfileepel/metalink|4.9kB00:00*base:mirrors.163.com*epel:mirrors.ustc.edu.cn*extras:mirrors.163.com*updates:mirrors.163.combase|3.7kB00:00epel|3.2kB00:00epel/primary|3.2MB00:01epel12521/12521extras|3.4kB00:00updates|3.4kB00:00updates/primary_db|1.2MB00:00ResolvingDependencies-->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-->FinishedDependencyResolutionDependenciesResolved====================================================================================================================PackageArchVersionRepositorySize====================================================================================================================Installing:mysql-serverx86_645.1.73-8.el6_8base8.6MInstallingfordependencies:mysqlx86_645.1.73-8.el6_8base895kmysql-libsx86_645.1.73-8.el6_8base1.2Mperl-DBD-MySQLx86_644.013-3.el6base134kperl-DBIx86_641.609-4.el6base705kTransactionSummary====================================================================================================================Install5Package(s)Totaldownloadsize:12MInstalledsize:33MIsthisok[y/N]:yDownloadingPackages:(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:04Runningrpm_check_debugRunningTransactionTestTransactionTestSucceededRunningTransactionWarning: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-libsInstalling:mysql-libs-5.1.73-8.el6_8.x86_641/5Installing:perl-DBI-1.609-4.el6.x86_642/5Installing:perl-DBD-MySQL-4.013-3.el6.x86_643/5Installing:mysql-5.1.73-8.el6_8.x86_644/5Installing:mysql-server-5.1.73-8.el6_8.x86_645/5Verifying:perl-DBD-MySQL-4.013-3.el6.x86_641/5Verifying:mysql-libs-5.1.73-8.el6_8.x86_642/5Verifying:mysql-server-5.1.73-8.el6_8.x86_643/5Verifying:mysql-5.1.73-8.el6_8.x86_644/5Verifying:perl-DBI-1.609-4.el6.x86_645/5Installed:mysql-server.x86_640:5.1.73-8.el6_8DependencyInstalled: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.el6perl-DBI.x86_640:1.609-4.el6Complete!

检查系统中是否安装mysql

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

检查mysql命令所在位置

[root@bigdata-pro02~]#whichmysql/usr/bin/mysql四、启动mysqld服务

[root@bigdata-pro02~]#servicemysqldstatusmysqldisstopped[root@bigdata-pro02~]#servicemysqldstartInitializingMySQLdatabase:InstallingMySQLsystemtables...OKFillinghelptables...OKTostartmysqldatboottimeyouhavetocopysupport-files/mysql.servertotherightplaceforyoursystemPLEASEREMEMBERTOSETAPASSWORDFORTHEMySQLrootUSER!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_installationwhichwillalsogiveyoutheoptionofremovingthetestdatabasesandanonymoususercreatedbydefault.Thisisstronglyrecommendedforproductionservers.Seethemanualformoreinstructions.YoucanstarttheMySQLdaemonwith:cd/usr;/usr/bin/mysqld_safe&YoucantesttheMySQLdaemonwithmysql-test-run.plcd/usr/mysql-test;perlmysql-test-run.plPleasereportanyproblemswiththe/usr/bin/mysqlbugscript![OK]Startingmysqld:[OK]五、使用mysql数据库

添加root用户并设置密码

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

登录mysql数据库

[root@bigdata-pro02~]#mysql-uroot-p123456WelcometotheMySQLmonitor.Commandsendwith;or\g.YourMySQLconnectionidis7Serverversion:5.1.73SourcedistributionCopyright(c)2000,2013,Oracleand/oritsaffiliates.Allrightsreserved.OracleisaregisteredtrademarkofOracleCorporationand/oritsaffiliates.Othernamesmaybetrademarksoftheirrespectiveowners.Type'help;'or'\h'forhelp.Type'\c'toclearthecurrentinputstatement.mysql>showdatabases;+--------------------+|Database|+--------------------+|information_schema||mysql||test|+--------------------+3rowsinset(0.00sec)mysql>usetest;Databasechangedmysql>showtables;Emptyset(0.01sec)mysql>createtabletest1(idint(10),namevarchar(20));QueryOK,0rowsaffected(0.00sec)mysql>showtables;+----------------+|Tables_in_test|+----------------+|test1|+----------------+1rowinset(0.00sec)

以上是“如何在线安装Mysql”这篇文章的所有内容,感谢各位的阅读!相信大家都有了一定的了解,希望分享的内容对大家有所帮助,如果还想学习更多知识,欢迎关注亿速云行业资讯频道!