phpMyAdmin 4.6.1 released today, is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add columns, execute any SQL statement, manage indexes on columns. phpMyAdmin 4.6.1 changelog PMA_Util not found in insert_edit.lib.php Fixed activation of some languages Fixed error in 3NF step of normalization Fix offering JSON datatype in incompatible MySQL versions Can not open table with JSON field Cannot highlight a column if I scroll down from the top of the table Fixed possible PHP error in SQL parser Fixed SQL quoting in SQL export Improve performance of database structure page Fix PHP error if user did unpack new version over old one Fix parsing of expression 0 Document setup with Google Cloud SQL Fix parsing of queries with double \ Fixed setting of language from user configuration Fixed check for ndb version Fixed loading of configuration file Check if sessions are working and report failures non-clickable initial letter for users / and can’t modify users with MySQL 5.
MongoDB 3.0.8 recently released, is an open-source, document-oriented database designed for ease of development and scaling. Think of MySQL but with JSON-like objects comprising the data model, rather than RDBMS tables. Significantly, MongoDB supports neither joins nor transactions. 3.1.7 is a development release and is not intended for production use. The 3.1 series will evolve into 3.2, which will be for production. MongoDB 3.0.8 Major Changes Security SERVER-21278 Remove executable bit from mongod.
digiKam 5.0.0-beta2 Photo Management has just been released. This version is the second public release of the new main digiKam version and is a result of the long development process by the team. This release marks almost complete port of the application to Qt5 and KF5 API. All Qt4/KDE4 code has been removed and many parts have been re-written, reviewed, and tested. Porting to Qt5 required a lot of work, as many important APIs had to be changed or replaced by new ones.
MongoDB 3.0 recently released, is an open-source, document-oriented database designed for ease of development and scaling. Think of MySQL but with JSON-like objects comprising the data model, rather than RDBMS tables. Significantly, MongoDB supports neither joins nor transactions. The key features in this latest release include support for the WiredTiger storage engine, pluggable storage engine API, SCRAM-SHA-1 authentication mechanism, and improved explain functionality. MongoDB Ops Manager, which includes Automation, Backup, and Monitoring, is now also available.
Adminer (formerly known as phpMinAdmin) is a full-featured database management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server. Adminer is available for MySQL, PostgreSQL, SQLite, MS SQL,Oracle, SimpleDB, Elasticsearch and MongoDB. Adminer 4.2.0 changelog Fix XSS in login form (bug #436) Allow limiting number of displayed rows in SQL command Fix reading routine column collations Unlock session in alter database Make master key unreadable to others (bug #410) Fix edit by long non-utf8 string Specify encoding for PHP 5.
phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add columns, execute any SQL statement, manage indexes on columns. phpMyAdmin 4.3.8 changelog Undefined constant PMA_DRIZZLE Wrongly positioned date-picker while Grid-Editing Forced ORDER BY for own sql statements Undefined property: stdClass::$version ‘only_db’ not working Error text: Internal Server Error Incorrect width table summary when favorite tables is disabled Nav tree error after filtering the tables Collapse all in navigation panel is sometimes broken Cannot navigate in filtered table list Database navigation menu broken when resolution/screen is changing Collation column missing in database list when DisableIS is true bug Undefined index central_columnswork bug Undefined index favorite_tables Install phpMyAdmin 4.
MySQL Cluster NDB 7.3.8 has just been released and its based on MySQL Server 5.6 and including features from version 7.3 of the NDB storage engine, as well as fixing a number of recently discovered bugs in previous MySQL Cluster releases. This release also incorporates all bugfixes and changes made in previous MySQL Cluster releases, as well as all bugfixes and feature changes which were added in mainline MySQL 5.6 through MySQL 5.
Percona has just announced the release of Percona XtraBackup 2.2.8. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered free as an open source solution, Percona XtraBackup drives down backup costs while providing unique features for MySQL backups. New Features: Percona XtraBackup has been rebased on MySQL 5.6.22. Bugs Fixed: Incremental backups would fail if the number of undo tablespaces (innodb_undo_tablespaces) was more than 1.
LAMP is a group of open source software that is typically installed together to enable a server to host dynamic websites and web apps. This term is an acronym for Linux operating system, Apache web server, MySQL database, and PHP/Perl/Python. In this tutorial, I will show you the easiest way on how to successfully install LAMP on Ubuntu 14.04 using Tasksel tool. Tasksel is a Debian/Ubuntu tool that installs multiple related packages as a co-ordinated “task” onto your system.
In this post, I will show you 2 simple steps on how to change the zabbix DB password from “zabbix” to something else. This comes in handy when you are running zabbix in a LIVE environment and you want to secure the DB connection password. Step 1. Update zabbix_server.conf & zabbix.conf.php configuration files – Log into zabbix, enter the command “vi /etc/zabbix/zabbix_server.conf” to edit the zabbix_server.conf file. Locate the line DBPassword= and change the password.
As promised from my previous post on Installing CentOs on VirtualBox, this post will be focused on step by step installation guide of Zabbix on CentOS. As at the writing of this post, Zabbix v2.0 and CentOS v6.4 where the latest. It is assumed that you already have CentOS 6.4 installed and configured. [box type=”info” size=”medium” style=”rounded” icon=”info”]Update: Added steps on how to open up zabbix ports in a production environment without having to disable IPTABLES[/box] Setup: 1: Download Package – # rpm -ivh http://repo.