[perfecT777]

Didelis dekui Veikia.

[digvm]

Susirask faile

/etc/my.cnf arba /etc/mysql/my.cnf

Elitutæ

bind-address = 127.0.0.1

Ir pakeisk á

bind-address = x.x.x.x (serverio IP)

2 þingsnis

service mysql restart

arba

/etc/init.d/mysql restart

3.

mysql -u root -p

Sukurti naujà MySQL duomenø bazæ*(jeigu reikia)

mysql> CREATE DATABASE LABAS_TAI_NAUJA_DB;

mysql> GRANT ALL ON LABAS_TAI_NAUJA_DB.* TO VARTOTOJAS@'xx.xxx.xxx.xx' IDENTIFIED BY 'SLAPTAÞODIS';

xx.xxx.xxx.xx - Tavo IP

mysql> update db set Host='xx.xxx.xxx.xx' where Db='LABAS_TAI_NAUJA_DB';

mysql> update user set Host='xx.xxx.xxx.xx' where user='VARTOTOJAS';

quit;

Galësi MySQL administruoti ið namø
Sëkmës :P

[vagiz]

pastebejimas tiems, kas nezino - default instaliacija root accountui turi tik host/localhost privilegija, todel prisijungti is kitur nepavyks. Reikes paredaguoti patiems kad prileistu is kitur

[Levasc]

Sveiki,

Negaliu prisijungti prie mysql duomenu bazes nei per navicat nei per lineage 2 web skriptus . Vienas tokiu error'u : Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 in /var/www/index.php on line 114
Lost connection to MySQL server at 'reading initial communication packet', system error: 111

Issiaiskinau su skriptai - teisiog rasyti reikia 127.0.0.1.

Sveiki

O kokia OS naudojate? MySQL jau buvo ádiegta, ar diegëte pats? Ar veikia phpMyAdmin ar komanda:
$ mysql -uroot -p

Ðiaip tai galite paieðkoti internete kà reiðkia: "Lost connection to MySQL server at 'reading initial communication packet', system error: 111"


Edit: Ai, panaðu, kad pavyko..

[perfecT777]

Sveiki,

Negaliu prisijungti prie mysql duomenu bazes nei per navicat nei per lineage 2 web skriptus . Vienas tokiu error'u : Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 in /var/www/index.php on line 114
Lost connection to MySQL server at 'reading initial communication packet', system error: 111

Issiaiskinau su skriptai - teisiog rasyti reikia 127.0.0.1.