-
解决mysql远程连接bug1.登录宝塔修改mysql数据库root账户密码2.ssh终端使用root账户登录mysql> mysql -u root -p
> 输入你的密码后回车3.按顺序一条一条执行如下命令：
===============================start===================================
-- 1. 使用mysql数据库
> use mysql;-- 2. 创建允许远程访问的用户
> CREATE USER 'root'@'%' IDENTIFIED BY 'your_password';-- 3. 授予该用户所有数据库的所有权限
> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';-- 4. 刷新权限使配置生效
> FLUSH PRIVILEGES;
==========================end====================================4. 然后就可以使用远程软件登录mysql啦
-
已解决：
1. 修改/etc/my.cnf为以下内容：
====================start============================
[client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock
[mysqld]
binlog_cache_size = 64K
thread_stack = 256K
join_buffer_size = 2048K
read_rnd_buffer_size = 512K
read_buffer_size = 768K
sort_buffer_size = 768K
thread_cache_size = 96
table_open_cache = 192
max_connections = 200
innodb_log_buffer_size = 16M
innodb_buffer_pool_size = 384M
max_heap_table_size = 384M
tmp_table_size = 384M
key_buffer_size = 256M
bind-address=0.0.0.0
port=3306
user=mysql
basedir=/www/server/mysql
datadir=/www/server/data/mysql
socket=/tmp/mysql.sock
log-error=/www/server/data/mysql/mysql.err
pid-file=/www/server/data/mysql/mysql.pid
character_set_server=utf8mb4
symbolic-links=0
plugin-load-add=mysqlx.so
mysqlx-bind-address=0.0.0.0================end============================
2. 执行以下两条命令：
===========start================> sudo usermod -a -G 3003 mysql
> sudo usermod -a -G 3003 root============end=====================3. 重启mysql> service mysqld restart
解决mysql远程连接bug
