DirectAdmin - как включить удаленный доступ к mysql

Материал из Wiki - Iphoster - the best ever hosting and support. 2005 - 2023
Перейти к:навигация, поиск
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.


Дать доступ со всех 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: