Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

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

Needs_decision
resolved
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

    • assigned_to: Madhura Jayaratne
    • Group: --> Needs_decision
     
  • 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.

     
    • summary: Work with --skip-grant-tables --> (ok 4.5) Work with --skip-grant-tables
    • status: open --> resolved