Цитата SharkyUA:
|
select User,Host from mysql.user; »
|
Код:
mysql> select User,Host from mysql.user;
+------------------+----------------------+
| User | Host |
+------------------+----------------------+
| root | 127.0.0.1 |
| root | 192.168.10.10 |
| root | 192.168.10.19 |
| root | 192.168.10.20 |
| root | ::1 |
| debian-sys-maint | localhost |
| phpmyadmin | localhost |
| root | localhost |
| root | pc11 |
| root | pc11.domain.local |
+------------------+----------------------+
10 rows in set (0.00 sec)
где, pc11 и 192.168.10.19 - мой хост, с которого я запускаю скрипт PowerShell.
192.168.10.20 - это другой сервер с Дебиан 6 и базой 5.1. с него доступ к базе есть:
Код:
root@doc:~# mysql -uroot -p -h debian7
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 48
Server version: 5.5.31-0+wheezy1 (Debian)
Copyright (c) 2000, 2011, 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>
и вот, кстати, настройка для работающего сервера. и с 19, и с 10 и со 2-го доступ есть.
Код:
mysql> select User,Host from mysql.user;
+------------------+---------------+
| User | Host |
+------------------+---------------+
| root | 127.0.0.1 |
| root | 192.168.10.10 |
| root | 192.168.10.19 |
| root | 192.168.10.2 |
| root | doc |
| cacti | localhost |
| debian-sys-maint | localhost |
| phpmyadmin | localhost |
| root | localhost |
+------------------+---------------+
9 rows in set (0.00 sec)
