ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

Discussion in 'Installation/Configuration' started by Pier-Luc, Jun 23, 2020.

  1. Pier-Luc

    Pier-Luc New Member

    Hi Everyone.

    I'm currently following this tutorial:
    The Perfect Server - Debian 10 (Buster) with Apache, BIND, Dovecot, PureFTPD and ISPConfig 3.1
    I'm on step 19, Installing Roundcube, and when I paste in the:

    Code:
    echo "CREATE DATABASE roundcube;" | mysql --defaults-file=/etc/mysql/debian.cnf
    I get the error message:

    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

    I saw that I'm not the only one who met this issue. I've tried to follow some step mentioned in the thread I found to make it work, but I always end up getting a "-->" and I don't know what to do from there.

    Can you lend a hand to a noob. :3

    Thank you :)
     
    Pier-Luc, Jun 23, 2020
    #1
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Check if you really set the correct password in the file /etc/mysql/debian.cnf as described in the tutorial.
     
    till, Jun 23, 2020
    #2
  3. Pier-Luc

    Pier-Luc New Member

    I made it :D

    It was a problem with the keyboard configuration. I'm used to type with the "Canadian multiligual standard", but my RPI seem to be in "French Canadian". So when I type, it does not match ^^' I feel so dumb.

    Thank you for your help :)
     
    Pier-Luc, Jun 25, 2020
    #3
    ahrasis likes this.

Share This Page