命令安装mariadb10

安装程序初始化。

 wget https://repo.huaweicloud.com/mariadb/mariadb-10.6.2/bintar-linux-systemd-x86_64/mariadb-10.6.2-linux-systemd-x86_64.tar.gz

tar -zxvf mariadb-10.6.2-linux-systemd-x86_64.tar.gz

./scripts/mysql_install_db --user=mysql --basedir=$(pwd) --datadir=$(pwd)/data


启动主mysql数据库
./bin/mysqld --server-id=1 --datadir=$(pwd)/data --port=23401  --log-bin=$(pwd)/logs/mysql-bin.log --socket=$(pwd)/tmp/mysql.sock --log-error=$(pwd)/logs/mysql_error.log


登陆mysql后，配置账号与密码，权限
./bin/mysql --socket=/data/mariadb23401/tmp/mysql.sock 




alter user 'root'@'localhost' identified by '80614621';
grant all privileges on *.* to 'root'@'*' identified by '80614621' with grant option;
flush privileges;




安装程序初始化。
./scripts/mysql_install_db --user=mysql --basedir=$(pwd) --datadir=$(pwd)/data


启动主mysql数据库，此次不支持相关参数
./bin/mysqld --server-id=2 --mysqlx=off --datadir=$(pwd)/data --port=23402  --log-bin=$(pwd)/logs/mysql-bin.log --socket=$(pwd)/tmp/mysql.sock --log-error=$(pwd)/logs/mysql_error.log --master-host=127.0.0.1 --master-port=23401 --master-user=root --master-password=80614621 --relay-log=$(pwd)/logs/mysql-relay-bin.log --skip_log_replica_updates --read-only