1 首先安装完成jdk,方法如上一篇文章
如果wget命令无效则输入如下指令安装(command not found):
yum -y install wget
2 安装mysql -yum源,可以自己下载,下载地址(百度搜索mysql yum源):
https://dev.mysql.com/downloads/repo/yum/
下载完成后可以透过远程软件传到linux文件夹中,也可以用wget自行在linux环境下载
3 安装yum源,输入命令
[root@localhost soft]# yum localinstall mysql57-community-release-el7-11.noarch.rpm
已加载插件:fastestmirror
正在检查 mysql57-community-release-el7-11.noarch.rpm: mysql57-community-release-el7-11.noarch
mysql57-community-release-el7-11.noarch.rpm 将被安装
正在解决依赖关系
--> 正在检查事务
---> 软件包 mysql57-community-release.noarch.0.el7-11 将被 安装
--> 解决依赖关系完成
依赖关系解决
================================================================================
Package 架构 版本 源 大小
================================================================================
正在安装:
mysql57-community-release
noarch el7-11 /mysql57-community-release-el7-11.noarch 31 k
事务概要
================================================================================
安装 1 软件包
总计:31 k
安装大小:31 k
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
正在安装 : mysql57-community-release-el7-11.noarch 1/1
验证中 : mysql57-community-release-el7-11.noarch 1/1
已安装:
mysql57-community-release.noarch 0:el7-11
完毕!
4 下载并安装mysql,输入命令,看到如下图
a. 安装之前可以输入如下命令,检查yum源是否安装成功
yum repolist enabled | grep "mysql.*-community.*"
b.输入如下命令开始安装
yum install mysql-community-server
5. 启动mysql
service mysqld start //启动mysql
chkconfig --add mysqld //加入系统服务
chkconfig mysqld on //开机自动启动
systemctl start mysqld #启动mysql
systemctl enable mysqld #设置开机启动
systemctl daemon-reload
6.登录mysql
mysql安装成功后会生成一个随机密码,存放在/var/log/mysqld.log
grep 'temporary password' /var/log/mysqld.log
2017-06-13T14:30:34.802886Z 1 [Note] A temporary password is generated for root@localhost: dsA&abJxe7Ju
mysql -uroot -p #输入上面获取到的初始密码进入mysql修改密码
打开找到密码并登陆
set password = password('root')
如果不允许设置简单密码,则输入这两句,第一句表示可以设定纯数字或字母,第二句表示密码长度最低4位
mysql> set global validate_password_policy=0;
Query OK, 0 rows affected (0.00 sec)
mysql> set global validate_password_length=4;
Query OK, 0 rows affected (0.01 sec)
set password=password('root');
Query OK, 0 rows affected, 1 warning (0.00 sec)
7.开启 允许mysql远程登录(mysql默认只能本地登录)
登录mysql后输入如下命令
mysql> grant all privileges on *.* to 'root' @'%' identified by 'root';
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> flush privileges;
8.开启Linux 3306对外访问的端口
[root@localhost /]# /sbin/iptables -I INPUT -p tcp --dport 3306 -j ACCEPT
[root@localhost /]# /etc/rc.d/init.d/iptables save #将设置保存到防火墙内
9.配置默认编码为UTF-8
修改/etc/my.cnf文件,在[mysqld]下面配置:
[mysqld]
character_se_server=utf8
init_connect='SET NAMES utf8'
也可以在mysql窗口内输入:
- mysql> SET character_set_client = utf8 ;
- mysql> SET character_set_connection = utf8 ;
- mysql> SET character_set_database = utf8 ;
- mysql> SET character_set_results = utf8 ;
- mysql> SET character_set_server = utf8 ;
-
- mysql> SET collation_connection = utf8 ;
- mysql> SET collation_database = utf8 ;
- mysql> SET collation_server = utf8
10.尝试远程连接,完成mysql安装