How to Set Up Root Password for Your MySQL Server

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

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.

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 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

January 17th, 2009 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> prompt): mysql> use mysql; 3) Change password for a user: mysql> update user set password=PASSWORD("newpass") where User='YOUR-USER-NAME'; 4) Reload privileges: mysql> flush privileges; mysql> quit [P.S.

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.

April 20th, 2008 1. Login to the Admin account (not the normal account) 2. Open up a command shell in the Terminal application by selecting - Macintosh HD -> Applications -> Utilities -> Terminal At the command prompt type this command: sudo passwd root You will then get the following prompts.

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'.

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.

November 3rd, 2008 Today I am going to tell you the trick to hack your root passoword in Linux if you are too forgetful to remember it or you have legal permission to enter a server run by a different admin and by any chance he forgot to give you the root password. Those Who Have GRUB bootloader The first step is to reboot server.

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.

November 18th, 2007 Replicating on two or more MySQL master database servers 1. MySQL Master-Master Replication Fails With ERROR 1200 (HY000) on Master 2.

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

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