Welcome to Centmin Mod Community
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

    Jun 2, 2016
    Local Time:
    10:04 PM
    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

    May 24, 2014
    Brisbane, Australia
    Local Time:
    3:04 PM
    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):

    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