You are not logged in.

#1 2012-12-31 00:48:11

justin91101990
Member
From: Philadelphia
Registered: 2012-12-19
Posts: 6
Website

PhpMyAdmin Error #1045 Can not log in to the MySQL Server

Having trouble when ever I enter in my username and password it won't log in  /etc/webapps/phpmyadmin/config.inc.php here is a snippet of the config where I suppose the error is being generated:

$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysql if your server does not have mysqli */
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'mypasswordhere';
$cfg['Servers'][$i]['AllowNoPassword'] = FALSE;

/*
* phpMyAdmin configuration storage settings.
*/

/* User used to manipulate with storage */
// $cfg['Servers'][$i]['controlhost'] = '';
// $cfg['Servers'][$i]['controluser'] = 'root';
// $cfg['Servers'][$i]['controlpass'] = 'mypasswordhere';

Last edited by justin91101990 (2012-12-31 00:48:32)

Offline

#2 2012-12-31 01:13:21

JokerBoy
Member
From: România
Registered: 2009-09-24
Posts: 641
Website

Re: PhpMyAdmin Error #1045 Can not log in to the MySQL Server

mysqli is loaded?

php -m|grep mysqli

Offline

#3 2012-12-31 09:22:39

yaffare
Member
Registered: 2011-12-29
Posts: 71

Re: PhpMyAdmin Error #1045 Can not log in to the MySQL Server

You do not put username and password in config.inc.php, this is only if you use $cfg['Servers'][$i]['auth_type'] = 'config';
but this means that the user is directly logged in and only when you have created the user in mysql first. This method is not recommened. just comment out user and password and then create the user IN MYSQL. If you have not set a root password yet you can do that by executing mysql_secure_installation on the command line. Just test the user to log in to mysql directy from the command line like this "mysql -u user -p". Only if you can log in from the command line, but not from phpmyadmin, then something with phpmyadmin configuration is wrong.


systemd is like pacman. enjoys eating up stuff.

Offline

Board footer

Powered by FluxBB