#785 Support for user information

Needs_decision
wont-fix
nobody
Privileges (25)
5
2013-06-11
2005-09-27
Michal Čihař
No

MySQL (at least 5.x) has support for storing additional
user information in mysql.user_info table. It should be
possible to read and modify these values from
privileges page.

Information that can be stored in that table:

- Full name
- Description
- Email
- Contact information
- Icon (BLOB)

Discussion

1 2 > >> (Page 1 of 2)
  • Michal Čihař
    Michal Čihař
    2005-09-27

    • labels: --> Privileges
     
  • Michal Čihař
    Michal Čihař
    2005-10-02

    Logged In: YES
    user_id=192186

    Okay, I was wrong. This table is created by MySQL
    Administrator and used by it.

    However we can still support this.

     
  • Yanster
    Yanster
    2010-01-21

    If anything, this information could very well be stored in the pma database (at worse) or pma could create the table in the mysql database if it doesn't exist (respecting the same structure as the one created by MySQL Administrator).

    For a MySQL server admin, having those details about user accounts is crucial. The lack of it means we have to keep track of those accounts somewhere else (i.e. in an Excel Spreadsheet) or create our own custom MySQL user manager.

    Pma being what it is, it SHOULD do that already. I'm very surprised that it hasn't been done before. For this reason, I think it should be prioritized as a new feature.

     
  • Marc Delisle
    Marc Delisle
    2010-01-21

    ygirouard,
    as phpMyAdmin SHOULD do that already, are you willing to help coding this feature?

     
  • Hello,
    I'm new to developing for phpMyAdmin and saw this on the Junior tasks page (http://wiki.phpmyadmin.net/pma/Devel:Junior) and would like to do this. Waiting for the go ahead and hopefully some starting pointers. btw I'm a college student.

     
  • Michal Čihař
    Michal Čihař
    2010-03-25

    I'm not aware of anybody working on this, so feel free to go ahead!

    All what is needed is to add edit boxes for mentioned fields in privileges page (server_privileges.php) while editing/creating user.

     
  • Are there anybody working in this task? If not, I will.

     
  • Ammar  Yasir
    Ammar Yasir
    2011-03-13

    I'll try this one is someone is not already working on this.

     
  • Ammar  Yasir
    Ammar Yasir
    2011-03-13

    *if

     
  • Marc Delisle
    Marc Delisle
    2011-03-14

    Sure.

     
  • Louis H
    Louis H
    2011-03-17

    I would appreciate if you can leave this ticket for me as I am already working on this. I am planning to publish my patch in week or two.

     
  • Marc Delisle
    Marc Delisle
    2011-03-17

    Both louisha and ammaryasir can work on this separately and publish their patch.

     
  • Gayan Hewa
    Gayan Hewa
    2011-03-26

    HI Nijel ,

    Is this feature request still open ?

    Can i dedicate my self for this :)

     
  • Hi, Nijel!

    I had not seen some people were trying to work on this feature and then I started to dedicated myself for it. So I'd like to join the conversation.

    Anyway, I have a doubt: do you think we should allow the user to upload an image and store it in the Database? There are some discussions about security, efficiency etc

    We could use the upload directory to store it. What do you t guys think?

     
  • Oooh.. And the feature is still an open request, right?

     
  • Koifim
    Koifim
    2012-03-19

    Is this still not developed? If not I'm willing to contribute some of my time to build this feature!

     
  • Marc Delisle
    Marc Delisle
    2012-03-19

    Indeed this feature request is still not developed.

     
  • Ahmed Waheed
    Ahmed Waheed
    2012-04-10

    I'm working on this feature now.

     
  • Kulisek23
    Kulisek23
    2012-05-13

    I am working on this feature.

     
  • Michal Čihař
    Michal Čihař
    2012-11-19

    BTW: The bellow pull request was not merged, so this feature is still not implemented.

     
  • Is there anything in this ticket that need working?

     
  • Marc Delisle
    Marc Delisle
    2013-02-04

    This feature has not been implemented. As Michal mentions, there was an attempt which was not accepted.

     
  • Reported bug when using user_info table to support hosts can be located at [1]
    Problem explained in this bug description affects requested feature.
    note that this bug is resolved as a "won't fix"

    If this feature is going to be implemented we can follow "Suggested fix:" for given bug as is, or create a new table in PMA data base to hold additional information.

    [1] http://bugs.mysql.com/bug.php?id=36799

     
    Last edit: Sameera Kannangara 2013-04-19
1 2 > >> (Page 1 of 2)