http://www.runoob.com/mysql/mysql-install.html

rpm方式安装mysql

https://www.linuxidc.com/Linux/2017-05/144363.htm

重置myql的root密码

update mysql.user set authentication_string=password('qbss2016-root') where user='root' and Host = 'localhost';
flush privileges;

如何解决MySQL 5.7 Access denied for user ‘root’@’localhost’ (using password YES)问题？

https://blog.csdn.net/Colton_Null/article/details/75949395

创建用户及授权

CREATE USER 'remoteuser'@'%' IDENTIFIED BY 'abc@123456'; 
GRANT ALL PRIVILEGES ON dbname.* TO 'remoteuser'@'%' IDENTIFIED BY 'abc@123456'; 
flush privileges;

DROP USER 'remoteuser'@'%';

Can’t create more than max_prepared_stmt_count statements

https://blog.csdn.net/niitlcj/article/details/8645859

 [MYSQL FATAL ERROR]prepare update_all_onlineflag 1,[Can't create more than max_prepared_stmt_count statements (current value: 16382)] [1461]

mysql> show global status like 'com_stmt%';
+-------------------------+---------+
| Variable_name           | Value   |
+-------------------------+---------+
| Com_stmt_execute        | 4037672 |
| Com_stmt_close          | 998362  |
| Com_stmt_fetch          | 0       |
| Com_stmt_prepare        | 1025483 |
| Com_stmt_reset          | 0       |
| Com_stmt_send_long_data | 0       |
| Com_stmt_reprepare      | 0       |
+-------------------------+---------+
7 rows in set (0.01 sec)

mysql> show global status like '%stmt_count';
+---------------------+-------+
| Variable_name       | Value |
+---------------------+-------+
| Prepared_stmt_count | 16382 |
+---------------------+-------+
1 row in set (0.01 sec)


set global max_prepared_stmt_count=124000;