Difference between revisions of "PHPMYADMIN"
Jump to navigation
Jump to search
(→Ubuntu) |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 12: | Line 12: | ||
$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]]== | ==[[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