MySql教程

CENTOS 8 +mysql

本文主要是介绍CENTOS 8 +mysql,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!
su root

#下载安装用的Yum Repository
wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm

#安装
rpm -ivh mysql-community-release-el7-5.noarch.rpm

#如果Error: Unable to find a match: mysql-community-server
yum module disable mysql

#安装
yum install mysql-community-server

#启动服务
systemctl start  mysqld.service

#查看服务状态
systemctl status mysqld.service

上面安装和启动了mysql 服务;

下面设置与配置mysql服务:

#查看临时密码
grep "password" /var/log/mysqld.log

#进入数据库
mysql -uroot -p

#修改密码(强密码)
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'NEWPASSWORD';

#授权远程连接
mysql> grant all privileges on *.* to 'root'@'%' identified by 'NEWPASSWORD' with grant option;

#刷新
mysql> flush privileges;

修改字符集;

vi /etc/my.cfg

增加几行:

[client]
default-character-set=utf8

[mysqld]
character-set-default=utf8
collation-server=utf8_general_ci

重启mysql

service mysqld restart

这篇关于CENTOS 8 +mysql的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!