ubuntu14和centos7安装配置mysql

ubuntu14安装配置mysql

1. 安装mysql

   apt-get install mariadb-server #ps:安装过程会提示你输入密码

2. 配置mysql
   编辑/etc/mysql/my.cnf文件

[mysqld]
...
bind-address = 10.0.0.11
default-storage-engine = innodb
innodb_file_per_table
collation-server = utf8_general_ci
init-connect = 'SET NAMES utf8'
character-set-server = utf8

3 重启msql服务

service mysql restart

4 初始化

mysql_secure_installation #由于之前设置过root密码，可以不用设置，然后一路y

centos7安装配置mysql

1. 安装mysql

   yum install mariadb mariadb-server

2. 配置mysql
   编辑/etc/my.cnf文件

[mysqld]
...
bind-address = 10.0.0.11 #ip地址默认为127.0.0.1
default-storage-engine = innodb
innodb_file_per_table
collation-server = utf8_general_ci
init-connect = 'SET NAMES utf8'
character-set-server = utf8

3 重启msql服务

systemctl enable mariadb.service
systemctl start mariadb.service

4 初始化

mysql_secure_installation #先设置root密码，然后一路y