Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 61 to 90 of 219 Next 30 Older Entries

Displaying posts with tag: Windows (reset)

Using MySqlClientPermission Class on Connector/Net 6.5 to restrict data access
Employee +0 Vote Up -0Vote Down
The release of the new 6.5 Connector/Net version includes a MySqlClientPermission class to help all the users define the security polices to use in the database connections within any application using a MySQL database.
Intellisense Support
Employee +0 Vote Up -0Vote Down

 Intellisense Support in Visual Studio

One of the cool features coming in Connector/NET 6.5 is the support in Visual Studio 2010 of Intellisense for MySql files.

As you probably know, the capability of editing mysql files (in the way of both .mysql raw files included in the solution and stored procedures/functions from Server Explorer) has been around for a while, yet a missing piece of the puzzle was to have advanced completion of sql statements in those files… until now.

Let’s explore the set of features currently implemented as part of Intellisense support.

Note: For completion intellisense features to work a database connection must be properly configured, see images below



  [Read more...]
Intellisense Support
Employee +0 Vote Up -0Vote Down

One of the cool features coming in Connector/NET 6.5 is the support in Visual Studio 2010 of Intellisense for MySql files.

As you probably know, the capability of editing mysql files (in the way of both .mysql raw files included in the solution and stored procedures/functions from Server Explorer) has been around for a while, yet a missing piece of the puzzle was to have advanced completion of sql statements in those files… until now.

Milliseconds value support on DateTime Columns
Employee +0 Vote Up -0Vote Down

Since the release of the 5.6 Community MySQL Server there is support for the milliseconds value in Time, TimeStamp and DateTime types.  You can find more information on this new feature at (http://dev.mysql.com/doc/refman/5.6/en/fractional-seconds.html).  Starting with version 6.5, Connector/Net fully supports milliseconds. This support does not affect compatibility with older versions of MySQL and it gives you the ability to use fractional seconds when combining Connector/Net 6.5 with MySQL Server 5.6 or later.  Let's see how we should use it.

Creating a DateTime column that include Milliseconds value.

You can do this either using Connector/Net or using any MySQL client with a valid connection to your database.

For this case we're going to

  [Read more...]
2011, A great year for MySQL in review...
+11 Vote Up -0Vote Down
I see so many posts on what happened to company X, product Y and dream Z that I couldn't resist the temptation to summarize this great year for MySQL. At the end of 2010, Oracle did an announcement we were all waiting for: MySQL 5.5 is GA! Another year has passed since then and it's time to reflect on what has been done.

I know this is a long post. I tried to rewrite it at least 10 times to make it shorter, but I couldn't condense the list. Hence, I wrote a summary in the beginning for those who don't want to read it all.

I believe that 2011 was an exceptional year for MySQL and I really enjoy being part of this team. I wish all of us a lot of success and fun in the years to come!

Summary:







  [Read more...]
MySQL Connector/Net 6.5.0 beta has been released
Employee +0 Vote Up -0Vote Down
MySQL Connector/Net 6.5.0, a new version of the all-managed .NET driver for MySQL has been released.  This is a beta release of our newest connector and comes with several new features.  It is of beta quality and should not be used in any production environment.  It is appropriate for use with MySQL server versions 5.0-5.6

It is now available in source and binary form from here and mirror sites (note that not all mirror sites may be up to date at this point-if you can't find this version on some mirror, please try again later or choose another download site.)

This new versions brings new features such as
  • Exception and command injector support
  • Millseconds support
  • Better partial-trust support
  • Better





  [Read more...]
MySQL Connector/Net 6.5.0 beta has been released
Employee +0 Vote Up -0Vote Down
MySQL Connector/Net 6.5.0, a new version of the all-managed .NET driver for MySQL has been released.  This is a beta release of our newest connector and comes with several new features.  It is of beta quality and should not be used in any production environment.  It is appropriate for use with MySQL server versions 5.0-5.6

It is now available in source and binary form from here and mirror sites (note that not all mirror sites may be up to date at this point-if you can't find this version on some mirror, please try again later or choose another download site.)

This new versions brings new features such as
  • Exception and command injector support
  • Millseconds support
  • Better partial-trust support
  • Better





  [Read more...]
Introducing the team!
Employee +3 Vote Up -0Vote Down

When Oracle acquired MySQL there was some concern about what would happen with the world's most popular open-source database.  It's clear now that not only is Oracle very serious about continuing the great database but it is expanding the teams working on it and it's related technologies.  I know because I run one of those teams!

I've been working on MySQL and .NET technologies for the past 8 years and I'm very proud to introduce a couple of people who have been and will continue be working on my team.  

Fernando Gonzalez currently serves as leader of our Connector/Net team and has just completed some early work on major intellisense improvements on Connector/Net 6.5.  He's done work on developing a new parser for our product.  [Read more...]
Introducing the team!
Employee +0 Vote Up -0Vote Down

When Oracle acquired MySQL there was some concern about what would happen with the world's most popular open-source database.  It's clear now that not only is Oracle very serious about continuing the great database but it is expanding the teams working on it and it's related technologies.  I know because I run one of those teams!

I've been working on MySQL and .NET technologies for the past 8 years and I'm very proud to introduce a couple of people who have been and will continue be working on my team.  

Fernando Gonzalez currently serves as leader of our Connector/Net team and has just completed some early work on major intellisense improvements on Connector/Net 6.5.  He's done work on developing a new parser for our  [Read more...]
MySQL Connector/Net 6.3.8 has been released
Employee +0 Vote Up -0Vote Down
MySQL Connector/Net 6.3.8, a new version of the all-managed .NET driver for MySQL has been released.  This is a maintenance release to our 6.3 release chain and includes 40 changes and fixes.

Version 6.3.8 is appropriate for use with versions of MySQL 5.0-5.5.

It is now available in source and binary form from here and mirror sites (note that not all mirror sites may be up to date at this point-if you can't find this version on some mirror, please try again later or choose another download site.)

The release is also available for download on My Oracle Support (MOS).

Enjoy and thanks for the support!
MySQL Connector/Net 6.3.8 has been released
Employee +0 Vote Up -0Vote Down
MySQL Connector/Net 6.3.8, a new version of the all-managed .NET driver for MySQL has been released.  This is a maintenance release to our 6.3 release chain and includes 40 changes and fixes.

Version 6.3.8 is appropriate for use with versions of MySQL 5.0-5.5.

It is now available in source and binary form from here and mirror sites (note that not all mirror sites may be up to date at this point-if you can't find this version on some mirror, please try again later or choose another download site.)

The release is also available for download on My Oracle Support (MOS).

Enjoy and thanks for the support!
MySQL HA Solutions – webinar replay
Employee +1 Vote Up -0Vote Down

If you were unable to attend the live webinar (or you want to go back and listen to it again) then it’s now available to view on-line here.

Databases are the center of today’s web and enterprise applications, storing and protecting an organization’s most valuable assets and supporting business-critical applications. Just minutes of downtime can result in significant lost revenue and dissatisfied customers. Ensuring database highly availability is therefore a top priority for any organization. Tune into this webcast to learn more.

The session discusses:

  [Read more...]
MySQL Workbench 5.2.36 GA available
Employee_Team +0 Vote Up -0Vote Down

MySQL Workbench 5.2.36 has been released. This release is part of an ongoing effort committed to improving the day to day usability of the product based on accumulated experience from tools such as MySQL Query Browser and input from user feedback.

This specific version was focused on improving usability of the Query Editor. Some of the changes introduced are:

  • New, redesigned Query Editor layout. Output messages are always visible while resultsets and the query editor can be resized according to the task at hand. Resultsets are now in the same tab as their generating query editor.
  • Several minor changes that make the difference for a frustration-free, comfortable use of the tool. Sidebar sizes, the last selected schema and other state information is now properly remembered between sessions. Keyboard navigation of resultsets has been fixed to properly handle Tab key navigation in all
  [Read more...]
Announcing new features in MariaDB
+3 Vote Up -0Vote Down

We have lately been talking about some upcoming features that we feel are important to MariaDB users, because the corresponding ones that will be provided with MySQL will be incompatible with MariaDB and closed source.

We’re happy to announce the following:

  • The next version of MariaDB, version 5.2.10 will include an open source PAM Authentication Plugin. MariaDB 5.2.10 is scheduled for release next week.
  • A Windows Authentication Plugin is in development and QA currently and will be part of MariaDB 5.2.11, which is scheduled for release before Christmas.
  • MariaDB 5.5 will include both of the above plugins and an open source thread pool implementation. The soon-to-be-launched first version however will not include the thread pool.

Stay tuned for more information

  [Read more...]
Added a Table of Contents
+1 Vote Up -0Vote Down

Not a big deal, but I just added a “Table of Contents” page to my blog to make finding older articles much easier.

I noticed most of my posts are quite lengthy, and it can take a bit of searching/clicking to find an older entry. So unless you happen to recall the ‘month/year’ it was published, which I don’t even remember that, then hopefully this will help.

Really simple, and looks just like this:

  [Read more...]
Startup problems with 5.2.35? Get 5.2.35.1
Employee_Team +0 Vote Up -0Vote Down

In the latest release of MySQL Workbench (5.2.35), we received a number of reports that some people upgrading over a previous installation ended up in not being able to launch MySQL Workbench afterwards, instead receiving an error such as Access to the path ‘C:\Program Files (x86)\MySQL\MySQL Workbench CE 5.2.35\db_utils.pyc’ is denied. The cause for that seems to be a problem with access privileges on files that are created when Workbench is run. If you run into that problem, a possible workaround should be to start Workbench with elevated privileges one time. To do this, right-click the Workbench application icon in your startmenu and select “Run as administrator”. Please leave a comment whether this workaround solves the reported problem for you.

UPDATE: A new 5.2.35.1 msi package has been uploaded, which resolves this issue. You can download it from the

  [Read more...]
451 CAOS Links 2011.10.25
+0 Vote Up -0Vote Down

Microsoft: “more than half your Android devices are belong to us”. And more

# Microsoft claimed that more than half of the world’s ODM industry for Android and Chrome devices is now under license to Microsoft’s patent portfolio following its agreement with Compal Electronics.

# Hadapt expanded its board of directors and confirmed its $9.5m series A funding round.

# Appcelerator entered into an

  [Read more...]
Setting up Perl on Windows for MySQL Scripts (mysqldumpslow, mysql_explain_log, etc.)
+3 Vote Up -0Vote Down

This article is just a how-to for setting up Perl on Windows in order to use the perl scripts provided with MySQL, such as mysqldumpslow.pl or mysql_explain_log.pl.

Now, you might say there is a section on this topic in the MySQL manual, to which I’d agree. But, this was for ActiveState Perl 5.6. The latest ActiveState Perl is 5.12, so thoese instructions are a bit out-of-date. Also, there are some helpful “User Comments” on that same page, but again, those are slightly out-of-date in the ActiveState 5.12. So, I thought I’d just post the steps I took in order to set this up.

First, download and install ActivePerl. Click the “Download ActivePerl 5.12.4 for Windows” button (choose either 32-bit or 64-bit). You’ll be

  [Read more...]
New Episode of Oracle’s "Meet The MySQL Experts" Podcast Series
Employee_Team +0 Vote Up -0Vote Down

This month, Alex Roedling interviews Software Development Manager Reggie Burnett about MySQL on Windows.

Reggie covers Connector/NET, integration with Visual Studio, MySQL Workbench, the new MySQL installer for Windows, the new external authentication module for Windows, and more...

Enjoy the podcast!

And, a quick reminder that if you’re either attending Oracle OpenWorld or in the bay area next Tuesday, we hope to see you at the MySQL Community Reception!

New Episode of Oracle’s "Meet The MySQL Experts" Podcast Series
Employee_Team +2 Vote Up -0Vote Down

This month, Alex Roedling interviews Software Development Manager Reggie Burnett about MySQL on Windows.

Reggie covers Connector/NET, integration with Visual Studio, MySQL Workbench, the new MySQL installer for Windows, the new external authentication module for Windows, and more...

Enjoy the podcast!

And, a quick reminder that if you’re either attending Oracle OpenWorld or in the bay area next Tuesday, we hope to see you at the MySQL Community Reception!

MySQL Connector/Net 6.4.4 has been released
Employee +0 Vote Up -0Vote Down
MySQL Connector/Net 6.4.4, a new version of the all-managed .NET driver for MySQL has been released.  This is an update to our latest GA release and is intended for full production deployment.

Version 6.4.4 is intended for use with versions of MySQL from 5.0 - 5.5

It is now available in source and binary form from [http://dev.mysql.com/downloads/connector/net/6.4.html] and mirror
sites (note that not all mirror sites may be up to date at this point of time
- if you can't find this version on some mirror, please try again later or choose another download site.)
The release is also available for download on the My Oracle






  [Read more...]
MySQL Connector/Net 6.4.4 has been released
Employee +0 Vote Up -0Vote Down
MySQL Connector/Net 6.4.4, a new version of the all-managed .NET driver for MySQL has been released.  This is an update to our latest GA release and is intended for full production deployment.

Version 6.4.4 is intended for use with versions of MySQL from 5.0 - 5.5

It is now available in source and binary form from [http://dev.mysql.com/downloads/connector/net/6.4.html] and mirror
sites (note that not all mirror sites may be up to date at this point of time
- if you can't find this version on some mirror, please try again later or choose another download site.)
The release is also available for download on the My Oracle






  [Read more...]
MySQL Workbench 5.2.35 GA Available
Employee_Team +2 Vote Up -0Vote Down

The MySQL Developer Tools team is proud to announce the next release of it’s flagship product, MySQL Workbench, version 5.2.35. This is the next maintenance release containing 29 bug fixes as well as new feature additions. We also updated the supported platforms to include most recent editions of Fedora and Ubuntu Linux.

MySQL Workbench 5.2.35 now supports the Native Windows Authentication Method – available in the commercial MySQL server product – and the creation of user accounts utilizing this new authentication method.

For the PHP developers out there, Workbench now also comes with a new set of plugins to turn SQL Queries into PHP code to be put right into your scripts.

A big “Thank You” again to everyone for the large amount of feedback and ideas we have received on how to further improve and extend MySQL Workbench. We are continuously working on improving the

  [Read more...]
MySQL Installer, once again
+2 Vote Up -0Vote Down
First an apology. I have not been blogging much lately, but I do have a reason, and I think a valid one for once (i.e. not along the lines of "I was out drinking last night" or "I was busy boiling potatoes" or something), I have been moving house. And my new office is now as tidy as ever (and if you believe that, let me tell you about a bridge in New York that I have for sale at a really good price). No, the place is a mess, but my beautiful wife keeps up with me, and I am slowly getting things together.

That said, let's get to the point, MySQL Installer! If you read this blog, you know I have copmplained about this puppy several times before (First attempts with MySQL Installer and

  [Read more...]
Hello World!
Employee +0 Vote Up -0Vote Down

Historically it is tradition to start learning a new programming language by writing a 'Hello World' application.  While this is not a new language, we are certainly opening up a new communication channel so the title seemed appropriate.

MySQL has and continues to be the world's most popular open source database.  It  has millions of users and processes billions of records every day. The breath and scope of it's reach is truly staggering.  While many consider MySQL to be targeted primarily at Linux and other Unix variants, you may be surprised to find out that Windows is the most popular development *and production* platform for MySQL.  Take a second and go back and read that sentence again.

 Oracle has been very clear in it's commitment to MySQL and especially MySQL on Windows.  My name is Reggie Burnett and I lead a team that is on the

  [Read more...]
Hello World!
Employee +0 Vote Up -0Vote Down

Historically it is tradition to start learning a new programming language by writing a 'Hello World' application.  While this is not a new language, we are certainly opening up a new communication channel so the title seemed appropriate.

MySQL has and continues to be the world's most popular open source database.  It  has millions of users and processes billions of records every day. The breath and scope of it's reach is truly staggering.  While many consider MySQL to be targeted primarily at Linux and other Unix variants, you may be surprised to find out that Windows is the most popular development *and production* platform for MySQL.  Take a second and go back and read that sentence again.

 Oracle has been very clear in it's commitment to MySQL and especially MySQL on Windows.  My name is Reggie Burnett and I lead a team that is on the

  [Read more...]
Centralized Login Management Comes to MySQL: Introducing PAM and Windows Authentication Support
Employee +7 Vote Up -2Vote Down
You probably remember the world of new possibilities introduced to MySQL 5.5. If you do, you probably would agree that no API is useful by itself.

This is why you need authentication plugins that fit the largest possible number of authentication setups.

I can only guess what these authentication solutions look like for your server. But chances are that your OS has a pretty good idea on how best to authenticate users in it. This is why we've decided to hook MySQL to the two most widely used OS authentication APIs : Pluggable Authentication Modules (a.k.a PAM) and the Windows Security Support Provider

  [Read more...]
Centralized Login Management Comes to MySQL: Introducing PAM and Windows Authentication Support
Employee +0 Vote Up -0Vote Down
You probably remember the world of new possibilities introduced to MySQL 5.5. If you do, you probably would agree that no API is useful by itself.

This is why you need authentication plugins that fit the largest possible number of authentication setups.

I can only guess what these authentication solutions look like for your server. But chances are that your OS has a pretty good idea on how best to authenticate users in it. This is why we've decided to hook MySQL to the two most widely used OS authentication APIs : Pluggable Authentication Modules (a.k.a PAM) and the Windows Security Support Provider

  [Read more...]
Oracle Enhances MySQL Manageability on Windows
Employee_Team +2 Vote Up -0Vote Down

Windows is a major development and deployment platform for MySQL. A few months ago, we held our first MySQL Online Forum, dedicated to MySQL on Windows. We outlined then why MySQL was a great fit for the Windows environment, and what were the upcoming milestones to make MySQL even better on the Microsoft platform.

We’re now pleased to announce that two important milestones have been completed:

1. The New MySQL Installer for Windows is GA

The MySQL Installer for Windows radically simplifies the installation process for all MySQL users on the Windows platform.

  [Read more...]
Oracle Enhances MySQL Manageability on Windows
Employee_Team +0 Vote Up -0Vote Down

Windows is a major development and deployment platform for MySQL. A few months ago, we held our first MySQL Online Forum, dedicated to MySQL on Windows. We outlined then why MySQL was a great fit for the Windows environment, and what were the upcoming milestones to make MySQL even better on the Microsoft platform.

We’re now pleased to announce that two important milestones have been completed:

1. The New MySQL Installer for Windows is GA

The MySQL Installer for Windows radically simplifies the installation process for all MySQL users on the Windows

  [Read more...]
Previous 30 Newer Entries Showing entries 61 to 90 of 219 Next 30 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.