安置更新与PHP证书安置

apt update && apt upgrade apt install ca-certificates apt-transport-https wget -q https://packages.sury.org/php/apt.gpg -O- | sudo apt-key add - echo "deb https://packages.sury.org/php/ buster main" | tee /etc/apt/sources.list.d/php.list

安置PHP

apt update apt install php7.3 apt install php7.3-cli php7.3-common php7.3-curl php7.3-gd php7.3-json php7.3-mbstring php7.3-mysql php7.3-xml

配置pdo(去失注释)

nano /etc/php/7.3/apache2/php.ini extension=pdo_mysql 安置MariaDB

安置MariaDB
apt install mariadb-server -y

设置开机启动MariaDB
systemctl enable mariadb.service
systemctl restart mariadb.service

设置MariaDB权限与暗码等

登陆MariaDB:无暗码mysql -uroot有暗码用mysql -uroot -p123456

显示数据库show databases;

选择数据库use mysql;

盘问用户SELECT host,user,password from user;

设置暗码set password for ‘root‘@‘localhost‘ =password(‘123456‘);

长途连接设置grant all privileges on *.* to [email protected]‘%‘identified by ‘123456‘;

如果是不是root则先新建用户
create user ‘用户名‘@‘%‘ ip地点 by ‘暗码‘
测试pdo代码(便利不懂的人使用改削,注意127.0.0.1与localhost有可能不一样!请改削mysql暗码)

，