Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-3501

For non-root installation, the mcsmysql alias needs to be set to use the non-root user

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 1.4.0
    • Icebox
    • installation
    • None

    Description

      Build tested: 1.4.0-1

      [guest@localhost ~]$ cat gitversionInfo.txt
      server commit:
      67452bc
      engine commit:
      64ceb86

      The mcsmysql alias is always set to use the root SQL user. This is no longer allowed by default in 1.4.0-1 (server 10.4.7-2). the SQL user needs to be set to the current non-root user, which is guest in my test

      [guest@localhost ~]$ mcsmysql
      ERROR 1698 (28000): Access denied for user 'root'@'localhost'
      [guest@localhost ~]$ alias mcsmysql
      alias mcsmysql='/home/guest/mariadb/columnstore/mysql/bin/mysql --defaults-extra-file=/home/guest/mariadb/columnstore/mysql/my.cnf -u root'
      [guest@localhost ~]$ alias mcsmysql='/home/guest/mariadb/columnstore/mysql/bin/mysql --defaults-extra-file=/home/guest/mariadb/columnstore/mysql/my.cnf -u guest'
      [guest@localhost ~]$ mcsmysql
      Welcome to the MariaDB monitor. Commands end with ; or \g.
      Your MariaDB connection id is 19
      Server version: 10.4.7-2-MariaDB-log Source distribution

      Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

      MariaDB [(none)]> exit
      Bye

      Attachments

        Activity

          People

            Unassigned Unassigned
            dleeyh Daniel Lee (Inactive)
            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.