Tag: MySQL Workbench

Feed: Planet MySQL; Author: Mike Frank; There could be from one to over ten ports used within your MySQL ecosystem.  It really depends on what you have enabled, which components you are using, how your applications connect, and other characteristics of your environment. From a security point, these ports need to be opened just wide enough to allow the various components  that should communicate to talk while blocking out anything else trying to hack its way in – the goal being to enforce the security principle of “least privilege”.  Obviously, what you should not do is open everything to get things ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . I was perusing the new questions on dba.stackexchange.com when I happened upon a question on How to see special characters in MySQL Workbench query results. Intrigued, I checked it out. The user was looking for a way to show trailing whitespace characters in order to see which values had extra spaces. Trailing whitespace is not always a bad thing; depending on what the data is used for, they may be perfectly acceptable. That got me thinking, how does one view these extra space characters? Since I could not find an option to ... Read More

Feed: Planet MySQL; Author: Colin Charles; Colin Charles | June 22, 2018 |  Posted In: MariaDB, MongoDB, MySQL, PostgreSQL PREVIOUS POST Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. This is a short working week for me due to a family emergency. It caused me to skip speaking at DataOps.Barcelona and miss hanging out with the awesome of speakers and attendees. This is the first time I’ve missed a scheduled talk, and I received many messages about my absence. I am sure we will all meet again soon. One of the ... Read More

Feed: Planet MySQL; Author: Yngve Svendsen; Last week, Ubuntu released their newest long term support version, Ubuntu 18.04. As of today, we offer 18.04 packages for recent versions of almost all MySQL products, both for manual download and through our APT repos. Congratulations to the Ubuntu community on another solid release, and a special shout-out to our friends over at Canonical: we really enjoy working with you to ensure that Ubuntu continues to be a particularly good platform for MySQL users. We have also added support for Fedora 28, their latest rev, due out in a day or so. Packages are ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL Users, A new GA (general availability) version of MySQL Connector/C++ has been made available: MySQL Connector/C++ 1.1.11 GA. The MySQL Connector/C++ provides a C++ API for connecting client applications to the MySQL Server 5.5 or newer. You can download the production release at: http://dev.mysql.com/downloads/connector/cpp/1.1.html MySQL Connector C++ (Commercial) will be available for download on the My Oracle Support (MOS) website. This release will be available on eDelivery (OSDC) in next month’s upload cycle. The MySQL driver for C++ offers an easy to use API derived from JDBC 4.0. MySQL Workbench has used it ... Read More

Feed: Planet MySQL; Author: Tony Darnell; MySQL Enterprise Edition Database Firewall – Control and Monitor SQL Statement Executions April 23, 2018 Leave a comment As of MySQL 5.6.24, MySQL Enterprise Edition includes MySQL Enterprise Firewall, an application-level firewall (it runs within the mysql database process) that enables database administrators to permit or deny SQL statement execution based on matching against whitelists of accepted statement patterns. This helps harden MySQL Server against attacks such as SQL injection or attempts to exploit applications by using them outside of their legitimate query workload characteristics. Each MySQL account registered with the firewall has its own ... Read More

Feed: Planet MySQL; Author: The Workbench Team; Dear MySQL users, The MySQL developer tools team announces 8.0.11 as our release candidate (RC) for MySQL Workbench 8.0. For the full list of changes in this revision, visithttp://dev.mysql.com/doc/relnotes/workbench/en/changes-8-0.html For discussion, join the MySQL Workbench Forums:http://forums.mysql.com/index.php?152 The release is now available in source and binary form for a number ofplatforms from our download pages at: http://dev.mysql.com/downloads/tools/workbench/ Enjoy! ... Read More

Feed: Planet MySQL; Author: Mike Frank; MySQL adds NoSQL and many new enhancements to the world’s most popular open source database: NoSQL Document Store gives developers the flexibility of developing traditional SQL relational applications and NoSQL, schema-free document database applications.  This eliminates the need for a separate NoSQL document database.  SQL Window functions, Common Table Expressions, NOWAIT and SKIP LOCKED, Descending Indexes, Grouping, Regular Expressions, Character Sets, Cost Model, and Histograms. JSON Extended syntax, new functions, improved sorting, and partial updates. With JSON table functions you can use the SQL machinery for JSON data. GIS Geography support. Spatial Reference Systems (SRS), as well ... Read More

Feed: Planet MySQL; Author: Sveta Smirnova; In this blog, I will provide answers to the Q & A for the Performance Schema for MySQL Troubleshooting webinar. First, I want to thank everybody for attending my March 1, 2018, webinar. The recording and slides for the webinar are available here. Below is the list of your questions that I was unable to answer fully during the webinar. Q: Is Workbench able to take advantage of the enhancements to Perf schema? A: MySQL Workbench is a graphical tool for database architects, administrators and developers. It uses Performance Schema for its Performance Schema Reports ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; In this blog post, I want to go over some of the day-to-day MySQL tools and methods DBAs use to analyze queries and visualize “what is going on?” I won’t be going into the nitty-gritty details of each of these tools, I just want to introduce you to them and show you what they look like so you will know what types of information they provide. This isn’t a comprehensive list by any means but consider it a primer for those starting with MySQL and wanting to know what a query is going ... Read More