MySQL

 

(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


chown mysql:mysql /etc/my.cnf

 

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 &

ps -ef | grep 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

ps -ef | grep mysql

 

(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

 

(2012R2)

https://dev.mysql.com/downloads/installer/