/ Register

Discover Centmin Mod today
Register Now

MariaDB Password is wrong after fresh install

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

Previous Thread Next Thread
Loading...
  1. Jan 7, 2018 #1
    R0rke

    R0rke Member

    168
    22
    18
    Jun 2, 2016
    Iran
    Ratings:
    +37
    Local Time:
    10:29 PM
    2
    10
    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. Jan 7, 2018 #2
    eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    3:29 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    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
     
Previous Thread Next Thread
Loading...

.