Welcome to Centmin Mod Community
Register Now

MariaDB MySQL Root Password Restart Error

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by Jimmy, Apr 22, 2017.

  1. Jimmy

    Jimmy Premium Member Premium Member

    1,114
    247
    63
    Oct 24, 2015
    East Coast USA
    Ratings:
    +596
    Local Time:
    12:59 AM
    1.13.x
    MariaDB 10.1.x
    CentOS 7 64bit / 123.09beta01

    I'm trying to change the mysql root password. I tried this on two separate systems (dedicated server and local VM) and I keep getting the error below on restart.

    I did a fresh 09 install on a VM and followed FAQ #35.

    Code:
    ngxstop && sleep 30
    Code:
    mysqlstop
    Code:
    mysqld_safe --skip-grant-tables --skip-networking &
    Code:
    mysql -e "UPDATE mysql.user SET Password=PASSWORD('B@2Dw%y#k3zXi7Vr') WHERE User='root'; FLUSH PRIVILEGES;" mysql
    Code:
    [23:51][root@localhost.localdomain centminmod]# mysqlrestart
    Restarting mysql (via systemctl):  Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.
                                                               [FAILED]
    
    Code:
    # journalctl -xe
    Apr 21 23:53:12 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:12 139806255372544 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    Apr 21 23:53:12 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:12 139806255372544 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log fi
    Apr 21 23:53:13 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:13 139806255372544 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    Apr 21 23:53:13 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:13 139806255372544 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log fi
    Apr 21 23:53:14 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:14 139806255372544 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    Apr 21 23:53:14 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:14 139806255372544 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log fi
    Apr 21 23:53:15 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:15 139806255372544 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    Apr 21 23:53:15 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:15 139806255372544 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log fi
    Apr 21 23:53:16 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:16 139806255372544 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    Apr 21 23:53:16 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:16 139806255372544 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log fi
    Apr 21 23:53:17 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:17 139806255372544 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    Apr 21 23:53:17 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:17 139806255372544 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log fi
    Apr 21 23:53:18 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:18 139806255372544 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    Apr 21 23:53:18 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:18 139806255372544 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log fi
    Apr 21 23:53:19 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:19 139806255372544 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    Apr 21 23:53:19 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:19 139806255372544 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log fi
    Apr 21 23:53:20 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:20 139806255372544 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    Apr 21 23:53:20 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:20 139806255372544 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log fi
    Apr 21 23:53:21 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:21 139806255372544 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    Apr 21 23:53:21 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:21 139806255372544 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log fi
    Apr 21 23:53:22 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:22 139806255372544 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    Apr 21 23:53:22 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:22 139806255372544 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log fi
    Apr 21 23:53:23 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:23 139806255372544 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    Apr 21 23:53:23 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:23 139806255372544 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log fi
    Apr 21 23:53:24 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:24 139806255372544 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    Apr 21 23:53:24 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:24 139806255372544 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log fi
    Apr 21 23:53:25 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:25 139806255372544 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    Apr 21 23:53:25 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:25 139806255372544 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log fi
    Apr 21 23:53:26 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:26 139806255372544 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    Apr 21 23:53:26 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:26 139806255372544 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log fi
    Apr 21 23:53:27 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:27 139806255372544 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    Apr 21 23:53:27 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:27 139806255372544 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log fi
    Apr 21 23:53:27 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:27 139806255372544 [Note] InnoDB: Unable to open the first data file
    Apr 21 23:53:27 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:27 7f272e305900  InnoDB: Operating system error number 11 in a file operation.
    Apr 21 23:53:27 localhost.localdomain mysqld[11677]: InnoDB: Error number 11 means 'Resource temporarily unavailable'.
    Apr 21 23:53:27 localhost.localdomain mysqld[11677]: InnoDB: Some operating system error numbers are described at
    Apr 21 23:53:27 localhost.localdomain mysqld[11677]: InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
    Apr 21 23:53:27 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:27 139806255372544 [ERROR] InnoDB: Can't open './ibdata1'
    Apr 21 23:53:27 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:27 139806255372544 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the sys
    Apr 21 23:53:27 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:27 139806255372544 [ERROR] Plugin 'InnoDB' init function returned error.
    Apr 21 23:53:27 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:27 139806255372544 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    Apr 21 23:53:27 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:27 139806255372544 [Note] Plugin 'FEEDBACK' is disabled.
    Apr 21 23:53:27 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:27 139806255372544 [ERROR] Unknown/unsupported storage engine: InnoDB
    Apr 21 23:53:27 localhost.localdomain mysqld[11677]: 2017-04-21 23:53:27 139806255372544 [ERROR] Aborting
    Apr 21 23:53:27 localhost.localdomain systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
    Apr 21 23:53:27 localhost.localdomain systemd[1]: Failed to start MariaDB database server.
    -- Subject: Unit mariadb.service has failed
    -- Defined-By: systemd
    -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    --
    -- Unit mariadb.service has failed.
    --
    -- The result is failed.
    Apr 21 23:53:27 localhost.localdomain systemd[1]: Unit mariadb.service entered failed state.
    Apr 21 23:53:27 localhost.localdomain systemd[1]: mariadb.service failed.
    Apr 21 23:53:27 localhost.localdomain polkitd[635]: Unregistered Authentication Agent for unix-process:11436:11071 (system bus name :1.27, object path /org/freedesktop/PolicyKit1/AuthenticationAgent
    Apr 21 23:53:54 localhost.localdomain chronyd[641]: Selected source 74.120.81.219
    Apr 21 23:55:01 localhost.localdomain systemd[1]: Started Session 4 of user root.
    -- Subject: Unit session-4.scope has finished start-up
    -- Defined-By: systemd
    -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    --
    -- Unit session-4.scope has finished starting up.
    --
    -- The start-up result is done.
    Apr 21 23:55:01 localhost.localdomain systemd[1]: Starting Session 4 of user root.
    -- Subject: Unit session-4.scope has begun start-up
    -- Defined-By: systemd
    -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    --
    -- Unit session-4.scope has begun starting up.
    Apr 21 23:55:01 localhost.localdomain CROND[11714]: (root) CMD (/usr/lib64/sa/sa1 1 1)
     
  2. eva2000

    eva2000 Administrator Staff Member

    30,163
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    2:59 PM
    Nginx 1.13.x
    MariaDB 5.5
  3. Jimmy

    Jimmy Premium Member Premium Member

    1,114
    247
    63
    Oct 24, 2015
    East Coast USA
    Ratings:
    +596
    Local Time:
    12:59 AM
    1.13.x
    MariaDB 10.1.x
    Code:
    systemctl stop mariadb
    Code:
    mysqld_safe --skip-grant-tables --skip-networking &
    Code:
    [1] 3423
    [00:15][root@localhost.localdomain ~]# 170422 00:15:02 mysqld_safe Logging to '/var/lib/mysql/localhost.localdomain.err'.
    170422 00:15:02 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    mysql -u root
    Welcome to the MariaDB monitor.  Commands end with ; or \g.
    Your MariaDB connection id is 2
    Server version: 10.1.22-MariaDB MariaDB Server
    
    Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    MariaDB [(none)]> update mysql.user set password=password('B@2Dw%y#k3zXi7Vr') where user='root';
    Query OK, 1 row affected (0.01 sec)
    Rows matched: 4  Changed: 1  Warnings: 0
    
    MariaDB [(none)]> FLUSH PRIVILEGES;
    Query OK, 0 rows affected (0.00 sec)
    
    MariaDB [(none)]> quit
    Bye
    [00:16][root@localhost.localdomain ~]# mysql -u root -p
    Enter password:
    Welcome to the MariaDB monitor.  Commands end with ; or \g.
    Your MariaDB connection id is 3
    Server version: 10.1.22-MariaDB MariaDB Server
    
    Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    MariaDB [(none)]> quit
    Bye
    Code:
    [00:17][root@localhost.localdomain ~]# systemctl start mariadb
    Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.
    Code:
    # journalctl -xe
    Apr 22 00:19:28 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:28 140057861314816 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log fil
    Apr 22 00:19:29 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:29 140057861314816 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    Apr 22 00:19:29 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:29 140057861314816 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log fil
    Apr 22 00:19:30 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:30 140057861314816 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    Apr 22 00:19:30 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:30 140057861314816 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log fil
    Apr 22 00:19:31 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:31 140057861314816 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    Apr 22 00:19:31 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:31 140057861314816 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log fil
    Apr 22 00:19:32 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:32 140057861314816 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    Apr 22 00:19:32 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:32 140057861314816 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log fil
    Apr 22 00:19:33 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:33 140057861314816 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    Apr 22 00:19:33 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:33 140057861314816 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log fil
    Apr 22 00:19:34 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:34 140057861314816 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    Apr 22 00:19:34 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:34 140057861314816 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log fil
    Apr 22 00:19:35 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:35 140057861314816 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    Apr 22 00:19:35 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:35 140057861314816 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log fil
    Apr 22 00:19:36 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:36 140057861314816 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    Apr 22 00:19:36 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:36 140057861314816 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log fil
    Apr 22 00:19:37 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:37 140057861314816 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    Apr 22 00:19:37 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:37 140057861314816 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log fil
    Apr 22 00:19:38 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:38 140057861314816 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    Apr 22 00:19:38 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:38 140057861314816 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log fil
    Apr 22 00:19:39 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:39 140057861314816 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    Apr 22 00:19:39 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:39 140057861314816 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log fil
    Apr 22 00:19:40 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:40 140057861314816 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    Apr 22 00:19:40 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:40 140057861314816 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log fil
    Apr 22 00:19:41 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:41 140057861314816 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    Apr 22 00:19:41 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:41 140057861314816 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log fil
    Apr 22 00:19:42 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:42 140057861314816 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    Apr 22 00:19:42 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:42 140057861314816 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log fil
    Apr 22 00:19:43 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:43 140057861314816 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    Apr 22 00:19:43 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:43 140057861314816 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log fil
    Apr 22 00:19:44 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:44 140057861314816 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    Apr 22 00:19:44 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:44 140057861314816 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log fil
    Apr 22 00:19:44 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:44 140057861314816 [Note] InnoDB: Unable to open the first data file
    Apr 22 00:19:44 localhost.localdomain mysqld[4057]: 2017-04-22 00:19:44 7f61c3125900  InnoDB: Operating system error number 11 in a file operation.
    Apr 22 00:19:44 localhost.localdomain mysqld[4057]: InnoDB: Error number 11 means 'Resource temporarily unavailable'.
    Apr 22 00:19:44 localhost.localdomain mysqld[4057]: InnoDB: Some operating system error numbers are described at
    Apr 22 00:19:44 localhost.localdomain mysqld[4057]: InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
    Apr 22 00:19:44 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:44 140057861314816 [ERROR] InnoDB: Can't open './ibdata1'
    Apr 22 00:19:44 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:44 140057861314816 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the syst
    Apr 22 00:19:44 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:44 140057861314816 [ERROR] Plugin 'InnoDB' init function returned error.
    Apr 22 00:19:44 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:44 140057861314816 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    Apr 22 00:19:44 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:44 140057861314816 [Note] Plugin 'FEEDBACK' is disabled.
    Apr 22 00:19:44 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:44 140057861314816 [ERROR] Unknown/unsupported storage engine: InnoDB
    Apr 22 00:19:44 localhost.localdomain mysqld[4057]: 2017-04-22  0:19:44 140057861314816 [ERROR] Aborting
    Apr 22 00:19:44 localhost.localdomain systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
    Apr 22 00:19:44 localhost.localdomain systemd[1]: Failed to start MariaDB database server.
    -- Subject: Unit mariadb.service has failed
    -- Defined-By: systemd
    -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    --
    -- Unit mariadb.service has failed.
    --
    -- The result is failed.
    Apr 22 00:19:44 localhost.localdomain systemd[1]: Unit mariadb.service entered failed state.
    Apr 22 00:19:44 localhost.localdomain polkitd[630]: Unregistered Authentication Agent for unix-process:3815:45816 (system bus name :1.30, object path /org/freedesktop/PolicyKit1/AuthenticationAgent,
    Apr 22 00:19:44 localhost.localdomain systemd[1]: mariadb.service failed.
    Apr 22 00:20:01 localhost.localdomain systemd[1]: Started Session 5 of user root.
    -- Subject: Unit session-5.scope has finished start-up
    -- Defined-By: systemd
    -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    --
    -- Unit session-5.scope has finished starting up.
    --
    -- The start-up result is done.
    Apr 22 00:20:01 localhost.localdomain systemd[1]: Starting Session 5 of user root.
    -- Subject: Unit session-5.scope has begun start-up
    -- Defined-By: systemd
    -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    --
    -- Unit session-5.scope has begun starting up.
    Apr 22 00:20:01 localhost.localdomain CROND[4074]: (root) CMD (/usr/lib64/sa/sa1 1 1)
     
    Last edited: Apr 22, 2017
  4. Jimmy

    Jimmy Premium Member Premium Member

    1,114
    247
    63
    Oct 24, 2015
    East Coast USA
    Ratings:
    +596
    Local Time:
    12:59 AM
    1.13.x
    MariaDB 10.1.x
    Opps forgot the password for root login. Let me try that again.

    I actually did do the root w/ password. Still won't restart.
     
  5. Jimmy

    Jimmy Premium Member Premium Member

    1,114
    247
    63
    Oct 24, 2015
    East Coast USA
    Ratings:
    +596
    Local Time:
    12:59 AM
    1.13.x
    MariaDB 10.1.x
    username and password seem to work. Just wonder why it won't restart after the change.
     
  6. eva2000

    eva2000 Administrator Staff Member

    30,163
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    2:59 PM
    Nginx 1.13.x
    MariaDB 5.5
  7. Jimmy

    Jimmy Premium Member Premium Member

    1,114
    247
    63
    Oct 24, 2015
    East Coast USA
    Ratings:
    +596
    Local Time:
    12:59 AM
    1.13.x
    MariaDB 10.1.x
    Finally got it to work! Whoot! Forgot to kill the processes. I had the FAQ in my docs not that thread. I'll make a new doc for the new way to change the root pw. Thank for your help!
     
  8. eva2000

    eva2000 Administrator Staff Member

    30,163
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    2:59 PM
    Nginx 1.13.x
    MariaDB 5.5
    yeah as the thread says MariaDB 10.1 change root password method outlined in official documentation doesn't work, I had to do the extra steps outlined at https://community.centminmod.com/th...r-password-for-centos-7-mariadb-10-1-19.9811/ to make it work :)
     
    • Like Like x 1
  9. Jimmy

    Jimmy Premium Member Premium Member

    1,114
    247
    63
    Oct 24, 2015
    East Coast USA
    Ratings:
    +596
    Local Time:
    12:59 AM
    1.13.x
    MariaDB 10.1.x
    I really appreciate your help. :)
     
    • Like Like x 1
  10. Jimmy

    Jimmy Premium Member Premium Member

    1,114
    247
    63
    Oct 24, 2015
    East Coast USA
    Ratings:
    +596
    Local Time:
    12:59 AM
    1.13.x
    MariaDB 10.1.x
    @eva2000 you might want to make a note in https://community.centminmod.com/th...r-password-for-centos-7-mariadb-10-1-19.9811/ that if the user is planning on using special characters in their MySQL root password in the .my.cnf they have to put the password in ' '.

    Otherwise the the root password won't work unless the user does mysql -u root -p and enters the password. I kept getting an error when I entered mysql and in the cminfo until I put the password in the .my.cnf like this: password='kkjdfk#kjkl2kjlk$dfkj'
     
    • Informative Informative x 1
  11. eva2000

    eva2000 Administrator Staff Member

    30,163
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    2:59 PM
    Nginx 1.13.x
    MariaDB 5.5
    updated :)