php和mysql安装配置

1、php安装

apt install apache2 apt install php7.0 php -v apt-cache search libapache2-mod-php apt install libapache2-mod-php7.0 apt install mysql-server mysql-client mysql -V apt install php7.0-mysql

2、写php代码

vi test_mysql.php <?php $servername = "localhost"; $username = "root"; $password = "111111"; $conn = mysqli_connect($servername, $username, $password); if (!$conn) { die("failed to connect"); } $sql = "CREATE DATABASE myDB"; if (mysqli_query($conn, $sql)) { echo "success to create db"; } else { echo "Error creating database: "; } mysqli_close($conn); ?>

3、更新mysql权限

//配置远程连接mysql： mysql -u root -p use mysql; GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' flush privileges; select host,user,password from user; //取消绑定本地IP，允许远程mysql连接 vi /etc/mysql/mysql.conf.d/mysqld.cnf #bind-address = 127.0.0.1 //配置php连接mysql select user, plugin from mysql.user; //设置登录密码，把auth_socket改成mysql_native_password update mysql.user set authentication_string=PASSWORD('111111'),plugin='mysql_native_password' where user='root'; flush privileges; //mysql重启 service mysql restart

4、访问php

http://126.12.195.233/test_mysql.php

5、调试

more /var/log/apache2/error.log

6、远程连接mysql

root@yp-pc# mysql -h 126.12.195.233 -P 3306 -u root -p111111 mysql: [Warning] Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 Server version: 5.7.24-0ubuntu0.16.04.1 (Ubuntu) Copyright (c) 2000, 2018, 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>

7、window安装mysql客户端

下载mysql front，地址：http://www.mysqlfront.de 

参考：https://www.cnblogs.com/miraclewong/p/3705607.html