› MySQL 5.5 Community Server
› MySQL 5.6 Community Server
› Percona Configuration Wizard
› XtraBackup 搭建主从复制
Great Sites on MySQL
› Percona
› MySQL Performance Blog
› Severalnines
推荐管理工具
› Sequel Pro
› phpMyAdmin
推荐书目
› MySQL Cookbook
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
fuge
V2EX  ›  MySQL

关于 mysql 权限的问题,请大家帮忙。

  •  
  •   fuge · Nov 10, 2016 · 2839 views
    This topic created in 3608 days ago, the information mentioned may be changed or developed.
    GRANT ALL PRIVILEGES ON `hello`.* TO 'wang'@'%'
    GRANT SELECT ON `hell0`.`path_for_you` TO 'wang'@'%' WITH GRANT OPTION
    

    wang 有 hello 的所有权限,现在想让 wang 对 hello 中的 path_for_you 表只有只读权限, 上面是

     show grants for 'wang'@'%';
    但是现在的问题是 wang 还能在 path_for_you 中写入

    No Comments Yet
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   3842 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 25ms · UTC 00:11 · PVG 08:11 · LAX 17:11 · JFK 20:11
    ♥ Do have faith in what you're doing.