mysql是免费开源的数据库产品,我们在centos mysql安装时报No package mysql-server available错误是因为我们本地yum仓库中没有可用的mysql-server rpm包,因此在yum安装之前先在本地备好rpm软件包。[root@VM_230_32_centos~]#yuminstallmysql-server
Loadedplugins:fastestmirror,ovl
base|3.6kB00:00:00
extras|3.4kB00:00:00
http://ftp.iitm.ac.in/centos/7.3.1611/updates/x86_64/repodata/repomd.xml
:[Errno14]curl#52-"Emptyreplyfromserver"
Tryingothermirror.
updates|3.4kB00:00:00
........
Nopackagemysql-serveravailable.
Error:Nothingtodo
下面我们对centos6/7系统分开来解决此问题,以安装的是mysql5.7为例
在Centos 7上使用[root@VM_230_32_centos~]#rpm-ivh//mysql57-community-release-el7-11.noarch.rpm
Retrieving
//mysql57-community-release-el7-11.noarch.rpm
warning:/var/tmp/rpm-tmp.7OOdD1:HeaderV3DSA/SHA1Signature,keyID5072e1f5:NOKEY
Preparing...#################################[100%]
Updating/installing...
1:mysql57-community-release-el7-11#################################[100%]
[root@eb2476e8763c/]#
Centos 6上安装mysql rpm包[root@VM_230_32_centos~]#rpm-ivh//mysql57-community-release-el6-11.noarch.rpm
Retrieving
//mysql57-community-release-el6-11.noarch.rpm
warning:/var/tmp/rpm-tmp.TWlyW7:HeaderV3DSA/SHA1Signature,keyID5072e1f5:NOKEY
Preparing...#################################[100%]
Updating/installing...
1:mysql57-community-release-el6-11#################################[100%]
rpm软件包安装好之后,我们就可以使用yum install mysql-server命令来安装mysql了。[root@VM_230_32_centos~]#yuminstallmysql-server
Loadedplugins:fastestmirror,ovl
base|3.6kB00:00:00
extras|3.4kB00:00:00
mysql-connectors-community|2.5kB00:00:00
mysql-tools-community|2.5kB00:00:00
mysql57-community|2.5kB00:00:00
updates|3.4kB00:00:00
mysql-connectors-community/x86_64/primary_db|16kB00:00:01
Loadingmirrorspeedsfromcachedhostfile
......
Installed:
mysql-community-server.x86_640:5.7.19-1.el7
Verifytheinstalledpackagesusing"rpm"command
安装好mysql之后,就可以启动mysql服务器了,centos6/7系统启动mysql服务的方式也不是一样的。
Centos 7系统启动mysql命令systemctlstartmysql
Centos 6启动mysql命令servicemysqldstart
验证mysql是否启动成功命令,使用netstat命令[root@VM_230_32_centos~]#netstat-nap|grep3306
tcp000.0.0.0:33060.0.0.0:*LISTEN4571/mysqld
最后需要查看mysql5.7的初始化密码(如果是mysql5.6的话默认密码应该为空,不需要此命令查询)#grep'temporarypassword'/var/log/mysqld.log
输出类似如下的随机密码(红色部分)
-11-08T16:24:46.311098Z 1 [Note] A temporary password is generated for root@localhost: MtPqF0/oN5zoSfdff
然后输入mysql -uroot -p命令登录mysql服务器,并修改mysql初始化密码。[root@VM_219_180_centos~]#mysql-uroot-p
//输入初始化密码登录之后,重新设置mysql密码
mysql>setpasswordforroot@localhost=password('123456');
来源网站:太平洋学习网,转载请注明出处:/a/mysql_oracle/371.html