Showing entries 11 to 20 of 70
« 10 Newer Entries | 10 Older Entries »
Displaying posts with tag: MySQL Workbench (reset)
SSL/TLS in 5.6 and 5.5 – oCERT Advisory

Today, oCERT published advisory 2015-003 describing a TLS vulnerability in MySQL and derivative products.  The content isn’t exactly news – it is documented legacy behavior and the subject of an earlier blog post describing how MySQL Server 5.7 solves the problem.  That said, the efforts of Duo Security are certainly appreciated and welcomed – it provides a meaningful context to discuss how to properly harden existing MySQL 5.5 and 5.6 deployments, as well as frame a discussion on potential changes in these versions to increase security.


The vulnerability described in the advisory relies on the legacy behavior of the client …

[Read more]
MySQL bind-address

While I try to keep things simple, sometimes eliminating options and explanations comes back to haunt me. After posting how to open a Fedora firewall port for a LAMP stack, somebody got trapped by my instructions for installing MySQL on Fedora. They got stuck because they had the following setting in their /etc/my.cnf file:


I’d suggested using that bind-address value for a DHCP VMware Fedora installation in Step #7. I was trying to create an example for an isolated testing instance, which is why I set the bind-address to a localhost.localdomain value. They raised the following error when they …

[Read more]
Using MySQL Workbench

I’ve been setting up a simplified lab environment to let my students learn use in class. This added content will show them how to do reverse engineering with MySQL Workbench.

It’s a complete Fedora image with MySQL and Oracle Database 11g for the course. The uncompressed image is 14GB and the compressed image is 5.3GB. I chose Fedora because it’s the smallest open source image that supports both environments, and Fedora is the closest to Red Hat and Oracle Unbreakable Linux. I’m inclined to make the instance available generally but haven’t figured out the best way to do that.

Here are the new instructions I’m adding and if you have any input leave it as a comment.

You connect as the student user, which puts you in the /home/student directory. Once connected to the Fedora OS, you open a Terminal session by clicking on Activities in the upper right hand corner, and then you …

[Read more]
MySQL Workbench on Fedora

The early release of Fedora 20 disallowed installation of MySQL Workbench but the current version allows it. Almost like Tom Cruise’s Edge of Tomorrow without the drama. All you need to do is follow my earlier instructions for installing MySQL on Fedora 20. I’d check your kernel to know whether it’s supported. You can check that with this command:

<shell> uname -r

My Fedora is at the following version:


Then, you can install MySQL Workbench with yum, like this:

<shell> sudo yum install mysql-workbench

It generates the following log file, and if you have Oracle 11g

[Read more]
Workbench 6.2, CakePHP’s new ORM, and OKC Meetup on Wednesday

In the beginning was the MySQL command line and it was good. Verbose yes, error prone yes, and even tedious. But it was good. The UPDATE USER set SELECT_PRIV=’Y’, DROP_PRIV_’Y”, UPDATE_PRIV=’Y’,……,LAST_BLOODY_PRIV=’Y”; type errors have caught of us old timers. But it was still good.

Then came some GUI tools that were okay. Not great but they had their uses.

And then came MySQL Workbench. And it was very good.

Now there is MySQL Workbench 6.2 and it is excellent. It came out in Beta last week and has built on the proven success of its predecessors. All the usual stuff is there – Server Status, Users & Privileges, Startup/Shutdown, logs, Dashboard, Performance Reports and more. But there area whole bunch of subtle little tweaks that make it easier to use.

For instance, the VISUAL EXPLAIN allows toggling between the visual display and the tabular display. Plus you can now get query …

[Read more]
Mountain Moodle Moot and MySQL in Montana

MySQL is a proud sponsor of the Mountain Moodle Moot, July 9-11, 2014 – Helena, Montana. There will be sessions back-to-back covering query tuning, system tuning, and little known tricks using MySQL Workbench. This years Moot is already SOLD OUT.

Moodle is a learning management system and very popular with many schools across the world.

There are 3 three amazing social events planned for Friday afternoon – sponsored by Oracle/MySQL. Lunch, a tour train ride and a great social at the Blackfoot Brewery complete with tour and brews.

If you have your ticket and want me to cover anything specific in my sessions, please let me know!

Getting started with Performance Schema and MySQL Workbench 6.1.2 Beta

MySQL’s Performance schema is a relatively new tool for measuring performance and MySQL Workbecn 6.1.2 is the latest beta of that software. I have not had a lot of time to play with performance schema but now I am taking my first steps with the help of Workbench. Startup Workbench and you will find under the Navigator an item labeled Performance Schema Setup. Flip the toggle from OFF to ON and then start exploring.

InnoDB Buffer stats by Schema are show here — one of more than twenty pre-established metrics available.

Now you can run queries and see what the costs are, where the server is waiting, or what indexes remain unused. You can even use workbench to alter the options file to setup other Performance Schema instruments. Trying various settings for optimizer_search_depth is simple with the …

[Read more]
MySQL Workbench as an administrative tool

MySQL Workbench is a handy administrative tool. Workbench provides server status information, client connection data, the best user admin interface, a browser for system variables, access to data export, an import/restore function, access to system logs, option file editing, performance reports, and startup/shutdown switch.

This is a snapshot of the dashboard on a laptop running a few very simplequeries.

In the past I have either used the CLI or tools like PHPMyAdmin. Well, the CLI is often victim to my poor typing skills and PHPMyAdmin is not always installed when I need it. But if I can connect via the CLI, I can connect with Workbench.

The …

[Read more]
MySQL Workbench Data Modeler

MySQL Workbench is a great tool when someone asks you to look at their schemas. It is hard to get the over-all view of data that you are not familiar with and this is a great aid for this situations. You an reverse engineer the database, make changes, and then roll them out but this blog is about creating the model only. The examples you see in this blog were made with MySQL Workbench 6.12, which is in beta. Beta means we want to you test the heck out of it and let us know how you broke it so we can make it better.

Click on the circled greater than sign next to model to begin.

Click on the circled greater than sign next to Models to begin. We want the Create EER model from database option.

We want to create a …

[Read more]
Workbench Beta 6.1.2

MySQL Workbench is the second most popular download of all MySQL products and recently a new Beta version was made available for evaluation. Workbench is a Swiss Army Knife tool with three very sharp blades — query tool, data modeler, and administration. Download here and pick the Development Release. We are looking for feedback on the new version so kick the tires, do a long afternoon test drive, and run it through the paces PLEASE! The changes over the GA release are very impressive and you do really need to try this beta. Packages for all the usual players — Ubuntu, Fedora, RHEL/Oracle, OSX and Windows — are available. Windows users get a Zip archive they can unpack where desired and run from there while others get to use their regular rituals for their package manager. The first window you see

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