linux yum安裝mysql後要注意的一些初始化問題

1. 配置開機啟動服務
/sbin/chkconfig httpd on [設定apache伺服器httpd服務開機啟動]
/sbin/chkconfig –add mysqld [在服務資訊清單中添加mysql服務]
/sbin/chkconfig mysqld on [設定mysql服務開機啟動]
/sbin/service httpd start [啟動httpd服務,與開機啟動無關]
/sbin/service mysqld start [啟動mysql服務,與開機無關]

2. 設定mysql資料庫root帳號密碼。預設的初始化密碼為空白~~~
mysqladmin -u root password ‘new-password’ [引號內填密碼]

3. 讓mysql資料庫更安全
mysql -u root -p
mysql> DROP DATABASE test; [刪除test資料庫]
mysql> DELETE FROM mysql.user WHERE user = ”; [刪除匿名帳戶]
mysql> FLUSH PRIVILEGES; [重載許可權]
4.安裝上mysql擴充
yum -y install mysql-connector-odbc mysql-devel libdbi-dbd-mysql
5.設定預設編碼等一些初始參數（my.cnf）
vi /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
default-character-set=utf8 [添加]
default-storage-engine=INNODB [添加]
old_passwords=1
[client]
default-character-set=utf8 [添加]
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid