一、下载进入到mysql官网下载自己对应版本的mysql下载地址https://dev.mysql.com/downloads/mysql/5.7.html#downloads我这里下载mysql-5.7.23-linux-glibc2.12-x86_64.tar.gz版本也可以进入linux后用命令下载wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.23-linux-glibc2.12-x86_64.tar.gz二、环境准备安装前我们可以检测系统是否自带安装 MySQL:rpm -qa | grep mysql如有类似mysql-libs-5.1.52-1.el6_0.1.x86_64那可以选择进行卸载:rpm -e mysql-libs-5.1.52-1.el6_0.1.x86_64 // 普通删除模式rpm -e --nodeps mysql-libs-5.1.52-1.el6_0.1.x86_64 // 强力删除模式如果使用上面命令删除时提示有依赖的其它文件则用该命令可以对其进行强力删除检查否存在 mariadb 数据库如有卸载之卸载同上rpm -qa | grep mariadb如有类似mariadb-libs-5.5.56-2.el7.x86_64则 卸载rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64用工具将下载的mysql-5.7.23-linux-glibc2.12-x86_64.tar.gz上传到linux服务器的/opt/目录下面三、安装3.1 解压文件进入安装包所在目录解压文件重命名mv mysql-5.7.23-linux-glibc2.12-x86_64 mysql3.2 添加系统mysql组和mysql用户检查mysql组和用户是否存在如无创建cat /etc/group | grep mysql 类似 mysql:x:490: cat /etc/passwd | grep mysql #类似 mysql:x:496:490::/home/mysql:/bin/bash以上为存在的情况如无执行添加命令groupadd mysql useradd -r -g mysql mysql #useradd -r参数表示mysql用户是系统用户不可用于登录系统3.3 安装数据库创建data目录cd mysqlmkdir data将/opt/mysql的所有者及所属组改为mysqlchown -R mysql.mysql /opt/mysql在/opt/mysql目录下创建my.cnf内容如下[client] # 设置mysql客户端默认字符集 default-character-set utf8 [mysqld] # 设置3306端口 port 3306 # 设置mysql的安装目录 basedir /opt/mysql # 设置 mysql数据库的数据的存放目录MySQL 8 不需要以下配置系统自己生成即可否则有可能报错 datadir /opt/mysql/data # 允许最大连接数 max_connections 1000 # 服务端使用的字符集默认为8比特编码的latin1字符集 character-set-server utf8 # 创建新表时将使用的默认存储引擎 default-storage-engine INNODB federated # 大小写忽略 lower_case_table_names 1 log-bin-trust-function-creators 1 long_query_time 1 log-queries-not-using-indexes slow_query_log 1 slow_query_log_file /opt/mysql/slow_query_log.log log-bin mysql-bin log_timestamps SYSTEM log-error /opt/mysql/error.log log_queries_not_using_indexes 1 log_throttle_queries_not_using_indexes 60 expire_logs_days 7 back_log 128 explicit_defaults_for_timestamp true sql_mode NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES master_info_repository TABLE relay_log_info_repository TABLE max_connect_errors 40 wait_timeout 60 interactive_timeout 7200 innodb_buffer_pool_size 2048M innodb_flush_log_at_trx_commit 1 innodb_log_buffer_size 32M innodb_log_file_size 128M innodb_log_files_in_group 3 max_binlog_size 512M max_allowed_packet 32M key_buffer_size 256M sort_buffer_size 2M join_buffer_size 2M read_buffer_size 1M read_rnd_buffer_size 16M bulk_insert_buffer_size 64M query_cache_size 256M query_cache_type 1 query_cache_limit 50M thread_cache_size 200 binlog_cache_size 2M max_binlog_cache_size 8M tmp_table_size 32M max_heap_table_size 32M gtid_mode on enforce_gtid_consistency 1 event_scheduler on server-id 1初始化 mysqld./bin/mysqld --initialize --usermysql --basedir/opt/mysql/ --datadir/opt/mysql/data/如下图临时密码请记住把启动脚本放到开机初始化目录cp support-files/mysql.server /etc/init.d/mysql修改/etc/init.d/mysql如下启动mysql服务service mysql start登录mysql密码为初始密码./bin/mysql -u root -p修改密码mysql set passwordpassword(‘123456’);mysql grant all privileges on.to root‘%’ identified by ‘123456’;mysql flush privileges;如果提示如下错误ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.则需要执行下面语句修改密码mysql alter user user() identified by “123456”;添加远程访问权限mysql use mysql;mysql update user set host‘%’ where user ‘root’;mysql flush privileges;重启mysql生效service mysql restart
一、下载进入到mysql官网下载自己对应版本的mysql下载地址https://dev.mysql.com/downloads/mysql/5.7.html#downloads我这里下载mysql-5.7.23-linux-glibc2.12-x86_64.tar.gz版本也可以进入linux后用命令下载wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.23-linux-glibc2.12-x86_64.tar.gz二、环境准备安装前我们可以检测系统是否自带安装 MySQL:rpm -qa | grep mysql如有类似mysql-libs-5.1.52-1.el6_0.1.x86_64那可以选择进行卸载:rpm -e mysql-libs-5.1.52-1.el6_0.1.x86_64 // 普通删除模式rpm -e --nodeps mysql-libs-5.1.52-1.el6_0.1.x86_64 // 强力删除模式如果使用上面命令删除时提示有依赖的其它文件则用该命令可以对其进行强力删除检查否存在 mariadb 数据库如有卸载之卸载同上rpm -qa | grep mariadb如有类似mariadb-libs-5.5.56-2.el7.x86_64则 卸载rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64用工具将下载的mysql-5.7.23-linux-glibc2.12-x86_64.tar.gz上传到linux服务器的/opt/目录下面三、安装3.1 解压文件进入安装包所在目录解压文件重命名mv mysql-5.7.23-linux-glibc2.12-x86_64 mysql3.2 添加系统mysql组和mysql用户检查mysql组和用户是否存在如无创建cat /etc/group | grep mysql 类似 mysql:x:490: cat /etc/passwd | grep mysql #类似 mysql:x:496:490::/home/mysql:/bin/bash以上为存在的情况如无执行添加命令groupadd mysql useradd -r -g mysql mysql #useradd -r参数表示mysql用户是系统用户不可用于登录系统3.3 安装数据库创建data目录cd mysqlmkdir data将/opt/mysql的所有者及所属组改为mysqlchown -R mysql.mysql /opt/mysql在/opt/mysql目录下创建my.cnf内容如下[client] # 设置mysql客户端默认字符集 default-character-set utf8 [mysqld] # 设置3306端口 port 3306 # 设置mysql的安装目录 basedir /opt/mysql # 设置 mysql数据库的数据的存放目录MySQL 8 不需要以下配置系统自己生成即可否则有可能报错 datadir /opt/mysql/data # 允许最大连接数 max_connections 1000 # 服务端使用的字符集默认为8比特编码的latin1字符集 character-set-server utf8 # 创建新表时将使用的默认存储引擎 default-storage-engine INNODB federated # 大小写忽略 lower_case_table_names 1 log-bin-trust-function-creators 1 long_query_time 1 log-queries-not-using-indexes slow_query_log 1 slow_query_log_file /opt/mysql/slow_query_log.log log-bin mysql-bin log_timestamps SYSTEM log-error /opt/mysql/error.log log_queries_not_using_indexes 1 log_throttle_queries_not_using_indexes 60 expire_logs_days 7 back_log 128 explicit_defaults_for_timestamp true sql_mode NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES master_info_repository TABLE relay_log_info_repository TABLE max_connect_errors 40 wait_timeout 60 interactive_timeout 7200 innodb_buffer_pool_size 2048M innodb_flush_log_at_trx_commit 1 innodb_log_buffer_size 32M innodb_log_file_size 128M innodb_log_files_in_group 3 max_binlog_size 512M max_allowed_packet 32M key_buffer_size 256M sort_buffer_size 2M join_buffer_size 2M read_buffer_size 1M read_rnd_buffer_size 16M bulk_insert_buffer_size 64M query_cache_size 256M query_cache_type 1 query_cache_limit 50M thread_cache_size 200 binlog_cache_size 2M max_binlog_cache_size 8M tmp_table_size 32M max_heap_table_size 32M gtid_mode on enforce_gtid_consistency 1 event_scheduler on server-id 1初始化 mysqld./bin/mysqld --initialize --usermysql --basedir/opt/mysql/ --datadir/opt/mysql/data/如下图临时密码请记住把启动脚本放到开机初始化目录cp support-files/mysql.server /etc/init.d/mysql修改/etc/init.d/mysql如下启动mysql服务service mysql start登录mysql密码为初始密码./bin/mysql -u root -p修改密码mysql set passwordpassword(‘123456’);mysql grant all privileges on.to root‘%’ identified by ‘123456’;mysql flush privileges;如果提示如下错误ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.则需要执行下面语句修改密码mysql alter user user() identified by “123456”;添加远程访问权限mysql use mysql;mysql update user set host‘%’ where user ‘root’;mysql flush privileges;重启mysql生效service mysql restart
平方复杂度无法被常规优化消除｜TaoToken 统一 Key 通道实测)
