[PR #4918] [MERGED] MySQL/MariaDB: fix create user with password #5193

Closed
opened 2026-02-26 14:33:23 +03:00 by kerem · 0 comments
Owner

📋 Pull Request Information

Original PR: https://github.com/community-scripts/ProxmoxVE/pull/4918
Author: @MickLesk
Created: 6/2/2025
Status: Merged
Merged: 6/2/2025
Merged by: @michelroegl-brunner

Base: mainHead: fix_mysql


📝 Commits (3)

  • aa84f12 MySQL/MariaDB: Fix Authentification with password
  • 06fcf8d add apache guac
  • 051d30e harmonize $STD value

📊 Changes

19 files changed (+37 additions, -37 deletions)

View changed files

📝 install/2fauth-install.sh (+1 -1)
📝 install/alpine-nextcloud-install.sh (+1 -1)
📝 install/apache-guacamole-install.sh (+3 -3)
📝 install/bookstack-install.sh (+3 -3)
📝 install/dolibarr-install.sh (+1 -1)
📝 install/firefly-install.sh (+3 -3)
📝 install/ghost-install.sh (+3 -3)
📝 install/glpi-install.sh (+4 -4)
📝 install/kimai-install.sh (+3 -3)
📝 install/monica-install.sh (+1 -1)
📝 install/paymenter-install.sh (+3 -3)
📝 install/pelican-panel-install.sh (+1 -1)
📝 install/phpipam-install.sh (+2 -2)
📝 install/plant-it-install.sh (+1 -1)
📝 install/projectsend-install.sh (+1 -1)
📝 install/pterodactyl-panel-install.sh (+1 -1)
📝 install/shinobi-install.sh (+1 -1)
📝 install/snipeit-install.sh (+3 -3)
📝 install/wavelog-install.sh (+1 -1)

📄 Description

✍️ Description

mysql and mariadb changed the auth code from, example:

CREATE USER '$DB_USER'@'localhost' IDENTIFIED WITH mysql_native_password AS PASSWORD('$DB_PASS');

to:

CREATE USER '$DB_USER'@'localhost' IDENTIFIED BY '$DB_PASS';

Link: #4880

Prerequisites (X in brackets)

  • Self-review completed – Code follows project standards.
  • Tested thoroughly – Changes work as expected.
  • No security risks – No hardcoded secrets, unnecessary privilege escalations, or permission issues.

🛠️ Type of Change (X in brackets)

  • 🐞 Bug fix – Resolves an issue without breaking functionality.
  • New feature – Adds new, non-breaking functionality.
  • 💥 Breaking change – Alters existing functionality in a way that may require updates.
  • 🆕 New script – A fully functional and tested script or script set.
  • 🌍 Website update – Changes to website-related JSON files or metadata.
  • 🔧 Refactoring / Code Cleanup – Improves readability or maintainability without changing functionality.
  • 📝 Documentation update – Changes to README, AppName.md, CONTRIBUTING.md, or other docs.

🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.

## 📋 Pull Request Information **Original PR:** https://github.com/community-scripts/ProxmoxVE/pull/4918 **Author:** [@MickLesk](https://github.com/MickLesk) **Created:** 6/2/2025 **Status:** ✅ Merged **Merged:** 6/2/2025 **Merged by:** [@michelroegl-brunner](https://github.com/michelroegl-brunner) **Base:** `main` ← **Head:** `fix_mysql` --- ### 📝 Commits (3) - [`aa84f12`](https://github.com/community-scripts/ProxmoxVE/commit/aa84f1249ec2d1dd5227b965d1747f20d5e3e1db) MySQL/MariaDB: Fix Authentification with password - [`06fcf8d`](https://github.com/community-scripts/ProxmoxVE/commit/06fcf8d6b580043e8a9bebe6c09760fffdec5261) add apache guac - [`051d30e`](https://github.com/community-scripts/ProxmoxVE/commit/051d30e4a7ed648fc4e1cf25dad457d9ec1c4f29) harmonize $STD value ### 📊 Changes **19 files changed** (+37 additions, -37 deletions) <details> <summary>View changed files</summary> 📝 `install/2fauth-install.sh` (+1 -1) 📝 `install/alpine-nextcloud-install.sh` (+1 -1) 📝 `install/apache-guacamole-install.sh` (+3 -3) 📝 `install/bookstack-install.sh` (+3 -3) 📝 `install/dolibarr-install.sh` (+1 -1) 📝 `install/firefly-install.sh` (+3 -3) 📝 `install/ghost-install.sh` (+3 -3) 📝 `install/glpi-install.sh` (+4 -4) 📝 `install/kimai-install.sh` (+3 -3) 📝 `install/monica-install.sh` (+1 -1) 📝 `install/paymenter-install.sh` (+3 -3) 📝 `install/pelican-panel-install.sh` (+1 -1) 📝 `install/phpipam-install.sh` (+2 -2) 📝 `install/plant-it-install.sh` (+1 -1) 📝 `install/projectsend-install.sh` (+1 -1) 📝 `install/pterodactyl-panel-install.sh` (+1 -1) 📝 `install/shinobi-install.sh` (+1 -1) 📝 `install/snipeit-install.sh` (+3 -3) 📝 `install/wavelog-install.sh` (+1 -1) </details> ### 📄 Description ## ✍️ Description mysql and mariadb changed the auth code from, example: ```sql CREATE USER '$DB_USER'@'localhost' IDENTIFIED WITH mysql_native_password AS PASSWORD('$DB_PASS'); ``` to: ```sql CREATE USER '$DB_USER'@'localhost' IDENTIFIED BY '$DB_PASS'; ``` ## 🔗 Related PR / Issue Link: #4880 ## ✅ Prerequisites (**X** in brackets) - [x] **Self-review completed** – Code follows project standards. - [x] **Tested thoroughly** – Changes work as expected. - [x] **No security risks** – No hardcoded secrets, unnecessary privilege escalations, or permission issues. --- ## 🛠️ Type of Change (**X** in brackets) - [x] 🐞 **Bug fix** – Resolves an issue without breaking functionality. - [ ] ✨ **New feature** – Adds new, non-breaking functionality. - [ ] 💥 **Breaking change** – Alters existing functionality in a way that may require updates. - [ ] 🆕 **New script** – A fully functional and tested script or script set. - [ ] 🌍 **Website update** – Changes to website-related JSON files or metadata. - [ ] 🔧 **Refactoring / Code Cleanup** – Improves readability or maintainability without changing functionality. - [ ] 📝 **Documentation update** – Changes to `README`, `AppName.md`, `CONTRIBUTING.md`, or other docs. --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>
kerem 2026-02-26 14:33:23 +03:00
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/ProxmoxVE#5193
No description provided.