简单,一是看到事物表面而觉得简单,另一是透彻事物本质而观着简单 #安装mysql5.7.32
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
cmake .. -DCMAKE_INSTALL_PREFIX=/data/application/mysql5.7.32 \ -DMYSQL_DATADIR=/data/application/mysql5.7.32/data \ -DSYSCONFDIR=/data/application/mysql5.7.32/etc \ -DMYSQL_UNIX_ADDR=/data/application/mysql5.7.32/mysql.sock \ -DWITH_INNOBASE_STORAGE_ENGINE=1 \ -DWITH_ARCHIVE_STORAGE_ENGINE=1 \ -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \ -DWITH_SSL=/data/application/openssl1.1.1j \ -DDEFAULT_CHARSET=utf8 \ -DDEFAULT_COLLATION=utf8_general_ci \ -DWITH_PARTITION_STORAGE_ENGINE=1 \ -DENABLED_LOCAL_INFILE=1 \ -DENABLED_PROFILING=0 \ -DWITH_BOOST=/data/software/mysql-5.7.32/boost ./bin/mysqld --initialize-insecure --datadir=/data/application/mysql5.7.32/data ./bin/mysqld_safe --defaults-file=/data/application/mysql5.7.32/etc/my.cnf --user=mysql & |
#安装percona5.7.32
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
cmake .. -DCMAKE_INSTALL_PREFIX=/data/application/percona5.7.32 \ -DMYSQL_DATADIR=/data/application/percona5.7.32/data \ -DSYSCONFDIR=/data/application/percona5.7.32/etc \ -DMYSQL_UNIX_ADDR=/data/application/percona5.7.32/mysql.sock \ -DWITH_INNOBASE_STORAGE_ENGINE=1 \ -DWITH_ARCHIVE_STORAGE_ENGINE=1 \ -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \ -DWITH_SSL=/data/application/openssl1.1.1j \ -DDEFAULT_CHARSET=utf8 \ -DDEFAULT_COLLATION=utf8_general_ci \ -DWITH_PARTITION_STORAGE_ENGINE=1 \ -DENABLED_LOCAL_INFILE=1 \ -DENABLED_PROFILING=0 \ -DWITH_BOOST=/data/software/mysql-5.7.32/boost ./bin/mysqld --initialize-insecure --datadir=/data/application/percona5.7.32/data ./bin/mysqld_safe --defaults-file=/data/application/percona5.7.32/etc/my.cnf --user=mysql & ./bin/mysqld --defaults-file=/data/application/percona5.7.32/etc/my.cnf --user=mysql & |
#安装mariadb10.5.8
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 |
cmake3 .. -DCMAKE_INSTALL_PREFIX=/data/application/mariadb10.5.8 \ -DMYSQL_DATADIR=/data/application/mariadb10.5.8/data \ -DMYSQL_UNIX_ADDR=/data/application/mariadb10.5.8/mysql.sock \ -DSYSCONFDIR=/data/application/mariadb10.5.8/etc \ -DWITH_ARCHIVE_STORAGE_ENGINE=1 \ -DWITH_ARIA_STORAGE_ENGINE=1 \ -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \ -DWITH_CONNECT_STORAGE_ENGINE=1 \ -DWITH_CSV_STORAGE_ENGINE=1 \ -DWITH_FEDERATED_STORAGE_ENGINE=1 \ -DWITH_INNOBASE_STORAGE_ENGINE=1 \ -DWITH_MEMORY_STORAGE_ENGINE=1 \ -DWITH_MYISAM_STORAGE_ENGINE=1 \ -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 \ -DWITH_SEQUENCE_STORAGE_ENGINE=1 \ -DWITH_SPHINX_STORAGE_ENGINE=1 \ -DWITH_XTRADB_STORAGE_ENGINE=1 \ -DDEFAULT_CHARSET=utf8mb4 \ -DDEFAULT_COLLATION=utf8mb4_general_ci \ -DEXTRA_CHARSETS=all \ -DENABLE_PROFILING=1 \ -DENABLED_LOCAL_INFILE=1 \ -DWITH_DEBUG=0 \ -DWITH_LIBWRAP=0 \ -DWITH_READLINE=1 \ -DWITH_SSL=/data/application/openssl1.1.1j ./scripts/mysql_install_db --basedir="/data/application/mariadb10.5.8" --defaults-file="/data/application/mariadb10.5.8/etc/my.cnf" #./bin/mysqld_safe --defaults-file=/data/application/mariadb10.5.8/etc/my.cnf --skip-grant-tables --skip-networking --user=mysql & ./bin/mysqld_safe --defaults-file=/data/application/mariadb10.5.8/etc/my.cnf --user=mysql & mysql -S mysql.sock --ALTER USER 'root'@'localhost' IDENTIFIED VIA mysql_native_password USING PASSWORD('root'); UPDATE mysql.user SET authentication_string = PASSWORD('new_password') WHERE User = 'root' AND Host = 'localhost'; |
[…]