LoginSignup
2
2

More than 5 years have passed since last update.

infinidbのtableにremote serverからアクセスさせる設定

Posted at
  • アクセスするテーブルへの権限設定
  • infinidb_vtableへのアクセス権限設定
mysql> show databases;
+---------------------+
| Database            |
+---------------------+
| information_schema  |
| calpontsys          |
| infinidb_querystats |
| infinidb_vtable     |
| mysql               |
| test                |
+---------------------+
8 rows in set (0.00 sec)

mysql> grant all privileges on infinidb_vtable.* to あんた@"どっか" identified by 'ぱすわーど' with grant option; 
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

2
2
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
2
2