Debian LAMP(Linux+Apache+MySQL/MariaDB+PHP)的数据库管理方法如下:
sudo apt update
sudo apt install mariadb-server
sudo mysql_secure_installation # 设置root密码及安全选项
sudo apt install mysql-server
sudo mysql_secure_installation
sudo systemctl start mariadb # 或 mysql
sudo systemctl enable mariadb
/etc/mysql/mariadb.conf.d/50-server.cnf
,调整 bind-address
(默认 127.0.0.1
,若需远程访问改为 0.0.0.0
)。sudo mysql -u root -p
CREATE DATABASE mydb;
CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON mydb.* TO 'myuser'@'localhost';
FLUSH PRIVILEGES;
mysqldump -u root -p mydb > backup.sql
mysql -u root -p mydb < backup.sql
sudo ufw allow 3306/tcp
#skip-networking
或限制root仅本地登录。操作 | 命令 |
---|---|
查看服务状态 | sudo systemctl status mariadb |
重启服务 | sudo systemctl restart mariadb |
查看数据库列表 | SHOW DATABASES; (登录后执行) |
删除数据库 | DROP DATABASE mydb; (谨慎操作) |
mysql
、mysqldump
phpMyAdmin
(需安装 sudo apt install phpmyadmin
)参考来源: