On 2014-05-04 9:17 PM, EdwardKing wrote:
I use mysql to create a database and grant rights to a user hadooptest,then I use hadooptest to login mysql and use the database,but it failed. Why raise error after I grant rights? How to solve it? Thanks.
The command sequence ...
mysql> create database hadooptest; mysql> grant all on hadooptest.* to 'hadoopuser'@'%' identified by '123456'; mysql> quit; mysql -u hadoopuser -p Enter password:
works fine, so your problem is due to something other than these commands, possibly other entries in the mysql.user or mysql.db table.
PB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
