How to Update or Change Password for a Single User in MySQL and Reload Privileges

November 23rd, 2007 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.

January 17th, 2009 Do you want to recover the MySQL root password. its by no means, easy.

January 17th, 2009 Do you get this error message when you try to change the root password? mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)' 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: $ mysqladmin -u user-name -p oldpassword newpass

April 27th, 2009 Suppose you want to change and enable the remote access to MySQL DB on your linux server (Debian). By default, you don't get such privileges so you will have to work your way through this.

October 22nd, 2007 Openfire is a cross-platform java based free Instant Messaging server which implements the XAMPP (Jabber) protocol with extensions. It is very well suited as corporate instant messaging solution.

April 20th, 2008 Let'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.

January 17th, 2009 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 root password, then you need to use the following command: $ mysqladmin -u root -p oldpassword newpass I hope this will work for you perfectly.

January 6th, 2009 MySQL data directory is the most important and sensitive place for any administrator. How do you move the whole data directory all on a sudden? There is no particular topic in the internet writing about it clearly.

October 23rd, 2006 First of all I want to make it clear that having a MySQL database without a password set (on your root account) is a very very bad idea. However I wanted to set it up on my home machine which has XAMPP installed.

September 1st, 2007 Try: mysql -e status|grep 'Server version' If that doesn't work then use: mysql -u root -p -e status|grep 'Server version' Provide root password when prompted. Default root password for MySQL is empty string, so just pressing enter when prompted for password will suffice by default.

May 12th, 2007 Mantis is popular php based defect tracking application which works on top of RDBMS like MySQL and PostgreSQL. Recently I ported our Windows based Mantis installation to Linux.

September 9th, 2007 I was looking for the wiki of a popular Linux based firewall site. The main url was 404, so I went up one level hoping to find a new url.

November 18th, 2007 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 'show processlist'.

March 23rd, 2007 Strangely the most obvious means to reset Google AdSense password may not work for you. By obvious I mean the link on AdSense login page: I cannot access my account.

August 13th, 2008 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.