mysql外部接続
mysql 外部接続
select user, host, password from mysql.user;
GRANT ALL PRIVILEGES ON . TO aaa@"192.168.50.%" IDENTIFIED BY 'aaa' WITH GRANT OPTION;
MariaDB [(none)]> select user, host, password from mysql.user;
+-------------+--------------+-------------------------------------------+
| user | host | password |
+-------------+--------------+-------------------------------------------+
| root | localhost | |
| root | cent74 | |
| root | 127.0.0.1 | |
| root | ::1 | |
| | localhost | |
| | cent74 | |
| aaa | localhost | *A02AA727CF2E8C5E6F07A382910C4028D65A053A |
| bbbbbbbbbbb | localhost | *C92Dxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx |
| aaa | 192.168.% | *A02AA727CF2E8C5E6F07A382910C4028D65A053A |
| aaa | 192.168.50.% | *A02AA727CF2E8C5E6F07A382910C4028D65A053A |
+-------------+--------------+-------------------------------------------+
削除
DROP USER [email protected].%;
ポート
MariaDB [(none)]> SHOW VARIABLES LIKE 'port';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port | 3306 |
+---------------+-------+
1 row in set (0.001 sec)
接続確認
mysql -h 192.168.3.58 -u aaa --password=aaa
Author And Source
この問題について(mysql外部接続), 我々は、より多くの情報をここで見つけました https://qiita.com/niceland/items/75b379581c21e93e0fed著者帰属:元の著者の情報は、元のURLに含まれています。著作権は原作者に属する。
Content is automatically searched and collected through network algorithms . If there is a violation . Please contact us . We will adjust (correct author information ,or delete content ) as soon as possible .