<?xml version="1.0" encoding="UTF-8"?><!-- generator="WordPress/2.7.1" -->
<rss version="0.92">
<channel>
	<title>Simple Thoughts - Java and Web Blog &#187; RDBMS</title>
	<link>http://tech.gaeatimes.com</link>
	<description>News and views from a Software Architect and Web Entrepreneur on Java, PHP and Web 2.0 Technologies.</description>
	<lastBuildDate>Fri, 05 Nov 2010 11:18:22 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	
	<item>
		<title>3 Effective MySQL Performance Optimization Tips for MyISAM Storage Engine (Optimizes WordPress performance too)</title>
		<description><![CDATA[
more images


more images
The first two tips should be used for heavily loaded MySQL databases using MyISAM storage engine. They are simple configuration options which can relieve your system to a significant extent. The third can be used for MyISAM or InnoDB but is likely to benefit MyISAM data storage more than InnoDB as per reports ... Read the original article on Gaea Times at  : <a href="http://tech.gaeatimes.com/index.php/archive/3-effective-mysql-performance-optimization-tips-for-myisam-storage-engine-optimizes-wordpress-performance-too/">3 Effective MySQL Performance Optimization Tips for MyISAM Storage Engine (Optimizes WordPress performance too)</a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/3-effective-mysql-performance-optimization-tips-for-myisam-storage-engine-optimizes-wordpress-performance-too/</link>
			</item>
	<item>
		<title>Cheapest Performance Improvement Tip for Heavily Used File Systems (High IO Wait) / Heavily Loaded MySQL Database / Over worked WordPress</title>
		<description><![CDATA[
more images


more images
I am sure you have heard a lot of theoretical discussions on what is the best file systems to use, which IO scheduler and which storage device - ATA (obsolete), SATA, SAS, SSD etc. Today I will talk about my personal experience.
My production server was having wait times in excess of 50% (average). .... Source &nbsp;: <a href="http://tech.gaeatimes.com/index.php/archive/cheapest-performance-improvement-tip-for-heavily-used-file-systems-high-io-wait-heavily-loaded-mysql-database-over-worked-wordpress/">Cheapest Performance Improvement Tip for Heavily Used File Systems (High IO Wait) / Heavily Loaded MySQL Database / Over worked WordPress</a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/cheapest-performance-improvement-tip-for-heavily-used-file-systems-high-io-wait-heavily-loaded-mysql-database-over-worked-wordpress/</link>
			</item>
	<item>
		<title>Oracle and Sun to Produce Hardware and Software Jointly for Data Center</title>
		<description><![CDATA[  Oracle chief Larry Ellison remarked after making all of the formalities to buy Sun Microsystem that the combined company is going to produce everything from semiconductors and operating systems to computer servers, databases and accounting software for the use of Data Centers. Oracle is going to invest heavily for 4 generations of SUN&#8217;s ultraSPARC .... Read the original article &nbsp;: <a href="http://tech.gaeatimes.com/index.php/archive/oracle-and-sun-to-pruduce-everything-for-data-center/">here</a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/oracle-and-sun-to-pruduce-everything-for-data-center/</link>
			</item>
	<item>
		<title>EU clears Oracle takeover of Sun, saying it won&#8217;t significantly affect competition</title>
		<description><![CDATA[
more images



more images


more images


more images

EU clears Oracle takeover of Sun
BRUSSELS — The European Union on Thursday cleared Oracle Corp.&#8217;s proposed $7.4 billion takeover of Sun Microsystems Inc., saying it would not significantly affect competition in the EU.
EU antitrust chief Neelie Kroes said one of the year&#8217;s biggest technology deals of the last year could now .... Original article on Gaea Times at  &nbsp;: <a href="http://tech.gaeatimes.com/index.php/archive/eu-clears-oracle-takeover-of-sun-saying-it-wont-significantly-affect-competition/">EU clears Oracle takeover of Sun, saying it won&#8217;t significantly affect competition</a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/eu-clears-oracle-takeover-of-sun-saying-it-wont-significantly-affect-competition/</link>
			</item>
	<item>
		<title>Summary Box: Oracle expects EU to unconditionally approve Sun deal, says profit rose 12.5 pct</title>
		<description><![CDATA[
more images


more images

Summary Box: Oracle earnings up, optimistic on Sun
TURNAROUND STORY: Software maker Oracle Corp. said its profit jumped more than 12 percent in the latest quarter as corporations seemed more willing to spend money on new technology projects. Oracle&#8217;s revenue from new software licenses rose 2 percent, ending a four-quarter run of declines.
THE NUMBERS:  [..] <a href="http://tech.gaeatimes.com/index.php/archive/summary-box-oracle-expects-eu-to-unconditionally-approve-sun-deal-says-profit-rose-125-pct/">Read the original article: here</a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/summary-box-oracle-expects-eu-to-unconditionally-approve-sun-deal-says-profit-rose-125-pct/</link>
			</item>
	<item>
		<title>Oracle expects EU to &#8216;unconditionally&#8221; approve Sun deal next month, says profit rose 13 pct</title>
		<description><![CDATA[
more images



more images

Oracle expects EU to approve Sun deal next month
SAN FRANCISCO — Oracle Corp. said Thursday that its profit jumped 12.5 percent in the latest quarter and that it expects the European Union will finally approve its $7.4 billion purchase of Sun Microsystems Inc. next month.
Oracle and Sun shares both rose in extended trading.
Oracle&#8217;s .... <a href="http://tech.gaeatimes.com/index.php/archive/oracle-expects-eu-to-unconditionally-approve-sun-deal-next-month-says-profit-rose-13-pct/">Source article on Gaea Times at  &nbsp;: Oracle expects EU to &#8216;unconditionally&#8221; approve Sun deal next month, says profit rose 13 pct</a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/oracle-expects-eu-to-unconditionally-approve-sun-deal-next-month-says-profit-rose-13-pct/</link>
			</item>
	<item>
		<title>EU regulators softening stance on Oracle-Sun; Oracle pledges support for Sun database</title>
		<description><![CDATA[
more images



more images

EU regulators softening stance on Oracle-Sun
SAN FRANCISCO — European Union regulators appear to be softening their opposition to Oracle Corp.&#8217;s proposed $7.4 billion takeover of Sun Microsystems Inc., a shift that has resurrected some investors&#8217; hopes that one of the year&#8217;s biggest technology deals will go ahead as planned.
Oracle and the European Commission ... Read more <a href="http://tech.gaeatimes.com/index.php/archive/eu-regulators-softening-stance-on-oracle-sun-oracle-pledges-support-for-sun-database/" title="EU regulators softening stance on Oracle-Sun; Oracle pledges support for Sun database">&raquo;&raquo;&raquo;</a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/eu-regulators-softening-stance-on-oracle-sun-oracle-pledges-support-for-sun-database/</link>
			</item>
	<item>
		<title>IBM Ventures in Real-Time Enterprise Database Monitoring And Protection With Guardium Acquisition</title>
		<description><![CDATA[IBM (IBM) announced it has acquired Guardium, reportedly a market leader in real-time enterprise database monitoring and protection. Guardium&#8217;s technology helps clients safeguard data, monitor database activity and reduce operational costs by automating regulatory compliance tasks. Guardium is a privately held company based in Waltham, Massachusetts.

The acquisition of Guardium will enable IBM clients to maintain ... Read : <a href="http://tech.gaeatimes.com/index.php/archive/ibm-ventures-in-real-time-enterprise-database-monitoring-and-protection-with-guardium-acquisition/">IBM Ventures in Real-Time Enterprise Database Monitoring And Protection With Guardium Acquisition</a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/ibm-ventures-in-real-time-enterprise-database-monitoring-and-protection-with-guardium-acquisition/</link>
			</item>
	<item>
		<title>EU extends antitrust review of Oracle&#8217;s Sun takeover until Jan 27</title>
		<description><![CDATA[
more images



more images

EU extends Oracle/Sun review deadline until Jan 27
BRUSSELS — European Union regulators said Friday that they have extended until Jan. 27 a deadline to wrap up their antitrust review of Oracle Corp.&#8217;s planned $7.4 billion takeover of Sun Microsystems Inc.
The European Commission said Oracle had asked for more time &#8220;in order to have ... Read more : <a href="http://tech.gaeatimes.com/index.php/archive/eu-extends-antitrust-review-of-oracles-sun-takeover-until-jan-27/">EU extends antitrust review of Oracle&#8217;s Sun takeover until Jan 27</a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/eu-extends-antitrust-review-of-oracles-sun-takeover-until-jan-27/</link>
			</item>
	<item>
		<title>European regulators object to Sun-Oracle deal; Oracle to fight &#8220;profound misunderstanding&#8221;</title>
		<description><![CDATA[
more images



more images

EU objects to Oracle&#8217;s takeover of Sun
SAN FRANCISCO — European antitrust regulators have formally objected to Sun Microsystems Inc.&#8217;s planned $7.4 billion sale to Oracle Corp., escalating a battle over a deal that has already been cleared in the U.S.
The so-called &#8220;statement of objections&#8221; that Sun received Monday from the European Commission isn&#8217;t .... <a href="http://tech.gaeatimes.com/index.php/archive/european-regulators-object-to-sun-oracle-deal-oracle-to-fight-profound-misunderstanding/">Original article &nbsp;: European regulators object to Sun-Oracle deal; Oracle to fight &#8220;profound misunderstanding&#8221;</a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/european-regulators-object-to-sun-oracle-deal-oracle-to-fight-profound-misunderstanding/</link>
			</item>
	<item>
		<title>Oracle shares slip after fiscal 1st-quarter revenue falls, missing analyst estimates</title>
		<description><![CDATA[SAN FRANCISCO — Shares of Oracle Corp. slipped in premarket activity Thursday after the information technology company reported sales fell below analyst expectations in the latest quarter, showing that businesses are still reluctant to buy new software.

The stock slid 68 cents, or 3 percent, to $21.45 ahead of the opening bell, edging back from their .... Original article on Gaea Times at  &nbsp;: <a href="http://tech.gaeatimes.com/index.php/archive/oracle-shares-slip-after-fiscal-1st-quarter-revenue-falls-missing-analyst-estimates/">Oracle shares slip after fiscal 1st-quarter revenue falls, missing analyst estimates</a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/oracle-shares-slip-after-fiscal-1st-quarter-revenue-falls-missing-analyst-estimates/</link>
			</item>
	<item>
		<title>Oracle profit rises 4 pct sales drop 5 pct as businesses stay tightfisted; shares fall</title>
		<description><![CDATA[SAN FRANCISCO — Oracle Corp.&#8217;s profit rose 4 percent in the latest quarter, matching Wall Street&#8217;s forecasts, despite a drop in sales that revealed businesses are still being tightfisted about buying new software.

The sales figure was short of analysts&#8217; expectations, and Oracle&#8217;s shares fell 4 percent.
The company&#8217;s results, reported after the market closed Wednesday, reflect ... Read more <a href="http://tech.gaeatimes.com/index.php/archive/oracle-profit-rises-4-pct-sales-drop-5-pct-as-businesses-stay-tightfisted-shares-fall/" title="Oracle profit rises 4 pct sales drop 5 pct as businesses stay tightfisted; shares fall">>>></a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/oracle-profit-rises-4-pct-sales-drop-5-pct-as-businesses-stay-tightfisted-shares-fall/</link>
			</item>
	<item>
		<title>Oracle, Sun link up for new database machine; in doing so, Oracle snubs HP</title>
		<description><![CDATA[SAN FRANCISCO — With the fate of its proposed $7.4 billion takeover of Sun Microsystems Inc. uncertain amid antitrust scrutiny, Oracle Corp. is moving ahead with a new product incorporating both companies&#8217; technology, and snubbing Hewlett-Packard Co. in the process.

Sun and Oracle unveiled a new database machine Tuesday built from Sun hardware and Oracle software.
The ... Read more <a href="http://tech.gaeatimes.com/index.php/archive/oracle-sun-link-up-for-new-database-machine-in-doing-so-oracle-snubs-hp/" title="Oracle, Sun link up for new database machine; in doing so, Oracle snubs HP">&raquo;&raquo;&raquo;</a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/oracle-sun-link-up-for-new-database-machine-in-doing-so-oracle-snubs-hp/</link>
			</item>
	<item>
		<title>EU opens probe of Oracle-Sun deal, ending hopes for $7.4 billion deal to get done this summer</title>
		<description><![CDATA[SAN FRANCISCO — Oracle Corp. figured its $7.4 billion buyout for Sun Microsystems Inc. could skate through antitrust scrutiny, folding Sun into a technology powerhouse when Sun badly needs the lifeline. Both companies will have to wait.

European Union regulators applied the brakes Thursday, launching a formal antitrust probe that shatters Oracle&#8217;s goal of completing the ... Read the original article on Gaea Times at  : <a href="http://tech.gaeatimes.com/index.php/archive/eu-opens-probe-of-oracle-sun-deal-ending-hopes-for-74-billion-deal-to-get-done-this-summer/">EU opens probe of Oracle-Sun deal, ending hopes for $7.4 billion deal to get done this summer</a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/eu-opens-probe-of-oracle-sun-deal-ending-hopes-for-74-billion-deal-to-get-done-this-summer/</link>
			</item>
	<item>
		<title>Summary Box: EU applies brakes to Oracle-Sun deal on questions about database market</title>
		<description><![CDATA[SLOW DOWN: European Union regulators are launching a formal antitrust investigation into Oracle Corp.&#8217;s proposed $7.4 billion takeover of Sun Microsystems Inc. Oracle expected to complete the acquisition this summer, but European regulators now have until Jan. 19 to decide whether to clear or block the deal. The U.S. Department of Justice has already approved ... <a href="http://tech.gaeatimes.com/index.php/archive/summary-box-eu-applies-brakes-to-oracle-sun-deal-on-questions-about-database-market/">Original article on  : Summary Box: EU applies brakes to Oracle-Sun deal on questions about database market</a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/summary-box-eu-applies-brakes-to-oracle-sun-deal-on-questions-about-database-market/</link>
			</item>
	<item>
		<title>EU opens probe of Oracle-Sun deal, says it wants to ensure buyer choice in database software</title>
		<description><![CDATA[SAN FRANCISCO — Oracle Corp. figured its $7.4 billion buyout for Sun Microsystems Inc. could skate through antitrust scrutiny, folding Sun into a technology powerhouse when Sun badly needs the lifeline. Both companies will have to wait.

European Union regulators applied the brakes Thursday, launching a formal antitrust probe that shatters Oracle&#8217;s goal of completing the ... Original article on  : <a href="http://tech.gaeatimes.com/index.php/archive/eu-opens-probe-of-oracle-sun-deal-says-it-wants-to-ensure-buyer-choice-in-database-software/">EU opens probe of Oracle-Sun deal, says it wants to ensure buyer choice in database software</a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/eu-opens-probe-of-oracle-sun-deal-says-it-wants-to-ensure-buyer-choice-in-database-software/</link>
			</item>
	<item>
		<title>EU says it must check that Oracle takeover of Sun will not hike prices for database software</title>
		<description><![CDATA[BRUSSELS — European Union regulators on Thursday launched an antitrust probe into U.S. software maker Oracle Corp.&#8217;s takeover of Sun Microsystems Inc., saying they wanted to make sure Oracle was committed to developing Sun&#8217;s rival open-source database software MySQL.

EU approval is now the main stumbling block for the $7.4 billion deal which has already been .... Original article &nbsp;: <a href="http://tech.gaeatimes.com/index.php/archive/eu-says-it-must-check-that-oracle-takeover-of-sun-will-not-hike-prices-for-database-software/">EU says it must check that Oracle takeover of Sun will not hike prices for database software</a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/eu-says-it-must-check-that-oracle-takeover-of-sun-will-not-hike-prices-for-database-software/</link>
			</item>
	<item>
		<title>Sun Microsystems&#8217; share of the server market slips as rivals exploit fears about Oracle deal</title>
		<description><![CDATA[SAN FRANCISCO — Uncertainty about Sun Microsystems Inc.&#8217;s future appears to have contributed to serious erosion in the company&#8217;s market share for computer servers in the latest quarter, according to new data being released Wednesday.

The latest numbers from market-research firm IDC show that Sun&#8217;s market share in servers stood at 10 percent in the second ... Read : <a href="http://tech.gaeatimes.com/index.php/archive/sun-microsystems-share-of-the-server-market-slips-as-rivals-exploit-fears-about-oracle-deal/">Sun Microsystems&#8217; share of the server market slips as rivals exploit fears about Oracle deal</a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/sun-microsystems-share-of-the-server-market-slips-as-rivals-exploit-fears-about-oracle-deal/</link>
			</item>
	<item>
		<title>PostgreSQL Vs MySQL: Comparative Review</title>
		<description><![CDATA[Most of the businesses these days use database server. Although commercial databases like Oracle, Microsoft&#8217;s SQL Server, and IBM&#8217;s DB2 server are widely used, but the open source databases are fast gaining popularity, especial with the small and mid size businesses.
For decade now open source community has improved upon its quality of software to be ... Original source on Gaea Times at  : <a href="http://tech.gaeatimes.com/index.php/archive/postgresql-vs-mysql-comparative-review/">PostgreSQL Vs MySQL: Comparative Review</a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/postgresql-vs-mysql-comparative-review/</link>
			</item>
	<item>
		<title>Top 7 Free Open Source Database Server</title>
		<description><![CDATA[Open Source Server based database management systems have become a common choice for organizations over the stand alone desktop databases. The server based databases or RDBMS such as MySQL, PostgreSQL, Microsoft SQL Server are designed to be used on servers and it can be easily shared by multiple users. Most evidently, server-based DBMS are used ... Original source on Gaea Times at  : <a href="http://tech.gaeatimes.com/index.php/archive/top-7-free-open-source-database-server/">Top 7 Free Open Source Database Server</a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/top-7-free-open-source-database-server/</link>
			</item>
	<item>
		<title>Justice Dept says OK to Oracle&#8217;s $7.4 billion deal for Sun; approval still needed in Europe</title>
		<description><![CDATA[SAN FRANCISCO — Business software maker Oracle Corp. said Thursday it has received the Justice Department&#8217;s approval to move forward with its $7.4 billion acquisition of former dot-com-era star Sun Microsystems Inc.

The deal still needs the go-ahead from the European Commission.
Clearance by the Justice Department had been held up over questions about the licensing of ... <a href="http://tech.gaeatimes.com/index.php/archive/justice-dept-says-ok-to-oracles-74-billion-deal-for-sun-approval-still-needed-in-europe/" title="Justice Dept says OK to Oracle&#8217;s $7.4 billion deal for Sun; approval still needed in Europe">Read more >></a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/justice-dept-says-ok-to-oracles-74-billion-deal-for-sun-approval-still-needed-in-europe/</link>
			</item>
	<item>
		<title>How do I Enable Remote Access To MySQL Database?</title>
		<description><![CDATA[Suppose you want to change  and enable the remote access to MySQL DB on your linux server (Debian). By default, you don&#8217;t get such privileges so you will have to work your way through this. I have a very simple article for you so that you can enable the remote access. This is a .... <a href="http://tech.gaeatimes.com/index.php/archive/how-do-i-enable-remote-access-to-mysql-database/">Source article on Gaea Times at  &nbsp;: How do I Enable Remote Access To MySQL Database?</a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/how-do-i-enable-remote-access-to-mysql-database/</link>
			</item>
	<item>
		<title>Feature: Will Sun Rise with Oracle?</title>
		<description><![CDATA[Unlike IBM&#8217;s failed attempt to acquire Sun Microsystems, the $7.4 billion tendered by Oracle to buy the Santa Clara-based enterprises solutions firm makes good sense for all three companies. It is also gives an honourable exit and hope of a new dawn for a setting Sun, in danger of being gobbled up and swallowed. Oracle, .... Original source &nbsp;: <a href="http://tech.gaeatimes.com/index.php/archive/sun-will-rise-again-with-oracle-comment/">Feature: Will Sun Rise with Oracle?</a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/sun-will-rise-again-with-oracle-comment/</link>
			</item>
	<item>
		<title>How to increase MySQL MyISAM Table Size Beyond 4GB</title>
		<description><![CDATA[When you started using MySQL, I am sure you never considered that it might have some limits on the maximum size of a table, did you?
Soon you may be facing the prospect of having tables over 4GB, the default limit imposed by MySQL. Fortunately MySQL provides a simple, but time-consuming, way to store data way .... <a href="http://tech.gaeatimes.com/index.php/archive/how-to-increase-mysql-myisam-table-size-beyond-4gb/">Source article on Gaea Times at  &nbsp;: How to increase MySQL MyISAM Table Size Beyond 4GB</a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/how-to-increase-mysql-myisam-table-size-beyond-4gb/</link>
			</item>
	<item>
		<title>Top 5 Recession Proof Jobs</title>
		<description><![CDATA[As the economy slows down, it’s harder to find good job opportunities in both technical and traditional lines of work. After interacting with HRD professional in different industries, Dipankar has found top 5  recession proof jobs in this economy. Of the 5 the only job relevant to my blog viewers is:

Network System Administrator: Many technology ... <a href="http://tech.gaeatimes.com/index.php/archive/top-5-recession-proof-jobs/">Read more : Top 5 Recession Proof Jobs</a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/top-5-recession-proof-jobs/</link>
			</item>
	<item>
		<title>How to Recover MySQL Root Password</title>
		<description><![CDATA[Do you want to recover the MySQL root password. its by no means, easy. But its quite simple if you follow the procedure. You will have to follow this step-by-step processes.

Step 1: Stop the MySQL server process.
Step 2: Start the MySQL (mysqld) server/daemon process with the &#8211;skip-grant-tables option so that it will not prompt for .... <a href="http://tech.gaeatimes.com/index.php/archive/how-to-recover-mysql-root-password/">Original source &nbsp;: How to Recover MySQL Root Password</a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/how-to-recover-mysql-root-password/</link>
			</item>
	<item>
		<title>How to Update or Change Password for a Single User in MySQL and Reload Privileges</title>
		<description><![CDATA[MySQL stores usernames and passwords in the user table inside the MySQL database. You can directly update a password using the following method to update or change passwords:

1) Login to the MySQL server, type the following command at the shell prompt:
$ mysql -u root -p
2) Use the mysql database (type commands at the mysql&#62; prompt):
mysql&#62; ... Original article on  : <a href="http://tech.gaeatimes.com/index.php/archive/how-to-update-or-change-password-for-a-single-user-in-mysql-and-reload-privileges/">How to Update or Change Password for a Single User in MySQL and Reload Privileges</a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/how-to-update-or-change-password-for-a-single-user-in-mysql-and-reload-privileges/</link>
			</item>
	<item>
		<title>How to Change MySQL Password for Other Users</title>
		<description><![CDATA[Do you get this error message when you try to change the root password?

mysqladmin: connect to server at &#8216;localhost&#8217; failed
error: &#8216;Access denied for user &#8216;root&#8217;@'localhost&#8217; (using password: YES)&#8217;

Or may be you need to change the MySQL password for other users. So what do you do then?

To change a normal user password you need to type:
$ ... Read more <a href="http://tech.gaeatimes.com/index.php/archive/how-to-change-mysql-password-for-other-users/" title="How to Change MySQL Password for Other Users">>>></a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/how-to-change-mysql-password-for-other-users/</link>
			</item>
	<item>
		<title>How to Set Up Root Password for Your MySQL Server</title>
		<description><![CDATA[If you have never set a root password for MySQL, the server does not require a password at all for connecting as root. To set up a root password for the first time, use the mysqladmin command at the shell prompt as follows:

$ mysqladmin -u root password newpass
If you want to change (or update) a .... <a href="http://tech.gaeatimes.com/index.php/archive/how-to-set-up-root-password-for-your-mysql-server/">Source article &nbsp;: How to Set Up Root Password for Your MySQL Server</a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/how-to-set-up-root-password-for-your-mysql-server/</link>
			</item>
	<item>
		<title>Sun Restricts MySQL Query Analyzer Tool To Gold Subscribers Only</title>
		<description><![CDATA[The MySQL Query Analyzer tool monitors query performance and quickly pinpoints and corrects problems in SQL code. It promises to &#8220;turbo-boost&#8221; the speed and uptime of MySQL database applications. One software developers reported it tripled his performance.

The tool is integrated into the MySQL Enterprise Monitor, a key part of Sun&#8217;s MySQL Enterprise subscription offering.
Subscriptions, as ... <a href="http://tech.gaeatimes.com/index.php/archive/sun-restricts-mysql-query-analyzer-tool-to-gold-subscribers-only/">Read this article on Gaea Times at  : Sun Restricts MySQL Query Analyzer Tool To Gold Subscribers Only</a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/sun-restricts-mysql-query-analyzer-tool-to-gold-subscribers-only/</link>
			</item>
	<item>
		<title>How To Export MS Access Database To MySQL Database</title>
		<description><![CDATA[Here are few tips (with undocumented features) to help you export huge MS Access database (production database with real data) to MySQL.

Use mdbtools utilities as described below:
mdb-tables displays the list of tables in MS Access
mdb-scheme export the MS Access schema to MySQL database. The documentation doesn&#8217;t mention that MySQL is supported. You should use the .... Source &nbsp;: <a href="http://tech.gaeatimes.com/index.php/archive/how-to-export-ms-access-database-to-mysql-database/">How To Export MS Access Database To MySQL Database</a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/how-to-export-ms-access-database-to-mysql-database/</link>
			</item>
	<item>
		<title>One MySQL Configuration Tip That Can Dramatically Improve MySQL Performance</title>
		<description><![CDATA[I mean every word of it. I found this simple configuration tip after days of continuously looking at MySQL logs (mytop), top, slow log queries, debugging the hell out of applications, reading tons of MySQL optimization tips (and pulling my remaining hairs in frustration) on the web. Even MySQL optimization tips from MySQL doesn&#8217;t mention ... <a href="http://tech.gaeatimes.com/index.php/archive/one-mysql-configuration-tip-that-can-dramatically-improve-mysql-performance/">Read this article on Gaea Times at  : One MySQL Configuration Tip That Can Dramatically Improve MySQL Performance</a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/one-mysql-configuration-tip-that-can-dramatically-improve-mysql-performance/</link>
			</item>
	<item>
		<title>How To Change MySQL Password</title>
		<description><![CDATA[Let&#8217;s look at all the ways to change MySQL password, for root and other users:
In MySQL the default password is empty. This is inherently unsafe and should be immediately changed. Here is how you can change MySQL default root password:

mysqladmin -u root password NEWPASSWORD

Here is how you can change OLDPASSWORD to NEWPASSWORD

mysqladmin -u LOGIN -p .... Original article on Gaea Times at  &nbsp;: <a href="http://tech.gaeatimes.com/index.php/archive/how-to-change-mysql-password/">How To Change MySQL Password</a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/how-to-change-mysql-password/</link>
			</item>
	<item>
		<title>How To Use AWK To Simplify Scripting: Multi-Database Backup Example</title>
		<description><![CDATA[AWK is an extremely versatile and powerful language for processing files and text data. Often you can use awk to perform complex tasks on Unix / Linux / Mac OS command line which would otherwise take a full-fledged programming effort. AWK is great for log processing, creating custom scripts which will then be executed and ... <a href="http://tech.gaeatimes.com/index.php/archive/how-to-use-awk-to-simplify-scripting-multi-database-backup-example/">Original source on Gaea Times at  : How To Use AWK To Simplify Scripting: Multi-Database Backup Example</a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/how-to-use-awk-to-simplify-scripting-multi-database-backup-example/</link>
			</item>
	<item>
		<title>MySQL Tip: How To Check, Repair &amp; Optimize All Tables in All Databases</title>
		<description><![CDATA[Here is a simple command to auto repair, check and optimize all the tables in all databases running on a MySQL server:

mysqlcheck -u root -p --auto-repair --check --optimize --all-databases
mysqlcheck is available in MySQL 3.23.38 and later.
mysqlcheck uses the SQL statements CHECK TABLE, REPAIR TABLE, ANALYZE TABLE, and OPTIMIZE TABLE in a convenient way for the .... <a href="http://tech.gaeatimes.com/index.php/archive/mysql-tip-how-to-check-repair-optimize-all-tables-in-all-databases/">Original source &nbsp;: MySQL Tip: How To Check, Repair &#038; Optimize All Tables in All Databases</a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/mysql-tip-how-to-check-repair-optimize-all-tables-in-all-databases/</link>
			</item>
	<item>
		<title>MySQL High End Features Should be Closed Source &amp; for Paid Customers Only</title>
		<description><![CDATA[I am serious. While MySQL is a great open source database, I have full respect to Sun&#8217;s plan to provide high-end features for paying customers only. After all they are in the business of making money and not philanthropy, last I checked.

Why is the blogosphere and MySQL community up in arms against the move? I ... Original source on Gaea Times at  : <a href="http://tech.gaeatimes.com/index.php/archive/mysql-high-end-features-should-be-closed-source-for-paid-customers-only/">MySQL High End Features Should be Closed Source &#038; for Paid Customers Only</a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/mysql-high-end-features-should-be-closed-source-for-paid-customers-only/</link>
			</item>
	<item>
		<title>MySQL SQL Delete Notes</title>
		<description><![CDATA[To delete duplicates from a MySQL database table I normally copy the duplicate data first to a temporary table and then use the copied id&#8217;s to delete from the original table. 

Delete using the temporary can take two forms. First is the slow way:

delete from target where id in (select id from temp);

This can be ... <a href="http://tech.gaeatimes.com/index.php/archive/mysql-sql-delete-notes/">Read : MySQL SQL Delete Notes</a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/mysql-sql-delete-notes/</link>
			</item>
	<item>
		<title>MySQL: Creating Users &amp; Granting Access Simplified</title>
		<description><![CDATA[In MySQL you can use the GRANT statement to create users and assign privileges to them at the same time. It is extremely convenient and beats create user or directly hacking the mysql.user table.  I learned few things about GRANT the hard way.

MySQL allows you to create users associated with a particular host name ... Read more <a href="http://tech.gaeatimes.com/index.php/archive/mysql-creating-users-granting-access-simplified/" title="MySQL: Creating Users &#038; Granting Access Simplified">>>></a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/mysql-creating-users-granting-access-simplified/</link>
			</item>
	<item>
		<title>6 MySQL Database Replication Tips</title>
		<description><![CDATA[Replicating on two or more MySQL master database servers
1. MySQL Master-Master Replication Fails With ERROR 1200 (HY000) on Master

2. Password problem are solved by carefully checking your grant statements
3. When you have more than two master servers, you must use log-slave-updates option to ensure that changes are propagated in a chain. Beware of infinite looping ... Read more <a href="http://tech.gaeatimes.com/index.php/archive/6-mysql-database-replication-tips/" title="6 MySQL Database Replication Tips">>>></a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/6-mysql-database-replication-tips/</link>
			</item>
	<item>
		<title>Monitoring MySQL Queries Using Bash Script</title>
		<description><![CDATA[Monitoring MySQL queries is a favorite pastime of MySQL administrators especially for performance reasons. Here is a simple bash script to monitor long running MySQL queries in realtime using the ubiquitous &#8217;show processlist&#8217;. The best part about this script is that you can use it to log your queries over time for later evaluation.


#!/bin/bash
while [ ... Original source on Gaea Times at  : <a href="http://tech.gaeatimes.com/index.php/archive/monitoring-mysql-queries-using-bash-script/">Monitoring MySQL Queries Using Bash Script</a>.]]></description>
		<link>http://tech.gaeatimes.com/index.php/archive/monitoring-mysql-queries-using-bash-script/</link>
			</item>
</channel>
</rss>

