lamp or lnmp 環境搭建之獨立安裝mysql數據庫

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

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

2. 安裝后，優化服務器。

3. 授權
   

實例一：

#創建用戶demo,密碼demo123

mysql> create user demo@localhost identified by 'demo123';

Query OK, 0 rows affected (0.00 sec)

#此時只能登錄，因為沒有授權

mysql> show grants for demo@localhost;  

+----------------------------------------------------------------------------------------------------------------+

| Grants for demo@localhost                                                                                   |

+----------------------------------------------------------------------------------------------------------------+

| GRANT USAGE ON *.* TO 'demo'@'localhost' IDENTIFIED BY PASSWORD '*2CADADD54086D5EB4C9F10E0430084D7F179885C' |

+----------------------------------------------------------------------------------------------------------------+

1 row in set (0.00 sec)

#授權本地登錄

mysql> grant all on test.* to 'demo'@'localhost';

Query OK, 0 rows affected (0.01 sec)

#查看授權情況

mysql> show grants for demo@localhost;           

+----------------------------------------------------------------------------------------------------------------+

| Grants for demo@localhost                                                                                   |

+----------------------------------------------------------------------------------------------------------------+

| GRANT USAGE ON *.* TO 'demo'@'localhost' IDENTIFIED BY PASSWORD '*2CADADD54086D5EB4C9F10E0430084D7F179885C' |

| GRANT ALL PRIVILEGES ON `test`.* TO 'demo'@'localhost'                                                      |

+----------------------------------------------------------------------------------------------------------------+

2 rows in set (0.00 sec)

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

實例二

授權所有的數據庫給myuser從局域網10.89.1.0網段上連接

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

FLUSH PRIVILEGES;

mysql> select user,host from mysql.user;

+---------+-------------+

| user    | host        |

+---------+-------------+

| tom     | %           |

| tom1    | %           |

| tom2    | %           |

| root    | 127.0.0.1   |

| myuser  | 10.89.1.%   |

| myuser  | localhost   |

| myuser  | localhost   |

| root    | localhost   |

| tom     | localhost   |

| root    | mysql       |

+---------+-------------+

10 rows in set (0.01 sec)

#客戶端連接測試

#如果是默認的3306 就不需要加，這里是使用多實例測試，端口是3308。

[root@weblnmp ~]# mysql -umyuser -pmypassword -h 10.89.1.30 -P3308; 

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 7

Server version: 5.5.32-log Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 

5.web服務器連接測試

[root@weblnmp blog]# vi test_mysql.php

   <?php

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

      if ($link_id) {

             echo "mysql _OK()";

         }

    else {

             echo "mysql _error()";

         }

  ?>