二进制安装mysql

下载mysql-5.7.35-linux-glibc2.12-x86_64.tar.gz

 

 
rpm -qa | grep mariadb  过滤mariadb
rpm -e mariadb-libs --nodeps    不考虑依赖关系卸载
rpm -qa | grep mariadb  显示没有
cd /usr/local/src
rz上传mysql-5.7.35-linux-glibc2.12-x86_64.tar.gz
tar zxf mysql-5.7.35-linux-glibc2.12-x86_64.tar.gz        解包
mv mysql-5.7.35-linux-glibc2.12-x86_64 /usr/local/mysql        移动目录
mkdir /usr/local/mysql/data            ---创建数据库目录
cd /usr/local/mysql/
groupadd -r mysql
useradd -g mysql -M -s /bin/false -r mysql    
chown -R mysql:mysql /usr/local/mysql/        给数据库权限
vim /etc/my.cnf
[mysqld]
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
pid-file=/usr/local/mysql/data/mysqld.pid
socket=/tmp/mysql.sock
log-error=/usr/local/mysql/data/mysql.err
vim /etc/profile
export PATH=/usr/local/mysql/bin:$PATH        设置环境变量
source /etc/profile
mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data        初始化
cd support-files/
cp mysql.server /etc/init.d/        复制启动脚本
/etc/init.d/mysql.server start        启动数据库
ss -anltp |grep mysql        查看mysql是否启动
grep password /usr/local/mysql/data/mysql.err        过滤密码
<1 grep password /usr/local/mysql/data/mysql.err |awk '{print $NF}'
<2 grep password /usr/local/mysql/data/mysql.err |awk -F ':' '{print $4}'
<3 grep password /usr/local/mysql/data/mysql.err |awk -F 'root@localhost: ' '{print $NF}'
<4 grep password /usr/local/mysql/data/mysql.err |awk -F 'root@localhost: ' '{print $2}'
以上四种均能过滤出密码
a=`grep password /usr/local/mysql/data/mysql.err |awk -F 'root@localhost: ' '{print $NF}'`
echo $mysqlpwd
不进入mysql修改密码为123
mysql -uroot -p${a} -e 'alter user root@localhost identified by"123"' --connect-expired-password
mysql -uroot -p123