# User add
mysql -e "CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';"

# User GET All Privileges
# ALL PRIVILEGES
# CREATE
# DROP
# DELETE
# INSERT
# SELECT
# UPDATE
# GRANT OPTION
mysql -e "GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';"

# Yetki kaldırma
mysql -e "REVOKE SELECT ON database_name.table_name FROM 'newuser'@'localhost';"

# Yetkileri görmek
mysql -e "SHOW GRANTS FOR 'newuser'@'localhost';"

# Yenileme reload
mysql -e "FLUSH PRIVILEGES;"

# User silmek
mysql -e "DROP USER 'newuser'@'localhost';"
Categories: Bash language

16 Comments

กายภาพ รามอินทรา · 02/09/2026 at 16:31

… [Trackback]

[…] Find More on to that Topic: durukanbal.com/2022/03/04/bash-mysql-user-add-and-permission/ […]

ร้านต่อผม · 08/09/2026 at 01:23

… [Trackback]

[…] Find More here to that Topic: durukanbal.com/2022/03/04/bash-mysql-user-add-and-permission/ […]

ข่าวเกม · 16/09/2026 at 00:48

… [Trackback]

[…] Find More on on that Topic: durukanbal.com/2022/03/04/bash-mysql-user-add-and-permission/ […]

emuay555 · 29/09/2026 at 06:52

… [Trackback]

[…] Info to that Topic: durukanbal.com/2022/03/04/bash-mysql-user-add-and-permission/ […]

รถเช่าหาดใหญ่ · 05/10/2026 at 15:17

… [Trackback]

[…] Read More here on that Topic: durukanbal.com/2022/03/04/bash-mysql-user-add-and-permission/ […]

https://dollycasinoprelievi.com · 09/10/2026 at 18:19

… [Trackback]

[…] Info to that Topic: durukanbal.com/2022/03/04/bash-mysql-user-add-and-permission/ […]

Tattoo Studio in Khaosan⁠ · 14/10/2026 at 23:01

… [Trackback]

[…] Info on that Topic: durukanbal.com/2022/03/04/bash-mysql-user-add-and-permission/ […]

สล็อตวอเลทเว็บตรงล่าสุด · 22/10/2026 at 22:15

… [Trackback]

[…] Info to that Topic: durukanbal.com/2022/03/04/bash-mysql-user-add-and-permission/ […]

รถเช่าดอนเมือง · 02/11/2026 at 09:41

… [Trackback]

[…] Info to that Topic: durukanbal.com/2022/03/04/bash-mysql-user-add-and-permission/ […]

Veneers Singapore · 03/11/2026 at 03:20

… [Trackback]

[…] There you will find 87644 additional Info to that Topic: durukanbal.com/2022/03/04/bash-mysql-user-add-and-permission/ […]

ปั้มคนดูไลฟ์ · 07/11/2026 at 08:54

… [Trackback]

[…] Here you will find 20677 additional Info to that Topic: durukanbal.com/2022/03/04/bash-mysql-user-add-and-permission/ […]

pet treats · 10/11/2026 at 07:41

… [Trackback]

[…] Find More here on that Topic: durukanbal.com/2022/03/04/bash-mysql-user-add-and-permission/ […]

ซื้อclaude พร้อมใบกำกับภาษี · 16/11/2026 at 09:51

… [Trackback]

[…] Find More Info here to that Topic: durukanbal.com/2022/03/04/bash-mysql-user-add-and-permission/ […]

china white heroin · 16/11/2026 at 16:27

… [Trackback]

[…] Info to that Topic: durukanbal.com/2022/03/04/bash-mysql-user-add-and-permission/ […]

ลวดสลิง · 20/11/2026 at 07:23

… [Trackback]

[…] Read More here to that Topic: durukanbal.com/2022/03/04/bash-mysql-user-add-and-permission/ […]

เบต้าออยล์ · 22/11/2026 at 02:19

… [Trackback]

[…] Find More Info here to that Topic: durukanbal.com/2022/03/04/bash-mysql-user-add-and-permission/ […]

Leave a Reply

Avatar placeholder