Showing entries 1 to 10 of 20
10 Older Entries »
Displaying posts with tag: users (reset)
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)

Securich – 0.1.4

Just a small note to advise that Securich reached 0.1.4.
Some new tools include:
* Added Password complexity
* Enhanced `set_password` – Old password is now necessary to replace it by a new one
* Enhanced Revoke privileges to accept regexp
* Added Block user@hostname on a database level
* Added Creation of reserved usernames
* Added Help stored procedure displays help for each stored proc
* Enhanced `create_update_role` to include the removal of privilages from roles
* Enhanced `grant_priveleges` on `alltables` for a database without tables would terminate with an error instead of gracefully (now fixed)
* Added Restore user@hostname on a database level
* Removed ’show warnings’ from sql installation

The database design using workbench is also available in the db folder (for easier understanding of what lies …

[Read more]
MySQL Conference Notes

MySQL Conference 2009 is coming around the corner, next week, in Santa Clara.

You may want to delve into the notes, as a fast way to learn about the happenings.

If you want to become an active code contributor to MySQL, the hackfest by Mark Callaghan seems interesting, and you should probably also start here and here

There will also be a special BoF geared to community contributors. (I still haven't been able to find out about the exact timing of this but you should be …

[Read more]
Showing entries 1 to 10 of 20
10 Older Entries »