Topic: phpMyAdmim Error #1045 - Access denied for user 'root'@'localhost' (using passwo

[mgic_box]

  Hello, Good day,

  After having intaled phpMyAdmin 2.11.1.2, acording instructions here:

  http://wiki.contribs.org/PHPMyAdmin

  When I:

  To access PHPMyadmin, go to your-domain/phpmyadmin
The initial login and password for phpmyadmin is login="admin" & password="admin"

  I Got:

------------------
Welcom to phpMyAdmin 2.11.1.2

Probably reason of this is that you did not create configuration file. You might want to use setup script to create one.

Error
Mensagens do MySQL : 

#1045 - Access denied for user 'root'@'localhost' (using password: NO)
----------------
 
  Is this normal?

  Should I "use setup script to create one."

  Or is tomething wrong?

  Thanks in advance.

[cactus]

Fix (until fixed in a new release) is here: http://bugs.contribs.org/show_bug.cgi?id=4321#c3

[mgic_box]

Fix (until fixed in a new release) is here: http://bugs.contribs.org/show_bug.cgi?id=4321#c3

 Thnk you for your fast reply,

 But not worked!!!! ????

[cactus]

Thnk you for your fast reply,

 But not worked!!!! ????

You are sure you did this:

Code: [Select]

expand-templete /opt/phpmyadmin/config.inc.php
Did it output any failure message?

What is the contents of /opt, please do

Code: [Select]

cd /opt; ls -la
What is the output of

Code: [Select]

mysql -e "SHOW DATABASES"

[mgic_box]

Fix (until fixed in a new release) is here: http://bugs.contribs.org/show_bug.cgi?id=4321#c3

 I got this problem, since I used this repair:

To repair this you can follow this:

http://wiki.contribs.org/SME_Server:Documentation:FAQ#Resetting_the_MySQL_root_password

[/quote]

 I had phmyadmin working... til done thais repair...

 Now, deinstaled... reinstaled phpmyadmin, and still unable to use phpmyadmin.

[cactus]

And why did you try to reset the root password? You should not start such drastic measures unless you really now what you are doing.

I think the problem is somewhere else, please answer the questions in this post.

[mgic_box]

 Moved to Webmin!!!!

 Why, if I am the administrator of the machine, I do not know the password of the database?

 Found the password.

 Do

 cat /opt/phpmyadmin/config.inc.php

 Regards

[mgic_box]

And why did you try to reset the root password? You should not start such drastic measures unless you really now what you are doing.

 The full stoy is here:

  http://forums.contribs.org/index.php?topic=40938.msg190143#msg190143

  Regrds.

[mgic_box]

You are sure you did this:

Code: [Select]

expand-templete /opt/phpmyadmin/config.inc.php
Did it output any failure message?

What is the contents of /opt, please do

Code: [Select]

cd /opt; ls -la
What is the output of

Code: [Select]

mysql -e "SHOW DATABASES"

Code: [Select]

[root@alas lib]# cd /
[root@alas ~]# expand-template /opt/phpmyadmin/config.inc.php
[root@alas ~]# cd /opt/
[root@alas opt]# ls -la
total 12
drwxr-xr-x   3 root      root   4096 Oct 19  2007 .
drwxr-xr-x  27 webmaster shared 4096 May  9 16:14 ..
drwxr-xr-x  11 root      root   4096 May  9 16:51 phpmyadmin
[root@alaska opt]# mysql -e "SHOW DATABASES"
+-----------+
| Database  |
+-----------+
| caem      |
| cfc       |
| egasm |
| era   |
| horde     |
| mysql     |
| sme7admin |
+-----------+
[root@alas opt]#

[mgic_box]

You are sure you did this:

Code: [Select]

expand-templete /opt/phpmyadmin/config.inc.php
Did it output any failure message?

What is the contents of /opt, please do

Code: [Select]

cd /opt; ls -la
What is the output of

Code: [Select]

mysql -e "SHOW DATABASES"

 Now it is working!!!!

 Problem solved.

 Sorry for beeing stupid!

 But I am shure, I have done as what was explined ...  (http://bugs.contribs.org/show_bug.cgi?id=4321#c3)

 I think that I do not uderstand nothing of this...

 AnyWay Thank you!

[cactus]

Why, if I am the administrator of the machine, I do not know the password of the database?

Because on SME Server the root password is a random 72 charachter string for security reasons, by a clever mechanism you do not need to type, remember nor know it, because when you login to the SME Server shell as root and issue the mysql command it is automatically filled in.

Furthermore you should only use the root account for administration purposes and never configure an application to use it, create a separate user with the minimal required privileges for the application and configure the appplication to use that user, please read the MySQL FAQ in the wiki as a lot of MySQL related stuff on SME Server is there, furthermore the MySQL manual itself is worth reading I guess.

[cactus]

Code: [Select]

[root@alas opt]# ls -la
total 12
drwxr-xr-x   3 root      root   4096 Oct 19  2007 .
drwxr-xr-x  27 webmaster shared 4096 May  9 16:14 ..
drwxr-xr-x  11 root      root   4096 May  9 16:51 phpmyadmin

So the source directory was there ....

Code: [Select]

[root@alaska opt]# mysql -e "SHOW DATABASES"
+-----------+
| Database  |
+-----------+
| caem      |
| cfc       |
| egasm |
| era   |
| horde     |
| mysql     |
| sme7admin |
+-----------+
[root@alas opt]#

But your database is not... as no phpmyadmin is listed there.

[byte]

Moving this topic to the SME 7.x contribs forum, it is more appropriate there. Thanks!