--safe-user-create option not taking any effect
Hi Team,
Added safe-user-create flag in my.conf file.
[mysqld]
safe-user-create=ON
Once MySQL started I queried the safe-user-create' variable and returned an empty set.
mysql> SHOW VARIABLES LIKE 'safe-user-create';
Empty set (0.00 sec)
Created a test1 user using the command's
---------------------------------------------
CREATE USER 'test1'@'localhost' IDENTIFIED BY 'test';
GRANT CREATE USER ON *.* TO 'test1'@'localhost';
mysql> SHOW GRANTS FOR 'test1'@'localhost';
+-------------------------------------------------+
| Grants for test1@localhost |
+-------------------------------------------------+
| GRANT CREATE USER ON *.* TO 'test1'@'localhost' |
+-------------------------------------------------+
1 row in set (0.00 sec)
Logged in using test1 user and able to create a user without INSERT(user) privileges
----------------------------------------------------------------------------------------
[root@localhost bin]# ./mysql -utest1 -ptest