南昌做网站后台投票,无锡工程建设信息网站,云猎建筑人才网,平面设计接单软件1.下载8.x版本的mysql
MySQL :: Download MySQL Community Server (Archived Versions)
2.安装linux
我安装的是Rocky Linux8.6 3.设置ip地址,方便远程连接
使用nmcli或者nmtui设置或修改ip地址
4.使用远程连接工具MobaXterm操作: (1)将mysql8版本的压缩包上传到mybaxterm…
1.下载8.x版本的mysql
MySQL :: Download MySQL Community Server (Archived Versions)
2.安装linux
我安装的是Rocky Linux8.6 3.设置ip地址,方便远程连接
使用nmcli或者nmtui设置或修改ip地址
4.使用远程连接工具MobaXterm操作: (1)将mysql8版本的压缩包上传到mybaxterm
(2)解压缩
tar -Jxvf mysql-8.0.25-linux-glibc2.12-x86_64.tar.xz(3)移动压缩后的目录到/usr/local/,并改名为mysql
注意:修改权限mysql:mysql
mv mysql-8.0.25-linux-glibc2.12-x86_64 /usr/local/mysql
useradd mysql -s /sbin/nologin
chown -R mysql.mysql /usr/local/mysql(4)cd /usr/local/mysql
创建配置文件/etc/my.cnf
[rootlocalhost bin]# vim /etc/my.cnf
[mysqld]
log-error/usr/local/mysql/log/mysql.err
basedir/usr/local/mysql
datadir/usr/local/mysql/data
socket/tmp/mysql.sock
character-set-serverUTF8MB4创建必要的文件目录:
mkdir /usr/local/mysql/{binlog,data,log,tmpdir,conf} -p利用配置文件初始化mysql
[rootlocalhost mysql]# bin/mysqld \
--defaults-file/etc/my.cnf \
--usermysql \
--initialize初始化数据库,它会给出一个临时密码,记住它,后面要用,如果找不到了,需要走忘记密码流程 (5)启动mysql
[rootlocalhost mysql]# support-files/mysql.server start如果是开启中的,启动需要重启mysql
[rootlocalhost mysql]# support-files/mysql.server restart(6)处理报错
当执行bin/mysql -u root -p命令时,出现以下报错:
mysql: error while loading shared libraries: libtinfo.so.5: cannot open shared object file: No such file or directory 解决办法:
[rootlocalhost mysql]# find / -name libtinfo.*
/usr/lib64/libtinfo.so.6
/usr/lib64/libtinfo.so.6.1[rootlocalhost mysql]# ln -s /usr/lib64/libtinfo.so.6.1 /usr/lib64/libtinfo.so.5
(7)如果想要service控制它的开启和关闭
[rootlocalhost mysql]# ls
bin data docs include lib LICENSE man README share support-files
[rootlocalhost mysql]# cp -a ./support-files/mysql.server /etc/init.d/mysql
#chkconfig --add mysql 这条命令的作用是将 mysql 服务添加到系统的服务管理列表中使得系统能够通过 chkconfig 工具来管理该服务的启动级别。
[rootlocalhost mysql]# chkconfig --add mysql
[rootlocalhost mysql]# service mysql restart
Shutting down MySQL.. SUCCESS!
Starting MySQL. SUCCESS!
[rootlocalhost mysql]# service mysql statusSUCCESS! MySQL running (26540)
[rootlocalhost mysql]# ln -s /usr/local/mysql/bin/mysql /usr/bin(8)使用临时密码登录验证mysql [rootlocalhost mysql]# mysql -uroot -pis/BIErGB051
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 8.0.25Copyright (c) 2000, 2021, Oracle and/or its affiliates.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 (9)修改密码
mysql alter user rootlocalhost identified by 123456
(10)exit退出,使用新密码登录
[rootlocalhost mysql]# mysql -uroot -p123456
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 8.0.25 MySQL Community Server - GPLCopyright (c) 2000, 2021, Oracle and/or its affiliates.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(11)使用systemctl控制mysql
• systemd一个更高效的系统服务管理器
– 开机服务并行启动各系统服务间的精确依赖
– 服务目录/usr/lib/systemd/system/
– 主要管理工具systemctl
systemd方式
注意: 为了和yum下载的情况一致,设置文件名称为mysqld.service,使用systemctl命令可以省略.service后缀
systemctl start mysqld #启动mysqld
systemctl stop mysqld #停止mysqld
systemd管理方式思路
用户--systemctl--》systemd--服务启动配置文件--》mysqld启动
•管理员服务文件默认路径
–/usr/lib/systemd/system/
•重新加载服务启动配置文件(每次修改mysqld.service文件都要执行这个命令一次)
systemctl daemon-reload
再启动mysqld:
systemctl start mysqld
[rootlocalhost system]# cd /usr/lib/systemd/system
[rootlocalhost system]# vim mysqld.service
[Unit]
DescriptionMySQL Server
Afternetwork.target[Service]
TypeforkingPIDFile/usr/local/mysql/data/mysql1.pid
ExecStart/usr/local/mysql/support-files/mysql.server start
ExecStop/usr/local/mysql/support-files/mysql.server stop[Install]
WantedBymulti-user.target[rootlocalhost system]# systemctl daemon-reload[rootlocalhost system]# systemctl stop mysqld
[rootlocalhost system]# systemctl status mysqld
[rootlocalhost system]# systemctl start mysqld 5.使用shell脚本安装,mysql并启动:
为了更好的效果新建一个Linux虚拟机处理
(1) 设置hostname方便查看pid文件因为pid的文件名称与hostname有关
就设置为mysql1
(2) 准备/etc/my.cnf文件(为了方便使用之前的同名文件也可)
[mysqld]
log-error/usr/local/mysql/log/mysql.err
basedir/usr/local/mysql
datadir/usr/local/mysql/data
socket/tmp/mysql.sock
character-set-serverUTF8MB4(3)shell脚本文件install_mysql.sh
#!/bin/bashif [ -d /usr/local/mysql ];thenecho /usr/local/mysql文件夹已经存在,请确认是否安装了mysqlexit
fi
echo 正在解压压缩包
tar -Jxf mysql-8.0.25-linux-glibc2.12-x86_64.tar.xz
mv mysql-8.0.25-linux-glibc2.12-x86_64 /usr/local/mysql#创建一些必要的文件夹
mkdir /usr/local/mysql/{binlog,data,log,tmpdir,conf} -p#检查mysql进程
mysql_pidps -ef | grep mysqld | wc -l
if [ $mysql_pid -eq 1 ];thenecho mysql进程没有运行
elseecho 有mysql进程运行,请检查
fi#检查mysql用户
mysql_usercat /etc/passwd | grep -w mysql | wc -l
if [ $mysql_user -eq 1 ];thenecho mysql用户已经存在
elseecho mysql用户不存在,开始添加mysql用户useradd mysql -s /sbin/nologinecho 添加mysql用户成功
fi#处理libtinfo.so.5报错
ln -s /usr/lib64/libtinfo.so.6.1 /usr/lib64/libtinfo.so.5#修改目录权限
chown -R mysql.mysql /usr/local/mysql#增加配置文件
if [ -f /etc/my.cnf ];thenecho /etc/my.cnf文件存在
elseecho /etc/my.cnf文件不存在exit
fi#初始化
echo 开始初始化
/usr/local/mysql/bin/mysqld \
--defaults-file/etc/my.cnf \
--usermysql \
--initialize
#判断初始化是否成功
mysql_initcat /usr/local/mysql/log/mysql.err | grep -i rootlocalhost: | wc -l
if [ $mysql_init -eq 1 ];thenecho mysql初始化成功
elseecho mysql初始化失败exit
fi#获取临时密码
temp_pwd$(grep temporary password /usr/local/mysql/log/mysql.err)
pwd${temp_pwd##* }
echo 临时密码是: ${pwd}#配置启动脚本
if [ ! -f /etc/init.d/mysql.server ];thencp /usr/local/mysql/support-files/mysql.server /etc/init.d/ -rfchmod 700 /etc/init.d/mysql.server
fi#启动mysql
/etc/init.d/mysql.server start#增加家环境变量
mysql_pathgrep export PATH$PATH:/usr/local/mysql/bin /etc/profile | wc -l
if [ $mysql_path -eq 0 ];thenecho export PATH\$PATH:/usr/local/mysql/bin /etc/profilesource /etc/profile
fi#通过临时密码登录mysql,并修改密码
mysql -uroot -p${pwd} --connect-expired-password -e alter user rootlocalhost identified by 123456
echo mysql8.0.25安装完成!4给脚本添加执行权限
chomod x install_mysql.sh
5执行脚本
./install_mysql.sh
注意如果要使用service命令处理mysql需要再将/etc/init.d/mysql.server改为/etc/init.d/mysql如下图所示也可以直接到脚本文件相应的位置修改代码
文章转载自： http://www.morning.rshs.cn.gov.cn.rshs.cn http://www.morning.tkzrh.cn.gov.cn.tkzrh.cn http://www.morning.brhxd.cn.gov.cn.brhxd.cn http://www.morning.nckjk.cn.gov.cn.nckjk.cn http://www.morning.gwsll.cn.gov.cn.gwsll.cn http://www.morning.rbnp.cn.gov.cn.rbnp.cn http://www.morning.gjlxn.cn.gov.cn.gjlxn.cn http://www.morning.fstesen.com.gov.cn.fstesen.com http://www.morning.qmfhh.cn.gov.cn.qmfhh.cn http://www.morning.lgznc.cn.gov.cn.lgznc.cn http://www.morning.yrrnx.cn.gov.cn.yrrnx.cn http://www.morning.rhlhk.cn.gov.cn.rhlhk.cn http://www.morning.ypqwm.cn.gov.cn.ypqwm.cn http://www.morning.jydhl.cn.gov.cn.jydhl.cn http://www.morning.qkrzn.cn.gov.cn.qkrzn.cn http://www.morning.hwlmy.cn.gov.cn.hwlmy.cn http://www.morning.hmxrs.cn.gov.cn.hmxrs.cn http://www.morning.kwqwp.cn.gov.cn.kwqwp.cn http://www.morning.sjpbh.cn.gov.cn.sjpbh.cn http://www.morning.rfjmy.cn.gov.cn.rfjmy.cn http://www.morning.glcgy.cn.gov.cn.glcgy.cn http://www.morning.tgqzp.cn.gov.cn.tgqzp.cn http://www.morning.ylkkh.cn.gov.cn.ylkkh.cn http://www.morning.nrddx.com.gov.cn.nrddx.com http://www.morning.rfwqt.cn.gov.cn.rfwqt.cn http://www.morning.rqfzp.cn.gov.cn.rqfzp.cn http://www.morning.kwrzg.cn.gov.cn.kwrzg.cn http://www.morning.kbgzj.cn.gov.cn.kbgzj.cn http://www.morning.nlkjq.cn.gov.cn.nlkjq.cn http://www.morning.fdmfn.cn.gov.cn.fdmfn.cn http://www.morning.kdrjd.cn.gov.cn.kdrjd.cn http://www.morning.lskyz.cn.gov.cn.lskyz.cn http://www.morning.ykklw.cn.gov.cn.ykklw.cn http://www.morning.qywfw.cn.gov.cn.qywfw.cn http://www.morning.drrt.cn.gov.cn.drrt.cn http://www.morning.jnoegg.com.gov.cn.jnoegg.com http://www.morning.mllmm.cn.gov.cn.mllmm.cn http://www.morning.tkchm.cn.gov.cn.tkchm.cn http://www.morning.jxfmn.cn.gov.cn.jxfmn.cn http://www.morning.smdkk.cn.gov.cn.smdkk.cn http://www.morning.gbljq.cn.gov.cn.gbljq.cn http://www.morning.bpxmw.cn.gov.cn.bpxmw.cn http://www.morning.plqkz.cn.gov.cn.plqkz.cn http://www.morning.slysg.cn.gov.cn.slysg.cn http://www.morning.nggry.cn.gov.cn.nggry.cn http://www.morning.lbgfz.cn.gov.cn.lbgfz.cn http://www.morning.xsfg.cn.gov.cn.xsfg.cn http://www.morning.bhwll.cn.gov.cn.bhwll.cn http://www.morning.zxfdq.cn.gov.cn.zxfdq.cn http://www.morning.knqck.cn.gov.cn.knqck.cn http://www.morning.wmrgp.cn.gov.cn.wmrgp.cn http://www.morning.bwmm.cn.gov.cn.bwmm.cn http://www.morning.rdnjc.cn.gov.cn.rdnjc.cn http://www.morning.pshtf.cn.gov.cn.pshtf.cn http://www.morning.yfrlk.cn.gov.cn.yfrlk.cn http://www.morning.lmhh.cn.gov.cn.lmhh.cn http://www.morning.llgpk.cn.gov.cn.llgpk.cn http://www.morning.xbxks.cn.gov.cn.xbxks.cn http://www.morning.sjjtz.cn.gov.cn.sjjtz.cn http://www.morning.kjyqr.cn.gov.cn.kjyqr.cn http://www.morning.jwgmx.cn.gov.cn.jwgmx.cn http://www.morning.wdshp.cn.gov.cn.wdshp.cn http://www.morning.nwmwp.cn.gov.cn.nwmwp.cn http://www.morning.lyhrg.cn.gov.cn.lyhrg.cn http://www.morning.nsncq.cn.gov.cn.nsncq.cn http://www.morning.qgxnw.cn.gov.cn.qgxnw.cn http://www.morning.ffksr.cn.gov.cn.ffksr.cn http://www.morning.aiai201.cn.gov.cn.aiai201.cn http://www.morning.npmx.cn.gov.cn.npmx.cn http://www.morning.yhywr.cn.gov.cn.yhywr.cn http://www.morning.jrplk.cn.gov.cn.jrplk.cn http://www.morning.lstmg.cn.gov.cn.lstmg.cn http://www.morning.paoers.com.gov.cn.paoers.com http://www.morning.pxmyw.cn.gov.cn.pxmyw.cn http://www.morning.qnhcx.cn.gov.cn.qnhcx.cn http://www.morning.rddlz.cn.gov.cn.rddlz.cn http://www.morning.pswqx.cn.gov.cn.pswqx.cn http://www.morning.coatingonline.com.cn.gov.cn.coatingonline.com.cn http://www.morning.zcrjq.cn.gov.cn.zcrjq.cn http://www.morning.mtbsd.cn.gov.cn.mtbsd.cn
