• MySql Soodejinta Iyadoo loo marayo Rakibaadaha
  • Ku rakibida MySQL ee MacOS
• Sawirka MySQL Docker
• MySQL Enterprise Edition
  • Su'aalaha Inta badan la Isweydiiyo & Jawaabaha
• 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.

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.

+———————+

Tallaabo tallaabo ah hage si aad u soo dejiso MySQL ee Windows iyo macOS iyadoo la adeegsanayo habab kala duwan: >

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.

>

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. > >

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).

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

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.

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.

docker stop mysql-docker-demo

docker start mysql-docker-demo

MySQL Noocyada Lacag bixinta waxay la yimaadaan taageero farsamo iyo kaalmo kooxda MySQL iyo sidoo kale qalabyada kale ee la socodka sida Backup, Encryption, Firewall, iwm.

Su'aalaha Inta badan la Isweydiiyo & Jawaabaha

Q #1) MySQL xor ma u tahay in la soo dejiyo? >

Si aad u isticmaasho MySQL il furan ujeeddooyin ganacsi, waxaad awoodi kartaa isticmaal MariaDB oo ku salaysan xogta MySQL.

Q #2) Sidee loo rakibaa macmiilka MySQL? >

MAC - /usr/local/mysql/binWINDOWS - C:\\Program Files\\MySQL\\MySQL Server 8.0

Macaamilka MySQL waxaa lagu bilaabi karaa adigoo ordaya MySQL lagu fulin karo hagaha sare.

Q #3) Sideen sameeyaa soo deji MySQL loogu talagalay Windows?

Tixraac faahfaahinta soo dejinta halkan ee bogga soo dejinta MySQL ee rasmiga ah kor iyo rakibida daabacaadda MySQL Community Server ee Windows halkan casharkan.

Gunaanad

Waxaan rajeyneynaa in casharkan uu caddeeyay dhammaan weydiimahaaga soo dejinta MySQL. >