Topic: MySQL and PHPmyadmin Problems on SME 7

[discovery]

HI All,

I have just upgraded to SME 7 (Wow what a nice server!) but I have the following problem

I am trying to get into the Phpmyadmin console as I did on my old SME 6 server

I have downloaded the following rpm from a post here on Contribs.org and have installed it

smeserver-phpmyadmin-multiuser-2.1-1.noarch.rpm

Now I have the following problems when I try to access the site

https://<your severname>/myadmin

Welcome to phpMyAdmin 2.8.2
Error:#1045 - Access denied for user 'admin'@'localhost' (using password: YES)
         
Cookies must be enabled past this point.

ok my cookies are enabled and I have had a good dig around Contribs and have tried a couple of posts and nothing appears to work

Is there a way to uninstall Phpmyadin 2.8.2 and install an older version or can I get around this error message?????

This ia driving me insane  

Any help would be greatly appreciated!!!!!!!!  

Cheers

Discovery

[steveo]

I logged into PHPmyadmin using:

User - root
password from:

Code: [Select]

cd /root
cat .my.cnf

You should be able to login using the admin user and password, but until I figure it out it is a work around.

[steveo]

In case anyone else has this problem:

1. The initial login and password for phpmyadmin is login="admin" & password="admin"
2. The password is changed using the privileges section of phpmyadmin. (Locate the admin user and assign a new password there).
3. If you have recently upgraded mysql you will need run the script "/usr/bin/mysql_fix_privilege_tables" providing the mysql root password.
4. The mysql root password can be obtained by:
 

Code: [Select]

cd /root
cat .my.cnf
Run the fix_privilege_tables by typing:

Code: [Select]

/usr/bin/mysql_fix_privilege_tables --password=[password from above]
Then change the admin password as per step two above.