what is the default Password Policy in mysql 5.0 ?


if by default password policy you mean "are there a minimum set of rules that need to be met in order to have a valid password with a default installation of MySQL", then the short answer is that there is no default password policy.

a default install of MySQL can be done with no password for a root user at all. Some distros (e.g. debian installing mysql via apt) insist on a root password, but no complexity rules are enforced.

there are 3rd party plugins to create policies (e.g. securich), but nothing that would enforce specific complexity or aging rules within the base system

 shell$ mysql
 mysql> use mysql;
 mysql> SELECT Host, User, Password  FROM user;
 | Host          | User | Password |
 | localhost     | root |          |
 | your uname -n | root |          |
 |     | root |          |
 | localhost     |      |          |
 | your uname -n |      |          |

 as you can see is quite clear that there is no password but it was said that some linux distribution will 'force' you to have a root password
 use mysqladmin to update the passwords

The distros that do force a root password only enforce it at install time. There's nothing stopping root from going in afterwards to do SET PASSWORD = PASSWORD('');

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.