Re: [Maria-discuss] mysql_native_password in mysql.user WAS Re: SHOW GRANTS change?

2015-04-15 Thread Sergei Golubchik
Hi, Felipe! On Apr 14, Felipe Gasper wrote: > On 13 Apr 2015 5:34 PM, Sergei Golubchik wrote: > > > >> Should MariaDB not accept “mysql_native_password” as a value in that > >> column? > > > > Right, that's exactly the issue I was referring to. > > I know about this case because I've fixed it. >

[Maria-discuss] MySQL for Database Administrators Ed 3.1

2015-04-15 Thread Lukas Lehner
Hi I will attend "MySQL for Database Administrators Ed 3.1" from Oracle University. I will take 1Z0-883 "OCP MySQL 5.6 Database Administrator" exam. I choose Oracle University because of their high quality education (did quite a lot of courses at them). On my job I will work mainly with MariaDB a

Re: [Maria-discuss] MySQL for Database Administrators Ed 3.1

2015-04-15 Thread Colin Charles
It should be a good background but the new features of MariaDB will obviously not be covered. And it will not help with Galera Cluster as that is completely new compared to what oracle offers. On Wednesday, April 15, 2015, Lukas Lehner wrote: > Hi > > I will attend "MySQL for Database Administra

[Maria-discuss] Does user have SUPER privilege?

2015-04-15 Thread Rasmus Johansson
Hi, I was wondering if there is a straight forward way to check whether a user has SUPER privileges or not. I came up with doing the following: --check for user’s Super_Priv on the current host SELECT Super_Priv FROM mysql.user WHERE user = 'user1' AND host = 'host1'; --and then also check for

Re: [Maria-discuss] Does user have SUPER privilege?

2015-04-15 Thread Peter Laursen
What about SHOW GRANTS FOR 'user'@'host' ?? Refer https://dev.mysql.com/doc/refman/5.6/en/show-grants.html On Wed, Apr 15, 2015 at 7:45 PM, Rasmus Johansson wrote: > Hi, > > I was wondering if there is a straight forward way to check whether a user > has SUPER privileges or not. > > I came up