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