Topic: [ANNOUNCE] phpmyadmin-multiuser for sme server 7

[MasterSleepy]

Hello all,

Following a thead on a french forum, I update phpmyadmin version used in multiuser contribs. Now it used version 2.8.2 of phpmyadmin.
There is some big change in install script of this new rpms, so it's better to uninstall older before.

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

Regards.

[mytime]

Hi MasterSleepy,

Works Great,

I just installed it!

Mytime

[arnoldob]

Thanks for the great contrib to the SME community. I noticed a there was a message to change the default password at the end of the install. Where is the password changed?

[MasterSleepy]

Hello,

It's admin password for mysql, so you can use phpmyadmin to change it in privileges option on the first page.

Regards.

[zach_flem]

hi there,
i tried to change the admin password and have somehow deleted the privileges for the admin user.

how do i got about getting these privileges back?

is it as simple as re-installing phpmyadmin-multiuser??

feedback is appreciated!

Cheers

Zach Fleming

[MasterSleepy]

Hello,

normally by removing and reinstalling after should solve your problem.
Otherwise you can try the following command at root prompt :

Code: [Select]

 mysql --execute="grant all privileges on *.* to admin@localhost identified by 'admin' WITH GRANT OPTION"
  mysql --execute="flush privileges"


Regards.

[Teviot]

Hi All

Have just installed this contrib after uninstalling the contrib by DMay.

I have the following error and don't kknow where to go to fix this.

#1045 - Access denied for user 'admin'@'localhost' (using password: YES)

Can anyone help?

Regard
Teviot

[jmripert]

Hi,

For configuring your phpmyadmin from a simple user archive to a cookie authentification (without download, go directly at the second point), do that :


1/ install
If you have downloaded the archive : rpm -Uvh smeserver-phpmyadmin-2.6.4-pl4.dmay.noarch.rpm

or

rpm -Uvh http://mirror.contribs.org/smeserver/contribs/dmay/smeserver/7.x/smeserver-phpmyadmin-2.6.4-pl4.dmay.noarch.rpm


2/ configure apache (dialog box)
- copy /etc/e-smith/templates/etc/httpd/conf/httpd.conf/86PhpmyadminAlias in /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/86PhpmyadminAlias
- edit /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/86PhpmyadminAlias
- comments require user

3/ configure phpmyadmin (access to mysql)
- copy /etc/e-smith/templates/opt/phpmyadmin/config.inc.php/10config in /etc/e-smith/templates-custom/opt/phpmyadmin/config.inc.php/10config
- édit /etc/e-smith/templates-custom/opt/phpmyadmin/config.inc.php/10config
- insert in blowfish_secret a continuation of character capital and/or tiny letter and number (46 max)
- modify in auth_type http by cookie
- delete the information in Servers’user’ and Servers’password’

You have now a page with a demand of login and password, user is in mysql with the right order...

[MasterSleepy]

Hello,

That's exactly what smeserver-phpmyadmin-multiuser-2.1-1.noarch.rpm made.
Without manual change, of course

Regards.

[chrislaurie]

I am also having the admin password problem described earlier by teviot. The install ran fine and when I need to logon it shows user admin but the admin password does not work I keep getting this error message:

Code: [Select]

#1045 - Access denied for user 'admin'@'localhost' (using password: YES)

What am I doing wrong?

Cheers

Chris

[william_syd]

Which admin password are you using?

Linux or MySQL ?

[MasterSleepy]

Hello,

If you have problem with password, you can reinitialised it.

You have to been connected as root at command line and type the following command:

Code: [Select]

mysql --execute="grant all privileges on *.* to admin@localhost identified by 'admin' with grant option"
mysql --execute="flush privileges"

After that command you can log with
login : admin
password : admin

Regards.