参考https://blog.csdn.net/unhejing/article/details/79893219
如果已安装mysql或者安装没成功要删除:https://www.cnblogs.com/nicknailo/articles/8563456.html
官方安装文档
http://dev.mysql.com/downloads/repo/yum/
查看最新版本
1.下载mysql源安装包
wget http://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
2.安装mysql源
yum localinstall mysql57-community-release-el7-11.noarch.rpm
3.查看是否安装成功
yum repolist enabled | grep "mysql.*-community.*"
4.这个指令可以修改安装版本(一般不用改,默认安装你的5.7)
vim /etc/yum.repos.d/mysql-community.repo
5.安装mysql
yum install mysql-community-server
6.启动MySql
systemctl start mysqld
systemctl status mysqld
7.开机自启
systemctl enable mysqld
systemctl daemon-reload
8.修改root本地密码
查看初始密码:
grep 'temporary password' /var/log/mysqld.log
记住给你的初始密码,进去以后首先修改密码
进入mysql
mysql -uroot -p
然后输入初始密码登陆
修改密码(密码要有字母数字和下划线):
mysql>set password for 'root'@'localhost'=password('你的密码');
或者
mysql>ALTER USER 'root'@'localhost' IDENTIFIED BY '你的密码';
注意如果你的密码简单,必须修改两个全局参数:
首先,修改validate_password_policy参数的值,这是在mysql里面设置的
mysql> set global validate_password_policy=0;
再修改密码的长度
mysql> set global validate_password_length=1;
再次执行修改密码就可以了
mysql>set password for 'root'@'localhost'=password('root1234');
或者
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'root1234';
9.授权所有其他机器登陆
创建用户用来远程连接
GRANT ALL PRIVILEGES ON *.* TO 'itoffice'@'%' IDENTIFIED BY 'itoffice' WITH GRANT OPTION;
(第一个itoffice表示用户名,%表示所有的电脑都可以连接,也可以设置某个ip地址运行连接,第二个itoffice表示密码)。
如果提示弱密码看上面
10.配置默认编码为utf8
修改/etc/my.cnf配置文件,在[mysqld]下添加编码配置,如下所示:
重启mysql
systemctl restart mysqld
在进入mysql后在产看是否修改成功
Mysql> show variables like '%character%';
修改前:
修改后:
11.配置文件:/etc/my.cnf
日志文件:/var/log//var/log/mysqld.log
服务启动脚本:/usr/lib/systemd/system/mysqld.service
socket文件:/var/run/mysqld/mysqld.pid
[mysqld]
character_set_server=utf8
init_connect='SET NAMES utf8'
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
query_cache_type= 1
query_cache_size= 512M
local-infile=0
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[root@arjenlee ~]# firewall-cmd --zone=public --add-port=3306/tcp --permanent
success
[root@arjenlee ~]# firewall-cmd --reload
---------------------
作者:unhejing
来源:CSDN
原文:https://blog.csdn.net/unhejing/article/details/79893219
版权声明:本文为博主原创文章,转载请附上博文链接!