Arch Linux

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)

JokerBoy

Member

From: România

Registered: 2009-09-24

Posts: 641

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

mysqli is loaded?

php -m|grep mysqli

---

Arch64/DWM || My Dropbox referral link

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.