Want more timely Centmin Mod News Updates?
Become a Member

MariaDB Password is wrong after fresh install

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by R0rke, Jan 7, 2018.

  1. R0rke

    R0rke Member

    124
    17
    18
    Jun 2, 2016
    Iran
    Ratings:
    +28
    Local Time:
    12:17 PM
    1.11.1
    10.1
    i don't know maybe its 10th time i installing a fresh centminmod and i allways having problem with mysql root password i just simply do password change to fix it .
    but the question is how i detrmine new password for wp-cli ?
    i mean when i chaning root password menu option 22 errors when creates database
    please some advise ? i think i just need to put the new password in my.cnf ?
    am i right is that enough ?
     
  2. eva2000

    eva2000 Administrator Staff Member

    37,324
    8,156
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,554
    Local Time:
    6:17 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    123.08stable or 123.09beta01 ? 123.09beta01 has more improved routines.

    • But how are you entering the password ? Copy and paste ?
    • How are you copying and pasting ? highlighting the password and right click copy ?
    • What is your local PC's default language ? Default language/character set for your SSH clients ? Some character sets non-English can be problematic so ensuring English/UTF-8 language and character set will help
    • CentOS 6 or 7 ?
    See MariaDB - How to reset MySQL root user password for CentOS 7 / MariaDB 10.1.19+

    after changing mysql root password also edit edit /root/.my.cnf with new mysql root password wrapped in single quotes
    Code (Text):
    [client]
    user=root
    password='MyNewPass'
    

    if you have problems some passwords require removing the single quotes

    and MariaDB MySQL - CentminMod.com LEMP Nginx web stack for CentOS for CentOS 6
     
    • Like Like x 1
..