(16)
apt install mysql-server mysql-client
systemctl enable mysql
systemctl restart mysql
systemctl status mysql
mysql -u root -p
(18)
apt install mysql-server mysql-client
mysql_secure_installation
systemctl enable mysql
systemctl restart mysql
systemctl status mysql
mysql -u root -p
(9)
リポジトリからインストールするとMairaDBとなるため、ソースからインストールする
https://qiita.com/dribble13/items/20c769f1e94eceac0186
※ディスクは40Gをシンプロビジョニング
wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.17.tar.gz
apt -y install cmake
groupadd mysql
useradd -g mysql -s /bin/bash mysql
tar xvzf mysql-8.0.17.tar.gz
cd mysql-8.0.17
apt -y install g++ build-essential
mkdir -p /root/boost
apt -y install libssl-dev libncurses5-dev pkg-config
cmake -DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DFORCE_INSOURCE_BUILD=1 \
-DDOWNLOAD_BOOST=1 -DWITH_BOOST=/root/boost
make
make install
chown -R mysql:mysql /usr/local/mysql
mkdir /var/lib/mysql
/usr/local/mysql/bin/mysqld --user=mysql --initialize-insecure --basedir=/usr/local/mysql --datadir=/var/lib/mysql
chown -R mysql:mysql /var/lib/mysql/*
vim /etc/my.cnf
[mysqld]
character_set_server = utf8mb4
max_connections = 300
max_allowed_packet = 1M
max_heap_table_size = 16M
table_open_cache = 500
sort_buffer_size = 2M
read_buffer_size = 128K
read_rnd_buffer_size = 256K
join_buffer_size = 128K
tmp_table_size = 16M
innodb_buffer_pool_size = 800M
innodb_log_file_size = 128M
innodb_log_buffer_size = 20M
su - mysql
vim .profile
export PATH=/usr/local/mysql/bin:$PATH
. .profile
--起動
/usr/local/mysql/bin/mysqld --pid-file=/var/lib/mysql/mysqld.pid --datadir=/var/lib/mysql &
--接続確認(パスワード設定前)
/usr/local/mysql/bin/mysql -u root --socket=/tmp/mysql.sock
--パスワード設定
set password for 'root'@'localhost' = 'Aaa!1234';
flush privileges;
--接続確認
/usr/local/mysql/bin/mysql -u root -h localhost -p
--停止
/usr/local/mysql/bin/mysqladmin -u root -h localhost -p shutdown
(7)
--mariaDB削除
yum remove -y mariadb-libs
rm -rf /var/lib/mysql/
--yum リポジトリの追加
yum install -y https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm
yum info mysql-community-server
--インストール
yum install -y mysql-community-server
mysqld --version
--DB起動
systemctl enable mysqld.service
systemctl start mysqld.service
systemctl status mysqld.service
--初期パスワードの確認
cat /var/log/mysqld.log | grep password
--セキュリティ設定
mysql_secure_installation
--設定ファイルによる設定
vim /etc/my.cnf
[mysqld]
character_set_server = utf8mb4
max_connections = 300
max_allowed_packet = 1M
max_heap_table_size = 16M
table_open_cache = 500
sort_buffer_size = 2M
read_buffer_size = 128K
read_rnd_buffer_size = 256K
join_buffer_size = 128K
tmp_table_size = 16M
innodb_buffer_pool_size = 800M
innodb_log_file_size = 128M
innodb_log_buffer_size = 20M
systemctl stop mysqld.service
systemctl start mysqld.service
systemctl status mysqld.service
--DB接続
mysql -u root -p
- Windows Server
(2012R2)
https://dev.mysql.com/downloads/installer/