https://downloads.mariadb.org/
cd /usr/local/src
lynx https://github.com/Kitware/CMake/releases/download/v3.15.5/cmake-3.15.5.tar.gz
tar zxf cmake-3.15.5.tar.gz
cd cmake-3.15.5
./configure
make
make test
make install
make clean
/usr/local/bin/cmake
cd /usr/local/src
lynx http://ftp.yz.yamagata-u.ac.jp/pub/dbms/mariadb//mariadb-5.5.66/source/mariadb-5.5.66.tar.gz
tar zxf mariadb-5.5.66.tar.gz
cd mariadb-5.5.66
/usr/local/bin/cmake . -LH
/usr/local/bin/cmake . -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci
make
make test
make install
make clean
cd /usr/local/mysql
useradd -r -s /sbin/nologin mysql
chown -R mysql .
chgrp -R mysql .
scripts/mysql_install_db --user=mysql
cd mysql-test
perl mysql-test-run.pl
chown -R root .
chown -R mysql data
cp support-files/my-huge.cnf /etc/my.cnf
cp support-files/mysqld_multi.server /etc/init.d/mysql.server
vi /etc/my.cnf
character-set-server = utf8
collation-server = utf8_general_ci
default_storage_engine = MyISAM
#default_storage_engine = InnoDB
/usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/data &
/usr/local/mysql/bin/mysqladmin -u root password '新密碼'
/usr/local/mysql/bin/mysql_secure_installation
/usr/local/mysql/bin/mysql -u root -p
use mysql;
delete from user where Host <> 'localhost' or User <> 'root';
exit;
新增時間 | 2020-01-22 |
最後更新 | 2022-02-09 |