JamesBranam's Blog

Changing the MySQL Root Password

Hi all,

Today I've decided to write a tip on changing the root password for MySQL. First, let me explain why. Yesterday I was having some problems manipulating my MySQL server using NetBeans IDE. There was an issue with passing a blank password to the connection pool, and I was advised by engineers to use a password for my root user.

Let's say that your password is elephant, and you want to change it to giraffe. This is how I changed the password for the MySQL root user:

1. I opened my terminal.
2. I typed mysqladmin -u root -p password "giraffe"
3. I was then prompted for my MySQL password. I entered elephant
4. The password was changed. No errors.

Cheers!

--James

Posted at 11:17AM Oct 08, 2008 by branajam in NetBeans  |