Difference between revisions of "PHPMYADMIN"

From rbachwiki
Jump to navigation Jump to search
 
(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


Ubuntu Tips