本文共 2884 字,大约阅读时间需要 9 分钟。
1、查看是否有mysql
mysql -uroot -p或者yum list installed mysql*或者rpm -qa | grep -i mysql
2、卸载
1.yum remove mysql mysql-server mysql-libs compat-mysql513.rm -rf /var/lib/mysql4.rm /etc/my.cnf
如果装了mysql-devel(其他一样add command),卸载为:
yum remove mysql mysql-devel mysql-server mysql-libs compat-mysql51
输入:y
1、创建用户并添加密码
[root@localhost ~]# adduser yanwang
[root@localhost ~]# passwd yanwang更改用户 zhangbiao 的密码 。新的 密码:无效的密码: 密码未通过字典检查 - 过于简单化/系统化重新输入新的 密码:passwd:所有的身份验证令牌已经成功更新。
2、授权
新创建的用户并不能使用sudo命令,需要给他添加授权。
sudo命令的授权管理是在sudoers文件里的。可以看看sudoers:
[root@localhost ~]# sudoersbash: sudoers: 未找到命令...[root@localhost ~]# whereis sudoerssudoers: /etc/sudoers /etc/sudoers.d /usr/libexec/sudoers.so /usr/share/man/man5/sudoers.5.gz
3、找到这个文件位置之后再查看权限:
[root@localhost ~]# ls -l /etc/sudoers-r--r----- 1 root root 4251 9月 25 15:08 /etc/sudoers
4、是的,只有只读的权限,如果想要修改的话,需要先添加w权限:
[root@localhost ~]# chmod -v u+w /etc/sudoersmode of "/etc/sudoers" changed from 0440 (r--r-----) to 0640 (rw-r-----)
5、然后就可以添加内容了,在下面的一行下追加新增的用户:
[root@localhost ~]# vim /etc/sudoers ## Allow root to run any commands anywher root ALL=(ALL) ALL yanwang ALL=(ALL) ALL #这个是新增的用户
6、wq保存退出,这时候要记得将写权限收回:
[root@localhost ~]# chmod -v u-w /etc/sudoersmode of "/etc/sudoers" changed from 0640 (rw-r-----) to 0440 (r--r-----)
7、这时候使用新用户登录,使用sudo:
[zhangbiao@localhost ~]$ sudo cat /etc/passwd[sudo] password for yanwang: We trust you have received the usual lecture from the local SystemAdministrator. It usually boils down to these three things: #1) Respect the privacy of others. #2) Think before you type. #3) With great power comes great responsibility.
wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
2、下载rpmmysql文件
rpm -ivh mysql80-community-release-el7-3.noarch.rpm
[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-t83LuMm3-1622438877867)(C:\Users\花孜然\AppData\Roaming\Typora\typora-user-images\image-20210531113224808.png)]
yum install mysql-server
输入y确定
systemctl start mysqld
grep 'temporary password' /var/log/mysqld.log
mysql -uroot -p
set global validate_password.policy=0;set global validate_password.length=4;set global validate_password.check_user_name=OFF;set global validate_password.number_count=0;set global validate_password.special_char_count=0;
更改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
使用修改密码登陆
mysql -uroot -p123456
CREATE USER 'root'@'%' IDENTIFIED BY 'wangge' ;授权grant all on *.* to 'root'@'%';ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'wangge';刷新flush privileges
添加端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
重启防火墙
systemctl restart firewalld.service
产看端口
firewall-cmd --list-ports
192.168.0.105
转载地址:http://vmkgf.baihongyu.com/