Jump to content
ELFORUM - Forumul Electronistilor
Sign in to follow this  
IRINEL_DS

Instalare baza de date MySql pe FreeBSD

Recommended Posts

Salutare , m-am gandit sa fac o serie de tutorial de FreeBSD... Multumiri userului Skaarj.Instalare baza de date MySQL sub FreeBSD :A- Executam urmatorile comenzi :1- portsnap fetch extract (Aceasta comanda va instala si uploada porturile )2- cd /usr/ports/databases/mysql56-server ( Aceasta comanda ne duce in folderol MySQL cel cu instalarea)3- make install WITH_XCHARSET=all clean (Aceasta comanda va incepe proceul de instalare dupa care va sterge fisierele necesare instalari propriu-zise)4-Asteptam instalarea - In timpul instalarii o sa primiti niste ferestre albastre cu diferite optiuni,selectati cancel la toate , asta daca nu doriti acele optinui, recomand cancel deoarece aveam nevoie doar de Baza de date MySQL)B- Setami permisiuni de administrator folderului in care s-a instalat baza MySQL.1- chown -R mysql /var/db/mysql2-chgrp -R mysql /var/db/MySQLC- Editarea fisierului rc.conf 1- ee /etc/rc.conf ( aceasta comanda ne permine sa editam fisierul rc.conf)2-In fisierul rc.conf la sfarsit adaugam urmatoarea linie mysql_enable=''YES''3-Apasam Esc ,dupa butonu A de doua ori.4-Reboot la FreeBSD prin comanda rebootD- Setarea userului principal mysql ,cel cu care o sa facem conexiunea intre Navicat si FreeBSD 1 - mysql -u root2- GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' (root este userul FreeBSD )3- IDENTIFIED BY 'parola' WITH GRANT OPTION; ( aici in loc de 'parola' parola aleasa de dvs )4- FLUSH PRIVILEGES; ( Confirmam ca vrem sa dam privilegii userului root) Asta e tot . :)Sticky daca se poate, cine stie cand e nevoie de ea .:)

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.