一、mysql5.7 rpm 安装(单机)
2021/6/29 19:22:43
本文主要是介绍一、mysql5.7 rpm 安装(单机),对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!
一、下载需要的rpm包
mysql-community-client-5.7.26-1.el6.x86_64.rpm
mysql-community-common-5.7.26-1.el6.x86_64.rpm
mysql-community-libs-5.7.26-1.el6.x86_64.rpm
mysql-community-server-5.7.26-1.el6.x86_64.rpm
下载地址:http://ftp.ntu.edu.tw/MySQL/Downloads/MySQL-5.7/
二、查看之前有没有安装mysql有就卸载
查看:rpm -qa | grep -i mysql
删除之前所有mysql相关的东西
yum -y remove mysql*
注:如果卸载失败使用如下语句
查看:rpm -qa | grep -i mysql
卸载:rpm -e mysql-community-common-5.7.26-1.el6.x86_64 mysql-community-client-5.7.26-1.el6.x86_64 mysql-community-libs-5.7.26-1.el6.x86_64 mysql-community-server-5.7.26-1.el6.x86_64
三、安装mysql
将如下四个rpm包拷贝到/opt下
然后执行
cd /opt
yum install mysql-community-server-5.7.26-1.el6.x86_64.rpm mysql-community-client-5.7.26-1.el6.x86_64.rpm mysql-community-common-5.7.26-1.el6.x86_64.rpm mysql-community-libs-5.7.26-1.el6.x86_64.rpm
service mysqld start #启动mysql
service mysqld stop #关闭mysql
service mysqld status #状态
service mysqld restart #重启
启动失败就:
rm -fr /var/lib/mysql/*
rm /var/lock/subsys/mysqld
killall mysqld
四、设置密码
mysql5.7安装好后默认临时密码放在/var/log/mysqld.log里面了
[root@localhost ~]#grep 'temporary password' /var/log/mysqld.log
[root@master51 mha-soft-student]# mysql -uroot -p"N%;j+r!!s0pr"
可以使用临时密码第一次登陆 mysql
注:如果临时密码里有!这样的字符,就重新初始化数据库,换一个新的初始密码
第一次登陆进去后必须马上修改密码,不然下次登陆会报错。
mysql> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> set global validate_password_policy=0; //只验证长度
注:如果这里设置有误使用mysql> INSTALL PLUGIN validate_password SONAME 'validate_password.so';
参考:https://www.cnblogs.com/alonely/p/10927541.html
mysql> set global validate_password_length=6; //修改密码长度,默认值是8个字符 注:感觉没用
mysql> alter user user()identified by"123456"; //修改登陆密码
查看密码验证策略
mysql> SHOW VARIABLES LIKE 'validate_password%';
上述操作的结果是——更改数据库用户root从本机访问时的密码,设为123456。
退出“mysql> ”环境,重新登录验证,必须采用新的密码才能登入:
[root@master51 mha-soft-student]# mysql -uroot -p"123456"
注:其他节点连接方式 >mysql -h 172.16.16.45 -P 3306 -uroot -p123
修改密码后:mysql>flush privileges;
五、设置所有机器都可以访问mysql服务
mysql> use mysql;
mysql> GRANT ALL ON *.* TO root@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
这句话的意思 ,允许任何IP地址(上面的 % 就是这个意思)的电脑 用admin帐户 和密码(admin)来访问这个MySQL Server
使配置生效
mysql>flush privileges;
查看版本
mysql> select version();
六、修改字符集
修改前
mysql> show variables like 'character_set_%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
vi /etc/my.cnf
[client]
default-character-set=utf8
[mysqld]
default-character-set=utf8
[mysql]
no-auto-rehash
default-character-set=utf8
重启数据库
修改后
mysql> show variables like 'character%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
创建数据库(一定要在修改字符集后在创建数据库,否则字符集不对)
mysql> create database example;
七、客户端问题:
问题:
使用Navicat Premium客户端执行语句成功后总出现如下报错
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
解决方案:
select version(),@@sql_mode;
SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
这篇关于一、mysql5.7 rpm 安装(单机)的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!
- 2024-12-25如何部署MySQL集群资料:新手入门教程
- 2024-12-24MySQL集群部署资料:新手入门教程
- 2024-12-24MySQL集群资料详解:新手入门教程
- 2024-12-24MySQL集群部署入门教程
- 2024-12-24部署MySQL集群学习:新手入门教程
- 2024-12-24部署MySQL集群入门:一步一步搭建指南
- 2024-12-07MySQL读写分离入门:轻松掌握数据库读写分离技术
- 2024-12-07MySQL读写分离入门教程
- 2024-12-07MySQL分库分表入门详解
- 2024-12-07MySQL分库分表入门指南