- MySql Soodejinta Iyadoo loo marayo Rakibaadaha
- Sawirka MySQL Docker
- MySQL Enterprise Edition
- Gunaanad
[Entrypoint] GENERATED ROOT PASSWORD: *ovIDej0cNAr[apq0jWuf4KdOpI
#6) Hadda waxaan galeynaa qolofka mysql ee ku jira weelka Docker oo wata erayga sirta ah ee la sameeyay.
0 Fuul amarka hoose.>docker exec -it mysql-docker-demo mysql -u root -p
Marka lagu weydiiyo furaha sirta ah, geli midka Tallaabo #5 ee sare. Marka, la galo waxa aad gali doonta macmiilka MySQL ee ku jira weelka Docker.
Wakhtigan, haddii aad gasho amar sida SHOW DATABASES; ka dib waxay tuuraysaa qalad oo wayddiin lahayd inaad cusboonaysiiso/badasho erayga sirta ah ee caadiga ah.
mysql> SHOW DATABASES;ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
#7) Aynu hadda dib u dajinno erayga sirta ah anagoo adeegsanayna ALTER Command.
BEDEL USER 'root'@'localhost' OO lagu aqoonsaday 'password';
Halkan 'password' waa erayga sirta ah ee dhabta ah ee aad rabto inaad u dejiso isticmaalaha xididka. Waxaad u beddeli kartaa qiime kasta sida ku habboon oo la rabo.
> #8)Hadda waxaan isku dayi doonaa inaan socodsiino amar fudud si aan u ansixiyo rakibaaddayada. Waxaan maamuli lahayn amarka SHOW DATABASES; si aad u heshid tafaasiisha dhamaan xogaha la heli karo tuso xogta;+———————+
Tallaabo tallaabo ah hage si aad u soo dejiso MySQL ee Windows iyo macOS iyadoo la adeegsanayo habab kala duwan: >
ku bilow isticmaalkeeda dhowr daqiiqo gudahood.MySQL waxa loo soo dejisan karaa sidii rakibe keligiis ah oo loogu talagalay nidaamyada hawlgalka kala duwan, ama sida sawir / archive ah oo kan ugu fudud ayaa isticmaalaya docker ee MySQL haddii aad rabto inaad wax barato. oo sahamin MySQL.
Sidoo kale, fadlan ogow in MySQL ay diyaar u tahay bulsho ahaan (lacag-la'aan) iyo daabacaad ganacsi (lacag leh) si loo soo dejiyo.
>
> Ujeedooyinka la taaban karo intooda badan rakibaadda mySMySQLQL iyada oo loo marayo rakibaha iyo sawirka docker xalliyo inta badan kiisaska isticmaalka. Waxaan ku arki doonaa labadan hab ee Windows iyo Mac-based Operating Systems halkan.MySql Soodejinta Iyadoo loo marayo Rakibaadaha
MySQL waa diyaar si loo soo dejiyo sidii xirmo gooni ah oo loogu talagalay Windows iyo macOS labadaba.3
Aynu aragno tafaasiisha mid kasta oo kuwan ka mid ah. > >
Ku Rakibaadda MySQL On Windows > a) Shuruudaha: > Kahor intaadan bilaabin habka rakibaadda, fadlan ogow in MySQL Installer u baahan yahay .NET Framework 4.5.2 (Haddii aad haysato nooc ka da'weyn qaabka .NET, ka dibna cusboonaysii taas si aad u bilowdo habka rakibidda).b) Soo deji rakibaha bulshada MySQL ka isha halkan. (Nooca hadda ee MySQL marka tan la qorayocasharka waa 8.0.20. Haddii aad u baahan tahay inaad soo dejiso nooc gaar ah oo MySQL ah, markaa waxaad tixraaci kartaa rakibaha kala duwan oo ka dooro nooca aad rabto inaad ku rakibto).
32bit ama 64bit (waxaad tixraac kartaa isku xirka halkan si aad u ogaato nooca OS ee aad isticmaalayso).>>>)Kadib soo dejista rakibaha, fur rakibaha exe oo sii wad tilmaamaha. Fadlan ogow in aad u baahan doonto xidhiidh internet oo firfircoon maadaama rakibayuhu yahay qolof oo uu soo dejiyo alaabooyinka la doortay ee internetka marka la doorto inta lagu jiro habka rakibidda.Doorashada qaabeynta, waxaad dooran kartaa 'Developer Default' kaas oo xanaaneeya ku dhawaad dhammaan walxaha loo baahan yahay ee baahiyaha horumarka/tijaabinta , haddii aad dooratay inaad ku rakibto macmiilka MySQL (MySQL Workbench oo ah Community/free download), markaa waxaad ku xidhi kartaa tusaale ahaan server-kaaga, haddii kale waxaad ka hubin kartaa rakibaadda khadka taliska adoo fulinaya amarka hoose.
C:\> "C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql" test
Ku rakibida MySQL ee MacOS
>#1) Ku rakibida / soo dejinta MySQL ee macOS iyada oo loo marayo sawirka diskka (.dmg) ama rakibaha - ka soo deji faylka sawirka diskka daabacaadda bulshada halkan
>#sawirka diskka oo bilow habka rakibidda adoo raacaya tilmaamaha ku jira xirmada rakibidda. Raac shaashadaha hoose ee habka rakibida tallaabo-tallaabo.
#3) Marka rakibiddu dhammaato, si aad u daarto server-ka MySQL, waxaad furi kartaa dookhyada MySql oo daar server-ka MySQL haddii aan hore loo shidin.
Fur nidaamka dookhyada oo guji summada MySQL.
Qaybta dookhyada MySQL hadda way furmi doontaa oo waxaad arki kartaa heerka server-ka MySQL. Haddii aysan hore u socon, markaas waxaad ka shid kartaa server-ka halkaas.
#4) Hadda aynu eegno in rakibaaddayadu guulaysteen iyo in kale. adigoo ka hubinaya nooca khadka taliska. Fur furaha terminalka oo u gudub MySQL install directory kaas oo ah default
/usr/local/mysql/bin
Ku socodsii amarka hoose si aad u hubiso nooca.
./mysql -V
Haddii aad aragto wax soo saarka hoos, markaas macnaheedu waa in Ku rakibidaada waa lagu guuleystey.
./mysql Ver 8.0.20 for macos10.15 on x86_64 (MySQL Community Server - GPL)
#5) Si aad MySQL uga isticmaasho khadka taliska, waxaad sii wadan kartaa adeegsiga khadka taliska ama terminalka habka) ama soo deji codsiyada macmiilka MySQL sida MySQL Workbench si aad uga gasho GUI.
Aynu sahamno dhawr ikhtiyaar oo talis ah. Si aad u bilawdo qolofka MySQL, socodsii amarada hoose.
./mysql -u root -p
Hadda, waxaa lagugu soo jeedin doonaaerayga sirta ah (Waxaad u baahan tahay inaad geliso kan la geliyey inta lagu guda jiro rakibaadda – ka soo qaad inaad erayga sirta ah u dhigtay ‘password’), ka dib lambarka sirta ah isla markiiba geli erayga sirta ah. Marka xaqiijinta la guulaysto, isticmaaluhu waxa uu gali doonaa qolofka MySQL.
Aan isku dayno in aan socodsiino amar muunad si aan u aragno in qolofku si sax ah u shaqaynayo iyo in kale. Ku fuli amarka hoose ee qolofka MySQL.
SHOW DATABASES;
Waa inaad awood u leedahay inaad aragto wax soo saarka hoose ee amarka.
> 3>
Sawirka MySQL Docker
Ku rakibida MySQL iyada oo loo marayo sawirka docker sida weelka docker waa habka ugu fudud haddii aad rabto inaad barato MySQL oo aadan rabin inaad ku rakibto software/server buuxa nidaamkaaga.
Docker wuxuu kuu ogolaanayaa inaad si dhakhso leh Dami, shid oo dami weelasha ay ku jiraan software-ka loo baahan yahay kaas oo xaaladdan yahay server-ka MySQL.
Aan aragno tillaabooyinka loo baahan doono in lagu rakibo MySQL sida sawirka Docker.
#1) Si loo isticmaalo sawirka Docker, waxaad u baahan doontaa inaad ku rakibto Docker ku salaysan OS-kaaga. Si loo rakibo Docker, raac tilmaamaha halkan
>> #2) Marka mishiinka Docker la rakibo, waxaan u baahan doonaa inaan soo dejino (ama jiidno) sawirka Docker xudunta Docker. Aynu aragno amarka loo isticmaali karo in lagu jiido sawirka Docker ee daabacaadda server-ka beesha.Ku fuli amarka hoose ee terminalka ama amarka degdega ah.
docker pull mysql/mysql-server:tag
Halkan, sumaddawaxay matalaysaa nooca MySQL Server-ka daabacaadda ee aad rabto inaad soo dejiso. Haddii aadan raadin nooc gaar ah, markaa waxaad si fudud uga tagi kartaa tafatirka taaga oo socodsii amarka hoose (Tani waxay soo qaadan doontaa sawirka daabacaadda ugu dambeysay ee la heli karo ee Daabacaadda Bulshada MySQL).
docker pull mysql/mysql-server
>23>
#3) Marka sawirka Docker la soo dejiyo, waxaan isku dayi karnaa inaan taxno sawirada, oo aragno haddii aan ka heli karno sawirka MySQL liiska soo muuqda. Ku socodsii amarka hoose ee terminal (oo loogu talagalay nidaamyada ku saleysan Linux).
docker image ls | grep "mysql-server"
Haddii aad aragto wax soo saarka sida hoose, markaa taasi waxay la macno tahay in sawirkaaga Docker si guul leh loo soo dejiyey.
> #4)Hadda aynu weel ka dhigno sawirka Docker-ka ee aan hadda soo dejinay. Waxaan weelka u magacaabi lahayn ''mysql-docker-demo''. Ku orod amarka hoose si aad weelka uga bilowdid sawirka.
docker run --name="mysql-docker-demo" -d mysql/mysql-server
#5) Hadda, si aad u hesho erayga sirta ah ee la dejiyay inta lagu jiro weelka Docker, waxaan faahfaahinta ka soo qaadan karnaa Docker logs ka dibna dib u bilow erayga sirta ah adoo isticmaalaya amarka ALTER.
Ku fuli amarka soo socda ee terminalka:
docker logs mysql-docker-demo 2>&1 | grep GENERATED
Fadlan ogow in 'mysql-docker -demo' ee amarka sare waa magaca weelka docker. Haddii aad si kale u magacawday weelka waxaad u baahan doontaa inaad ku bedesho magaca weelka.
> Haddii weelka Docker-ka si sax ah loo bilaabo, markaaKu socodsiinta amarrada MySQL-si la mid ah sida loo rakibo mishiinka maxalliga ah.Waxa kale oo aad bilaabi kartaa/joojin kartaa weelka Docker marka loo baahdo iyo marka loo baahdo.
Si Jooji weelka MySQL, waxaad isticmaali kartaa amarka hoose.
docker stop mysql-docker-demo
Si aad u bilowdo weelka Docker dib, waxaad isticmaali kartaa amarka hoose. >
docker start mysql-docker-demo
MySQL Enterprise Edition
MySQL waa xog-ururin furan oo si weyn loo isticmaalo.
Daabacaadda Enterprise waxaa iska leh Oracle waxaana ku jira qalabyo iyo astaamo la socda nooca lacag bixinta oo keliya (Nooca xorta ah waa daabacaadda bulshada MySQL).
MySQL Enterprise Edition waxa laga heli karaa Oracle Cloud si ay u noqoto adeeg si buuxda loo maareeyay.
Hoos:
>daabacaadda | > 27> Diiwaangelinta Sannadlaha ah (USD)|
---|---|
Daabacaadda Heerka MySQL | 2000 - 4000 |
MySQL Enterprise Edition | 5000 - 10000 | 29>> Macluumaad dheeraad ah.