Access Denied for User debian-sys-maint

Aug 30, 2018 00:01 · 54 words · 1 minute read

Access denied for user debian-sys-maint

When trying to install phpmyadmin after installing MariaDB 10.3, there might be a permissions error with debian-sys-maint account.

  1. Get debian-sys-maint password
$ cat /etc/mysql/debian.cnf
  1. Login to mysql as root
$ mysql -u root
  1. Grant privilieges to debian-sys-maint in mysql
GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY '<password>';