Menu ▾ ▴

#1242 (ok 4.5) Work with --skip-grant-tables

Needs_decision
resolved
Madhura Jayaratne
MySQL feature (40)
Normal
2015-05-22
2010-05-26
Michal Čihař
No

phpMyAdmin currently fails to work when MySQL is started with --skip-grant-tables (see http://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld_skip-grant-tables\). It might be useful for recovery to work in this state.

Discussion

  • Madhura Jayaratne

    Madhura Jayaratne - 2015-05-11
    • assigned_to: Madhura Jayaratne
    • Group: --> Needs_decision
     

  • Madhura Jayaratne

    Madhura Jayaratne - 2015-05-11

    Testing from the master branch, I am able to log in with any username and any password. Most of the things seems to be working except the following.

    1. Input field to create a new database is not displayed with a message, "no privileges" (However, I can create a new db by executing a query)
    2. Users and Privileges pages do not allow editing privileges
    3. In the database level, events and routines pages are not displayed (missing in menu)

    It looks like 'SHOW GRANTS' queries are not allowed and most of the above are due to that. However, given that this mode is only used temporarily, I'm fine with its current state.

     

  • Madhura Jayaratne

    Madhura Jayaratne - 2015-05-22
    • summary: Work with --skip-grant-tables --> (ok 4.5) Work with --skip-grant-tables
    • status: open --> resolved