cp php.ini-development /usr/local/php/lib/php.ini
vi /usr/local/php/lib/php.ini
mysqli.default_socket = /usr/local/mysql/mysql.sock
date.timezone = Asia/Shanghai
/usr/local/php/bin/php -m //验证安装的模块
vi /etc/httpd.conf //在合适位置新增
AddType application/x-httpd-php .php
AddType application/x-httpd-php-source .phps
DirectoryIndex index.php index.html
rm-f /usr/local/httpd/htdocs/index.html
vi /usr/local/httpd/htdocs/index.php
<?php
phpinfo();#调用一个函数
?>
systemctl restart httpd
http://192.168.32.21/
mysqladmin -uroot -p password 'abc123'////这个地方回车后,输入是初始密码,我们这边安装的初始密码是空的。回车即可
--------下面测试数据库工作是否正常-----
mysql -u root -p
CREATE DATABASE myadm;
GRANT all ON myadm.* TO 'myadm'@'%' IDENTIFIED BY 'admin123';
GRANT all ON myadm.* TO 'myadm'@'localhost' IDENTIFIED BY 'admin123';
flush privileges;
vi /usr/local/httpd/htdocs/index.php
<?php
$link=mysqli_connect('192.168.32.21','myadm','admin123');if($link)echo"<h1>Success!!</h1>";elseecho"Fail!!";
?>
在浏览器上输入 192.168.32.21 测试一下
安装phpMyadmin
cd /opt
unzip phpMyAdmin-4.7.6-all-languages.zip -d /opt/mv phpMyAdmin-4.7.6-all-languages /usr/local/httpd/htdocs/myadm
cd /usr/local/httpd/htdocs/myadm
cp config.sample.inc.php config.inc.php
vi config.inc.php
$cfg['Servers'][$i]['host'] = '127.0.0.1';//把localhost 改成IP 31行
http://192.168.32.21/myadm
使用root 以及前面为root配置的密码登录管理系统。可以对数据库进行管理操作了
问题
2019-02-20T10:25:17.505498Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
解决方案:在打开my.cf(可用记事本打开),找到“[mysqld]”设置项,添加代码:
#开启查询缓存
explicit_defaults_for_timestamp=true