Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-11523

The "CONNECT Table Types - MYSQL..." page does not show how to specify a password

    XMLWordPrintable

    Details

      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

        Attachments

          Activity

            People

            Assignee:
            greenman Ian Gilfillan
            Reporter:
            ccalender Chris Calender
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.