*Problemă/Întrebare: Nu ma pot conecta la navicat
Tipologie server: Pvm
*Resursă folosită:
*ServerFiles utilizat: MondialMt2 -stabil
*Syserr:
Poză:
*Detalii suplimentare: Am comandat un host, nu stiu daca am voie sa postez firma, mi-au dat prin ticket ip, user, parola, port. Toate bune, ma conectez la putty, la winscp, dau update la userul root la navicat, cand sa ma conectez imi spune "2003 - Can't connect to Mysql server on "ip" (10038)
Ce am incercat pana acum: Update user 'root'...
Create user 'user'@'ip-u meu'
Create user 'user'@'%'
Sunt incepator, mai ales cand vinde vorba de host. Pe VM imi mergea totu bine doar ca atunci cand cineva alegea caracterul primea kick. Hostul respectiv are o funcite VNC, nu stiu ce inseamna si nici nu pot sa o accesez, am nevoie de java applets si am tot incercat dar fara succes
Nu am de gand sa deschid mare server, vreau ceva pentru mine si prietenii mei.

Acceseaza mysql din consola cu mysql -u root -p si nu in ultimul rand poti instala phpmyadmin si ai rezolvat local, grafic si accesibil managementul bazelor de date.

Multumesc, nu stiam de optiunea asta, exista vreun tutorial cum as putea instala phpmyadmin? Din ce am gasit pe google am vazut ca am nevoie de php72 si ma blochez la instalare.

AiZzenGoD scrie: ↑15 Mar 2021, 21:45 Multumesc, nu stiam de optiunea asta, exista vreun tutorial cum as putea instala phpmyadmin? Din ce am gasit pe google am vazut ca am nevoie de php72 si ma blochez la instalare.

portsnap fetch update
cd /usr/ports/www/apache24/ && make install clean
sysrc apache24_enable=yes
cd /usr/ports/databases/php74-mysqli/ && make install clean
cd /usr/ports/www/mod_php74/ && make install clean
cd /usr/ports/converters/php74-mbstring/ && make install clean
cd /usr/ports/archivers/php74-zlib/ && make install clean
cd /usr/ports/ftp/php74-curl/ && make install clean
cd /usr/ports/graphics/php74-gd/ && make install clean
cd /usr/ports/devel/php74-json/ && make install clean
cd /usr/ports/converters/php74-iconv/ && make install clean
cd /usr/ports/security/php74-openssl/ && make install clean
cd /usr/ports/textproc/php74-xml/ && make install clean
cd /usr/ports/www/php74-session/ && make install clean

cp /usr/local/etc/php.ini-production /usr/local/etc/php.ini
ee /usr/local/etc/apache24/Includes/php.conf
Asta iei copy-paste:
<IfModule dir_module>
DirectoryIndex index.php index.html
<FilesMatch "\.php$">
SetHandler application/x-httpd-php
</FilesMatch>
<FilesMatch "\.phps$">
SetHandler application/x-httpd-php-source
</FilesMatch>
</IfModule>

service apache24 start

Si acum sa ne ocupam de phpmyadmin

cd /usr/local/www/apache24/data
fetch https://files.phpmyadmin.net/phpMyAdmin ... ges.tar.gz
tar -zxvf phpMyAdmin-5.1.0-all-languages.tar.gz && rm -rf phpMyAdmin-5.1.0-all-languages.tar.gz
mv -f phpMyAdmin-5.1.0-all-languages phpMyAdmin
cd /usr/local/www/apache24/data/phpMyAdmin
cp config.sample.inc.php config.inc.php
mkdir /usr/local/www/apache24/data/phpMyAdmin/tmp
chown -R www:www /usr/local/www/apache24/data/phpMyAdmin/tmp
ee /usr/local/www/apache24/data/phpMyAdmin/config.inc.php

Sa pui cel putin $cfg['blowfish_secret'], apoi te duci cu browserul la http://server-ip/phpmyadmin
De acolo dupa ce te autentifici cu userul root mysql (!!!!! root mysql nu sistem) iti faci contul pma cu baza de date phpmyadmin in care importi create_table.sql din dosarul sql din phpmyadmin.

Citeste cu atentie fiecare linie pana o intelegi apoi da comanda.
Ce nu stii intreaba punctual si la obiect cu subiect, predicat, atribut si complement in fiecare propozitie.
Am scris din cap, scuze daca nu e chiar un ghid copy-paste in intregime.


* fix
AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using 127.0.0.1.
Set the 'ServerName' directive globally to suppress this message
ee /usr/local/etc/apache24/httpd.conf
CTRL+Y
scrie ServerName
cobori la linia 288 si pui
ServerName localhost
service apache24 restart

Multumesc, puteti da T/C

Subiect inchis si mutat unde trebuie