Difference between revisions of "PHPMYADMIN"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
== Fix error mysqli_real_connect(): (HY000/1045)== | == 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'; | CREATE USER 'username'@'%' IDENTIFIED BY 'password_here'; | ||
| Line 11: | Line 12: | ||
$cfg['Servers'][$i]['controluser'] = 'username'; | $cfg['Servers'][$i]['controluser'] = 'username'; | ||
$cfg['Servers'][$i]['controlpass'] = 'password'; | $cfg['Servers'][$i]['controlpass'] = 'password'; | ||
==[[Ubuntu]]== | |||
Revision as of 21:23, 5 May 2022
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';