4月 6, 2010
Mysql初期設定
・ユーザ一覧を確認
[root@centos ~]# mysql -u root mysql> select user,host,password from mysql.user; +------+-----------------------+----------+ | user | host | password | +------+-----------------------+----------+ | root | localhost | | | root | localhost.localdomain | | | root | 127.0.0.1 | | | | localhost | | | | localhost.localdomain | | +------+-----------------------+----------+
・rootユーザにパスワードを設定
mysql> set password for root@localhost=password('パスワード'); mysql> set password for root@'localhost.localdomain'=password('パスワード'); mysql> set password for root@'127.0.0.1'=password('パスワード');
・不要なユーザを削除
mysql> delete from mysql.user where user='';
・データベースtestを削除
mysql> drop database test; mysql> quit