mkdir /root/.ssh && cd /root/.ssh && touch authorized_keys cat >> /root/.ssh/authorized_keys <<eof 此处是公钥信息 eof chmod 600 /root/.ssh/authorized_keys sed -i "s/PermitRootLogin no/PermitRootLogin yes/g" /etc/ssh/sshd_config systemctl restart sshd
mysql> SELECT @@sql_mode; +------------------------------------------------------------------------------------------------------------------------+ | @@sql_mode | +------------------------------------------------------------------------------------------------------------------------+ | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | +------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) #方法一： #修改为： mysql> set GLOBAL sql_mode = 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'; #方法二： #修改配置文件，去掉ONLY_FULL_GROUP_BY sql_mode = "ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
在powershell中输入如下代码，开启卓越性能模式，然后去电源选项中选择卓越性能模式即可安全超频： powercfg -duplicatescheme 8c5e7fda-e8bf-4a96-9a85-a6e23a8c635c powercfg -duplicatescheme e9a42b02-d5df-448d-aa00-03f14749eb61