Showing entries 1 to 10 of 22
10 Older Entries »
Displaying posts with tag: users (reset)
MySQL 8.0 new features in real life applications: roles and recursive CTEs

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, …

[Read more]
Reinstall MySQL and Preserve All MySQL Grants and Users

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.

[Read more]
Roles on MySQL 8.0

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 …
[Read more]
Why Oracle’s donation of OpenOffice disappoints

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 …

[Read more]
Dueling Conferences and the Art of Hyperbole

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 …

[Read more]
MySQL track at ODTUG conference 2010

The Oracle Development Tools Users Group (ODTUG) is holding its annual conference in Washington, DC, from June 27th to July 1st. The great news this year is that, at popular demand, there will be a MySQL track, organized and manned by the MySQL community.

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, …

[Read more]
The MySQL Community meets the Independent Oracle Users Group
After the MySQL Conference, while most of my European colleagues were busy with volcanic disruptions and seeking alternative routes to the Old Continent, I headed to Las Vegas, to attend Collaborate10 a conference different from the ones I have been used so far.

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 …

[Read more]
The MySQL Community meets the Independent Oracle Users Group
After the MySQL Conference, while most of my European colleagues were busy with volcanic disruptions and seeking alternative routes to the Old Continent, I headed to Las Vegas, to attend Collaborate10 a conference different from the ones I have been used so far.

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 …

[Read more]
The MySQL Community meets the Independent Oracle Users Group
After the MySQL Conference, while most of my European colleagues were busy with volcanic disruptions and seeking alternative routes to the Old Continent, I headed to Las Vegas, to attend Collaborate10 a conference different from the ones I have been used so far.

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 …

[Read more]
CAOS Theory Podcast 2009.12.04

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)

Showing entries 1 to 10 of 22
10 Older Entries »