Samuel

OS: CentOS 5.5 64bit

yum install mysql mysql-server mysql-devel

裝完後 

chgrp -R mysql /var/lib/mysql 
chmod -R 770 /var/lib/mysql

然後打開服務

service mysqld start

改密碼

/usr/bin/mysqladmin -u root password 'new-password' 
/usr/bin/mysqladmin -u root -h hostname password 'new-password' 

reset root 密碼

/etc/init.d/mysqld stop

mysqld_safe --skip-grant-tables &

mysql -u root -p

mysql> use mysql;
mysql> update user set password=PASSWORD("新root密碼") where User='root';
mysql> flush privileges;
mysql> quit

/etc/init.d/mysqld stop

/etc/init.d/mysqld start

新增mysql.user host

mysql> CREATE USER 'root'@'192.168.1.1' IDENTIFIED BY '設定此host的password';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.1' WITH GRANT OPTION;

新增mysql.user host '%' : 允許所有內外部連線

mysql> CREATE USER 'root'@'%' IDENTIFIED BY '設定此host的password';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;

刪除host

drop user 'root'@'localhost'; 

登入root 加 host

mysql -u root -h hostname -p