VPS侦探论坛

 找回密码
 注册
查看: 5991|回复: 1

[Oracle] 如何修改my.cnf的配置能允许远程连接

[复制链接]
发表于 2015-11-11 17:28:00 | 显示全部楼层 |阅读模式

配置内容如下[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



请问如何修改能允许远程访问??账号权限什么的绝对没问题!
美国VPS推荐: 遨游主机LinodeLOCVPS主机云搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
发表于 2015-11-12 08:37:41 | 显示全部楼层
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|VPS侦探 ( 鲁ICP备16040043号-1 )

GMT+8, 2024-11-25 03:08 , Processed in 0.025452 second(s), 16 queries .

Powered by Discuz! X3.4

© 2001-2023 Discuz! Team.

快速回复 返回顶部 返回列表