lamp or lnmp 环境搭建之独立安装mysql数据库
lamp or lnmp 环境搭建,如果mysql 是独立安装的则需要授权：
单独一台服务器独立安装mysql
安装后，优化服务器。
授权
实例一：
#创建用户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
$link_id=mysql_connect('10.89.1.30','myuser','mypassword') or mysql_error();
if ($link_id) {
echo "mysql _OK()";
}
else {
echo "mysql _error()";
}
?>
