Koozali.org: home of the SME Server

[CONTRIB UPDATE] phpmyadmin-multiuser

Offline MasterSleepy

  • *
  • 386
  • +0/-0
    • http://www.vanhees.cc
[CONTRIB UPDATE] phpmyadmin-multiuser
« Reply #15 on: January 10, 2007, 09:44:43 AM »
Hello william,

Ok I'll made a new version of this contrib asap.

Regards.

Offline william_syd

  • ****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
[CONTRIB UPDATE] phpmyadmin-multiuser
« Reply #16 on: January 10, 2007, 10:43:43 AM »
Quote from: "MasterSleepy"
asap.



No need to rush... :)

Thank You.
Regards,
William

IF I give advise.. It's only if it was me....

Offline MasterSleepy

  • *
  • 386
  • +0/-0
    • http://www.vanhees.cc
[UPDATED] smeserver-phpmyadmin-multiuser-2.9.2-1
« Reply #17 on: January 19, 2007, 08:48:16 AM »
Hello all,

I've updated phpmyadmin-multiuser contrib to use lastest version(2.9.2) of it.
It also correct template problem.


RPM :
http://www.vanhees.cc/modules.php?op=modload&name=CmodsDownload&file=index&req=viewdownloaddetails&lid=296&ttitle=smeserver-phpmyadmin-multiuser-2.9.2-1.noarch.rpm

sRPM :
http://www.vanhees.cc/modules.php?op=modload&name=CmodsDownload&file=index&req=viewdownloaddetails&lid=297&ttitle=smeserver-phpmyadmin-multiuser-2.9.2-1.src.rpm

Install instruction:
Code: [Select]
wget "http://www.vanhees.cc/index.php?name=CmodsDownload&file=index&req=getit&lid=296"
rpm -Uvh smeserver-phpmyadmin-multiuser-2.9.2-1.noarch.rpm


Regards.

Beast

Unable to login as admin
« Reply #18 on: January 29, 2007, 11:40:09 AM »
Have installed the contrib but the logon screen tells me that the logon/password is wrong - using admin. Have also tried root and users etc.

What can be wrong?

NB: New installation of 7.1

Offline william_syd

  • ****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
[CONTRIB UPDATE] phpmyadmin-multiuser
« Reply #19 on: January 29, 2007, 11:41:51 AM »
Username: admin
Password: admin
Regards,
William

IF I give advise.. It's only if it was me....

Beast

[CONTRIB UPDATE] phpmyadmin-multiuser
« Reply #20 on: January 29, 2007, 11:44:42 AM »
:lol:

Beast

[CONTRIB UPDATE] phpmyadmin-multiuser
« Reply #21 on: January 29, 2007, 11:47:29 AM »
How do i change this easy password?

In the user table of MySQL as allways?

Offline william_syd

  • ****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
[CONTRIB UPDATE] phpmyadmin-multiuser
« Reply #22 on: January 29, 2007, 11:55:02 AM »
Quote from: "Beast"
How do i change this easy password?

In the user table of MySQL as allways?


In keeping with the easy theme...

Edit /opt/administration/phpmyadminmulti/config.inc.php and change this bit. Save and login to phpmyadmin and you will have a change password prompt on the fist screen.

 
Code: [Select]
// In the main frame, at startup...
$cfg['ShowStats']             = TRUE;   // allow to display statistics and space usage in
                                        // the pages about database details and table
                                        // properties
$cfg['ShowMysqlInfo']         = TRUE;  // whether to display the "MySQL runtime
$cfg['ShowMysqlVars']         = TRUE;  // information", "MySQL system variables", "PHP
$cfg['ShowPhpInfo']           = TRUE;  // information" and "change password" links for
$cfg['ShowChgPassword']       = TRUE;  // simple users or not
$cfg['SuggestDBName']         = TRUE;   // suggest a new DB name if possible (false = keep empty)
Regards,
William

IF I give advise.. It's only if it was me....

Offline MasterSleepy

  • *
  • 386
  • +0/-0
    • http://www.vanhees.cc
[CONTRIB UPDATE] phpmyadmin-multiuser
« Reply #23 on: January 29, 2007, 02:09:07 PM »
Quote from: "Beast"
How do i change this easy password?

In the user table of MySQL as allways?

Hello,

You can use phpmyadmin to change it!
Take a look at "privileges" option in main screen of phpmyadmin.

Regards.

Beast

[CONTRIB UPDATE] phpmyadmin-multiuser
« Reply #24 on: January 29, 2007, 02:57:35 PM »
There is something I do not understand here!

If I change a password in the user table or by the privileges screen it is not reflected when I try to access the DB again.

The only thing that work is the admin/admin combination.

This is really not good!

I have tried to create new users and access the DB from PHP, but only admin/admin work (and I have even changed the password for the admin user)


???????????????????????????????

Beast

[CONTRIB UPDATE] phpmyadmin-multiuser
« Reply #25 on: January 29, 2007, 03:09:38 PM »
Just found out how to update privileges !!!!!

 :oops:

Offline MasterSleepy

  • *
  • 386
  • +0/-0
    • http://www.vanhees.cc
[CONTRIB UPDATE] phpmyadmin-multiuser
« Reply #26 on: January 29, 2007, 03:13:45 PM »
Try launching the following commands:
Code: [Select]

update user set Password=PASSWORD('theoneyouwant') WHERE host='localhost' and user='admin';
flush privileges;

You have to been connected to mysql database

Regards.

pnmls

Can't access users-panel in phpmyadmin
« Reply #27 on: January 30, 2007, 11:54:58 PM »
Hi,
I'm new to this, so I'll try to explain the best I can!!!

I've SME server installed and upgraded till v.7.1
I've installed phpmyadmin v.2.9.2 and phpmyadmin-multiuser and followed the directives posted here.

Now accessing users-panel (priveligies???) in phpmyadmin I get this:
"Warning: Your privilege table structure seems to be older than this MySQL version!
Please run the script mysql_fix_privilege_tables that should be included in your MySQL server distribution to solve this problem!"

The MySQL version is 4.1.2 and problem is I can't find the script "mysql_fix_privilege_tables".
Do you know how to get it or what can I do to get over this?!?!?!

Thanks,
Pedro Silva

livinginx

[CONTRIB UPDATE] phpmyadmin-multiuser
« Reply #28 on: January 31, 2007, 02:01:15 AM »
Same as the guy above me,
But, when I run
Code: [Select]
mysql_fix_privilege_tables

It returns:
Code: [Select]
Got a failure from command:
cat /usr/share/mysql/mysql_fix_privilege_tables.sql | /usr/bin/mysql --no-defaults --force --user=root --host=localhost --database=mysql
Please check the above output and try again.

Running the script with the --verbose option may give you some information
of what went wrong.

If you get an 'Access denied' error, you should run this script again and
give the MySQL root user password as an argument with the --password= option


So, now I am lost.  Any ideas?

livinginx

[CONTRIB UPDATE] phpmyadmin-multiuser
« Reply #29 on: January 31, 2007, 03:51:15 AM »
Bah, I solved it.
I ran:
Code: [Select]
mysql_fix_privilege_tables --user=admin --password=admin --verbose

There were a couple errors, but now I can access the privileges section of myadmin.