✨✨ 欢迎大家来到小伞的大讲堂✨✨养成好习惯先赞后看哦~所属专栏MySQL小伞的主页xiaosan_bloggitee:许星让 (xu-xingrang) - Gitee.com制作不易点个赞吧谢谢喵说明安装与卸载中用户全部切换成为root一旦 安装普通用户能使用的初期练习mysql不进行用户管理全部使用root进行尽快适应mysql语句后面学了用户管理在考虑新建普通用户1、卸载不要的环境有时候会默认存在ps ajx |grep mariadb # 先检查是否有mariadb存在 13134 14844 14843 13134 pts/0 14843 S 1005 0:00 grep --colorauto mariadb 19010 19187 19010 19010 ? -1 Sl 27 16:55 /usr/libexec/mysqld -- basedir/usr --datadir/var/lib/mysql --plugin-dir/usr/lib64/mysql/plugin -- log-error/var/log/mariadb/mariadb.log --pid-file/var/run/mariadb/mariadb.pid --socket/var/lib/mysql/mysql.sock systemctl stop mariadb.service # 停⽌mariadb 服务 AUTHENTICATING FOR org.freedesktop.systemd1.manage-units Authentication is required to manage system services or units. Authenticating as: root Password: AUTHENTICATION COMPLETE ps axj |grep mariadb # 停⽌完成 13134 14976 14975 13134 pts/0 14975 S 1005 0:00 grep --colorauto mariadb2、检查系统安装包rpm -qa | grep mariadb rpm -qa | grep mysql ------------------------------//样例 mysql-community-common-5.7.41-1.el7.x86_64 mysql-community-server-5.7.41-1.el7.x86_64 mysql57-community-release-el7-11.noarch mysql-community-client-5.7.41-1.el7.x86_64 mysql-community-libs-5.7.41-1.el7.x86_643、我们要卸载这些默认安装包#卸载显⽰出来的mariadb/mysql安装包 sudo yum remove mariadb4、获取mysql官方yum源#1获取mysql官方yum源 http://repo.mysql.com/#一定要看下面的文字如果后面自己安装不成功就看看这个# 注意最好安装和自己系统一致的mysq版本否则可能会存在软件兼容性问题#查看自己的系统版本# [rootvM-0-2-centos ~]# cat /etc/redhat-release# Cent0s Linux release 7.8.2003 (Core) # 可以进入 http://repo.mysql.com/找一下和自己版本一致的资源8# 下载到你的本地然后上传到你的Linux服务器我们下载mysql157的为了看清是Centos 7 的后续版本号查看页面源代码这里我们的版本号是Centos 7.6的所以选择下载.rpm的通用版本这里为我版本的下载请查询自己的版本进行寻找5、安装mysql yum源对比前后##安装前查看本地的yum源##安装中安装指令rpm -Uvh xxxxx.rpm##出错信息warning: mysql57-community-release-el7.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY error: cant create transaction lock on /var/lib/rpm/.rpm.lock (Permission denied)换成root用户安装sudo rpm -Uvh mysql57-community-release-el7.rpm##安装后##表明已经安装完成6、看看是否能正常工作7、安装mysql服务sudo yum install -y mysql-community-server##可能会出现秘钥过期的问题 Failing package is: mysql-community-client-5.7.39-1.el7.x86_64 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql 解决⽅案这个会获取网址中的秘钥然后重新安装即可 rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-20228、查看配置文件和数据存储位置[rootiZ2vc09opqmjec5hsbsi0aZ ~]# ls /etc/my.cnf /etc/my.cnf[rootiZ2vc09opqmjec5hsbsi0aZ ~]# sudo ls /var/lib/mysql auto.cnf client-cert.pem ibdata1 ibtmp1 mysql.sock.lock public_key.pem sys ca-key.pem client-key.pem ib_logfile0 mysql performance_schema server-cert.pem ca.pem ib_buffer_pool ib_logfile1 mysql.sock private_key.pem server-key.pem9、启动服务systemctl start mysqld.service AUTHENTICATING FOR org.freedesktop.systemd1.manage-units Authentication is required to manage system services or units. Authenticating as: root Password: AUTHENTICATION COMPLETE 10、查看启动服务11、登录方法一获取临时root密码##获取临时root密码 sudo grep temporary password /var/log/mysqld.log #使⽤临时密码登录 mysql -uroot -p #判断修改密码时候新密码是否符合当前的策略不满⾜报错不让修改关闭它 #安全强度默认为中即1要求必须包含 数字、符号、⼤⼩写字⺟⻓度⾄少为8位 mysql set global validate_password_policy0; Query OK, 0 rows affected (0.00 sec) #密码最⼩⻓度 mysql set global validate_password_length1; Query OK, 0 rows affected (0.00 sec) #修改本地登录密码暂不授权远程登录 mysql ALTER USER rootlocalhost IDENTIFIED BY qwerwu.888; Query OK, 0 rows affected (0.00 sec) mysql FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) #如果你安装的最新的mysql没有所谓的临时密码root默认没有密码12、登录方法二最新mysql默认没有密码# 如果你安装的最新的mysql没有所谓的临时密码root默认没有密码 # 试着直接client登陆⼀下13、登录方法三修改配置文件无需密码登录vim /etc/my.cnf # 打开mysql配置⽂件 在[mysqld]最后⼀栏配置(不知道是什么就放在配置⽂件最后) 加⼊: skip-grant-tables 选项, 并保存退出 systemctl restart mysqld # 重启mysql服务 mysql -uroot ##回车即可14、设置开机自启动#开启开机⾃启动 systemctl enable mysqld systemctl daemon-reload15、配置my.cnf#配置⼀下my.conf,主要是数据库客⼾端和服务器的编码格式 [whbVM-0-3-centos 9.9]$ cat /etc/my.cnf # For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html [mysql] #default-character-setutf8 暂不设置mysql有bug汉字不回显 [mysqld] # # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. # innodb_buffer_pool_size 128M # # Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. # log_bin # # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. # join_buffer_size 128M # sort_buffer_size 2M # read_rnd_buffer_size 2M --------------------------------------------------------- ##这里添加 port3306 datadir/var/lib/mysql character-set-serverutf8 default-storage-engineinnodb --------------------------------------------------------- socket/var/lib/mysql/mysql.sock # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links0 log-error/var/log/mysqld.log pid-file/var/run/mysqld/mysqld.pid # 配置完毕重启mysql即可mysql 已经配置了客户端服务器utf8编码但是无法输入中文mysql 已经配置了客⼾端服务器utf8编码但是⽆法输⼊中⽂ 确保您在终端命令⾏中可以输⼊中⽂ [whbVM-0-3-centos ~]$ env |grep LANG LANGen_US.utf816、退出mysqlmysql quit