[MDEV-11523] The "CONNECT Table Types - MYSQL..." page does not show how to specify a password Created: 2016-12-09  Updated: 2016-12-13  Resolved: 2016-12-13

Status: Closed
Project: MariaDB Server
Component/s: Documentation
Fix Version/s: 10.0.29, 10.1.20, 10.2.3

Type: Task Priority: Minor
Reporter: Chris Calender (Inactive) Assignee: Ian Gilfillan
Resolution: Fixed Votes: 0
Labels: None


 Description   

The "CONNECT Table Types - MYSQL Table Type: Accessing MySQL/MariaDB Tables" page:

https://mariadb.com/kb/en/mariadb/connect-table-types-mysql-table-type-accessing-mysqlmariadb-tables/

Does not show an example, except for the "deprecated" syntax, on how to actually specify a password. Not sure who is not using passwords, so this is extremely unhelpful, and good luck SELECTing from a table you create without this.

If you follow the current example there, and then try to SELECT from the table, you'll receive:

mysql> select * from t1_conn;
ERROR 1296 (HY000): Got error 174 '(1045) Access denied for user 'root'@'localhost' (using password: NO)' from CONNECT



 Comments   
Comment by Olivier Bertrand [ 2016-12-13 ]

It was just said that the syntax to use was the same as the one of the FEDERATED engine.

I added an example showing the syntax used by FEDERATED.

Generated at Thu Feb 08 07:50:36 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.