|
|
|
Mysql 113 код ошибки (CentOS)
|
|||
|---|---|---|---|
|
#18+
PHP скрипт должен подключаться к удаленной базе данных, на другой VDS, но подключение не происходит. Попробовал подключиться через консоль - ошибка 113 mysql -h IP -P 3306 -u root -p Enter password: ERROR 2003 (HY000): Can't connect to MySQL server on 'IP' (113) Конфиг MySQL(VDS исходящего подключения)|/etc/my.cnf(CentOS)|[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 # Settings user and group are ignored when systemd is used (fedora >= 15). # If you need to run mysqld under a different user or group, # customize your systemd unit file for mysqld according to the # instructions in http://fedoraproject.org/wiki/Systemd user=mysql #bind-address= # Semisynchronous Replication # http://dev.mysql.com/doc/refman/5.5/en/replication-semisync.html # uncomment next line on MASTER ;plugin-load=rpl_semi_sync_master=semisync_master.so # uncomment next line on SLAVE ;plugin-load=rpl_semi_sync_slave=semisync_slave.so # Others options for Semisynchronous Replication ;rpl_semi_sync_master_enabled=1 ;rpl_semi_sync_master_timeout=10 ;rpl_semi_sync_slave_enabled=1 # http://dev.mysql.com/doc/refman/5.5/en/performance-schema.html ;performance_schema [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 29.11.2013, 20:04:13 |
|
||
|
Mysql 113 код ошибки (CentOS)
|
|||
|---|---|---|---|
|
#18+
а почему bind-address не настроен? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 29.11.2013, 20:14:38 |
|
||
|
|

start [/forum/moderation_log.php?user_name=Hanna_Urievna]: |
0ms |
get settings: |
5ms |
get forum list: |
10ms |
get settings: |
5ms |
get forum list: |
8ms |
check forum access: |
2ms |
check topic access: |
2ms |
track hit: |
26ms |
get topic data: |
6ms |
get forum data: |
1ms |
get page messages: |
20ms |
get tp. blocked users: |
1ms |
| others: | 708ms |
| total: | 794ms |

| 0 / 0 |
