2017年06月07日

CentOS7 MariaDB 5.5.52 (バンドル)


vi /etc/my.cnf

systemctl enable mariadb.service

systemctl start mariadb.service

mysql_secure_installation


mysql -u root -p

Screenshot from 2017-06-07 14-34-48.png

SHOW variables like 'character_set%';
Screenshot from 2017-06-07 14-34-48.png
文字コードりセットは、最初にやっておく。


Screenshot from 2017-06-08 13-17-58.png

ls /usr/share/mysql/my*.cnf
Screenshot from 2017-06-07 16-35-13.png



/usr/share/mysql/my-huge.cnf
/usr/share/mysql/my-medium.cnf
/usr/share/mysql/my-innodb-heavy-4G.cnf
/usr/share/mysql/my-small.cnf
/usr/share/mysql/my-large.cnf

cp /usr/share/mysql/my-lage.cnf /etc/my.cnf.d/server.cnf
cp /usr/share/mysql/my-huge.cnf /etc/my.cnf.d/server.cnf
cp /usr/share/mysql/my-large.cnf /etc/my.cnf.d/server.cnf
cp /usr/share/mysql/my-innodb-heavy-4G.cnf /etc/my.cnf.d/server.cnf

vi /etc/my.cnf.d/server.cnf
[client]
default-character-set = utf8
[mysqld]
character-set-server = utf8






https://downloads.mariadb.org/mariadb/repositories/#mirror=yamagata-university&distro=CentOS&distro_release=centos7-amd64--centos7&version=10.1

CentOS7のMariaDB5.5を10.1にアップグレードする
http://qiita.com/egnr-in-6matroom/items/6dbb684ff03a228947bd



/etc/yum.repos.d/MariaDB.repo
-------------------------------------------------------------------------------------
# MariaDB 10.1 CentOS repository list

[mariadb]
name = MariaDB
gpgcheck=1
-------------------------------------------------------------------------------------
sudo systemctl stop mariadb
sudo yum update mariadb-server -y
sudo systemctl start mysql


SHOW variables like 'character_set%';
Screenshot from 2017-06-07 17-12-18.png



posted by a23 at 14:30| Comment(0) | MySQL
この記事へのコメント
コメントを書く
お名前:

メールアドレス:

ホームページアドレス:

コメント: