mysql安装

1.普通安装

1.1 安装

• 下载Mysql源安装包

wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm

• yum安装mysql源

yum localinstall mysql57-community-release-el7-8.noarch.rpm -y

• 检查mysql源是否安装成功

yum repolist enabled | grep "mysql.*-community.*"

• yum安装Mysql

yum install mysql-community-server -y

• 启动Mysql服务

systemctl start mysqld

• 并添加开机启动

systemctl enable mysqld systemctl daemon-reload

• 查看Mysql状态

systemctl status mysqld

• 查看默认的mysql密码

vi /var/log/mysqld.log

修改mysql的密码
登录mysql:

mysql -uroot -p 回车

密码： =>g6hj.Nx4e （上面查看的原始密码）

set password for 'root'@'localhost'=password('Jamie@3975');

• 添加远程登陆的用户权限

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Jamie@3975' WITH GRANT OPTION;

FLUSH PRIVILEGES;

• 修改mysql字符编码

vi /etc/my.cnf

添加

character_set_server=utf8
init_connect='SET NAMES utf8'

• 重启Mysql

systemctl stop mysqld
systemctl start mysqld

• 查看Mysql字符集

show variables like '%character%'

1.2 卸载

rpm -qa|grep -i mysql
yum remove mysql-community-server -y
rpm -ev mysql-community-libs-5.7.24-1.el7.x86_64 --nodeps
//删除文件
find / -name mysql
rm -rf /var/lib/mysql
rm -rf /etc/my.cnf

2.docker安装

• 启动docker后，执行安装命令

docker run --name mysql3307 -p 3307:3306 --privileged=true -ti -e MYSQL_ROOT_PASSWORD=123456 -e MYSQL_DATABASE=my -e MYSQL_USER=user -e MYSQL_PASSWORD=123456 -v /home/mysql/docker-data/3307/conf:/etc/mysql/conf.d -v /home/mysql/docker-data/3307/data/:/var/lib/mysql -v /home/mysql/docker-data/3307/logs/:/var/log/mysql -d mysql:5.7