jetersen
/ create_user.sql
Created
October 24, 2022 08:42
Create user and grant privileges to database
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE USER 'user'@'%' IDENTIFIED BY 'password'; | |
| GRANT USAGE ON *.* TO 'user_o'@'%'; | |
| GRANT EXECUTE, SELECT, SHOW VIEW, ALTER, ALTER ROUTINE, CREATE, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE VIEW, DELETE, DROP, EVENT, INDEX, INSERT, REFERENCES, TRIGGER, UPDATE, LOCK TABLES ON `database`.* TO 'user'@'%'; | |
| FLUSH PRIVILEGES; | |
| SHOW GRANTS FOR 'user'@'%'; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| version="1.16.1" | |
| url="https://github.com/podman-desktop/podman-desktop/releases/download/v${version}/podman-desktop-${version}.tar.gz" | |
| iconUrl="https://raw.githubusercontent.com/podman-desktop/podman-desktop/acfd93abbf719c6bdc2e2a932e3ebf90affa465d/buildResources/icon.png" | |
| curl -sSfL $url -o podman-desktop.tar.gz | |
| sudo rm -rf /opt/podman-desktop | |
| sudo mkdir -p /opt/podman-desktop | |
| sudo tar -xzf podman-desktop.tar.gz --strip-components=1 -C /opt/podman-desktop | |
| rm podman-desktop.tar.gz | |
| sudo chmod +x /opt/podman-desktop/podman-desktop | |
| sudo ln -sf /opt/podman-desktop/podman-desktop /usr/local/bin/podman-desktop |
OlderNewer