赋于权限出错了，请高人帮助看一下

cenalulu

这里还有一个相似的症状：
http://forums.mysql.com/read.php?30,159744,159744

感觉bug的可能性比较大，换个版本试试？

wangc0727

show grants for 'bbs'.'cdb_threads';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.'cdb_threads'' at line 1

show grants for bbs;              
+---------------------------------------------------------------------------------------------------------------------------------------------------+
| Grants for bbs@%                                                                                                                                |
+---------------------------------------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'bbs'@'%' IDENTIFIED BY PASSWORD '4dda5b0b2150b69c'                                                                       |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON `bbs`.* TO 'bbs'@'%'    |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON `oaweixiu`.* TO 'bbs'@'%' |
+---------------------------------------------------------------------------------------------------------------------------------------------------+


实在不行我换个版本试试吧

[ 本帖最后由 wangc0727 于 2009-11-10 09:35 编辑 ]

ruochen

bug的可能性比较大

检查mysql的所有log
看mysql在这个过程中是不是出什么问题了

wangc0727

Number of processes running now: 0
091109 15:27:01  mysqld restarted
091109 15:27:01 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
091109 15:27:01 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
091109 15:27:01 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.58-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
091109 15:27:05 - mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.

key_buffer_size=1073741824
read_buffer_size=16777216
max_used_connections=10
max_connections=1000
threads_connected=2
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 262144 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd=0x6f190e00
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Cannot determine thread, fp=0x6ed9bb0c, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x81a4265
0x84ead0b
0x84eb248
0x823a023
0x81bf077
0x81c1420
0x81c223d
0x81c359f
0x4f23cc
0x44ac3e
New value of fp=(nil) failed sanity check, terminating stack trace!
Please read http://dev.mysql.com/doc/mysql/en/using-stack-trace.html and follow instructions on how to resolve the stack trace. Reso
lved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0xaa99ec0 = grant  update on `bbs`.`cdb_threads` to 'abc'@'%'  identified by 'pass'
thd->thread_id=109
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.


以上为错误日志的信息，帮我看看吧

cenalulu

可以比较肯定是bug了，最直接的方法，换个版本。
我的感觉是这条语句和现有的某条记录冲突产生了bug，楼主可以试试，把bbs相关的这3条先revoke掉，再执行这条语句看看会不会报错。

cenalulu

更正：
我10楼说的语句应该是，show grants for bbs@'%' ;
不是show grants for bbs.cbd_threads;              
细心的楼主已经发现拉～

ruochen

原帖由 wangc0727 于 2009-11-10 10:03 发表
Number of processes running now: 0
091109 15:27:01  mysqld restarted
091109 15:27:01 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
091109 15:27:0 ...

应该是bug
join_size在参数中限制下吧
buffer_size你看看要不要做调整

其余的参考LS的建议

wangc0727

join_size在参数中限制下吧
buffer_size你看看要不要做调整
以上两项有没有具体的调整方法：

la19850302

动作好快啊

[ 本帖最后由 la19850302 于 2009-11-10 16:30 编辑 ]

Coolriver

原帖由 cenalulu 于 2009-11-9 15:02 发表
coolriver也粗心了。。。。注意数据库名和表名，外面是反引号不是引号
grant  update on `bbs`.`cdb_threads` to 'abc'@'%'  identified by 'pass';

如果还报错，贴一下报错信息

一般情况下是：单引号，执行附号都可以的。