1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91
| rpm -qa | grep mariadb
rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64
rpm -qa | grep mysql
rpm -e --nodeps XXX
rm -rf /usr/lib64/libLLVM-7.so
rpm -qa | grep mysql
whereis mysql
tar -zxvf mysql-8.0.33-el7-x86_64.tar.gz
mv mysql-8.0.33-el7-x86_64 /usr/local/mysql
mkdir /usr/local/mysql/{data,log,run}
groupadd mysql
useradd -g mysql mysql
chown -R mysql:mysql /usr/local/mysql
touch /usr/local/mysql/log/mysqld_safe_error.log
chown -R mysql:mysql /usr/local/mysql/log/mysqld_safe_error.log
vim /etc/my.cnf
cd /usr/local/mysql/bin
./mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data/ --initialize
./mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data/ --initialize --lower-case-table-names=1
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
service mysqld start
service mysqld stop
service mysqld restart
service mysqld status
cd /usr/local/mysql/
./bin/mysql -u root -p
grep -e 'temporary' /usr/local/mysql/log/alert.log
alter user root@localhost identified by '123456';
set global validate_password_policy=LOW;
set global validate_password_length=6;
SHOW VARIABLES LIKE 'validate_password%';
use mysql;
update user set user.Host='%' where user.User='root';
flush privileges;
exit;
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload
|