隨風而行

1.#yum groupinfo “mysql” //查詢mysql會安裝那些套件

2.#yum groupinstall “mysql” //使用yum進行群組安裝
Ps.如果想將mysql DB放置資料夾從預設的/var/lib/mysql改放到別的目錄的話
ex./home/db/mysql。
#mkdir /home/db; mkdir /home/db/mysql
#chown mysql:mysql /home/db/mysql
#vim /etc /my.cnf

[mysqld]
Datadir = /var/lib/mysql //修改前
Datadir = /home/db/mysql //修改後

3.#chkconfig mysql on

4.#chkconfig --list | grep mysql //查看mysqld是否啟動

5.#/etc/init.d/mysqld start //啟動mysql服務

6.#netstat –tnl //檢查mysql是否啟動成功並listen相關port(3306)

7.#mysqladmin –u root password yourpassword //設定新密碼
#mysqladmin –u root –p yourpassword newpassword //日後若要更改密碼

8.#mysql –u root –p //測試登入mysql

9.重設密碼： ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
# /etc/init.d/mysql stop # mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';
mysql> FLUSH PRIVILEGES;
mysql> quit
# /etc/init.d/mysqld restart
# mysql -uroot -p Enter password:
mysql>

10.建立其它mysql帳號 ex.允許連線主機來源是localhost帳號：result密碼：1234登入的使用者，能對指定的資料庫testdb擁有所有權限。
mysql>GRANT ALL PRIVILEGES ON testdb.* TO result@localhost IDENTIFIED BY ‘1234’;
mysql>FLUSH PRIVILEGES; //重新載入，使其生效