Details
-
New Feature
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
Description
CREATE SERVER is a valid statement in MariaDB:
https://mariadb.com/kb/en/library/create-server/
However, it seems like SHOW CREATE SERVER isn't implemented yet. Maybe it would be worth implementing?
MariaDB [(none)]> CREATE SERVER srv1
|
-> FOREIGN DATA WRAPPER mysql
|
-> OPTIONS(
|
-> HOST '172.30.0.58',
|
-> DATABASE 'db1',
|
-> USER 'maxscale',
|
-> PASSWORD 'password'
|
-> );
|
Query OK, 0 rows affected (0.00 sec)
|
 |
MariaDB [(none)]> SHOW CREATE SERVER srv1;
|
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SERVER srv1' at line 1
|
MariaDB [(none)]> SELECT * FROM mysql.servers\G
|
*************************** 1. row ***************************
|
Server_name: srv1
|
Host: 172.30.0.58
|
Db: db1
|
Username: maxscale
|
Password: password
|
Port: 3306
|
Socket:
|
Wrapper: mysql
|
Owner:
|
1 row in set (0.00 sec)
|
Attachments
Issue Links
- blocks
-
-
- Closed
-
- causes
-
MDEV-35136 Sporadic hang on shutdown after using [SHOW] CREATE SERVER syntax
-
- Open
-
- includes
-
-
- Closed
-
- relates to
-
-
- Open
-