在线安装
1.安装前看是否安装过mysql,如果有就卸载mysql
yum list installed mysql*
2.通过RPM方式安装mysql（二选一）
wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
rpm -ivh mysql-community-release-el7-5.noarch.rpm
3.通过源方式安装mysql（二选一）
- 查看yum库下是否有mysql-server
yum list | grep mysql 或 yum -y list mysql*
- 通过YUM方式进行安装
yum install mysql-server
yum install mysql-devel
4.修改mysql配置文件
vim /etc/my.cnf
在[mysqld]中加入
character-set-server=utf8
5.启动mysql服务
service mysqld start
修改密码
1.修改配置文件
vim /etc/my.cnf
#添加一行
skip-grant-tables
2.重启mysql
重启mysql
service mysql restart
3.进入mysql修改密码
mysql
use mysql ;
UPDATE user SET password='password' WHERE user='root';
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
4.查询授权情况
SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;
5.还原配置文件并重启mysql
vim /etc/my.cnf
#添加一行
# skip-grant-tables
卸载mysql
1.查看是否安装mysql
yum list installed mysql*
2.卸载软件
yum remove mysql-community-client mysql-community-common mysql-community-libs mysql-community-libs-compat mysql-community-server mysql-community-release
3.卸载配置文件
rm -rf /var/lib/mysql
rm /etc/my.cnf
4.检查安装
rpm -qa | grep -i mysql
5.清除余项，并删除文件
whereis mysql
rm -rf /usr/share/mysql
通过DOCKER安装MYSQL（推荐）
1.搜索mysql容器
docker search mysql
2.拉取容器
docker pull docker.io/mysql:5.7
3.创建用于挂载的目录
mkdir -p /data/mysql/datadir #用于挂载mysql数据文件
mkdir -p /data/mysql/conf.d #用于挂载mysql配置文件
4.使用镜像创建容器
docker run --name mysql -p 3306:3306 -v /data/mysql/datadir:/var/lib/mysql -v /data/mysql/conf.d:/etc/mysql/conf.d -v /data/mysql/my.cnf:/etc/mysql/my.cnf -e MYSQL_ROOT_PASSWORD=password -d mysql:5.7
--name：容器名(自定义)
-p：映射宿主主机端口:容器的端口
-v：挂载宿主目录到容器目录
-e：设置环境变量，此处指定root密码
-d：后台运行容器(容器:tar)
其中my.cnf内容
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
[mysqld]
#
# 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
character-set-server=utf8
#skip-grant-tables
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Recommended in standard MySQL setup
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
5.启动容器
docker start containerId
6.停止容器
docker stop containerId
7.删除容器
docker rm containerId
网友评论