[Tutorial] Instalare MySQL (baza de date)

Tastam in SSH:

Code:

---

pkg install mysql55-server

---

La confirmarea cu Y/N apasam y si dam enter. Dupa ce s-a procesat complet pachetul, vom intra in /etc/rc.conf cum facem asta?

Code:

---

ee /etc/rc.conf

---

Mergem la sfarsitul fisierului si adaugam

Code:

---

mysql_enable="YES"

---

Apasam tasta "ESC" selectam "LEAVE Editor" si dam "Save Changes";

Acum tastam urmatoarea comanda:

Code:

---

service mysql-server onestart

---

Acordarea de privilegii userilor MySQL. Asteptam sa se creeze baza de date standard de test si trecem la treaba. Am instalat baza de date, acum ce facem? Hai sa oferim privilegii de conectare.

Scriem in SSH:

Code:

---

mysql;

---

Dupa, incepem cu alocarea de privilegii. Daca vreti sa-l faceti pe ip, va folositi de urmatorul query.

Code:

---

GRANT ALL PRIVILEGES ON *.* TO 'user'@'ip' identified by 'paroladumneavoastra' with grant option;

---

Acum va trebui doar sa restartam serviciul de mysql.

Code:

---

service mysql-server restart

---