mysql mysql --> mysql -u root -p select version(), @@sql_mode; set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'; set session sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
## mysql8 分配权限 use mysql select host,user,plugin from user; update user set host='222.176.211.8' where user ='root' and host='183.69.220.79'; ALTER USER 'root'@'183.69.220.79' IDENTIFIED WITH mysql_native_password BY 'qym2021'; FLUSH PRIVILEGES; grant all privileges on tableName.* to 'root'@'183.69.220.79'; grant all privileges on database.table to 'root'@'183.69.220.79'; // 分配权限到表 grant all privileges on database.* to 'root'@'183.69.220.79'; // 分配权限到数据库 grant all privileges on *.* to 'root'@'18...
### 宝塔搭建mysql主从复制方法 两台服务器上创建数据库 进入服务器 并且登录root登录控制台 mysql -u root -p 一号服务器创建的用户 进行权限升级 mysql> grant all privileges on *.* to 'rz_db0'@'%' identified by 'N3SkmDNif28ibYHp' with grant option; show master status; 进入二号服务器 同样使用root用户登录数据 使用命令开始进行连接 change master to master_host='192.168.85.132',master_user='rz_db0',master_password='N3SkmDNif28ibYHp',master_log_file='mysql-bin.000004',master_log_pos=6843; master_user:主服务器的用户 master_password: 主服务器的密码 master_log_file: 也就是我们一号服务器打印的File表里的信息 master_log_p...
动图演示 JavaScript 实例 function bubbleSort(arr) { var len = arr.length; for (var i = 0; i < len - 1; i++) { for (var j = 0; j < len - 1 - i; j++) { if (arr[j] > arr[j+1]) { // 相邻元素两两对比 var temp = arr[j+1]; // 元素交换 arr[j+1] = arr[j]; arr[j] = temp; } } } return arr; } Python实例 def bubbleSort(arr): for i in range(1, len(arr)): for j in range(0, len(arr)-i): i...