Skip to content

Instantly share code, notes, and snippets.

@Hikingyo
Hikingyo / admin.sql
Last active April 14, 2024 06:42
create admin user with all privileges on mysql/mariadb
CREATE USER 'admin'@'localhost' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;
## remote connection - not secure
CREATE USER 'admin'@'%' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
# reset unity
dconf reset -f /org/compiz/ && setsid unity

Keybase proof

I hereby claim:

  • I am hikingyo on github.
  • I am hikingyo (https://keybase.io/hikingyo) on keybase.
  • I have a public key whose fingerprint is 8E64 F1C6 27CA A1E5 7EAD 4244 B0DD 1FAE 37CF 51C1

To claim this, I am signing this object: