PHPMYADMIN

From rbachwiki
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


Ubuntu Tips