Difference between revisions of "PHPMYADMIN"
Jump to navigation
Jump to search
| (5 intermediate revisions by the same user not shown) | |||
| 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 5: | Line 6: | ||
GRANT ALL PRIVILEGES ON *.* TO 'pmauser'@'%' WITH GRANT OPTION; | GRANT ALL PRIVILEGES ON *.* TO 'pmauser'@'%' WITH GRANT OPTION; | ||
/* User for advanced features */ | '''/* User for advanced features */''' | ||
'''/etc/phpmyadmin/config.inc.php''' | '''/etc/phpmyadmin/config.inc.php''' | ||
$cfg['Servers'][$i]['controluser'] = 'username'; | $cfg['Servers'][$i]['controluser'] = 'username'; | ||
$cfg['Servers'][$i]['controlpass'] = 'password'; | $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]]== | |||
[[Category:Mysql]][[Category:PhpMyadmin]] | |||
Latest revision as of 14:27, 11 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';
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