PhpMyAdmin access error

neoice · #1 04-Mar-2009, 05:11

Hi,

Having been a windows user for ages I am now on a steep learning curve with SLES 10.2. I have installed Apache 2.2.3, PHP 5.2.5, MYSQL 5.0.26 and phpMyAdmin 3.1.3 - RC1

When I access phpMyAdmin and enter the root as user name with no password I get an "access denied" error.

I do get the standard "it works!" Apache message and phpinfo is showing MYSQL information - so Apache and PHP seem ok.

If I type /etc/init.d/mysql -u root I can view databases and create tables, etc

I have created the config folder and applied read/write and execute. I have created the config.inc.php file and stored it here.

I really don't know what to try now. I have no problems getting phpMyAdmin to work on a windows computer.

Any advice is much appreciated. TIA
config.inc.php

PHP Code:


/* Servers configuration */
$i = 0;

/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = '';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';

/* End of servers configuration */

$cfg['blowfish_secret'] = '49a55ecf82da66.14425008';
$cfg['DefaultLang'] = 'en-utf-8';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
?>

neoice · #2 04-Mar-2009, 06:39

ok, solved it by change false to true

$cfg['Servers'][$i]['AllowNoPasswordRoot'] = 'true';

admin · #3 04-Mar-2009, 10:46

Good to know, and thank you for sharing the solution.

If I may, a small correction: it is TRUE, not 'true'. Of course what you have now will (probably) also work. But if you had intended to disable the option and put 'false' instead of false, you would still be enabling the option.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Two-Tier data dissemination code installation problem	nidhibansal1984	Computer Software Forum - Linux	6	16-Sep-2007 11:13
Linked Lists advice request	promsan	C Programming Language	74	23-May-2007 09:29
Major newbie problem	cynack	MS Visual C++ / MFC Forum	1	08-Apr-2007 12:25
Winsock error when compiling FLTK 2.0 Projects	mauriciorossi	FLTK Forum	3	16-Aug-2005 11:18
Help with syntax errors	PeteGallo	C Programming Language	7	08-Aug-2005 21:30

PhpMyAdmin access error

Re: PhpMyAdmin access error

Re: PhpMyAdmin access error