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

system upgrade install fails when a mysql root password is set

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.0.5
    • 1.0.6
    • ?
    • None
    • 2016-23, 2016-24

    Description

      Setup a mysql root user password following the below instructions and got an error reported from postConfigure:

      post-mysqld-install Successfully Completed
      NOTE: Using MariaDB Columnstore password from /root/.my.cnf
      ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
      ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
      Error running post-mysql-install, /tmp/post-mysql-install.log

      ---------------------------------------------------------------------

      setup:

      /usr/local/mariadb/columnstore/mysql/bin/mysqladmin --socket=/usr/local/mariadb/columnstore/mysql/lib/mysql/mysql.sock -u root password 'Calpont1'

      You will then also need to let cron jobs work on the database so create a personal mysql config file for root in /root/.my.cnf containing:

      [mysqladmin]
      user = root
      password = Calpont1

      Make sure the permissions are set appropriately:

      1. chmod 0600 /root/.my.cnf

      Attachments

        Activity

          People

            dleeyh Daniel Lee (Inactive)
            hill David Hill (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.