各位大侠:
我有一台装有mysql5.0.0-alpha-nt的电脑作为server
现在给另一台电脑设置非管理员权限:如下:
Grant select,update,insert,delete on testdb.testTable to [email protected]
Identified by ‘password’;然后在192.168.1.xx(客户机)上通过mysqlfont可以连接到server上,
但server重启之后发现192.168.1.xx上的权限消失,必须重设才可以连接.但惹设置的是管理员权限则在server重启之后权限不会消失,依旧可以连接,
这是什么问题,请各位高手指教,谢谢!
我有一台装有mysql5.0.0-alpha-nt的电脑作为server
现在给另一台电脑设置非管理员权限:如下:
Grant select,update,insert,delete on testdb.testTable to [email protected]
Identified by ‘password’;然后在192.168.1.xx(客户机)上通过mysqlfont可以连接到server上,
但server重启之后发现192.168.1.xx上的权限消失,必须重设才可以连接.但惹设置的是管理员权限则在server重启之后权限不会消失,依旧可以连接,
这是什么问题,请各位高手指教,谢谢!
flush privileges;
才能永久生效
可我按照你说的做了以后,server重启以后还是没有权限,只是在mysql.user
这个表中显示某个非管理员用户有权限,但却在客户机上不能连接过来.
必须重新设置权限才可以.
不知道为什么?
现在给另一台电脑设置非管理员权限:如下:
Grant select,update,insert,delete on testdb.testTable to [email protected]
Identified by ‘password’;
flush privileges;然后在192.168.1.xx(客户机)上通过mysqlfont可以连接到server的testdb.testTable上,
但server重启以后再在192.168.1.xx(客户机)上通过mysqlfont则只能连接到server的test数据库上,
而不能看到testdb.testTable上.管理员权限则没有这种情况.
mysql.err:MySql: ready for connections.
Version: '5.0.0-alpha-nt' socket: '' port: 3306
061223 9:43:53 MySql: Normal shutdown061223 9:43:55 MySql: Forcing close of thread 9 user: 'steven'061223 9:43:56 InnoDB: Starting shutdown...
061223 9:44:00 InnoDB: Shutdown completed; log sequence number 0 43634
061223 9:44:00 MySql: Shutdown CompleteMySql: ready for connections.
Version: '5.0.0-alpha-nt' socket: '' port: 3306
061223 10:45:27 MySql: Normal shutdown061223 10:45:27 InnoDB: Starting shutdown...
061223 10:45:30 InnoDB: Shutdown completed; log sequence number 0 43634
061223 10:45:30 MySql: Shutdown CompleteMySql: ready for connections.
Version: '5.0.0-alpha-nt' socket: '' port: 3306
061228 11:15:42 MySql: Normal shutdown061228 11:15:43 InnoDB: Starting shutdown...
061228 11:15:51 InnoDB: Shutdown completed; log sequence number 0 43634
061228 11:15:51 MySql: Shutdown CompleteMySql: ready for connections.
Version: '5.0.0-alpha-nt' socket: '' port: 3306
070103 8:11:26 MySql: Normal shutdown070103 8:11:27 InnoDB: Starting shutdown...
070103 8:11:36 InnoDB: Shutdown completed; log sequence number 0 43634
070103 8:11:36 MySql: Shutdown CompleteMySql: ready for connections.
Version: '5.0.0-alpha-nt' socket: '' port: 3306
070105 10:58:28 MySql: Normal shutdown070105 10:58:30 MySql: Forcing close of thread 630 user: 'steven'070105 10:58:30 MySql: Forcing close of thread 626 user: 'steven'070105 10:58:30 MySql: Forcing close of thread 625 user: 'steven'070105 10:58:30 InnoDB: Starting shutdown...
070105 10:58:38 InnoDB: Shutdown completed; log sequence number 0 43634
070105 10:58:38 MySql: Shutdown CompleteMySql: ready for connections.
Version: '5.0.0-alpha-nt' socket: '' port: 3306
070131 10:07:22 MySql: Normal shutdown070131 10:07:24 InnoDB: Starting shutdown...
070131 10:07:34 InnoDB: Shutdown completed; log sequence number 0 43634
070131 10:07:34 MySql: Shutdown CompleteMySql: ready for connections.
Version: '5.0.0-alpha-nt' socket: '' port: 3306
MySql: ready for connections.
Version: '5.0.0-alpha-nt' socket: '' port: 3306
070303 3:09:29 MySql: Normal shutdown070303 3:09:34 InnoDB: Starting shutdown...
070303 3:09:39 InnoDB: Shutdown completed; log sequence number 0 43644
070303 3:09:40 MySql: Shutdown CompleteMySql: ready for connections.
Version: '5.0.0-alpha-nt' socket: '' port: 3306
070312 17:55:19 MySql: Normal shutdown070312 17:55:25 InnoDB: Starting shutdown...
070312 17:55:35 InnoDB: Shutdown completed; log sequence number 0 43644
070312 17:55:35 MySql: Shutdown CompleteMySql: ready for connections.
Version: '5.0.0-alpha-nt' socket: '' port: 3306
070315 10:05:36 MySql: Normal shutdown070315 10:05:40 InnoDB: Starting shutdown...
070315 10:05:51 InnoDB: Shutdown completed; log sequence number 0 43644
070315 10:05:51 MySql: Shutdown CompleteMySql: ready for connections.
Version: '5.0.0-alpha-nt' socket: '' port: 3306
070323 15:12:00 MySql: Normal shutdown070323 15:12:02 InnoDB: Starting shutdown...
070323 15:12:10 InnoDB: Shutdown completed; log sequence number 0 43644
070323 15:12:10 MySql: Shutdown CompleteMySql: ready for connections.
Version: '5.0.0-alpha-nt' socket: '' port: 3306
070329 11:38:28 MySql: Normal shutdown070329 11:38:32 InnoDB: Starting shutdown...
070329 11:38:39 InnoDB: Shutdown completed; log sequence number 0 43644
070329 11:38:39 MySql: Shutdown CompleteMySql: ready for connections.
Version: '5.0.0-alpha-nt' socket: '' port: 3306
MySql: ready for connections.
Version: '5.0.0-alpha-nt' socket: '' port: 3306
070411 8:06:54 MySql: Normal shutdown070411 8:06:55 InnoDB: Starting shutdown...
070411 8:07:03 InnoDB: Shutdown completed; log sequence number 0 43644
070411 8:07:03 MySql: Shutdown CompleteMySql: ready for connections.
Version: '5.0.0-alpha-nt' socket: '' port: 3306
070411 8:25:38 MySql: Normal shutdown070411 8:25:50 InnoDB: Starting shutdown...
070411 8:25:57 InnoDB: Shutdown completed; log sequence number 0 43644
070411 8:25:57 MySql: Shutdown Complete还有很多,一次帖不下
但在mysql.user中还有[email protected]这个用户.
而且在mysql.tables_priv中也有如下数据:
Host DB User Table_name grantor timestamp table_priv .....
192.168.1xx testuser testTable root@localhost 2007-12-15 08:1 select,update这里就是有个timestamp栏位不知道做什么用.
上述表明我是12.15早上给[email protected]赋予权限,
当天没关server可以连接到testdb.testTable上.
到12.16再开server就只能连到test数据库了.
如果我再一次给[email protected]赋予相同权限
其他的数据栏位都没有改变,mysql.user中也没改变.唯一改变的是timestamp栏位变成2007-12-16 08:1不知道是不是这个栏位的值的问题?