I am happy that the MySQL team is, during the last years, blogging about each major feature that MySQL Server is getting; for example, the series on Recursive Common Table Expressions. Being extremely busy myself, …

In this blog post, we’ll look at how to preserve all MySQL grants and users after reinstalling MySQL.

Every so often, I need to reinstall a MySQL version from scratch and preserve all the user accounts and their permissions (or move the same users and privileges to another server).

As of MySQL 5.7, MySQL does not make this easy! MySQL SHOW GRANTS only shows permissions for one user, and the method suggested on StackExchange – dumping tables containing grants information directly – is not robust (as Rick James mentions in the comments). It also doesn’t work between different MySQL versions.

…

This is a blogpost about MySQL 8.0.0, the content here could be subject to changes in the future since this is not a stable release.

This is a feature that will make life the many DevOps and DBAs easier. Believe it or not, a lot of people control access to the database by sharing the same username and password. Which is completely insecure for a number of reasons:

• If someone is fired, they still have access
• If you get hacked for using the same password, well, I only can say: good luck

That also means: no more querying to Stack Overflow to get that giant GRANT statement for each user you need to create. (Thank you @mwop for reminding me of this).

Creating a Role

This is a group of privileges that will be assigned to users:

CREATE ROLE …

While Oracle deserves some praise for its donation of OpenOffice.org code to the Apache Foundation, it is disappointing again to see a legitimate open source market contender that has been marginalized by miscommunication and mismanagement of the project by a large vendor.

OpenOffice.org, warts and all, was probably the most significant competition for Microsoft Office for years and in many ways demonstrated the advantages of open source, helping usher in wider use of it, as well as greater usability. OO.o was in fact my reason for originally investigating and moving to open source software more than a decade ago. Regardless of past mismanagement of community and technology, that competitive factor has been diminished greatly since Oracle took ownership of OO.o. Now, after prompting a fork — as has …

Last week someone sent me an article about the “dueling” MySQL conferences from IOUG and O’Reilly. On the one hand, I find it really entertaining that there’s a perception that, three years ago, when the Sun acquisition wasn’t even on the radar, we purposefully scheduled our conferences against each other in anticipation of this moment. If we had a crystal ball or the ability to see the future that well, I would have picked better lottery numbers three weeks ago.

The sad part is all the focus is placed on a hypothetical negative, and it overshadows the real point of the article – that a collection of MySQL community supporters are pooling their time and effort to make sure the community stays strong. I’m lucky enough to get to work with the MySQL Council, and so I know that working on anything related to MySQL is about …

The ODTUG is an independent group of very skilled Oracle users, fond of high level training, specifically in matters of development tools. This year, after the Sun acquisition was finalized, the ODTUG board of directors asked the MySQL community to provide some contents for their conference, …

Collaborate10 is the conference of the Oracle Users Groups. I had been asked to participate with a few talks on MySQL, and I was curious of meeting this for me new organization. I prepared three talks, one introduction to MySQL and two advanced ones, and thus equipped I ventured …

Collaborate10 is the conference of the Oracle Users Groups. I had been asked to participate with a few talks on MySQL, and I was curious of meeting this for me new organization. I prepared three talks, one introduction to MySQL and two advanced ones, and thus equipped I ventured …

Collaborate10 is the conference of the Oracle Users Groups. I had been asked to participate with a few talks on MySQL, and I was curious of meeting this for me new organization. I prepared three talks, one introduction to MySQL and two advanced ones, and thus equipped I ventured …

Topics for this podcast:

*As the Oracle-Sun-MySQL EC world turns
*Google gets its Web on with Go and Chrome
*Open source and cloud computing complement, compete
*How transparent is your open core?

iTunes or direct download (26:20, 6.0 MB)