Unable to login to phpMyAdmin LAMP openSUSE 11.1

Hallo!I recently configured LAMP in my computer.In phpMyAdmin,I configured to have the username root and password mypassword by altering the command below in config.inc.php

$cfg’blowfish_secret’] = ‘mypassword’;

When I load the phpMyAdmin homepage via URL below


and enter username root and password mypassword in the relevant textboxes,I get the error below

#1045 - Access denied for user ‘root’@‘localhost’ (using password: YES)

How do I solve this problem?

$cfg’blowfish_secret’] is used for cookie authentication,
not for storing your mysql password,

try accessing your database through the terminal console, using

mysql -u root -p 

and see whether you could access it or not,

if it still fails, then you must be entering the wrong root password

i have tried to access database using command prompt the password is blank it is enters into mysql but I cant able to access phpmyadmin :frowning:

You first have to create a user in mysql. Then grant that user all privileges, then start phpMyAdmin and use the credentials you created in mysql.

To add to Knurpht post, this article might help you to create users and assigning privileges through terminal.

Good Luck!

On Thu, 21 Oct 2010 13:36:02 +0530, mmarif4u
<mmarif4u@no-mx.forums.opensuse.org> wrote:

> To add to Knurpht post, ‘this article’ (http://anl4u.com/?p=710) might
> help you to create users and assigning privileges through terminal.

that’s a nice tutorial, but it assumes that your MySQL root account
already has a password. last time i installed MySQL, root had no password,
means totally insecure. you’ll find more extensive info. about securing a
new MySQL install and managing users here:

this ‘reference manual’ also answers all other types of questions you may
come across dealing with MySQL. depending on reliability & speed of your
internet connection, you may want to download it to your local machine
from here: http://dev.mysql.com/doc/index.html

if you still have problems configuring phpMyAdmin, you can find the
documentation here: http://www.phpmyadmin.net/home_page/docs.php