# 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/ […]