DirectAdmin - как включить удаленный доступ к mysql
Материал из Wiki - Iphoster - the best ever hosting and support. 2005 - 2024
Дать доступ со всех IP - добавить в Access Hosts:
%
Дать доступ с подсети 1.2.3.0/24 - добавить в Access Hosts:
1.2.3.%
[root@vds /]# netstat -nlp | grep mysql tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 866/mysqld unix 2 [ ACC ] STREAM LISTENING 1952876216 866/mysqld /var/lib/mysql/mysql.sock
После настройки проверяем подключение с нашего IP:
[root@serv /]# mysql -u admin_main -p admin_main -h xxx.xxx.xxx.xxx Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 264 Server version: 5.5.31 MySQL Community Server (GPL) Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql>
Links:
