MySQL 8.0 and user password management
I already covered some information related to users password recently (see this post and this one). Today, let’s have a look at the password management features available in MySQL 8.0.
lefred
I am MySQL Community Manager for EMEA & APAC. I joined the MySQL Community Team in May 2016. I have been an OpenSource and MySQL consultant for more than 15 years. My favorite topics are High Availability and Performance.
How to grant privileges to users in MySQL 8.0
It seems, that this is a question that regularly shows up in forums or stackoverflow. To start, let’s highlight the fact that in MySQL 8.0 it’s not any more possible to create a user directly from the GRANT command (ERROR…
MySQL 8.0 and keywords
As you know, MySQL uses some keywords and some of them are also reserved. Let’s have a look how to deal with that: mysql> create table WRITE (id int auto_increment primary key, varying varchar(10), than int); ERROR 1064 (42000): You…
Have a nice MySQL Season Holidays
I wish you all the best for this end of 2018 and of course a nice start of 2019’s edition ! For the best possible start of 2019, I already invite you to these different events where I will have…
Group Replication: A member in “RECOVERING” state is part of the primary partition
If you are using MySQL InnoDB Cluster (Group Replication) with ProxySQL, you should be familiar with the 2 functions and 1 view required in SYS Schema that ProxySQL uses to see if a node is online, partitioned or not, and…
