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

mysql_install_db fail

    XMLWordPrintable

Details

    Description

      I execute bottom command.
      mysql_install_db --defaults-file=/etc/my.cnf --datadir=/maria_data/db01 --basedir=/maria/mariadb --user=maria

      I got a error message. what shall I do for fixing this error?

      [maria@cento7 mariadb]$ ./scripts/mysql_install_db --defaults-file=/etc/my.cnf --datadir=/maria_data/db01 --basedir=/maria/mariadb --user=maria
      Installing MariaDB/MySQL system tables in '/maria_data/db01' ...
      OK

      To start mysqld at boot time you have to copy
      support-files/mysql.server to the right place for your system

      PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
      To do so, start the server, then issue the following commands:

      '/maria/mariadb/bin/mysqladmin' -u root password 'new-password'
      '/maria/mariadb/bin/mysqladmin' -u root -h cento7 password 'new-password'

      Alternatively you can run:
      '/maria/mariadb/bin/mysql_secure_installation'

      which will also give you the option of removing the test
      databases and anonymous user created by default. This is
      strongly recommended for production servers.

      See the MariaDB Knowledgebase at http://mariadb.com/kb or the
      MySQL manual for more instructions.

      You can start the MariaDB daemon with:
      cd '/maria/mariadb' ; /maria/mariadb/bin/mysqld_safe --datadir='/maria_data/db01'

      You can test the MariaDB daemon with mysql-test-run.pl
      cd '/maria/mariadb/mysql-test' ; perl mysql-test-run.pl

      Please report any problems at http://mariadb.org/jira

      The latest information about MariaDB is available at http://mariadb.org/.
      You can find additional information about the MySQL part at:
      http://dev.mysql.com
      Consider joining MariaDB's strong and vibrant community:
      https://mariadb.org/get-involved/

      [maria@cento7 mariadb]$

      log-error messages bottom
      [root@cento7 trc]# ls
      mysql.err
      [root@cento7 trc]# cat mysql.err
      100 200 300 400 500 600 700 800 900 1000
      100 200 300 400 500 600 700 800 900 1000
      100 200
      100 200
      100 200
      100 200
      100 200
      100 200
      100 200
      100 200
      2017-03-01 12:26:55 140272513292160 [Warning] InnoDB: Creating foreign key constraint system tables.
      2017-03-01 12:26:55 140272513184512 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
      [root@cento7 trc]#

      Attachments

        Activity

          People

            Unassigned Unassigned
            a76014 seoungho
            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.