Welcome to the PufferPanel community forums! Please visit our discord for support: https://discord.gg/v8dz49e

ERROR 1045 (28000): Access denied for user



  • I just installed pufferpanel on my Debian 9.8 server. everything seemed to install fine but after I ran ./pufferpanel updatesite to set it up to a subdomain I received an error

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

    I figured that after I ran mysql_secure_installation it stopped allowing root access form something like pufferpanel. So I created a new mysql user called pufferpanel and granted it full rights, and went ahead and dropped the DB (./pufferpanel won't work as it just returns ERROR 1045). I also double checked that my sql user was working via mysql -upufferpanel -p and I logged in fine.

    root@web:/srv/pufferpanel# ./pufferpanel install
    PHP 7.1.0+: [Installed]
    PHP-curl: [Installed]
    PHP-hash: [Installed]
    PHP-openssl: [Installed]
    PHP-pdo: [Installed]
    PHP-pdo_mysql: [Installed]
    ------------
    Thank you for using the PufferPanel installer!
    Please do not run this installer if PufferPanel has already been installed without first running ./pufferpanel purge
    
    Before we can complete the installation, we need to ask you some questions
    These questions will help configure PufferPanel so that you can get to using it
    ------------
    MySQL Configuration
    Enter the MySQL host [localhost]:
    Enter the MySQL port [3306]:
    Enter the MySQL username (MUST HAVE GRANT) [root]: pufferpanel
    Enter the MySQL account password:
    Creating pufferpanel account and installing database...
    ERROR 1044 (42000) at line 2: Access denied for user 'pufferpanel'@'localhost' to database 'pufferpanel'
    MySQL has been configured and the database was installed
    Switching to new user for further commands
    
    

    Again I am getting "Access Denied". What am I missing here?


Log in to reply
 

5
Online

1.1k
Users

946
Topics

3.8k
Posts