Difference between revisions of "PHPMYADMIN"
Jump to navigation
Jump to search
(Created page with "== Fix error mysqli_real_connect(): (HY000/1045)== CREATE USER 'pmauser'@'%' IDENTIFIED BY 'password_here'; GRANT ALL PRIVILEGES ON *.* TO 'pmauser'@'%' WITH GRANT OPTION;") |
|||
| (6 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 ' | CREATE USER 'username'@'%' IDENTIFIED BY 'password_here'; | ||
GRANT ALL PRIVILEGES ON *.* TO 'pmauser'@'%' WITH GRANT OPTION; | 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]]== | |||
[[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