Skip to content

Mysql Db Access denied backup #1778

Closed
Closed
@TahaJalali

Description

@TahaJalali

درود من بعد از وارد کردن دیتابیس در pma وقتی میخوام از سرویس بک‌آپ استفاده کنم ارور زیر رو دریافت میکنم

os: ubuntu 22
panel: marzban:latest

Marzban backup bot log:
Database detected: mysql
Database detected: mysql
mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
sending incremental file list
created directory /tmp/marzban_backup/marzban_data

Marzban .env mysql config:
SQLALCHEMY_DATABASE_URL="mysql+pymysql://root:[email protected]/marzban"
MYSQL_ROOT_PASSWORD=0hbae2iZwt7pL

Marzban docker-compose.yml config:
services:
marzban:
image: gozargah/marzban:latest
restart: always
env_file: .env
network_mode: host
volumes:
- /var/lib/marzban:/var/lib/marzban
depends_on:
- mysql
mysql:
image: mysql:lts
restart: always
env_file: .env
network_mode: host
command: --bind-address=127.0.0.1 --mysqlx-bind-address=127.0.0.1 --disable-log-bin
environment:
MYSQL_DATABASE: marzban
volumes:
- /var/lib/marzban/mysql:/var/lib/mysql
phpmyadmin:
image: phpmyadmin/phpmyadmin:latest
restart: always
env_file: .env
network_mode: host
environment:
PMA_HOST: 127.0.0.1
APACHE_PORT: 8010
UPLOAD_LIMIT: 1024M
depends_on:
- mysql

این اولین issues که تو گیت هاب ثبت میکنم ببخشید اگه ناکامل هست

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions