#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 3 > >> (Page 1 of 3)
  • 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.

     
1 2 3 > >> (Page 1 of 3)