Adminer - ﺕﺎﻧﺎﻴﺑ ﺪﻋﺍﻮﻗ ﺓﺭﺍﺩﺇ ﺓﺍﺩﺃ MySQL ﺕﺎﻔﺻﺍﻮﻤﻟﺍ ﺔﻠﻣﺎﻛ

.ﻪﻴﻠﻋ Adminer ﺖﻴﺒﺜﺗ ﻢﺘﻴﺳ ﻱﺬﻟﺍ ﻑﺪﻬﻟﺍ ﻡﺩﺎﺨﻟﺍ ﻰﻠﻋ ﻪﻠﻳﺰﻨﺗ ﻦﻜﻤﻳ ﺪﺣﺍﻭ PHP ﻒﻠﻣ ﻦﻣ ﻂﻘﻓ

.Elasticsearch ﺚﺤﺒﻟﺍ ﻙﺮﺤﻣ ﻰﻟﺇ ﺔﻓﺎﺿﻹﺎﺑ MS SQL ﻭ SQLite ﻭ Oracle ﻭ MySQL ﻭ Postg

.RHEL ﻰﻠﻋ ﺔﻤﺋﺎﻘﻟﺍ ﺕﺎﻌﻳﺯﻮﺘﻟﺍ ﻰﻠﻋ Adminer ﺖﻴﺒﺜﺗ ﻝﻼﺧ ﻙﺪﺷﺮﻨﺳ ، ﻞﻴﻟﺪﻟﺍ ﺍﺬﻫ ﻲﻓ

RHEL ﻲﻓ LAMP Stack ﺖﻴﺒﺜﺘﺑ ﻢﻗ :1 ﺓﻮﻄﺨﻟﺍ

.RHEL ﻰﻠﻋ ﺔﻤﺋﺎﻘﻟﺍ ﺕﺎﻌﻳﺯﻮﺘﻟﺍ ﻰﻠﻋ LAMP ﺔﻣﺰﺣ ﺖﻴﺒﺜﺗ ﺔﻴﻔﻴﻛ ﻝﻮﺣ ﻞﻣﺎﺷ ﻞﻴﻟﺩ ﻞﻌﻔﻟﺎﺑ ﺎﻨﻳ

.Adminer ﻊﻣ ﻞﻤﻌﻠﻟ ﺔﺑﻮﻠﻄﻤﻟﺍ ﺔﻴﻓﺎﺿﻹﺍ PHP ﺕﺎﻘﺤﻠﻣ ﺖﻴﺒﺜﺗﻭ ﻊﺑﺎﺗ ، ﺎﻬﻧﺎﻜﻣ ﻲﻓ

Linux ﻲﻓﺮﺸﻤﻟ MySQL/MariaDB GUI ﺕﺍﻭﺩﺃ ﻞﻀﻓﺃ ﻦﻣ 8

.ﺓﺄﺒﻌﻤﻟﺍ ﺞﻣﺍﺮﺒﻟﺍﻭ ﺔﻠﻴﻘﺜﻟﺍ ﻝﺎﻤﺣﻷﺍ ﺕﺍﺫ ﺝﺎﺘﻧﻹﺍ ﺔﻤﻈﻧﺃﻭ ﺔﺟﺮﺤﻟﺍ ﻡﺎﻬﻤﻠﻟ ﺺﺼﺨﻣ ﻡﺍﺪﺨﺘﺳﻻﺍ

.Linux ﺔﻤﻈﻧﻷ MySQL ﻲﻓ (GUI) ﺔﻴﻣﻮﺳﺮﻟﺍ ﻡﺪﺨﺘﺴﻤﻟﺍ ﺔﻬﺟﺍﻭ ﺕﺍﻭﺩﺃ ﻞﻀﻓﺄﺑ ﺔﻤﺋﺎﻗ ﻙﺭﺎﺸﻨﺳ ،

1. phpMyAdmin

.Mac OS X ﻭ Windows OS ﻭ Linux ﺔﻤﻈﻧﺃ ﻰﻠﻋ ﻞﻤﻌﻳ .ﻦﻳﺭﻮﻄﻤﻟﺍ ﻦﻴﺑﻭ ، ﺐﻳﻮﻟﺍ ﺔﻓﺎﻀﺘﺳﺍ ﺕ

.ﺪﻳﺰﻤﻟﺍﻭ ، PDF ﻭ ، XML ﻭ ، SQL ﻭ ، CSV ﻰﻟﺇ ﺕﺎﻧﺎﻴﺒﻟﺍ ﺮﻳﺪﺼﺗﻭ ، SQL ﻭ CSV ﻖﻴﺴﻨﺘﺑ

.ﻯﺮﺧﻷﺍ ﺕﺍﺰﻴﻤﻟﺍ ﻦﻣ ﺪﻳﺪﻌﻟﺍﻭ ، ﺎﻬﻨﻣ ﺔﻴﻋﺮﻓ ﺔﻋﻮﻤﺠﻣ ﻭﺃ ﺕﺎﻧﺎﻴﺑ ﺓﺪﻋﺎﻗ ﻲﻓ ﺎﻴًﻤﻟﺎﻋ ﺚﺤﺒﻟﺍﻭ

Fedora 36 Linux ﻲﻓ MySQL 8 ﺖﻴﺒﺜﺗ ﺔﻴﻔﻴﻛ

MySQL ﺖﻨﻠﻋﺃ ﻥﺃ ﺬﻨﻣ .ﺎﻴًﻣﻮﻳ ﻦﻴﻣﺪﺨﺘﺴﻤﻟﺍ ﻦﻴﻳﻼﻣ ﺎﻬﻣﺪﺨﺘﺴﻳﻭ ﺔﻗﻮﺛﻮﻣ ﻲﻫﻭ ، ﺔﻴﻗﻮﺛﻮﻣ ﺎﻫﺮﺜ

.ﻥﺎﻜﻣﻹﺍ ﺭﺪﻗ ﺔﻄﻴﺴﺑ ﻩﺬﻫ ﺖﻴﺒﺜﺘﻟﺍ ﺔﻴﻠﻤﻋ ﻞﻌﺟ ﻦﻣ ﻦﻜﻤﺘﻧ ﻰﺘﺣ ﺔﻴﺿﺍﺮﺘﻓﻻﺍ Fedora ﺕﺎﻋﺩﻮﺘﺴﻣ

.ﺎﻤﻬﻴﻠﻛ ﺲﻴﻟﻭ MariaDB ﻭﺃ MySQL ﺖﻴﺒﺜﺗ ﻂﻘﻓ ﻚﻴﻠﻋ ﺐﺠﻳ ، ﺐﺒﺴﻟﺍ ﺍﺬﻬﻟ .ﺾﻌﺒﻟﺍ ﺎﻬﻀﻌﺑ ﻊﻣ

Fedora Linux ﻲﻓ MySQL ﺖﻴﺒﺜﺗ

:ﺩﺪﺤﻤﻟﺍ dnf ﺮﻣﺄﺑ ﺕﺎﻋﺩﻮﺘﺴﻤﻟﺍ ﺚﻳﺪﺤﺘﺑ ﻡﻮﻘﻨﺳ .ﺔﻳﻮﻗ ﺔﺑﺮﺠﺗ (ﺕﺪﺟﻭ ﻥﺇ) ﺕﺎﺜﻳﺪﺤﺘﻟﺍ ﻖﻴﺒﻄﺗ

.ﻊﻤﺘﺠﻤﻟﺍ ﺭﺍﺪﺻﺇ ﻡﺪﺨﺘﺴﻨﺴﻓ ، MySQL ﻦﻣ ﺭﺍﺪﺻﺇ

ﺎﻬﺣﻼﺻﺇﻭ MySQL ﻲﻓ ﺔﻌﺋﺎﺸﻟﺍ ءﺎﻄﺧﻷﺍ ﻑﺎﺸﻜﺘﺳﻻ ﺓﺪﻴﻔﻣ ﺢﺋﺎﺼﻧ

MySQL ﺔﻴﻃﺎﺒﺗﺭﺍ ﺕﺎﻧﺎﻴﺑ ﺪﻋﺍﻮﻗ ﺓﺭﺍﺩﺇ ﻡﺎﻈﻧ ﻮﻫ (RDMS) ﺔﻛﺮﺸﻟ ﻙﻮﻠﻤﻣ ﻊﺳﺍ

.ﻯﺮﺧﻷﺍ ﺕﺎﻘﻴﺒﻄﺘﻟﺍ ﻦﻣ ﺪﻳﺪﻌﻟﺍﻭ YouTube ﻭ Wikipedia ﻭ Twitter ﻭ Face

.ﺎﻬﻠﺤﻟ ﻞﻌﻔﺗ ﺍﺫﺎﻣﻭ ﻞﻛﺎﺸﻤﻟﺍ ﺏﺎﺒﺳﺃ ﺪﻳﺪﺤﺗ ﺔﻴﻔﻴﻛ ﻒﺼﻧ ﻑﻮﺳ .ﺎﻬﺣﻼﺻﺇﻭ MyS

ﻲﻠﺤﻤﻟﺍ MySQL ﻡﺩﺎﺨﺑ ﻝﺎﺼﺗﻻﺍ ﻦﻜﻤﻳ ﻻ .1

.var/run/mysqld/mysqld.sock (2)/ ﺲﺒﻘﻤﻟﺍ ﻝﻼﺧ ﻦﻣ ﻲﻠﺤﻤﻟﺍ MySQL ﻡ

MySQL 8.0 ﻲﻓ ﺭﺬﺠﻟﺍ ﺭﻭﺮﻣ ﺔﻤﻠﻛ ﻦﻴﻴﻌﺗ ﺓﺩﺎﻋﺇ ﺔﻴﻔﻴﻛ

.ﺭﻭﺮﻤﻟﺍ ﺔﻤﻠﻛ ﻞﺠﺳ ﺚﻳﺪﺤﺗ ﻦﻣ ﻦﻜﻤﺘﻧ ﻰﺘﺣ ، MySQL ﺔﻗﺩﺎﺼﻣ ﺯﻭﺎﺠﺘﻟ ﺔﻘﻳﺮﻃ

.MySQL 8.0 ﺭﺍﺪﺻﺇ ﻲﻓ ﺎﻬﻨﻴﻴﻌﺗ ﺓﺩﺎﻋﺇ ﻭﺃ ﺭﺬﺠﻟﺍ ﺭﻭﺮﻣ ﺔﻤﻠﻛ ﺓﺩﺎﻌﺘﺳﺍ ﺔﻴﻠ

.ﺎﻤﻬﻴﻠﻛ ﻊﺟﺍﺮﻨﺳ .ﺭﺬﺠﻟﺍ MySQL ﺭﻭﺮﻣ ﺔﻤﻠﻛ ﻦﻴﻴﻌﺗ ﺓﺩﺎﻋﻹ ﻥﺎﺘﻘﻳﺮﻃ ﻙﺎﻨﻫ ،

init-file– ﻡﺍﺪﺨﺘﺳﺎﺑ MySQL ﺭﺬﺟ ﺭﻭﺮﻣ ﺔﻤﻠﻛ ﻦﻴﻴﻌﺗ ﺓﺩﺎﻋﺇ

.ﺢﺿﻮﻣ ﻮﻫ ﺎﻤﻛ --init-file ﺭﺎﻴﺧ ﻡﺍﺪﺨﺘﺳﺎﺑ MySQL ﺔﻣﺪﺧ

:ﻲﻠﻳ ﺎﻣ ﻖﺼﻟﺍ ﻒﻠﻤﻟﺍ ﺍﺬﻫ ﻞﺧﺍﺩ .mysql ﻡﺪﺨﺘﺴﻣ ﺔﻄﺳﺍﻮﺑ ﺓءﺍﺮﻘﻠﻟ ﻞﺑﺎﻗ ﻒﻠ

RHEL 8 ﻰﻠﻋ PHP ﻭ MySQL/MariaDB ﻭ Nginx ﺖﻴﺒﺜﺗ ﺔﻴﻔﻴﻛ

.ﻪﻣﺍﺪﺨﺘﺳﺍ ﺭﺎﺘﺨﺗ ﻱﺬﻟﺍ ﺩﺪﺤﻤﻟﺍ ﻚﻔﻗﻮﻣ ﻰﻠﻋ ﻚﻟﺫ ﺪﻤﺘﻌﻳﻭ ﻪﺗﺎﻴﺒﻠﺳﻭ ﻪﺗﺎﻴﺑﺎ

.RHEL 8 ﻡﺎﻈﻧ ﻰﻠﻋ PHP ﻭ MySQL/MariaDB ﻭ Nginx ﻭ LEMP stack - Li

.ﻚﺑ ﺹﺎﺨﻟﺍ RHEL ﻡﺎﻈﻧ ﻰﻟﺇ ﻝﻮﺻﻮﻟﺍ ﻖﺣ ﻚﻳﺪﻟ ﻥﺃﻭ RHEL 8 ﻲﻓ ﺎﻄًﺸﻧ ﺎﻛًﺍﺮﺘﺷ

Nginx Web Server ﺖﻴﺒﺜﺘﺑ ﻢﻗ :1 ﺓﻮﻄﺨﻟﺍ

.ﺔﺑﻮﻠﻄﻤﻟﺍ ﺕﺎﻴﻌﺒﺘﻟﺍ ﻊﻴﻤﺟ ﻊﻣ nginx ﺖﻴﺒﺜﺘﺑ ﻡﻮﻘﻴﺳ ﻱﺬﻟﺍﻭ ، ﻲﻟﺎﺘﻟﺍ ﺮﻣﻷ

ﺪﻳﺪﺟ ﻡﺩﺎﺧ ﻰﻟﺇ ﻢﻳﺪﻗ ﻡﺩﺎﺧ ﻦﻣ MySQL ﺕﺎﻧﺎﻴﺑ ﺪﻋﺍﻮﻗ ﻊﻴﻤﺟ ﻞﻘﻧ ﺔﻴﻔﻴﻛ

.ﺎﻬﻠﻘﻧ ﻲﻓ ﺐﻏﺮﺗ ﻲﺘﻟﺍ ﺕﺎﻧﺎﻴﺒﻟﺍ ﻢﺠﺣ ﻰﻠﻋ ﺍﺩًﺎﻤﺘﻋﺍ ﺖﻗﻮﻟﺍ ﺾﻌﺑ ﻕﺮﻐﺘﺴﻳ ﺪﻗ

.ﺕﺎﻧﺎﻴﺒﻟﺍ ﺩﻮﺟﻭ ﻦﻣ ﺪﻛﺄﺘﻟﺍﻭ ﺡﺎﺠﻨﺑ ﺎﻫﺩﺍﺮﻴﺘﺳﺍﻭ ، ﺪﻳﺪﺟ ﻡﺩﺎﺧ ﻰﻟﺇ ﻢﻳﺪﻘﻟ

ﻎﻳﺮﻔﺗ ﻒﻠﻣ ﻰﻟﺇ MySQL ﺕﺎﻧﺎﻴﺑ ﺪﻋﺍﻮﻗ ﺮﻳﺪﺼﺗ

.ﺢﺿﻮﻣ ﻮﻫ ﺎﻤﻛ systemctl ﺮﻣﻷﺍ ﻡﺍﺪﺨﺘﺳﺎﺑ mysql/mariadb ﺔﻣﺪﺧ ﻒﻗﻭﺃﻭ

# systemctl stop mariadb OR # systemctl stop mysql

.mysqldump ﺮﻣﻷﺍ ﻡﺍﺪﺨﺘﺳﺎﺑ ﺪﺣﺍﻭ ﻒﻠﻣ ﻲﻓ MySQL ﺕﺎﻧﺎﻴﺑ ﺪﻋﺍﻮﻗ ﻊﻴﻤﺟ ﻎﻳﺮ

# mysqldump -u [user] -p --all-databases > all_databases.sq
اقرأ أكثر →

Fedora 35 ﻭ RHEL/CentOS 8/7 ﻰﻠﻋ MySQL 8.0 ﺖﻴﺒﺜﺗ ﺔﻴﻔﻴﻛ

MySQL ﺔﻴﻃﺎﺒﺗﺭﻻﺍ ﺕﺎﻧﺎﻴﺒﻟﺍ ﺪﻋﺍﻮﻗ ﺓﺭﺍﺩﻹ ﺭﺪﺼﻤﻟﺍ ﺡﻮﺘﻔﻣ ﻲﻧﺎﺠﻣ ﻡﺎﻈﻧ ﻮﻫ

.YUM ﺓﺪﻋﺎﺴﻤﻟﺍ ﺓﺍﺩﻷﺍ ﺮﺒﻋ MySQL Yum ﻉﺩﻮﺘﺴﻣ ﻡﺍﺪﺨﺘﺳﺎﺑ Fedora ﻭ/RHE

MySQL Yum ﻉﺩﻮﺘﺴﻣ ﺔﻓﺎﺿﺇ :1 ﺓﻮﻄﺨﻟﺍ

.35-30 ﺍﺭﻭﺪﻴﻓﻭ/RHEL/CentOS 8/7/6 ـﻟ Connector/Python ﻭ ،

. MySQL Yum Repository ﻡﺍﺪﺨﺘﺳﺎﺑ ﺔﺘﺒﺜﻤﻟﺍ MySQL ﺔﻣﺰﺣ ﻝﺍﺪﺒﺘﺳﺍ ﻭﺃ ﺔ

.ﺔﻴﻃﺎﻴﺘﺣﻻﺍ MySQL ﺕﺎﻧﺎﻴﺑ ﺪﻋﺍﻮﻗ ﻞﻴﻟﺩ ﻡﺍﺪﺨﺘﺳﺎﺑ ﺔﻤﻬﻤﻟﺍ ﺕﺎﻧﺎﻴﺒﻟﺍ ﺓﺪﻋﺎ

.(2018 ﻮﻴﻟﻮﻳ 27 ﻲﻓ ﻩﺭﺍﺪﺻﺇ ﻢﺗ 8.0 ﻱﺃ) MySQL ﻦﻣ ﺭﺍﺪﺻﺇ ﺙﺪﺣﺃ ﺖﻴﺒﺜﺘﻟ

CentOS 7 ﻰﻠﻋ Netdata ﻡﺍﺪﺨﺘﺳﺎﺑ MySQL/MariaDB ﺕﺎﻧﺎﻴﺑ ﺪﻋﺍﻮﻗ ﺔﺒﻗﺍﺮ

Netdata ـﺑ ﺔﻬﻴﺒﺸﻟﺍ ﺔﻤﻈﻧﻸﻟ ﻲﻠﻌﻔﻟﺍ ﺖﻗﻮﻟﺍ ﻲﻓ ﺔﺤﺼﻟﺍ ﺔﺒﻗﺍﺮﻣﻭ ﻡﺎﻈﻨﻟﺍ ء

.RHEL 7 ﻭﺃ CentOS 7 ﻊﻳﺯﻮﺗ ﻰﻠﻋ Netdata ﻡﺍﺪﺨﺘﺳﺎﺑ MySQL/MariaDB ﺕ

.netdata ﺔﺒﻗﺍﺮﻣ ﺐﻳﻭ ﺔﻬﺟﺍﻭ ﻦﻣ MySQL/MariaDB ﺕﺎﻧﺎﻴﺑ ﺓﺪﻋﺎﻗ ﻡﺩﺎﺨﻟ

CentOS 7 ﻰﻠﻋ MariaDB Database Server ﺖﻴﺒﺜﺘﺑ ﻢﻗ :1 ﺓﻮﻄﺨﻟﺍ

.ﻚﻣﺎﻈﻧ ﻰﻟﺇ MariaDB YUM ﺞﻣﺍﺮﺑ ﻉﺩﻮﺘﺴﻣ ﺔﻓﺎﺿﺈﺑ ﻻًﻭﺃ ﺃﺪﺑﺍ .1

# vim /etc/yum.repos.d/MariaDB.repo

.ﻒﻠﻤﻟﺍ ﺍﺬﻫ ﻲﻓ ﺔﻴﻟﺎﺘﻟﺍ ﺮﻄﺳﻷﺍ ﻒﺿﺃ ﻥﻵﺍ

اقرأ أكثر →

18.04 ﻮﺘﻧﻮﺑﻭﺃ ﻲﻓ MySQL 8.0 ﺖﻴﺒﺜﺗ ﺔﻴﻔﻴﻛ

.ﻯﺮﺧﻷﺍ ﺕﺍﺰﻴﻤﻟﺍ ﻦﻣ ﺪﻳﺪﻌﻟﺍﻭ ، ﺔﻓﻭﺮﻌﻤﻟﺍ ﺕﺎﻐﻠﻟﺍ ﻦﻣ ﻱﺃ ﻡﺍﺪﺨﺘﺳﺎﺑ ﺕﺎﻘﻴﺒ

.ﺮﻴﺜﻜﻟﺍ ﻚﻟﺫ ﺮﻴﻏﻭ ﺮﻴﺒﻜﻟﺍ ﻢﺠﺤﻟﺍ ﺕﺍﺫ ﺕﺎﻘﻴﺒﻄﺘﻟﺍ/ﺐﻳﻮﻟﺍ ﻊﻗﺍﻮﻣ ﻢﻋﺪﻟ ﺱ

:ﻲﻠﻳ ﺎﻤﻟ ﺺﺨﻠﻣ ﻰﻠﻋ ﺓﺮﻈﻧ ﻲﻘﻠﻧ ﺎﻨﻋﺩ ، ﺔﻴﻠﻌﻔﻟﺍ ﺖﻴﺒﺜﺘﻟﺍ ﺕﺍﻮﻄﺧ ﻰﻟﺇ ﻞﻘﺘ

MySQL Apt Repository ﻒﺿﺃ :1 ﺓﻮﻄﺨﻟﺍ

.ﺮﻣﺍﻭﻷﺍ ﺮﻄﺳ ﻦﻣ wget ﺓﺍﺩﺃ ﻡﺍﺪﺨﺘﺳﺎﺑ ﻉﺩﻮﺘﺴﻤﻟﺍ ﺔﻣﺰﺣ ﻞﻳﺰﻨﺘﺑ ﺃﺪﺑﺍ ؛ ﻚﻣ

$ wget -c https://repo.mysql.com//mysql-apt-config_0.8.13-1_all.deb

.ﻲﻟﺎﺘﻟﺍ dpkg ﺮﻣﻷﺍ ﻡﺍﺪﺨﺘﺳﺎﺑ MySQL ﻉ

اقرأ أكثر →