/
搜索到
51
篇与
的结果
-
CentOS7 安装高版本gcc/g++ CentOS7 安装高版本gcc/g++一、安装依赖yum install -y make cmake cmake3 python3 python3-pip git wget curl vim net-tools rpm-build rpmdevtools gcc gcc-c++ bison libaio ncurses-devel perl perl-DBI perl-DBD-MySQL perl-Time-HiRes perl-Data-Dumper readline-devel numactl zlib-devel curldevel boost boost-doc boost-devel bzip2 openssl-devel libtirpc-devel.x86_64 compat-libstdc expat fontconfig freetype libstdc libX11 libXau libxcb libXext libXft libXi libXrender perl-Digest-MD51.1 安装 devtoolsetyum localinstall -y devtoolset-11-binutils-2.36.1-1.el7.2.x86_64.rpm devtoolset-11-binutils-devel-2.36.1-1.el7.2.x86_64.rpm devtoolset-11-gcc-11.2.1-9.el7.x86_64.rpm devtoolset-11-gcc-c++-11.2.1-9.el7.x86_64.rpm devtoolset-11-libstdc++-devel-11.2.1-9.el7.x86_64.rpm devtoolset-11-runtime-11.1-2.el7.x86_64.rpmln -sf /opt/rh/devtoolset-11/root/usr/bin/* /usr/bin/ # 下载ibstdc++.so.6.0.26 上传到/usr/lib64目录 mv libstdc++.so.6.0.26 /usr/lib64/ ln -sf /usr/lib64/libstdc++.so.6.0.26 /usr/lib64/libstdc++.so.6 strings /usr/lib64/libstdc++.so.6 |grep GLIBC # 验证： cc -v， gcc -v， c++ -v1.2 安装make[root@localhost soft]# tar zxf make-4.0.tar.gz [root@localhost soft]# cd make-4.0 [root@localhost make-4.0]# ./configure --prefix=/usr/local/make [root@localhost make-4.0]# make && make install [root@localhost make-4.0]# cd /usr/bin/ [root@localhost bin]# mv make make.old [root@localhost bin]# ln -sf /usr/local/make/bin/make /usr/bin/make ‘/usr/bin/make’ -> ‘/usr/local/make/bin/make’1.3 安装glibc2.38[root@localhost soft]# tar zxf glibc-2.38.tar.gz [root@localhost soft]# cd glibc-2.38 [root@localhost glibc-2.38]# mkdir build [root@localhost glibc-2.38]# cd build/ [root@localhost build]# ../configure --prefix=/usr --disable-profile --enable-add-ons --with-headers=/usr/include --with-binutils=/usr/bin [root@localhost build]# make [root@localhost build]# make install # make install 报错，导致所有命令失效 [root@localhost build]#LD_PRELOAD=/lib64/libc-2.17.so rm -rf /lib64/libc.so.6 [root@localhost build]#LD_PRELOAD=/lib64/libc-2.17.so ln -s /lib64/libc-2.17.so /lib64/libc.so.6 # **make install 报错 执行以下** [root@localhost build]# LD_PRELOAD=/lib64/libc-2.38.so sln /root/soft/glibc-2.38/build/libc.so.6 /lib64/libc.so.6 [root@localhost build]# LD_PRELOAD=/lib64/libc-2.38.so sln /root/soft/glibc-2.38/build/dlfcn/libdl.so.2 /lib64/libdl.so.2 [root@localhost build]# LD_PRELOAD=/lib64/libc-2.38.so sln /root/soft/glibc-2.38/build/nptl/libpthread.so.0 /lib64/libpthread.so.0 [root@localhost build]# LD_PRELOAD=/lib64/libc-2.38.so sln /root/soft/glibc-2.38/build/elf/ld-linux-x86-64.so.2 /usr/lib64/ld-linux-x86-64.so.2 # 再次执行 make install 即可1.4 重建rpmdb数据库rpmdb: BDB0113 Thread/process 重建rpm数据库 cd /var/lib/rpm rm -fr __db* rpm --rebuilddb [root@localhost ~]# yum install -y redis Failed to set locale, defaulting to C echo "export LC_ALL=en_US.UTF-8" >> /etc/profile source /etc/profile1.5 升级openssl# 安装依赖 yum -y install gcc perl make zlib-devel perl-CPAN # 安装cpan IPC::Cmd cpan IPC::Cmd # 编译安装 ./config --prefix=/usr/local/ssl --openssldir=/usr/local/ssl shared zlib make && make install echo "/usr/local/ssl/lib64" > /etc/ld.so.conf.d/openssl.conf # 备份旧版 mv /usr/bin/openssl /usr/bin/openssl.old cp /usr/local/ssl/bin/openssl /usr/bin/openssl -
-
MySQL 8.0.35源码编译安装 二、MySQL 8.0.35源码编译安装可用于部署泛微OA Ecology9OS: Rocky Linux 9.1DB: mysql-boost-8.0.35.tar.gz2.0 安装 epel源dnf install epel-release -y2.1 编辑rocky-devel.repo源默认enabled=0 把它改为1 ，否则搜索不到如：libtirpc-devel 软件包# rocky-devel.repo [devel] name=Rocky Linux $releasever - Devel WARNING! FOR BUILDROOT ONLY DO NOT LEAVE ENABLED mirrorlist=https://mirrors.rockylinux.org/mirrorlist?arch=$basearch&repo=devel-$releasever$rltype #baseurl=http://dl.rockylinux.org/$contentdir/$releasever/devel/$basearch/os/ gpgcheck=1 enabled=1 countme=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-Rocky-9 [devel-source] name=Rocky Linux $releasever - Devel Source WARNING! FOR BUILDROOT ONLY DO NOT LEAVE ENABLED mirrorlist=https://mirrors.rockylinux.org/mirrorlist?arch=$basearch&repo=devel-$releasever-source$rltype #baseurl=http://dl.rockylinux.org/$contentdir/$releasever/devel/source/tree/ gpgcheck=1 enabled=1 countme=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-Rocky-92.2安装依赖dnf install ncurses ncurses-devel libtirpc libtirpc-devel rpcgen gcc-toolset-12-gcc gcc-toolset-12-gcc-c++ gcc-toolset-12-binutils gcc-toolset-12-annobin-annocheck gcc-toolset-12-annobin-plugin-gcc2.3 编译MySQLcmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \ -DSYSCONFDIR=/usr/local/mysql/etc \ -DWITH_MYISAM_STORAGE_ENGINE=1 \ -DWITH_INNOBASE_STORAGE_ENGINE=1 \ -DWITH_PARTITION_STORAGE_ENGINE=1 \ -DWITH_FEDERATED_STORAGE_ENGINE=1 \ -DEXTRA_CHARSETS=all \ -DDEFAULT_CHARSET=utf8mb4 \ -DDEFAULT_COLLATION=utf8mb4_general_ci \ -DWITH_EMBEDDED_SERVER=1 \ -DENABLED_LOCAL_INFILE=1 \ -DFORCE_INSOURCE_BUILD=1 \ -DWITH_BOOST=/opt/soft/mysql-8.0.35/boostmake && make install2.4 创建MySQL用户组groupadd mysql useradd -r -g mysql -s /sbin/nologin mysql2.5 创建数据目录、日志目录，配置文件目录mkdir /usr/local/mysql/data mkdir /usr/local/mysql/etc mkdir /usr/local/mysql/log chown -R mysql:mysql /usr/local/mysql/2.6 编辑MySQL配置文件[client] port=3306 socket=/tmp/mysql.sock [mysqld] port=3306 user = mysql socket=/tmp/mysql.sock tmpdir = /tmp key_buffer_size=256M max_allowed_packet=128M default_authentication_plugin=mysql_native_password open_files_limit = 60000 explicit_defaults_for_timestamp server-id = 1 character-set-server = utf8 federated max_connections = 1000 group_concat_max_len = 102400 max_connect_errors = 100000 table_open_cache = 4096 event_scheduler = ON skip-name-resolve lower_case_table_names = 1 interactive_timeout = 86400 wait_timeout = 86400 sync_binlog=0 back_log=100 default-storage-engine = InnoDB log_slave_updates = 1 binlog_cache_size = 32M max_heap_table_size = 256M read_rnd_buffer_size = 64M sort_buffer_size = 256M join_buffer_size = 512M thread_cache_size = 300 log_bin_trust_function_creators = 1 read_buffer_size = 32M read_rnd_buffer_size = 128M bulk_insert_buffer_size = 512M sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER,ERROR_FOR_DIVISION_BY_ZERO' transaction_isolation = READ-COMMITTED tmp_table_size = 512M log-bin=mysql-bin binlog_format=mixed expire_logs_days = 15 slow_query_log = 1 slow_query_log_file = /usr/local/mysql/log/slow.log long_query_time = 5 innodb_buffer_pool_size = 512M innodb_thread_concurrency = 16 innodb_flush_log_at_trx_commit = 2 innodb_log_buffer_size = 32M innodb_log_file_size = 1024M innodb_log_files_in_group = 4 innodb_max_dirty_pages_pct = 90 innodb_lock_wait_timeout = 120 [mysqldump] quick max_allowed_packet = 64M [client] password="my password" [mysqladmin] force [mysql] no-auto-rehash [myisamchk] key_buffer = 16M sort_buffer_size = 16M read_buffer = 8M write_buffer = 8M [mysqlhotcopy] interactive-timeout [mysqld_safe] open-files-limit = 65535 log-error=/usr/local/mysql/log/mysqld.log pid-file=/usr/local/mysql/etc/mysqld.pid2.7 初始化数据库cd /usr/local/mysql ./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data输出结果：......... 2024-01-30T10:13:40.227290Z 0 [Warning] CA certificate ca.pem is self signed. 2024-01-30T10:13:40.640989Z 1 [Note] A temporary password is generated for root@localhost: FwIai&pq*3v3 #临时密码2.8 配置环境变量vim /etc/profile.d/mysql.sh export PATH=$PATH:/usr/local/mysql/bin source /etc/profile.d/mysql.sh2.9 配置开机启动 使用systemd管理mysql服务[root@dxm system]# vim /usr/lib/systemd/system/mysqld.service [Unit] Description=MySQL Server After=network.service [Service] User=mysql Group=mysql Type=forking TimeoutSec=0 PermissionsStartOnly=true ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/usr/local/mysql/etc/my.cnf --user=mysql --daemonize ExecStop=/usr/local/mysql/bin/mysql stop LimitNOFILE = 65535 Restart=on-failure RestartSec=10 RestartPreventExitStatus=1 PrivateTmp=false [Install] WantedBy=multi-user.targetsystemctl daemon-reload systemctl enable mysqld systemctl start mysqld systemctl status mysqld2.10 登录MySQL 使用临时密码mysql -uroot -pFwIai&pq*3v32.11 修改密码#修改密码 ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER; #NAVER永不过期 # 使用WITH mysql_native_password加密 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456' PASSWORD EXPIRE NEVER; #刷新授权表 flush privileges;2.12 创建ecology数据库CREATE DATABASE ecology; CREATE USER ecology IDENTIFIED WITH mysql_native_password BY 'ecology123'; GRANT ALL PRIVILEGES ON ecology.* to 'ecology'@'%'; FLUSH PRIVILEGES;
-
MySQL 8.0.35 二进制包安装 一、MySQL 8.0.35 二进制包安装可用于部署泛微OA Ecology9.0OS: Rocky Linux 9.1Database: mysql-8.0.35-linux-glibc2.28-x86_64.tar.xzQQ: 22193771351.0 解压缩tar xf mysql-8.0.35-linux-glibc2.28-x86_64.tar.xz1.1 创建软链接ln -sf /usr/localmysql-8.0.35-linux-glibc2.28-x86_64/ /usr/localmysql1.2 创建MySQL用户组group add mysql useradd -r -g mysql -s /sbin/nologin mysql1.3 创建数据目录、日志目录，配置文件目录mkdir /usr/local/mysql/data mkdir /usr/local/mysql/etc mkdir /usr/local/mysql/log chown -R mysql:mysql /usr/local/mysql/1.4 编辑MySQL配置文件[client] port=3306 socket=/tmp/mysql.sock [mysqld] port=3306 user = mysql socket=/tmp/mysql.sock tmpdir = /tmp key_buffer_size=256M max_allowed_packet=128M default_authentication_plugin=mysql_native_password open_files_limit = 60000 explicit_defaults_for_timestamp server-id = 1 character-set-server = utf8 federated max_connections = 1000 group_concat_max_len = 102400 max_connect_errors = 100000 table_open_cache = 4096 event_scheduler = ON skip-name-resolve lower_case_table_names = 1 interactive_timeout = 86400 wait_timeout = 86400 sync_binlog=0 back_log=100 default-storage-engine = InnoDB log_slave_updates = 1 binlog_cache_size = 32M max_heap_table_size = 256M read_rnd_buffer_size = 64M sort_buffer_size = 256M join_buffer_size = 512M thread_cache_size = 300 log_bin_trust_function_creators = 1 read_buffer_size = 32M read_rnd_buffer_size = 128M bulk_insert_buffer_size = 512M sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER,ERROR_FOR_DIVISION_BY_ZERO' transaction_isolation = READ-COMMITTED tmp_table_size = 512M log-bin=mysql-bin binlog_format=mixed expire_logs_days = 15 slow_query_log = 1 slow_query_log_file = /usr/local/mysql/log/slow.log long_query_time = 5 innodb_buffer_pool_size = 512M innodb_thread_concurrency = 16 innodb_flush_log_at_trx_commit = 2 innodb_log_buffer_size = 32M innodb_log_file_size = 1024M innodb_log_files_in_group = 4 innodb_max_dirty_pages_pct = 90 innodb_lock_wait_timeout = 120 [mysqldump] quick max_allowed_packet = 64M [client] password="my password" [mysqladmin] force [mysql] no-auto-rehash [myisamchk] key_buffer = 16M sort_buffer_size = 16M read_buffer = 8M write_buffer = 8M [mysqlhotcopy] interactive-timeout [mysqld_safe] open-files-limit = 65535 log-error=/usr/local/mysql/log/mysqld.log pid-file=/usr/local/mysql/etc/mysqld.pid1.5 初始化数据库cd /usr/local/mysql ./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data输出结果：......... 2024-01-15T11:16:44.157258Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2024-01-15T11:16:50.486157Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2024-01-15T11:16:55.164521Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: :F&gdX?GQ6ip #临时密码1.6 配置环境变量vim /etc/profile.d/mysql.sh export PATH=$PATH:/usr/local/mysql/bin source /etc/profile.d/mysql.sh1.7 配置开机启动 使用systemd管理mysql服务[root@dxm system]# vim /usr/lib/systemd/system/mysqld.service [Unit] Description=MySQL Server After=network.service [Service] User=mysql Group=mysql Type=forking TimeoutSec=0 PermissionsStartOnly=true ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/usr/local/mysql/etc/my.cnf --user=mysql --daemonize ExecStop=/usr/local/mysql/bin/mysql stop LimitNOFILE = 65535 Restart=on-failure RestartSec=10 RestartPreventExitStatus=1 PrivateTmp=false [Install] WantedBy=multi-user.targetsystemctl daemon-reload systemctl enable mysqld systemctl start mysqld systemctl status mysqld1.8 登录MySQL 使用临时密码mysql -uroot -p:F&gdX?GQ6ip1.9 修改密码#修改密码 ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER; # 使用WITH mysql_native_password加密 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456' PASSWORD EXPIRE NEVER; #刷新授权表 flush privileges;1.10 创建ecology数据库CREATE DATABASE ecology; CREATE USER ecology IDENTIFIED WITH mysql_native_password BY 'ecology123'; GRANT ALL PRIVILEGES ON ecology.* to 'ecology'@'%'; FLUSH PRIVILEGES;
-
MySQL 5.7.44源码编译安装 二、MySQL 5.7.44源码编译安装可用于部署泛微Ecology9.0OS: Rocky Linux 9.1DB: mysql-boost-5.7.44.tar.gz2.0 安装 epel源dnf install epel-release -y2.1 编辑rocky-devel.repo源默认enabled=0 把它改为1 ，否则搜索不到如：libtirpc-devel 软件包# rocky-devel.repo [devel] name=Rocky Linux $releasever - Devel WARNING! FOR BUILDROOT ONLY DO NOT LEAVE ENABLED mirrorlist=https://mirrors.rockylinux.org/mirrorlist?arch=$basearch&repo=devel-$releasever$rltype #baseurl=http://dl.rockylinux.org/$contentdir/$releasever/devel/$basearch/os/ gpgcheck=1 enabled=1 countme=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-Rocky-9 [devel-source] name=Rocky Linux $releasever - Devel Source WARNING! FOR BUILDROOT ONLY DO NOT LEAVE ENABLED mirrorlist=https://mirrors.rockylinux.org/mirrorlist?arch=$basearch&repo=devel-$releasever-source$rltype #baseurl=http://dl.rockylinux.org/$contentdir/$releasever/devel/source/tree/ gpgcheck=1 enabled=1 countme=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-Rocky-92.2安装依赖dnf install ncurses ncurses-devel libtirpc libtirpc-devel rpcgen2.3 编译MySQLcmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \ -DSYSCONFDIR=/usr/local/mysql/etc \ -DWITH_MYISAM_STORAGE_ENGINE=1 \ -DWITH_INNOBASE_STORAGE_ENGINE=1 \ -DWITH_PARTITION_STORAGE_ENGINE=1 \ -DWITH_FEDERATED_STORAGE_ENGINE=1 \ -DEXTRA_CHARSETS=all \ -DDEFAULT_CHARSET=utf8mb4 \ -DDEFAULT_COLLATION=utf8mb4_general_ci \ -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 \ -DWITH_BOOST=/opt/soft/mysql-5.7.44/boostmake && make install2.4 创建MySQL用户组groupadd mysql useradd -r -g mysql -s /sbin/nologin mysql2.5 创建数据目录、日志目录，配置文件目录mkdir /usr/local/mysql/data mkdir /usr/local/mysql/etc mkdir /usr/local/mysql/log chown -R mysql:mysql /usr/local/mysql/2.6 编辑MySQL配置文件[client] port=3306 socket=/tmp/mysql.sock [mysqld] port=3306 user = mysql socket=/tmp/mysql.sock tmpdir = /tmp key_buffer_size=256M max_allowed_packet=128M open_files_limit = 60000 explicit_defaults_for_timestamp server-id = 1 character-set-server = utf8 federated max_connections = 1000 group_concat_max_len = 102400 max_connect_errors = 100000 table_open_cache = 4096 event_scheduler = ON skip-name-resolve lower_case_table_names = 1 interactive_timeout = 86400 wait_timeout = 86400 sync_binlog=0 back_log=100 default-storage-engine = InnoDB log_slave_updates = 1 binlog_cache_size = 32M max_heap_table_size = 256M read_rnd_buffer_size = 64M sort_buffer_size = 256M join_buffer_size = 512M thread_cache_size = 300 log_bin_trust_function_creators = 1 read_buffer_size = 32M read_rnd_buffer_size = 128M bulk_insert_buffer_size = 512M sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER,ERROR_FOR_DIVISION_BY_ZERO' transaction_isolation = READ-COMMITTED tmp_table_size = 512M log-bin=mysql-bin binlog_format=mixed expire_logs_days = 15 slow_query_log = 1 slow_query_log_file = /usr/local/mysql/log/slow.log long_query_time = 5 innodb_buffer_pool_size = 512M innodb_thread_concurrency = 16 innodb_flush_log_at_trx_commit = 2 innodb_log_buffer_size = 32M innodb_log_file_size = 1024M innodb_log_files_in_group = 4 innodb_max_dirty_pages_pct = 90 innodb_lock_wait_timeout = 120 [mysqldump] quick max_allowed_packet = 64M [client] password="my password" [mysqladmin] force [mysql] no-auto-rehash [myisamchk] key_buffer = 16M sort_buffer_size = 16M read_buffer = 8M write_buffer = 8M [mysqlhotcopy] interactive-timeout [mysqld_safe] open-files-limit = 65535 log-error=/usr/local/mysql/log/mysqld.log pid-file=/usr/local/mysql/etc/mysqld.pid2.7 初始化数据库cd /usr/local/mysql ./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data输出结果：......... 2024-01-30T10:13:40.227290Z 0 [Warning] CA certificate ca.pem is self signed. 2024-01-30T10:13:40.640989Z 1 [Note] A temporary password is generated for root@localhost: FwIai&pq*3v3 #临时密码2.8 配置环境变量vim /etc/profile.d/mysql.sh export PATH=$PATH:/usr/local/mysql/bin source /etc/profile.d/mysql.sh2.9 配置开机启动 使用systemd管理mysql服务[root@dxm system]# vim /usr/lib/systemd/system/mysqld.service [Unit] Description=MySQL Server After=network.service [Service] User=mysql Group=mysql Type=forking TimeoutSec=0 PermissionsStartOnly=true ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/usr/local/mysql/etc/my.cnf --user=mysql --daemonize ExecStop=/usr/local/mysql/bin/mysql stop LimitNOFILE = 65535 Restart=on-failure RestartSec=10 RestartPreventExitStatus=1 PrivateTmp=false [Install] WantedBy=multi-user.targetsystemctl daemon-reload systemctl enable mysqld systemctl start mysqld systemctl status mysqld2.10 登录MySQL 使用临时密码mysql -uroot -pFwIai&pq*3v32.11 修改密码#修改密码 ALTER USER 'root'@'localhost' IDENTIFIED BY 'Aa123456' PASSWORD EXPIRE NEVER; #NAVER永不过期 #刷新授权表 flush privileges;2.12 创建ecology数据库CREATE DATABASE ecology; GRANT ALL ON ecology.* to 'ecology'@‘localhost' IDENTIFIED BY 'ecology123'; FLUSH PRIVILEGES;
