Posts tagged MySQL
Amazon has released Relational Database Service (RDS). This is big news. Infact more of a landmark. The reason being, it is the first time that Amazon is offering Relational Database in the form of a service even though it offers other cloud services such as Database Cloud (SimpleDB), Compute Cloud (EC2), Storage Cloud (S3).
Yesterday, we shared with you the unfortunate news of the outdated WordPress blogs (that are not running the latest version) might be attacked by a potential worm. The only real solution/step to avoid being attacked by this latest worm is to upgrade to the latest version. Having said that, you might be wondering how would you detect that your WordPress blog security hasn’t been compromised. Well in this post, we will be sharing with you how to do that. As you probably know that this attack creates and registers an unsolicited administrator account. So you need to check whether there is any extra admin account for your WordPress account or not. This can be done through a simple SQL query. You need to run this query against your MySQL WordPress DB. There are a couple of ways to run this query which are:
- Go to phpMyAdmin , Select your WordPress database and then go to the ‘SQL’ tab to run the query.
- Run the query mentioned below directly in the command-line MySQL client (Recommended for Advanced users).
The query is
SELECT u.ID, u.user_login FROM wp_users u, wp_usermeta umWHERE u.ID = um.user_id AND um.meta_key = ‘wp_capabilities’ AND um.meta_value LIKE ‘%administrator%’;
WordPress – A semantic personal publishing platform with a focus on aesthetics, web standards, and usability.
The new version, 2.8 has taken a long time before the release date has been set. It was originally planned for April, then May, now June.
Ryan Boren announced on Wednesday that the developers were hoping for the content management system to be released on Wednesday 10th June.
The new version will include a built-in theme installer, just like the current plugins installer that arrived with 2.7. Not only that but a better permalink system, new icons and an updated admin color scheme, a better widgets API among other things. and an even more controllable user management system.
The most interesting thing is that WordPress versions have a history of being named after famous jazz musicians. Version 2.7, the most recent, was named ‘Coltrane’, who was famous for improvisation, due to the sheer ability to customise the admin interface. 2.7 recently had a small update, and was re-numbered to 2.7.1.
There is news for WordPress 2.9 as well, WordPress said:
WP 2.9 will require MySQL 4.1.2 or greater. This is raised from the current requirement of 4.0.
Checks will be added to the automatic upgrader that will prevent upgrading to 2.9 if MySQL < 4.1.2 is being used. The upgrader will also issue a notice that suggests asking the host to upgrade MySQL to meet the minimum requirement.
There have been two betas of WordPress released already, the first on May 16th, and the second on May 23rd. I can’t wait for the new version, and I’m sure the other millions of bloggers can’t either. Lets hope for the release on date given by WordPress.
Just after a day of setting up the deal with Oracle, Sun Microsystems has released MySQL 5.4, a new version of the popular open source database.
Sun Microsystem Karen Tegan Padir said:
Without any modifications to your applications, MySQL 5.4 will transparently increase the performance and scalability of your applications, to enable them to scale under more demanding user and data processing loads. MySQL 5.4 is also better suited for scale-up deployments on SMP systems.
MySQL 5.4 features are:
Scalability improvements — these fixes allow the InnoDB storage engine to scale up to 16-way x86 servers and 64-way CMT servers;
Subquery optimizations — improves the performance of analytic query operations, with some subqueries;
New query algorithms — utilizes main memory to speed up the execution time of multi-way joins, especially for MySQL Cluster;
Improved stored procedures — enables more robust error management through the implementation of the SIGNAL/RESIGNAL functions;
Improved prepared statements — Output parameters will now be supported in prepared statements, which increases their functionality;
Improved Information Schema — provides more metadata access to parameters and data return types that stored procedures use, which allows much more information to be made available for developers using connectors such as ODBC and JDBC;
Improved DTrace support — improves diagnostics and troubleshooting capabilities for MySQL on Solaris Operating System.
MySQL 5.4 will be available for a wide variety of hardware and software platforms, including Red Hat Enterprise Linux, SuSE Enterprise Linux, Microsoft Windows, Sun Solaris 10 Operating System, Mac OS X.
The preview version of MySQL 5.4 is currently available for download at Website for 64-bit versions of the Linux and Solaris 10 Operating Systems.