phpMyAdmin 开启高级管理特性

phpMyAdmin 开启高级管理特性

TONYLABS 20 Aug, 2014


  1. 导入  phpmyadmin 数据库,一般会跟随各个版本的,下载后解压缩可以找到 create_tables.sql
  2. 创建 pma 帐号
  3. 设置 pma 帐号权限
  4. 更新 文件
  5. 注销 phpMyadmin,再次登录

导入 phpMyadmin 数据库

设置 pma 账户权限

GRANT USAGE ON mysql.* TO 'pma'@'localhost'; GRANT SELECT ( Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv ) ON mysql.user TO 'pma'@'localhost'; GRANT SELECT ON mysql.db TO 'pma'@'localhost'; GRANT SELECT ON TO 'pma'@'localhost'; GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv) ON mysql.tables_priv TO 'pma'@'localhost'; GRANT SELECT, INSERT, UPDATE, DELETE ON phpmyadmin.* TO 'pma'@'localhost';

Like what you're reading? Subscribe to our top stories.

We will continue to update Front; if you have any questions or suggestions, please contact us!

Follow us on Medium, Twitter, Facebook, YouTube, and Dribbble.

Image Description
Written by

Hanna Wolfe

I create advanced website builders made exclusively for web developers.


  • Image Description
    Dave Austin 1 day ago

    As a Special Education teacher this resonates so well with me. Fighting with gen ed teachers to flatten for the students with learning disabilities. It also confirms some things for me in my writing.

    • Image Description
      Hanna Wolfe 1 day ago

      Love it Dave! We're all about keeping it up.

  • Image Description
    Christina Kray 2 days ago

    Since our attention spans seem to be shrinking by the day — keeping it simple is more important than ever.


Post a comment

Stay in the know

Get special offers on the latest developments from Front.