进入mysql官网获取RPM包下载地址
https://dev.mysql.com/downloads/repo/yum/(根据自身的Linux操作系统版本来下载对应的mysql版本)
右击复制链接地址,https://dev.mysql.com/get/mysql57 -社区-释放- el7 - 11. - noarch.rpm
得到这个,这个就是百胜仓库的RPM包其实就是一个下载地址
先下载mysql源安装包
[root@localhost ~] https://dev.mysql.com/get/mysql57 # wget -社区-释放- el7 - 11. - noarch.rpm
bash: wget:未找到命令
我们先安装下wget
Yum安装wget - y
然后执行,wget https://dev.mysql.com/get/mysql57 -社区-释放- el7 - 11. - noarch.rpm
安装mysql源
Yum - y localinstall mysql57 -社区-释放- el7 - 11. - noarch.rpm
Yum - y安装mysql-community-server
下载的东西比较多要稍微等会;
systemctl开始mysqld
[root@localhost ~] # systemctl启用mysqld
[root@localhost ~] # systemctl daemon-reload
mysql安装完成之后,在/var/log/mysqld。日志文件中给根生成了一个临时的默认密码。
root@localhost ~ # vi/var/log/mysqld.日志
这里的临时密码eMV。R # mWe3ha
[root@localhost ~] #, mysql - u root - p
输入密码:,
输入临时密码进入mysql命令行;
mysql>改变用户& # 39;根# 39;@ # 39;localhost # 39;被& # 39;Caofeng2012@& # 39;;
查询好,0行影响(0.00秒)
修改密码为,Caofeng2012@,,(备注mysql5.7默认密码策略要求密码必须是大小写字母数字特殊字母的组合,至少8位),
Mysql默认不允许远程登录,我们需要设置下,并且防火墙开放3306端口;
mysql>所有特权授予alt=" Linux下安装部署Mysql教程">
编辑保存完重启Mysql服务,
[root@localhost ~] # systemctl重启mysqld
[root@localhost ~] #,
查看下编码:
mysql>显示变量如& # 39;%字符% & # 39;;
+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +
| Variable_name,,,,,|值大敌;,,,,,,,,,,|
+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +
| character_set_client,,| utf8,,,,,,,,,,,|
| character_set_connection | utf8,,,,,,,,,,,|
| character_set_database,| utf8,,,,,,,,,,,|
| character_set_filesystem |二进制,,,,,,,,,,|
| character_set_results,| utf8大敌;,,,,,,,,,,|
| character_set_server,,| utf8,,,,,,,,,,,|
| character_set_system,,| utf8,,,,,,,,,,,|
| character_sets_dir,,,|/usr/share/mysql/charsets/|
+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +
8行组(0.00秒)
我们用本机的sqlyog远程连接下虚拟机里的mysql
