Showing entries 11 to 20 of 22
« 10 Newer Entries | 2 Older Entries »
Displaying posts with tag: users (reset)
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]
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]
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]
Data Backup and Recovery for MySQL - a MySQL Time Machine is Born.

Sure, you've heard it before: [some company's logo] has a new MySQL backup tool that promises to solve all of your data recovery needs. The good news is most of these tools work pretty well. However, they tend to suffer from a similar set of limitations. Most require sophisticated infrastructures or complex setup and maintenance and can become a resource drain for some organizations. You're probably wondering, "Why can't someone build a fully automated MySQL backup solution that you can just turn on and forget?"

I am happy to say that the MySQL Developers at Sun are doing just that. In fact, a prototype will be demonstrated at the 2009 MySQL Users' Conference that will show the feasibility of a fully automated MySQL backup and recovery tool. It's being called the MySQL Time Machine and (with all due respect to all vendors with products of similar names) it allows you to recover your data using a datetime value. How cool is that? Even MySQL …

[Read more]
Data Backup and Recovery for MySQL - a MySQL Time Machine is Born.

Sure, you've heard it before: [some company's logo] has a new MySQL backup tool that promises to solve all of your data recovery needs. The good news is most of these tools work pretty well. However, they tend to suffer from a similar set of limitations. Most require sophisticated infrastructures or complex setup and maintenance and can become a resource drain for some organizations. You're probably wondering, "Why can't someone build a fully automated MySQL backup solution that you can just turn on and forget?"

I am happy to say that the MySQL Developers at Sun are doing just that. In fact, a prototype will be demonstrated at the 2009 MySQL Users' Conference that will show the feasibility of a fully automated MySQL backup and recovery tool. It's being called the MySQL Time Machine and (with all due respect to all vendors with products of similar names) it allows you to recover your data using a datetime value. How cool is that? Even MySQL …

[Read more]
Data Backup and Recovery for MySQL - a MySQL Time Machine is Born.

Sure, you've heard it before: [some company's logo] has a new MySQL backup tool that promises to solve all of your data recovery needs. The good news is most of these tools work pretty well. However, they tend to suffer from a similar set of limitations. Most require sophisticated infrastructures or complex setup and maintenance and can become a resource drain for some organizations. You're probably wondering, "Why can't someone build a fully automated MySQL backup solution that you can just turn on and forget?"

I am happy to say that the MySQL Developers at Sun are doing just that. In fact, a prototype will be demonstrated at the 2009 MySQL Users' Conference that will show the feasibility of a fully automated MySQL backup and recovery tool. It's being called the MySQL Time Machine and (with all due respect to all vendors with products of similar names) it allows you to recover your data using a datetime value. How cool is that? Even MySQL …

[Read more]
Backing up permissions for individual databases

Sometimes, you want to backup individual databases in MySQL to move to a different server. This part is easy using mysqldump:

shell> mysqldump -u root -p --databases db1 db2 ... > backup.sql

The problem is, what happens when you want to backup the permissions associated with these databases? Well, here are a few queries to help you out.

-- Grab the users with global permissions, 
-- with permissions to the databases you want, 
-- and tables/stored procedures in it.
mysql> SELECT u.* INTO OUTFILE '/tmp/user.txt'
        FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\'
        LINES TERMINATED BY '\n'
        FROM
                mysql.user u
        WHERE
                u.Select_priv='Y'
        UNION
        SELECT u.*
        FROM
                mysql.user u,
                mysql.db d
        WHERE
                d.Db IN('db1', 'db2', ...) AND
                d.User = u.user
        UNION
        SELECT u.* …
[Read more]
MySQL Use case Competition - When theory meets practice

MySQL 5.1 is almost ready for prime time, but in the meantime some brave users have already started putting it to work in production environment.

MySQL wants to hear from these intrepid souls. The MySQL 5.1 use Case competition is under way. We want feedback from users who have found a practical usage for 5.1 features, and also from the ones who have met usability challenges.

Two articles have already been published from the competition submissions. One …

[Read more]
The 2008 MySQL Users' Conference - an Engineer's Perspective

This past week was the annual MySQL Users’ Conference. It was my fourth time attending the conference, my second as a MySQL-er, and my first as a Sun employee.

The conference was very well attended with many more people than last year. Overall, I’d say it was a great success.

I work on the Backup project for MySQL and I must say it was a very strange experience being in the spotlight of so much controversy concerning the announcement made about making some backup features enterprise only releases.

While there was a lot of blogging expressing the general distaste for the suggestion of making some features of backup enterprise only (as opposed to free), most of these comments seemed to come from a relatively small number of people.

I presented the Backup session and led the Birds of a Feather session on Backup. I must say that the sentiments of the bloggers was not represented in the audience of these sessions. I …

[Read more]
Showing entries 11 to 20 of 22
« 10 Newer Entries | 2 Older Entries »