Skip to content

AlieeLinux/password-manager-sql

Repository files navigation

🔒 SQL password manager

Koishi

🍎 Simple password manager via Mysql and Mariadb server

passwd.webm

Installation

🪟 🐧 Windows and Linux: Using uv(recommended)

uv sync

uv run main.py

🐧 Linux: using pip

python -m venv .venv

source .venv/bin/activate

pip install -r requirements.txt

🪟 Windows: using pip

python -m venv .venv

.\.venv\Scripts\activate

pip install -r requirements.txt

Running

🪟: 🐧 : Flask gui (stil testing)

uv run main.py

🪟 🐧 Windows and Linux: using uv(recommended)

uv run main.py

🪟 Windows: using python

# Activating
.\.venv\Scripts\activate

# Executing
python main.py

🐧 Linux: using python

# Activating the environment
source ./.venv/bin/activate

# Running
python main.py

You can sneak that in as a warning/note right before users run the app, so they see it before trying to connect to the SQL server. Here's a clean way to add it to your markdown:

⚠️ Important: It is highly recommended that you set a user and password on your SQL/MariaDB server before running the manager

If your server is still not configured, follow these steps

  1. Log in as root (the default admin user)

    On Linux / WSL / Mac:

    sudo mysql -u root

    On Windows (Command Prompt or PowerShell):

    mysql -u root -p
  2. Run the secure installation wizard (if first time):

    sudo mysql_secure_installation
    
  3. Create a new user:

    CREATE USER 'youruser'@'localhost' IDENTIFIED BY 'yourpassword';
  4. Grant privileges to the user:

    GRANT ALL PRIVILEGES ON yourdatabase.* TO 'youruser'@'localhost';
    FLUSH PRIVILEGES;
  5. Update your .env file with the new user credentials:

    DB_USER=youruser
    DB_PASS=yourpassword
    DB_SERVER="mysql or mariadb"

This way its:

  • Prominent but not intrusive
  • Gives both the recommendation and steps
  • Keeps your markdown clean and readable

❓ What if I'm using sqlite instead?

Then good for you, No need to add username passwords on sql


contributors

Made with contrib.rocks.

📚 Additional Resources


Koishi

Love from koishi 💚

About

No description, website, or topics provided.

Resources

License

Stars

5 stars

Watchers

1 watching

Forks

Packages

 
 
 

Contributors