Linux环境下安装mysql的数据库
下载新的CentOS-Base.repo 到/etc/yum.repos.d/
curl -o /etc/yum.repos.d/CentOS-Base.repo https://mirrors.aliyun.com/repo/Centos-7.repo
wget -O /etc/yum.repos.d/epel.repo http://mirrors.aliyun.com/repo/epel-7.repo
把服务器的信息包下载到本地,缓存起来
yum makecache
安装MariaBD
yum -y install mariadb mariadb-server
最后出现complete,如下:
启动MariaDB
systemctl start mariadb
注意:如果再次步骤不能启动成功,出现:
Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.
解决方法:
1、输入:cp /usr/share/mysql/my-huge.cnf /etc/my.cnf
2、出现:cp: overwrite ‘/etc/my.cnf’? 输入:y
2、在启动服务:systemctl start mariadb.service
设置开机启动
systemctl enable mariadb
编辑mysql的文件
mysql_secure_installation
测试登录
mysql -uroot -p
配置MariaDB字符集
- 文件:etc/my.cnf
vi /etc/my.cnf
在[mysqld]标签下添加
init_connect='SET collation_connection = utf8_unicode_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshake
- 编辑文件 /etc/my.cnf.d/client.cnf
vi /etc/my.cnf.d/client.cnf
在[client]中添加
default-character-set=utf8
- 文件:/etc/my.cnf.d/mysql-clients.cnf
vi /etc/my.cnf.d/mysql-clients.cnf
在[mysql]中添加
default-character-set=utf8
这几个配置完成之后,重启mariadb
systemctl restart mariadb
查看配置的字符集
使用mysql -uroot -p
进入到数据库中执行下面的命令
show variables like "%character%"; show variables like "%collation%";
给用户授权
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY 'root' WITH GRANT OPTION;
授权生效:
flush privileges