centos7 安装 mysql
1. 卸载MariaDB, centos 7 自带的
[root@esbu-cos7-01 /]# rpm -qa|grep -i mariadb
用命令卸载 rpm -e --nodeps
2. 官网下载
https://dev.mysql.com/downloads/mysql/5.7.html#downloads
3. 解压 tar -xvf
#tar -xvf mysql-5.7.22-1.el7.x86_64.rpm-bundle
由于是.tar包,所以解压的时候要用-xvf,而不要使用-zxvf是解压.tar.gz的
4. install one by one
使用rpm -ivh命令进行安装,安装的时候一定要注意先后顺序,因为有顺序依赖,必须按照顺序来安装。
[root@localhost mysql]# rpm -ivh mysql-community-common-5.7.22-1.el7.x86_64.rpm
warning: mysql-community-common-5.7.22-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:mysql-community-common-5.7.22-1.e################################# [100%]
[root@localhost mysql]# rpm -ivh mysql-community-libs-5.7.22-1.el7.x86_64.rpm
warning: mysql-community-libs-5.7.22-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:mysql-community-libs-5.7.22-1.el7################################# [100%]
[root@localhost mysql]# rpm -ivh mysql-community-client-5.7.22-1.el7.x86_64.rpm
warning: mysql-community-client-5.7.22-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:mysql-community-client-5.7.22-1.e################################# [100%]
[root@localhost mysql]# rpm -ivh mysql-community-server-5.7.22-1.el7.x86_64.rpm
warning: mysql-community-server-5.7.22-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:mysql-community-server-5.7.22-1.e################################# [100%]
[root@localhost mysql]#
如果出错系统已经安装了其他版本的mysql-libs包和mysql数据库文件导致不兼容
解决:# yum remove mysql-libs
5. 启动:
# systemctl start mysqld
查看状态:
# systemctl status mysqld
6. 登陆:
这种方式安装好后,会再my.cnf文件中自动生成一个密码,执行看一下吧:
# cat /var/log/mysqld.log | grep password
7. reset初始密码:
修改密码:set password = password('你的密码');
mysql> SET PASSWORD = PASSWORD('Mysql@12345');
创建对象并赋予权限
grant all privileges on *.* to 'dev' @'%' identified by 'Mysql@123456';
flush privileges;
8. 设置开机自启动
systemctl enable mysqld.service
9. 查看服务当前状态
systemctl status mysqld.service
10.centos7开放及查看端口3306
centos7中的防火墙改成了firewall,使用iptables无作用,开放端口的方法如下:
firewall-cmd --zone=public --add-port=3306/tcp --permanent
命令含义:
--zone #作用域
--add-port=80/tcp #添加端口,格式为:端口/通讯协议
--permanent #永久生效
重启防火墙:
systemctl restart firewalld.service
关闭防火墙:
systemctl stop firewalld.service
查看监听(Listen)的端口
netstat -lntp
检查端口被哪个进程占用
netstat -lnp|grep 8080
11. centos下mysql安装完后是默认:区分表名的大小写,不区分列名的大小写;
root登录,修改/etc/my.cnf,在末尾添加一行:lower_case_table_names=1
lower_case_table_names参数: 0为敏感,1为不敏感。
MySQL在Linux下数据库名、表名、列名、别名大小写规则是这样的:
1、数据库名与表名是严格区分大小写的;
2、表的别名是严格区分大小写的;
3、列名与列的别名在所有的情况下均是忽略大小写的;
4、变量名也是严格区分大小写的;
参考以下文章
查看MariaDB包信息
a) rpm -qi mariadb
install mysql centos7安装mysql-5.7.18-1.el7.x86_64.rpm-bundle.tar
b) rpm -ivh mysql-community-common-5.7.22-1.el7.x86_64.rpm
c) rpm -ivh mysql-community-client-5.7.22-1.el7.x86_64.rpm
d) rpm -ivh mysql-community-server-5.7.22-1.el7.x86_64.rpm
e) rpm -ivh mysql-community-libs-5.7.22-1.el7.x86_64.rpm
CentOS 7.4下使用yum安装MySQL5.7.20 最简单的
b) 默认配置文件路径:
配置文件:/etc/my.cnf
日志文件:/var/log/mysqld.log
服务启动脚本:/usr/lib/systemd/system/mysqld.servicesocket文件:/var/run/mysqld/mysqld.pid
CentOS7下安装步骤如下
查看mysql是否开机启动
b)
systemctl list-unit-files |grep
mysql
首次启动mysql查看密码
a)
[root@esbu-cos7-01 /]# cat
/var/log/mysqld.log |grep password
centos7开放及查看端口
centos7系统服务管理命令systemctl
卸载mysql mariadb
centos下,更改mysql数据库表名大小写敏感
b)