vim /etc/httpd/conf/httpd.conf
Listen 172.16.10.34:80
ServerName www.benet.com //域名自定义
DirectoryIndex index.html index.php
时区设置
vim /etc/php.ini
date.timezone = PRC //
启动服务
systemctl start httpd.service
systemctl enable httpd.service
systemctl start mariadb.service
systemctl enable mariadb.service
netstat -ntap | egrep '(80|3306)'
初始化数据库
mysql_secure_installation
数据库的创建及用户授权
mysql -u root -p
CREATE DATABASE zabbix character set utf8 collate utf8_bin;
GRANT all privileges ON *.* TO 'zabbix'@'%' IDENTIFIED BY 'admin123';
flush privileges;
测试连通性
vim /var/www/html/index.php //
<?php
$link=mysql_connect('172.16.10.34','zabbix','admin123');
if($link) echo "<h1>The database connection was successful!</h1>";
else echo "<h1>The database connection was Fail!!</h1>";
mysql_close();
?>
解决本地用户无法登陆问题
有时我们会遇到在mysql数据库中添加用户,并授权其远程登陆,但是在你测试时却是无法登陆,甚至在本地
也无法登陆,可能原因是在mysql的用户列表中有空用户,对本地用户登陆造成了干扰,导致无法登陆。
mysql -uroot -p
select user,host from mysql.user;
+--------+-----------+
| user | host |
+--------+-----------+
| zabbix | % |
| root | 127.0.0.1 |
3 1
关注
cchenyz
1
分享
在线
客服
评论