默认情况下安装完成后mysql没设root密码,可以直接登录:
[root@centos6 ~]# mysql -uroot
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.1.49 MySQL Community Server (GPL)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
可以使用mysqladmin工具的password选项给root用户添加密码:
[root@centos6 ~]# mysqladmin -uroot password '654321'
设置密码后,不输入密码将登陆失败:
[root@centos6 ~]# mysql -uroot
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO