Sekuyiminyaka ngihlala ngiphatha imininingwane yami ye-MySQL ngokufaka isiphakeli se-MySQL futhi ngenza imiyalelo, okungukuthi:
mysql -u root -p
Futhi lapha ngibhala iphasiwedi futhi ngingenza engikufunayo, kepha ngithole nje: mysqladmin
Uhlobo nesimo se-MySQL?
Okokuqala, ake sihlole inguqulo ye-MySQL efakiwe:
mysqladmin -u root -p ping
Kulungile:
sudo service mysql status
Endabeni yami ngithola lokhu:
Noma kunjalo, bangayazi inguqulo ye-MySQL esebenza ne:
mysqladmin -u root -p version
/ Ungayisetha kanjani noma uyiguqule kanjani iphasiwedi ukuyifaka ku-MySQL?
Kuma-distros amaningi lapho kufakwa isiphakeli se-MySQL akuhlali kulungiselelwe nge-password eyimpande ngokuzenzakalela kwe-MySQL, ukusungula iphasiwedi yezimpande lapho ingenayo kulula njengoku:
mysqladmin -u root password PASSWORD-QUE-QUIERAN
Uma lokhu kungenjalo futhi banephasiwedi yempande kepha bafisa ukuyiguqula, i-syntax imi kanjena:
mysqladmin -u root -pPASSWORD-QUE-TIENEN password 'NUEVO-PASSWORD'
/ Ungayakha kanjani i-database ku-MySQL?
Kulula njengokusebenza:
mysqladmin -u root -p create NOMBRE-DE-DB
Ungasusa kanjani i-database ku-MySQL?
Ifana kakhulu nomyalo wangaphambilini:
mysqladmin -u root -p drop NOMBRE-DE-DB
Ungazi kanjani ukuthi yikuphi ukuxhumana okukhona kuseva ye-MySQL?
mysqladmin -u root -p status
Okwamanje ngibhala le ndatshana kwi-laptop yami ingikhombisa okulandelayo:
Isikhathi sokuphumula: Imicu engu-19381: Imibuzo eyi-1: 9518 Imibuzo engasheshi: 0 Ivula: 431 Amatafula agobhozayo: 1 Amatafula avulekile: Imibuzo eyi-106 ngomzuzwana ngamunye: 0.491
Ngokufanayo, uma ufuna ukwazi wonke amanani nezimo zokuguquguqukayo, vele ubeke:
mysqladmin -u root -p extended-status
Okukhiphayo kuzoba kukhulu kakhulu manje.
Noma uma lokhu kungakutsheli imininingwane oyidingayo, zama:
mysqladmin -u root -p variables
Uma kwenzeka ufuna ukulayisha kabusha amalungelo, okusho ukuthi, yenza umyalo ukuthi ube ngumyalo:
mysqladmin -u root -p reload;
mysqladmin -u root -p refresh
Yonke le miyalo isebenza nesiphakeli se-MySQL esiku-localhost, uma ufuna ukwenza imiyalo kuseva ekude kufanele ungeze:
-h IP-DE-SERVIDOR
Noma kunjalo, ngiyazi ukuthi abaningi bakhetha i-PHPMyAdmin kanti abanye bamane bakhetha ukuphela, lapha sinamathiphu wesiginali terminal
Uma ufuna ukwazi okwengeziwe nge-MySQLAdmin usuvele uyazi - » mysqladmin - usizo
Phendula ngokucaphuna
Yazisa kumhleli weposi ukuthi isithombe besingakwazi ukubukwa noma kunezinkinga ngezimvume zemikhombandlela yokubuka isithombe.
Ngiyayilungisa njengamanje, ngiyabonga 🙂
Namanje akukabonakali 😮
njengamanje ushintsho luyasetshenziswa
Kuze kube manje, angiboni lutho nhlobo. Into elula ukufaka isithombe ku-Imgur, bese usixhuma futhi kuphelele lapho.
Kulungisiwe manje, ngiyaxolisa ngokubambezeleka ... benginenkinga yokungena ku-inthanethi kulezi zinsuku.
Mmm .. Nami angisiboni isithombe, kubonakala sengathi "othile" ubeka iminwe yakhe lapho kungafanele khona 😀
Funda iMicrosoft Access, ungachithi isikhathi ngalokhu. Akekho oyisebenzisayo
JAAAAAAAAAAAAAAAAAAAAAAAJAJAJAJAJAJAJAJAJAJAJAJA… Microsoft Access? Ngokuzimisela? Usizi oluhle, ongakufunda ...
Nami ngisho into efanayo, yize i-MySQL ibonakala kulula kakhulu ukuyiphatha kune-Access ngokuya ngokusebenza kwayo (nokuningi uma ukwenza kusuka kukhonsoli).
Ngabe lokho Ukufinyelela akufani neze ne-MySQL. Ake sibone ukuthi ngubani ophatha i-DB yesayithi esebenzisa i-Access?
lokho ukuthi ama-acces awenzi umsebenzi ofanayo we-LOL!
EPeru, bayisebenzisa kakhulu ku-MyPES, noma kunjalo ukusetshenziswa kwangempela okunikezwa lolu hlelo kuncane, ngaphandle kokubheka ukuthi ibuthakathaka impela uma kuqhathaniswa ne-MySQL / MariaDB, PostgreSQL neqembu lezigelekeqe.
Ukufinyelela komngani akuyona i-DB ngaleyo ndlela, iseva ye-sql yebo, ukufinyelela kufana nokulingisa okuncane kwe-DB, iMysql uma kuyinjini yedatha, enezinto eziningi ezinama-DB aphathelene kulezi zinsuku, akukho lutho olunomona kwezinye izinjini ngu-DB.
Ubuwazi ukuthi abaphathi be-inthanethi bayayisekela imvelo ku-mysql? ama-cm amaningi afana ne-drupal, i-joomla, i-wordpress nakho konke okuphathelene nezinhlelo zokusebenza zewebhu ezimweni eziningi zisebenzisa i-mysql, lapho zikufundisa khona ngokuqinisekile ukuthi zenza okuthile okuyisisekelo yingakho zisebenzisa ukufinyelela, kepha kuyadingeka ukuthi ufunde futhi uthole ngezinjini noma abaphathi yolwazi.
URodolfo Yebo Uyazi Ngiyabonga
I-Acces akuyona i-DB acces uhlelo lokuphathelene lweGuindous
Impela, inkinga ibibangelwa ukuthi i-KZKGGaara ibidlala ne-BD ye-VPN futhi yenza isithombe singabonakali.
Endabeni yokungabi nalusizo kangangokuthi akukho nomyalo okusebenzele, kopisha lo myalo ku-terminal:
~ # sudo apt-get -y khipha -ipurge mysql
HAHAHAJAJAJAJAJAJAJAJAJAJAAAAAAAAAAAAAA !!!!!!
Angikholwa ukuthi baphonse ithawula ngokushesha okukhulu nge-MySQL.
Hola
ukufinyelela, kusetshenziswa yilabo abangakwazi ukuthenga lutho olungcono, futhi noma iyiphi inkampani enkulu isebenzisa i-mysql,
yeka ukuba yi-troll
Kungakho ePeru, ithembele kakhulu ku-Microsoft, isebenzisa imikhiqizo yayo ngokuphelele (kufaka phakathi i-Access ne-SQL Server).
Ngicabanga ukuthi umyalo obalulekile awukho: i-mysql -u root -p source db-name esetshenziselwa ukungenisa i-database. Ozithobayo.
Ngiyazi ukuthi selokhu ngafundiswa i-MySQL ngeWindows.
Kuze kube manje angikatholi ithuluzi elisha elikhulu lokusebenza ne-MySQL - iValentina Studio. Kungumagazini wamahhala ongawenza ngaphezu kwamathuluzi amaningi wokuthengisa!
Kunconywe kakhulu ukuyihlola. http://www.valentina-db.com/en/valentina-studio-overview
Ungayiphatha kanjani i-db mysql kuma-centos 6 ngeklayenti lewindows
Kulinganiselwe.
Ngingazi kanjani nge-console kuseva ye-linux, izinjini ezigciniwe ezifakiwe?
Ngiyabonga
I-Atte.
I-ML.
Sawubona,
Uma ucabanga ukuthi usebenzisa i-distro efana ne-Debian enomyalo wokufaneleka osuvele efakiwe, ungahlola kanjena:
aptitude search mysql | grep server
Lokhu kuzokutshela ukuthi ngabe iseva ye-MySQL ifakiwe noma cha
Ungazama okufanayo noPostgre.
Khumbula ukuthi uhlamvu lokuqala kwesobunxele luyinkomba. P kusho ukuthi ayifakiwe, ngisho ukuthi ifakiwe.
Bengiluthanda lolu lwazi, luyathandeka kakhulu 😉
Ngiyabonga ngakho konke…