linux安装mysql命令步骤_怎么在linux部署mysql

linux安装mysql命令步骤_怎么在linux部署mysql,第1张

linux安装mysql命令步骤_怎么在linux部署mysql 确认linux对应的版本:cat /proc/versionuname -alsb_release -acat /etc/redhat-releasecat /etc/issue这个是内核的版本:3.10.0-1062.9.1.el7.x86_64选择 *** 作系统版本:2.解压mysql的tar格式文件 tar -xvf mysql-8.0.20-1.el7.x86_64.rpm-bundle.tar运行上述命令,得到如下结果,有8个文件包:也可以创建一个文件夹,在同一个子目录下解压。


3.安装解压的rpm安装包然后我们可以用rpm -ivh命令来进行安装,注意安装顺序,因为这些包的安装是相互依赖的:必须安装(注意顺序) rpm -ivh mysql-community-common-8.0.20-1.el7.x86_64.rpmrpm -ivh mysql-community-libs-8.0.20-1.el7.x86_64.rpmrpm -ivh mysql-community-client-8.0.20-1.el7.x86_64.rpmrpm -ivh mysql-community-server-8.0.20-1.el7.x86_64.rpm非必要安装(注意顺序)rpm -ivh mysql-community-libs-compat-8.0.20-1.el7.x86_64.rpmrpm -ivh mysql-community-embedded-compat-8.0.20-1.el7.x86_64.rpmrpm -ivh mysql-community-devel-8.0.20-1.el7.x86_64.rpmrpm -ivh mysql-community-test-8.0.20-1.el7.x86_64.rpm安装过程中可能会报以下错误:出现问题:error:Failed dependencies:libnuma.so.1()(64bit) is needed by mysql-community-server-8.0.13-1.el7.x86_64 libnuma.so.1(libnuma_1.1)(64bit) is needed by mysql-community-server-8.0.13-1.el7.x86_64 libnuma.so.1(libnuma_1.2)(64bit) is needed by mysql-community-server-8.0.13-1.el7.x86_64解决办法:yum install numactl出现问题:error:Failed dependencies:pkgconfig(openssl) is needed by mysql-community-devel-8.0.13-1.el7.x86_64解决办法:yum install openssl-devel.x86_64 openssl.x86_64 -y出现问题:error:Failed dependencies:perl(Data::Dumper) is needed by mysql-community-test-8.0.13-1.el7.x86_64解决办法:yum -y install autoconf出现问题:error:Failed dependencies:perl(JSON) is needed by mysql-community-test-8.0.13-1.el7.x86_64解决办法:yum install perl.x86_64 perl-devel.x86_64 -yyum install perl-JSON.noarch -y出现问题:error:error: Failed dependencies:libaio.so.1()(64bit) is needed by MySQL-server-5.5.25a-1.rhel5.x86_64libaio.so.1(LIBAIO_0.1)(64bit) is needed by MySQL-server-5.5.25a-1.rhel5.x86_64libaio.so.1(LIBAIO_0.4)(64bit) is needed by MySQL-server-5.5.25a-1.rhel5.x86_64解决办法:yum install libaio以上我们的MySQL就安装好了,下面可以直接使用了。


4.使用数据库初始化数据库mysqld –initialize –console目录授权,不授权的话MySQL没有写入权限,会启动失败所以在初始化之前,记得授权,命令为:chown -R mysql:mysql /var/lib/mysql/启动msyql服务命令:systemctl start mysqld停止MySQL命令:service mysqld stop查看msyql服务的状态service mysqld status当看到Active后面是active(runing)说明启动成功了4.修改数据库密码当我们输入mysql -u root -p需要输入密码,我们可以去mysqld.log里面查看一下临时密码:cat /var/log/mysqld.log下面我们就可以使用你的临时密码登录数据库画线的部分就是安装好生成的初始密码mysql -u root -p+回车输入临时密码修改命令:alter USER ‘root’@’localhost’ IDENTIFIED BY ‘新密码(必须包含:数字大小写字母特殊字符,长度最小为8位)’;后面一定要加分号,不然无效然后ctrl+d退出,重新进入就可以了,输入命令show databases;use mysql;正常就可以了

欢迎分享,转载请注明来源:内存溢出

原文地址: http://outofmemory.cn/tougao/643222.html

(0)
打赏 微信扫一扫 微信扫一扫 支付宝扫一扫 支付宝扫一扫
上一篇 2022-04-17
下一篇 2022-04-17

发表评论

登录后才能评论

评论列表(0条)

保存