[MCOL-3501] For non-root installation, the mcsmysql alias needs to be set to use the non-root user Created: 2019-09-12  Updated: 2019-09-13  Resolved: 2019-09-13

Status: Closed
Project: MariaDB ColumnStore
Component/s: installation
Affects Version/s: 1.4.0
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Daniel Lee (Inactive) Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: 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



 Comments   
Comment by Andrew Hutchings (Inactive) [ 2019-09-13 ]

mcsmysql now does nothing special as of latest develop and will go away soon. It should not be used.

Generated at Thu Feb 08 02:43:11 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.