做mla的网站,工作网站开发制作,用pc网站建设手机网站,手机微网站怎么制作的文章目录 Linux——MySQL5.7编译安装、RPM安装、yum安装一、编译安装二、RPM安装三、yum安装 Linux——MySQL5.7编译安装、RPM安装、yum安装 卸载mysql # 查看是否安装了mysql
[rootcsq ~]# rpm -qa |grep mysql
mysql-community-server-5.7.36-1.el7.x86_64
mysql-community-c… 文章目录 Linux——MySQL5.7编译安装、RPM安装、yum安装一、编译安装二、RPM安装三、yum安装 Linux——MySQL5.7编译安装、RPM安装、yum安装 卸载mysql # 查看是否安装了mysql
[rootcsq ~]# rpm -qa |grep mysql
mysql-community-server-5.7.36-1.el7.x86_64
mysql-community-common-5.7.36-1.el7.x86_64
mysql-community-client-5.7.36-1.el7.x86_64
mysql-community-libs-5.7.36-1.el7.x86_64
# 停止mysql服务器并删除mysql
[rootcsq ~]# systemctl stop mysqld
# 卸载
[rootcsq ~]# rpm -ev mysql-community-server-5.7.36-1.el7.x86_64
[rootcsq ~]# rpm -ev mysql-community-common-5.7.36-1.el7.x86_64 --nodeps
[rootcsq ~]# rpm -ev mysql-community-client-5.7.36-1.el7.x86_64
[rootcsq ~]# rpm -ev mysql-community-libs-5.7.36-1.el7.x86_64 --nodeps
# 删除mysql目录文件和库
[rootcsq ~]# find / -name mysql
[rootcsq ~]# rm -rf /var/lib/mysql
[rootcsq ~]# rm -rf /etc/my.cnf
# 删除mysql用户及组
[rootcsq ~]# id mysql
uid27(mysql) gid27(mysql) groups27(mysql)
[rootcsq ~]# userdel mysql
[rootcsq ~]# groupdel mysql
[rootcsq ~]# cat /etc/passwd |grep mysql
[rootcsq ~]# cat /etc/group |grep mysql
# 再次查询
[rootcsq ~]# whereis mysql一、编译安装 安装依赖包 [rootcsq ~]# yum -y install ncurses ncurses-devel openssl-devel bison gcc gcc-c make cmake wget下载 wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-boost-5.7.27.tar.gz创建mysql目录 mkdir /usr/local/mysql创建mysql用户 useradd -r mysql -M -s /sbin/nologin
# -r建立一个系统账号
# -M强制不要建立使用者家目录
# -s指定登陆者的shell解压并编译安装 # 解压
tar -zxvf mysql-boost-5.7.27.tar.gz -C /usr/local/
# 切换到编译目录
cd /usr/local/mysql-5.7.27/
# 编译安装
cmake . \
-DWITH_BOOSTboost/boost_1_59_0/ \
-DCMAKE_INSTALL_PREFIX/usr/local/mysql \
-DSYSCONFDIR/etc \
-DMYSQL_DATADIR/usr/local/mysql/data \
-DINSTALL_MANDIR/usr/share/man \
-DMYSQL_TCP_PORT3306 \
-DMYSQL_UNIX_ADDR/tmp/mysql.sock \
-DDEFAULT_CHARSETutf8 \
-DEXTRA_CHARSETSall \
-DDEFAULT_COLLATIONutf8_general_ci \
-DWITH_READLINE1 \
-DWITH_SSLsystem \
-DWITH_EMBEDDED_SERVER1 \
-DENABLED_LOCAL_INFILE1 \
-DWITH_INNOBASE_STORAGE_ENGINE1make make install参数详解
cmake . \
-DWITH_BOOSTboost/boost_1_59_0/ \ # 指定使用Boost库的路径和版本
-DCMAKE_INSTALL_PREFIX/usr/local/mysql \ # 指定MySQL的安装目录为/usr/local/mysql
-DSYSCONFDIR/etc \ # 指定MySQL的配置文件目录为/etc即将生成的配置文件放在该目录下
-DMYSQL_DATADIR/usr/local/mysql/data \ # 指定MySQL的数据目录为/usr/local/mysql/data即将数据库文件存储到该路径
-DINSTALL_MANDIR/usr/share/man \ # 指定MySQL的man手册安装路径为/usr/share/man即将生成的man手册安装到该目录
-DMYSQL_TCP_PORT3306 \ # 指定MySQL的TCP端口为3306即在运行MySQL时使用该端口进行通信
-DMYSQL_UNIX_ADDR/tmp/mysql.sock \ # 指定MySQL的Unix套接字路径为/tmp/mysql.sock即MySQL通过Unix套接字进行本地通信
-DDEFAULT_CHARSETutf8 \ # 指定MySQL的默认字符集为utf8即在创建数据库和表时使用UTF-8字符集
-DEXTRA_CHARSETSall \ # 设置MySQL支持所有额外字符集
-DDEFAULT_COLLATIONutf8_general_ci \ # 指定MySQL的默认排序规则为utf8_general_ci即在比较和排序时使用UTF-8字符集的默认规则
-DWITH_READLINE1 \ # 启用MySQL的Readline库支持用于命令行交互的编辑和历史记录功能
-DWITH_SSLsystem \ # 指定使用系统提供的SSL库用于启用MySQL的SSL连接支持
-DWITH_EMBEDDED_SERVER1 \ # 启用MySQL的嵌入式服务器功能允许将MySQL嵌入到其他应用程序中
-DENABLED_LOCAL_INFILE1 \ # 启用MySQL的本地数据导入功能允许从客户端加载本地文件到数据库中
-DWITH_INNOBASE_STORAGE_ENGINE1 # 启用InnoDB存储引擎该引擎提供了事务支持和行级锁定初始化 # 设置mysql根目录文件属主和属组
[rootcsq ~]# chown -R mysql:mysql /usr/local/mysql/
# 进入mysql安装目录
[rootcsq ~]# cd /usr/local/mysql/
# 更新PATH环境变量使可以在任何目录下执行mysql命令行工具
[rootcsq mysql]# echo export PATH${PATH}:/usr/local/mysql/bin/ /etc/profile
[rootcsq mysql]# source /etc/profile
# 初始化
mysqld --initialize --usermysql --basedir/usr/local/mysql --datadir/usr/local/mysql/data
# 执行结束会告诉你mysql登陆密码要记下来 待会要改密码会用到
# --initialize: 这个参数告诉MySQL服务器执行初始化操作
# --usermysql: 这个参数指定MySQL服务器以mysql用户身份运行
# --basedir/usr/local/mysql: 这个参数指定MySQL服务器的基础目录即MySQL的安装目录
# --datadir/usr/local/mysql/data: 这个参数指定MySQL的数据目录即数据库文件的存储位置编辑mysql配置文件 vim /etc/my.cnf[mysqld]
basedir/usr/local/mysql
#指定安装目录
datadir/usr/local/mysql/data
#指定数据存放目录启动mysql # 启动mysql
mysqld_safe --usermysql
[rootcsq mysql]# netstat -tlnp |grep 3306
tcp6 0 0 :::3306 :::* LISTEN 14878/mysqld 登陆mysql并修改密码 [rootcsq mysql]# /usr/local/mysql/bin/mysql -uroot -pIWFXDuyi(1fg
mysql alter user rootlocalhost identified by 000000;
mysql exit
[rootcsq mysql]# mysql -uroot -p000000 # 再次使用修改的密码登陆
mysql show databases;
--------------------
| Database |
--------------------
| information_schema |
| mysql |
| performance_schema |
| sys |
--------------------
4 rows in set (0.00 sec)
mysql exit配置mysqld服务的管理工具 [rootcsq support-files]# cd /usr/local/mysql/support-files/
[rootcsq support-files]# cp -rf mysql.server /etc/init.d/mysqld
# 将MySQL服务添加到系统的服务管理列表中
[rootcsq support-files]# chkconfig --add mysqld
# 将MySQL服务设置为在系统启动时自动启动
[rootcsq support-files]# chkconfig mysqld on
# 启动命令
[rootcsq support-files]# service mysqld stop
[rootcsq support-files]# service mysqld start
[rootcsq support-files]# service mysqld restart
[rootcsq support-files]# service mysqld reload
[rootcsq support-files]# service mysqld status
# 或者
[rootcsq ~]# systemctl start mysqld
[rootcsq ~]# systemctl stop mysqld二、RPM安装 下载地址https://downloads.mysql.com/archives/community/ # 下载
[rootcsq ~]# wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.36-1.el7.x86_64.rpm-bundle.tar
# 解压按照顺序安装rpm软件包 [rootcsq ~]# rpm -ivh mysql-community-common-5.7.36-1.el7.x86_64.rpm
[rootcsq ~]# rpm -ivh mysql-community-libs-5.7.36-1.el7.x86_64.rpm
[rootcsq ~]# rpm -ivh mysql-community-devel-5.7.36-1.el7.x86_64.rpm
[rootcsq ~]# rpm -ivh mysql-community-libs-compat-5.7.36-1.el7.x86_64.rpm
[rootcsq ~]# rpm -ivh mysql-community-client-5.7.36-1.el7.x86_64.rpm
[rootcsq ~]# yum install -y net-tools
[rootcsq ~]# rpm -ivh mysql-community-server-5.7.36-1.el7.x86_64.rpm
# 验证
[rootcsq ~]# whereis mysql
mysql: /usr/bin/mysql /usr/lib64/mysql /usr/include/mysql /usr/share/mysql /usr/share/man/man1/mysql.1.gz启动mysql # 查看服务状态
[rootcsq ~]# systemctl status mysqld
● mysqld.service - MySQL ServerLoaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)Active: inactive (dead) since Tue 2024-05-07 14:50:20 CST; 20s agoDocs: man:mysqld(8)http://dev.mysql.com/doc/refman/en/using-systemd.html
# 初始化数据库
[rootcsq ~]# mysqld --initalize --console
# 授权
[rootcsq ~]# chown -R mysql:mysql /var/lib/mysql
# 启动
[rootcsq ~]# systemctl start mysqld
[rootcsq ~]# systemctl status mysqld
● mysqld.service - MySQL ServerLoaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)Active: active (running) since Tue 2024-05-07 14:55:09 CST; 3s agoDocs: man:mysqld(8)http://dev.mysql.com/doc/refman/en/using-systemd.htmlProcess: 24825 ExecStart/usr/sbin/mysqld --daemonize --pid-file/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (codeexited, status0/SUCCESS)Process: 24807 ExecStartPre/usr/bin/mysqld_pre_systemd (codeexited, status0/SUCCESS)Main PID: 24830 (mysqld)CGroup: /system.slice/mysqld.service└─24830 /usr/sbin/mysqld --daemonize --pid-file/var/run/mysqld/mysqld.pidMay 07 14:55:09 csq systemd[1]: Starting MySQL Server...
May 07 14:55:09 csq systemd[1]: Started MySQL Server.查看临时密码登陆mysql改密码 [rootcsq ~]# cat /var/log/mysqld.log |grep password 2024-05-07T06:29:54.096170Z 1 [Note] A temporary password is generated for rootlocalhost: enk8:(8wlWf
[rootcsq ~]# mysql -u root -penk8:(8wlWf
mysql alter user rootlocalhost identified by 123456;
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
# 设置密码的验证强度等级设置为low
mysql set global validate_password_policyLOW;
Query OK, 0 rows affected (0.00 sec)
# 设置密码长度为6
mysql set global validate_password_length6;
Query OK, 0 rows affected (0.00 sec)
# 设置密码只要满足6位数长度即可
mysql ALTER USER rootlocalhost IDENTIFIED BY 123456;
Query OK, 0 rows affected (0.00 sec)mysql show databases;
--------------------
| Database |
--------------------
| information_schema |
| mysql |
| performance_schema |
| sys |
--------------------
4 rows in set (0.00 sec)
mysql exit三、yum安装 安装依赖包 [rootcsq ~]# yum install -y perl net-tools下载地址http://repo.mysql.com/ [rootcsq ~]# wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
[rootcsq ~]# rpm -ivh mysql-community-release-el7-5.noarch.rpm 如果要安装mysql5.7版本可以设置一下yum仓库 vim /etc/yum.repos.d/mysql-community.repo
# 文件中会显示5.55.65.7的版本把5.7版本下的enabled0改成1
# 把默认5.6版本下的enabled1改成0然后再进行安装就可以了yum安装mysql-5.7 [rootcsq ~]# yum install -y mysql-server
[rootcsq ~]# mysql --version
mysql Ver 14.14 Distrib 5.7.44, for Linux (x86_64) using EditLine wrapper开启mysql服务 [rootcsq ~]# systemctl start mysqld
[rootcsq ~]# systemctl status mysqld
● mysqld.service - MySQL ServerLoaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)Active: active (running) since Tue 2024-05-07 15:37:13 CST; 4s agoDocs: man:mysqld(8)登陆mysql修改密码 [rootcsq ~]# cat /var/log/mysqld.log |grep password
[rootcsq ~]# mysql -uroot -piywr#:Wo3yZ
mysql alter user rootlocalhost identified by 123456;
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
mysql set global validate_password_policyLOW;
Query OK, 0 rows affected (0.00 sec)mysql
mysql set global validate_password_length6;
Query OK, 0 rows affected (0.00 sec)mysql ALTER USER rootlocalhost IDENTIFIED BY 123456;
Query OK, 0 rows affected (0.00 sec)mysql show databases;
--------------------
| Database |
--------------------
| information_schema |
| mysql |
| performance_schema |
| sys |
--------------------
4 rows in set (0.00 sec)
