VPS侦探论坛

标题: 如何修改my.cnf文件允许远程访问 [打印本页]

作者: cj1989 时间: 2015-11-11 17:31
标题: 如何修改my.cnf文件允许远程访问
哪位大大能解决啊，就是lnmp初始安装后发现无法远程连接：[client]
#password
= your_password
port
= 3306
socket
= /tmp/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port
= 3306
socket
= /tmp/mysql.sock
datadir = /usr/local/mysql/var
skip-external-locking
max_connections = 1000
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M

#skip-networking

作者: licess 时间: 2015-11-11 20:34
不允许远程连接和my.cnf没任何关系，提问前现在论坛搜索，论坛里已经说过很多次了

https://bbs.vpser.net/thread-3135-1-1.html

作者: cj1989 时间: 2015-11-12 10:11
谢谢啊，不过我没发现论坛有搜索功能啊

作者: cj1989 时间: 2015-11-12 10:11
看到了。。。。。。。

欢迎光临 VPS侦探论坛 (https://bbs.lnmp.com/)