zhengxiaoya2017的博客

set GLOBAL sync_binlog=2000;set GLOBAL innodb_flush_log_at_trx_commit=0;

&allowPublicKeyRetrieval=true&&serverTimezone=UTC

我的配置文件的路径在/etc/my.cnf.d/mysql-server.cnf在[mysqld]下添加这一行 并重启mysqlsql_mode ='STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION'重启mysqlsystemctl stop mysqld.servicesystemctl start mysqld.service

使用root用户在服务器登陆可以开启或关闭远程登陆权限。关闭MySQL root用户远程访问权限：use mysql;update user set host = “localhost” where user = “root” and host = “%”;flush privileges;打开MySQL root用户的远程访问权限：use mysql;update user set...

set global max_allowed_packet = 210241024*10

To recover your lost Database send 0.03 Bitcoin (BTC) to our Bitcoin address 17MdANMqgETBGjZJkmVw5aT9NEfqGVV4oN and contact us by Email with your Server IP or Domain name and a Proof of Payment. Your ...