-
解决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
留言板
-
Humility requires you to recognize weakness in your own arguments and sometimes also to accept reasons on the opposite side. 谦逊需要你在自己的观点当中认识到自己的弱点并且有时也要求你接受反方的理由。
-
你无法比此刻更年轻
Humility requires you to recognize weakness in your own arguments and sometimes also to accept reasons on the opposite side.
谦逊需要你在自己的观点当中认识到自己的弱点并且有时也要求你接受反方的理由。
你无法比此刻更年轻