PHPMYADMIN
Jump to navigation
Jump to search
Fix error mysqli_real_connect(): (HY000/1045)
you need to create the user that you log in with to phpmyadmin
CREATE USER 'username'@'%' IDENTIFIED BY 'password_here';
GRANT ALL PRIVILEGES ON *.* TO 'pmauser'@'%' WITH GRANT OPTION;
/* User for advanced features */
/etc/phpmyadmin/config.inc.php
$cfg['Servers'][$i]['controluser'] = 'username'; $cfg['Servers'][$i]['controlpass'] = 'password';
Login using system maintenance user
' if the user you created do not have enough privileges
cd /etc/mysql
nano debian.cnf
Just look - don't change anything!
[mysql_upgrade] host = localhost user = debian-sys-maint <----use this user password = s0meRaND0mChar$s <----use this password socket = /var/run/mysqld/mysqld.sock