StarBlog文字与索引
返回文章列表文章索引阅读全文
STARBLOG / 阅读手记
系统配置

Configure MariaDB database server remote access

Operating Steps Enable Remote Access Connect to the MariaDB database and execute the following command to enable remote access. grant all privileges on *.* to 'root'@'192.168.248.248' identified by 'password'; flush privileges; If access from any IP address is needed, replace the IP address with '%'. Modify Configuration Files The information available online only mentions the first step, but after testing, it does not work.

曦远 (DealiAxy)约 2 分钟
目录4 个章节

Steps

Enabling Remote Access

Connect to the MariaDB database and execute the following command to enable remote access.

grant all privileges on *.* to 'root'@'192.168.248.248' identified by 'password';
flush privileges;

If access is needed from any IP address, replace the IP address with %.

Modify the Configuration File

Most resources available online only mention the first point, but testing showed otherwise. This is because MariaDB defaults to binding to the local IP address. The exact file location depends on the database version. It took me some time to find it at the time. /etc/mysql/my.cnf/mariadb.conf.d/50-server.cnf Comment out the line bind-address = 127.0.0.1.

Restart MariaDB Service

_EOF_

Configure MariaDB database server remote access

本文作者：
程序设计实验室
版权声明：
本博客所有文章除特别声明外，均采用 BY-NC-SA 许可协议。转载请注明出处！

相关文章

Debian8-stable-升级Python版本到3-6

前言 最近把一个Python项目部署到服务器上，然而服务器上的Python版本实在是太旧了，于是着手进行更新。 互联网上搜索到的方法都是下载Python3.6的代码之后手动编译，然而在服务器上编译安装出了点问题，于是想到了Ubuntu的ppa方式，debian和Ubuntu本属同源，理论上Ubuntu的ppa，debian也是可以用的。 操作步骤如下： 添加软件源 add-apt-reposito

2025-10-27 · 系统配置 · 约 1 分钟

讨论

共 0 条

良言一句三冬暖，恶语伤人六月寒。

加载评论中…