One More Possible Reason for ERROR 1959 (OP000) Invalid role specification ift.tt/1C5MMGY Mon, 2015-01-26 09:59chris.calenderI ran into this error today while working with ROLES, bundled privileges for a group of users (a nice addition in MariaDB 10.0): ERROR 1959 (OP000) Invalid role specification The manual suggests that this error occurs if a role that doesnt exist, or to which the user has not been assigned, is specified. However, I ran into a case where the role was created and assigned properly (examine SHOW GRANTS for user in question). In this case, the problem was just due to a bug that affected remote connections on older versions. Thus if you encounter this error, check if youre using a remote connection, and if so, this bug is your problem (assuming you created and assigned the role properly). If interested in reading more about roles, please refer to: ift.tt/1C5MMXe Hope this helps. Tags: Howto About the Author Chris Calender Chris Calender is a Principal Support Engineer with MariaDB. Earlier he was a Principal Support Engineer at MySQL/Sun/Oracle. And before that, he worked as a MySQL DBA and developer for numerous Fortune 500 Companies, including Clear Channel, Western & Southern, and Cincinnati Bell. Chris has both Bachelors and Masters degrees in Computer Science, from Miami University and the University of Cincinnati, respectively. from Planet MySQL ift.tt/1du18ol
Posted on: Mon, 26 Jan 2015 11:10:40 +0000
Trending Topics
Recently Viewed Topics
© 2015