Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

what is the default Password Policy in mysql 5.0 ?

share|improve this question
add comment

3 Answers

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

share|improve this answer
add comment
 shell$ mysql
 mysql> use mysql;
 mysql> SELECT Host, User, Password  FROM user;
 +---------------+------+----------+
 | Host          | User | Password |
 +---------------+------+----------+
 | localhost     | root |          |
 | your uname -n | root |          |
 | 127.0.0.1     | 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
share|improve this answer
add comment

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('');

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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