linux sort 使用
LVM创建快照出错
2010/07/19 14:23 | by
因为线上存在mysql版本的差异,因此经常需要mysql4从mysql5 server 上认证去拿资料
因此需要在mysql5上授权mysql4客户端。
方法如下：
mysql> GRANT SELECT ON somedatabase.sometables TO 'some_user'@'some_hosts' identified by 'password';
mysql> update mysql.user set PassWord = OLD_PASSWORD('newpassword')
-> where Host = 'some_host' and user = 'some_user';
mysql> flush privileges;
因此需要在mysql5上授权mysql4客户端。
方法如下：
引用
mysql> GRANT SELECT ON somedatabase.sometables TO 'some_user'@'some_hosts' identified by 'password';
mysql> update mysql.user set PassWord = OLD_PASSWORD('newpassword')
-> where Host = 'some_host' and user = 'some_user';
mysql> flush privileges;
