Maitiro ekuisa MySQL paUbuntu

Isa MySQL ubuntu phpMyAdmin

Kune akati wandei dhatabhesi manejimendi masisitimu, asi mazhinji anosarudza Microsoft Access, senguva dzose, nekuti inobva kuMicrosoft uye chikamu chehofisi yayo suite. Vamwe vazhinji, sezvo kutonga dhatabhesi ibasa rinoitwa nevanhu vane ruzivo, vanoziva nezve yakavhurika sosi sarudzo iyo, kubva pane zvandakaona, isarudzo yemakambani mazhinji. Pano tiri kuzokudzidzisai kuisa mysql muUbuntu.

Kana isu tiri paWindows, kuisa MySQL ibasa riri nyore kana iwe uchiziva zvekuisa, sezvo paine mapakeji anosanganisira zvese. MuLinux hazvina kufanana, uye zvakatonyanya kuomarara nekuti zvakawanda zvinoitwa nemitsara yekuraira. Nhasi tichaedza kutsanangura nzira yekuisa MySQL muUbuntu, kunyangwe zvichigona kutaurwa kuti zvatichaisa zvichave. LAMPkureva Linux, Apache, MySQL uye PHP.

Usati watanga

MySQL chishandiso chisina graphical interface inoshanda kubva kune terminal nekuraira mutsara (CLI). Kuiswa kwayo kuri nyore, asi chete neMySQL taizofanira kuita mibvunzo yese kubva kune terminal. Kuti uvandudze ruzivo rwemushandisi, iwe unofanirwawo kuisa uye kugadzirisa phpMyAdmin. Izvi ndizvo zvinoomesa zvinhu zvishoma. Zvichienderana nemagadzirirwo ayo, tinogona kupinda phpMyAdmin kana kuti tichawana imwe yezvikanganiso zvakawanda zvarinogona kutiratidza.

Zvinoitawo zvakakosha kwandiri kutaura kuti izvo zvinotsanangurwa pano zvinoshanda panguva yekunyora chinyorwa ichi, uye yakaedzwa paUbuntu 22.10. Kuona sezvo pasina mapakeji kana chero chinhu chakakosha, inofanirwa kushanda mune yakapfuura uye yeramangwana shanduro, asi haina kuvimbiswa. Saka, kana iwe ukamhanyira mune chero tsikidzi, ini ndinokurudzira kudzokera kune zvawakaita kuti uwane chinyorwa ichi (kana iwe usina kuchiwana pasocial media): tsvaga chaiyo bug pa Google DuckDuckGo.

Maitiro ekuisa MySQL paUbuntu

Nezviri pamusoro zvakatsanangurwa, ngatiendei nematanho ekutevera kuisa LAMP pamwe nephpMyAdmin uye kuita kuti zvese zvishande muUbuntu.

  1. Kuti tive nechokwadi chekuti zvese zvasvika parizvino, tinogadziridza mapakeji ese, kungave kubva kuSoftware Update kana nemurairo sudo apt update && sudo apt upgrade.
  2. Sedanho rekusarudza, tinoenda kubrowser toisa "localhost", kuita shuwa yekubvisa iyo S kubva kuHTTPS kana ikadaro. Tichaona kukanganisa nekuti hapana server iri kuita basa rayo.

localhost isiri kushanda

  1. Isu tinoenda kune terminal uye tinoisa iyo A yeLAMP: Apache.
sudo apt kuisa apache2
  1. Seimwe nhanho yekusarudzika, iyo isina kukosha asi inoratidza kuti tiri kuita zvakanaka, tinodzokera kubrowser, toisa "localhost" uye simbisa kuti ikozvino chimwe chinhu chakafanana neichi chinotevera.

localhost working

  1. Tevere tinoisa MySQL, iyo M yeLAMP:
sudo apt install mysql-server
  1. Munhanho inotevera, kana tisina, tinoisa iyo P yeLAMP (PHP):
sudo apt kuisa php

Uye neizvi isu taizove nezvose zvinodiwa kushandisa MySQL muUbuntu. Kuvandudza ruzivo rwemushandisi, tinoenderera mberi.

Isa phpMyAdmin pa Ubuntu

  1. Mune terminal, tinonyora:
sudo apt kuisa phpmyadmin
  1. Ichauya nguva iyo ichatikumbira kuti server ishandise. Isu tinosarudza apache2 ine space bar, ipapo tebhu uye OK.

phpmyadmin server

  1. Ichatizivisa kuti inofanirwa kuve neiyo inoshanda dhatabhesi, uye kana isu tichida kuibata ne dbconfig-yakajairika. Isu tinobvuma hwindo rekutanga, iro risingapi mamwe sarudzo, uye tinoenda kune yechipiri, tinoti hongu uye tinoisa password ku phpMyAdmin (kaviri):

dbconfig-yakajairika

Seta phpMyAdmin password

  1. Isu tinodzokera kubrowser uye tinowedzera "phpmyadmin" kune "localhost", iyo ingave localhost/phpmyadmin.

phpMyAdmin login

  1. Isu tinoita imwe cheki: tinoisa iyo default mushandisi, iyo phpmyadmin, uye password yatakagadzira mudanho 10. Tichaona kuti inopinda, asi isu hatina ropafadzo.

phpMyAdmin pasina ropafadzo

  1. Isu tinovhara chikamu mu phpMyAdmin.

Bvisa

  1. Isu tinodzokera kune terminal, nyora sudo -i (kana sudo su) uye isa password yedu.
  2. Iye zvino tinonyora mysql -u mudzi -py tinoisa password ye phpMyAdmin (iyo kubva padanho regumi).

kupinda mysql

  1. Ya no queda nada. En el siguiente paso vamos a crear un usuario (1), cambiando 1234 por otra clave (que debe ir entre las comillas simples) y ubunlog por vuestro usuario, le damos privilegios (2) y los reiniciamos (se confirmará que ha ido bien con el mensaje «Query OK» tras cada intro):
create user 'ubunlog'@'%' identified by '1234';
grant all privileges on *.* to 'ubunlog'@'%' with grant option;
flush privileges;

Uye ndizvo zvose. Izvo zvinosara kudzokera kubrowser, zorodza iyo login/phpmyadmin peji uye simbisa kuti isu tinogona kupinda nemushandisi akagadzirwa, uye zvakare kuti isu tinokwanisa kubata dhatabhesi.

Tonga dhatabhesi mu phpMyAdmin paUbuntu

Kuviga dhatabhesi uye kushandura dingindira

Iye zvino zvatave kugona kubata dhatabhesi, isu tingada kuzviita isu pachedu. Pa peji guru tinowana "Theme" sarudzo, uye zvichienderana nehurongwa hwekushanda kwatine phpMyAdmin yakaiswa, 3 kana 4 sarudzo dzinogona kuonekwa. Kunyangwe pasina akawanda, kune dzimwe nzira mukati phpmyadmin.net/themes, uye, semuenzaniso, zvinotevera BooDark (Rima Bootstrap):

BhukuDark Theme

Iwo madingindira anofanirwa kuvhurwa uye woisa iyo folda mukati meiyo theme folda ichave mukati mephpmyadmin folda (muUbuntu inowanzoita /usr/share/phpmyadmin/themes).

Kune rimwe divi, kana iwe waona, iwe unenge waona kuti kuruboshwe kweBooDark skrini kune mashoma dhatabhesi pane ari skrini iri pamusoro. Ndizvo nokuti zvakavanzwa. Dzidziso yacho inoti ndizvo databases ane configuration mafaira uye kuti zvakakodzera kusabata chero chinhu ipapo, asi tinogona kuvanza, kuti zvinhu zvose zvicharamba zvichishanda sezvinenge zvichionekwa.

Kuti uzvivanze, uye nokudaro kushanda chete nedhatabhesi dzedu, tinogona kuzarura Mafaira, kuenda kune dzimwe nzvimbo, kupinda mudzi we hard drive yedu, hit the magnifying glass, tsvaga phpmyadmin, pinda faira uye uzarure config.inc file. .php. Pakupedzisira iwe unogona kuwedzera mutsara senge unotevera:

$cfg['Servers'][$i]['hide_db'] = '^mysql|sys|phpmyadmin|performance_schema|information_schema$';

Kubva pane zviri pamusoro, isu tiri kushandisa iyo sarudzo yekuvanza databases (hide_db) uye kuratidza kuti ndedzipi dzatisingade kuona. Tambo yacho inotanga uye inopera nemashoko ega ega; mukati maro, chiratidzo chekutanga chinofanira kuva "^" uye chekupedzisira "$"; uye mukati mune dhatabhesi rakapatsanurwa ne "|". Kana iwe ukaona chimwe chinhu chisinganzwisisike, kunyangwe usingafanire, unogona "kutaura" mutsara iwoyo nekuisa zvidimbu zviviri (//) pamberi payo kana kuisa pakati /*…*/.

Kugadzirisa dhatabhesi neLibreOffice Base

Sezvatakatsanangura pakutanga kwechinyorwa chino, chii chinonyanya kudiwa kushandisa MySQL muUbuntu chinoitwa mune dzinenge 7 nhanho. Kana isu tozokwanisa neiyo terminal, hapana chimwe chinodiwa. Ne phpMyAdmin tichazviita ne graphical interface, iyo inowanzo kuwanikwa mumasevhisi ekutambira, saka zvakakosha kuti tijairirwe pamberi pechimwe chinhu. Asi iwe unogona zvakare kubata dhatabhesi nemamwe software.

Semuenzaniso, sezvatine Access muMicrosoft 365, LibreOffice ane Base. Uye hongu, isu tinogona kubatana neMySQL dhatabhesi neBase, rudzi rwe. Kunyangwe ichokwadi kuti isu tinokwanisa kuwedzera matafura kune dhatabhesi, ichokwadi zvakare kuti haititenderi kugadzirisa matafura atakagadzira kubva phpMyAdmin, saka zvakakosha kuti kana tichizoshanda neBase, isu gadzira dhatabhesi neMySQL, ngatibatanei nayo uye tozogadzirisa matafura kubva kuBase. Kana zviri zve SQL mibvunzo, iyo chete yekuwana ruzivo inotenderwa; kana tichida kuita shanduko, tinofanira kuzviita kuburikidza neiyo graphical interface.

Kuti tiite izvi, kana tangoisa ese LAMP (Linux yatovepo, Apache, MySQL uye PHP), isu tinofanirwa kutevedzera aya matanho:

  1. Isu tinovhura LibreOffice Base. Ticharatidzwa muroyi.
  2. Muhwindo rekutanga, tinosarudza "Batanidza kune dhatabhesi iripo", donhedza menyu uye sarudza "MySQL / MariaDB".

Gadzira Dhatabhesi neLibreOffice Base

  1. Muhwindo rinotevera, tinosarudza "Batanidza zvakananga (kuburikidza neMariaDB C chinongedzo)" uye tinya inotevera:

Batanidza uchishandisa MariaDB

  1. Zvadaro, tinoisa zita re database uye server. Iyo dhatabhesi ichave iyo yatinoda kubatana nayo, uye sevha ndeye localhost.

Database data

  1. Mushure mekudzvanya pane inotevera, isu tinoisa zita rekushandisa uye, nebhokisi re "Inodiwa password" rakatariswa, isu tichadzvanya pakuyedza kubatana.

Edza kubatana

  1. Ichatibvunza iyo password (yeMySQL mushandisi), tinoiisa. Kana zvese zvikafamba zvakanaka, tichaona meseji inosimbisa kuti kubatana kwabudirira.
  2. Isu tinya pane inotevera uye isu tichaona yekupedzisira hwindo umo zvakakodzera kusiya zvinhu nekukasira uye nekudzvanya pa "Pedzisa".

Sevha dhatabhesi

Izvi zvinotitendera kuti tiwane dhatabhesi kubva kuLibreOffice Base, asi ini ndaingoishandisa chete kana chimwe chinhu chekuzvarwa chichidiwa uye chekutanga manejimendi. Zvakare kana ukasarudza kushanda nechimwe chinhu chinotaridzika zviri nani padesktop yako, seGTK muUbuntu kana Qt mune dzimwe nzvimbo dzakajeka.

Pakati pezvimwe zvingasarudzwa, imwe yevanofarira ndeye dbeaver, iyo ine yakavhurika sosi Nharaunda sarudzo, asi kushandisa imwe kana imwe inofanira kunge yatova nyaya yekuravira. Izvo uye izvo zvimwe mubasa ravanokukumbira kuti ufambe zvakanaka mu phpMyAdmin.

Uye iyi ndiyo nzira yaunokwanisa kuisa MySQL paUbuntu uye kugadzirisa dhatabhesi ine graphical interface kubva kuUbuntu.


Mhinduro, siya zvako

Siya yako yekutaura

Your kero e havazobvumirwi ichibudiswa. Raida minda anozivikanwa ne *

*

*

  1. Inotarisira iyo data: Miguel Ángel Gatón
  2. Chinangwa cheiyo data: Kudzora SPAM, manejimendi manejimendi.
  3. Legitimation: Kubvuma kwako
  4. Kutaurirana kwedata
  5. Dhata yekuchengetedza: Dhatabhesi inobatwa neOccentus Networks (EU)
  6. Kodzero: Panguva ipi neipi iwe unogona kudzora, kupora uye kudzima ruzivo rwako

  1.   Francisco Velasco akadaro

    Zvakanaka, ndanga ndichitsvaga ruzivo rwekuiswa kweMySQL kwemazuva uye iyi email yakasvika nenguva nematanho