VPS nie dziala mysql

[XxErionxX]

Czesc kupilem sb vps'a za 4zl na Aruba i chce postawic na nim serwa do metka zrobilem z poradnika by Jachu

ale nie moge dostac sie do mysql pomoglby ktos ?

 

[Zeph]

Czesc kupilem sb vps'a za 4zl na Aruba i chce postawic na nim serwa do metka zrobilem z poradnika by Jachu

ale nie moge dostac sie do mysql pomoglby ktos ?

 

Zainstaluj to w ten sposób:

 

ntpdate pl.pool.ntp.org
portsnap fetch extract
pkg update
pkg upgrade
pkg install mysql55-server
ee /etc/rc.conf
mysql_enable="YES"
/usr/local/etc/rc.d/mysql-server start 
/usr/local/bin/mysqladmin -u root password
mysql -p
CREATE USER 'root'@'%' IDENTIFIED BY 'HASŁO' ;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION ;
CREATE USER 'mt2'@'localhost' IDENTIFIED BY 'mt2!@#' ;
GRANT ALL PRIVILEGES ON *.* TO 'mt2'@'localhost' WITH GRANT OPTION ;
flush privileges;
quit
/usr/local/etc/rc.d/mysql-server restart

[radeon252]

reinstall mysql

[XxErionxX]

@Zeph

 

Czesc kupilem sb vps'a za 4zl na Aruba i chce postawic na nim serwa do metka zrobilem z poradnika by Jachu

ale nie moge dostac sie do mysql pomoglby ktos ?

 

Zainstaluj to w ten sposób:

ntpdate pl.pool.ntp.org
portsnap fetch extract
pkg update
pkg upgrade
pkg install mysql55-server
ee /etc/rc.conf
mysql_enable="YES"
/usr/local/etc/rc.d/mysql-server start 
/usr/local/bin/mysqladmin -u root password
mysql -p
CREATE USER 'root'@'%' IDENTIFIED BY 'HASŁO' ;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION ;
CREATE USER 'mt2'@'localhost' IDENTIFIED BY 'mt2!@#' ;
GRANT ALL PRIVILEGES ON *.* TO 'mt2'@'localhost' WITH GRANT OPTION ;
flush privileges;
quit
/usr/local/etc/rc.d/mysql-server restart

 

przy wpisywaniu "/usr/local/bin/mysqladmin -u root password"

 

/usr/local/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!"

[Kaerad]

@Zeph

 

Czesc kupilem sb vps'a za 4zl na Aruba i chce postawic na nim serwa do metka zrobilem z poradnika by Jachu

ale nie moge dostac sie do mysql pomoglby ktos ?

 

Zainstaluj to w ten sposób:

ntpdate pl.pool.ntp.org
portsnap fetch extract
pkg update
pkg upgrade
pkg install mysql55-server
ee /etc/rc.conf
mysql_enable="YES"
/usr/local/etc/rc.d/mysql-server start 
/usr/local/bin/mysqladmin -u root password
mysql -p
CREATE USER 'root'@'%' IDENTIFIED BY 'HASŁO' ;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION ;
CREATE USER 'mt2'@'localhost' IDENTIFIED BY 'mt2!@#' ;
GRANT ALL PRIVILEGES ON *.* TO 'mt2'@'localhost' WITH GRANT OPTION ;
flush privileges;
quit
/usr/local/etc/rc.d/mysql-server restart

 

przy wpisywaniu "/usr/local/bin/mysqladmin -u root password"

 

/usr/local/bin/mysqladmin: connect to server at 'localhost' failed

error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'

Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!"

W tej linijce ustawiasz swoje hasło, nie pamiętam dobrze ale to chyba będzie jakoś tak:

/usr/local/bin/mysqladmin -u root password twojehaslo

[Gość Lajk™]

reinstall mysql

Pie*****ij się w ten pusty łeb.

w pliku .err napisane jest czemu się nie uruchamia, napisz do mnie na pw albo na gg: 49588480.