lamp or lnmp 環境搭建,如果mysql 是獨立安裝的則需要授權：

單獨一臺服務器獨立安裝mysql

安裝后，優化服務器。

授權

實例如下：

創建用戶

CREATE USER demo IDENTIFIED BY “passwd123”;

授權使用mysql數據庫下面的所有表

GRANT ALL PRIVILEGES ON mysql.* TO 'demo'@'%'IDENTIFIED BY 'passwd123'WITH GRANT OPTION;

FLUSH PRIVILEGES;

-------------------------------------------------------------------------------------------

實例二

授權所有的數據庫給myuser連接

CREATE USER myuser IDENTIFIED BY “mypassword”;

GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%'IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

FLUSH PRIVILEGES;

實例三

授權所有的數據庫給myuser從192.168.1.3上連接

GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'10.89.1.30'IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

FLUSH PRIVILEGES;

4.web服務器連接測試

[root@weblnmp blog]# vi oldboy_mysql.php

$link_id=mysql_connect('10.89.1.30','myuser','mypassword') or mysql_error();

if ($link_id) {

echo "mysql _OK()";

}

else {

echo "mysql _error()";

}

?>