lefred's blog


There Are 10 Types of People in the World....

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.


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 1410 (42000): You are not allowed to create a user with GRANT). This means that to grant some privileges, the … Read More


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 an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right … Read More


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 to honor to talk about MySQL: MySQL Innovation Day in Stockholm (Jan 23rd) pre-FOSDEM MySQL Day in Brussels (Feb 1st) … Read More


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 if it’s lagging or not (see link1 and link2). I received recently a very valuable contribution from Bruce DeFrang that … Read More


recent

Last Tweets

Locations of visitors to this page
categories