MySQL Server Default Password

[vinhdizzo]

Hi,

What is the default username and password to mysql server? I want to log into the server via "mysql -u username -p" to be able to create a database. The username and password from this link doesn't seem to work.

Thanks.

 

[randy7376]

The MySQL root password is passw0rd by default (if I remember correctly).

Note that is a zero and not an 'oh'.

 

[vinhdizzo]

Thanks. What's the proper way to change this password? Would anything be broken if I change it?

Is there a list of default passwords listed anywhere? Thanks

 

[duggerd]

Do NOT change the MySQL password. This WILL break your PBX and cause other problems. This does not cause any security problems, and should be set to this for your PBX to work.

 

[randy7376]

Unless you have some compelling reason to change that password, it's definitely a good idea to leave it alone. As duggerd suggests, changing it can cause a multitude of problems.

 

[wardmundy]

Don't Change The Default Mysql Password!

The only way for someone to access your MySQL password is to gain root access to your server. So... as long as your root password is secure, your MySQL password really doesn't matter. MySQL access is limited in the PIAF setup to access from the local server only. Just as an FYI, anyone with root access to your server could discover the MySQL server password in less than a minute because numerous apps store it in plain text. It's also trivial to reset it if you have root access to a Linux server. Here's how.

If you want to see a good sample of the apps that would be broken by changing your MySQL password, log into your server as root and issue the following commands:

grep -r passw0rd /var/www/html/*
grep -r passw0rd /var/lib/asterisk/*

 

[rossiv]

I want to log into the server via "mysql -u username -p" to be able to create a database.
Thanks.

Just use phpMyAdmin - http://ipaddress/maint/phpmyadmin