Türkce » WHM cPanel

Mysql serveri dis Ersime acmak

http://forum.whmdestek.com/

Go Back   WHM/cPanel Support Platform » Türkce » WHM cPanel
 

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 27. July 2007
Said Tuncbilek
Misafir
 
Posts: n/a
Mysql serveri dis Ersime acmak

mysql veri tabani serveri kurdunuz ve disaridan mysql front ve benzeri programler ile baglanamiyorsaniz sirasi ile asagidakileri yerine getirin

Linux icin ssh girdikten sonra : mysql -u root -p (sifreyi soracak alt satirda )
daha sonra connect mysql
update user set Host = '%' where User = 'root';
flush privileges;

ve artik mysql disardan erisebiliriz.

Windows icin c:\mysql dizini icin oldugunu varsayalim
Code:
cd c:\mysql\bin 
mysql.exe -u root -p sifre
daha sonra
Code:
connect mysql 
update user set Host = '%' where User = 'root'; 
flush privileges;
ve artik mysql`imiz disaridan erisilebilir konumda.

Dikkat edin bu riskli olabilir önemli verileriniz var ise

kaynak: enderunix
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2  
Old 27. July 2007
tespara's Avatar
Gamzede
 
Join Date: Jun 2007
Location: dersaadet
Posts: 67
Rep Power: 51
tespara has a reputation beyond reputetespara has a reputation beyond reputetespara has a reputation beyond reputetespara has a reputation beyond reputetespara has a reputation beyond reputetespara has a reputation beyond reputetespara has a reputation beyond reputetespara has a reputation beyond reputetespara has a reputation beyond reputetespara has a reputation beyond reputetespara has a reputation beyond repute
Send a message via MSN to tespara Send a message via Skype™ to tespara
Peki hangi porta yonlendirdin ?
__________________
cok kaygi cekme, mukadder olan olur, takdir olunan rizkin da sana gelir.[Hz Muhammed (S.A.V)]
siir vardir ki, hikmettir. Beyân vardir ki, büyüdür.[Hz Muhammed (S.A.V)]
Kim, bir zümreye benzemeye calisirsa, o, onlardandir.[Hz Muhammed (S.A.V)]
Hikmetin basi, Allah korkusudur.[Hz Muhammed (S.A.V)]
Elif Lam Mim. insanlar "inandik" deyip kurutlacaklarinimi sanirlar [Ankebut ,1]
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3  
Old 27. July 2007
Said Tuncbilek
Misafir
 
Posts: n/a
3306 SQL portuna.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #4  
Old 27. July 2007
tespara's Avatar
Gamzede
 
Join Date: Jun 2007
Location: dersaadet
Posts: 67
Rep Power: 51
tespara has a reputation beyond reputetespara has a reputation beyond reputetespara has a reputation beyond reputetespara has a reputation beyond reputetespara has a reputation beyond reputetespara has a reputation beyond reputetespara has a reputation beyond reputetespara has a reputation beyond reputetespara has a reputation beyond reputetespara has a reputation beyond reputetespara has a reputation beyond repute
Send a message via MSN to tespara Send a message via Skype™ to tespara
Quote:
Originally Posted by Said Tuncbilek View Post
3306 SQL portuna.
Onu sormadim (zaten o varsaylan deger)

peki Public IP den gelen istegi Host IP ye yönlendirecek komut belirtmedin bunu neden belirtmedigini sordum ?
__________________
cok kaygi cekme, mukadder olan olur, takdir olunan rizkin da sana gelir.[Hz Muhammed (S.A.V)]
siir vardir ki, hikmettir. Beyân vardir ki, büyüdür.[Hz Muhammed (S.A.V)]
Kim, bir zümreye benzemeye calisirsa, o, onlardandir.[Hz Muhammed (S.A.V)]
Hikmetin basi, Allah korkusudur.[Hz Muhammed (S.A.V)]
Elif Lam Mim. insanlar "inandik" deyip kurutlacaklarinimi sanirlar [Ankebut ,1]
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #5  
Old 27. July 2007
Said Tuncbilek
Misafir
 
Posts: n/a
Ama zaten bunun icin bir komut gerekmiyor ki. Bu zaten Mysql Front programi ile Mysql Server a uzaktan erisim islem yapmak icin. Yani yukaridakilerin hepsi ile bu islemi yapabilirsiniz.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #6  
Old 18. January 2008
Atari
 
Join Date: Jan 2008
Posts: 1
Rep Power: 0
stormist is on a distinguished road
Peki nasil kapatacaz

Arkadasim eline saglik güzel bir anlatim ama acilani kapatmak istedigimizde nasil bir yol izlemeliyiz

Tesekkurler
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #7  
Old 13. May 2008
Sempron
 
Join Date: Feb 2008
Posts: 35
Rep Power: 0
kskobi is on a distinguished road
update user set Host = '%' where User = 'root';
ERROR 1062 (23000): Duplicate entry '%-root' for key 1

bole bi hata verdi:S
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #8  
Old 26. March 2016
Atari
 
Join Date: Mar 2016
Posts: 1
Rep Power: 0
Clawyel is on a distinguished road
: mysql -u root -p
şifreyi de giriyorum
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
bu hatayı alıyorum ne yapmam gerekiyor acaba?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #9  
Old 26. March 2016
baracuda's Avatar
Administrator
 
Join Date: Jun 2008
Posts: 1,752
Rep Power: 100000
baracuda has a reputation beyond reputebaracuda has a reputation beyond reputebaracuda has a reputation beyond reputebaracuda has a reputation beyond reputebaracuda has a reputation beyond reputebaracuda has a reputation beyond reputebaracuda has a reputation beyond reputebaracuda has a reputation beyond reputebaracuda has a reputation beyond reputebaracuda has a reputation beyond reputebaracuda has a reputation beyond repute
mysql serverınızın çalıştığından eminmisiniz ?
komutunuz doğru mysql e root kullanıcısı ile bağlan ve şifre sor diyorsunuz.
mysql de size mysql servera bağlanamıyorum diyor dolayısıyla muhtemel olarak mysql serverınız şu anda çalışmıyor önce onu bulup çalışır hale getirmelisiniz.
__________________
Bir kisinin ki yardimcisi Allah ola, Var kiyas eyle ol ne sah ola!.

Ücretli Teknik Destek İçin özel mesaj atınız.

** Hp DL380/ G7 E5645 Six Core x2 Socket **
10 K Sas Diskli - Raid 50 Yapısıyla
Ücretsiz Haftalık Yedekli VDS serverlar
25 $ dan başlayan fiyatlarla, sunulmaktadır.

Talep için lütfen özel mesaj gönderin.
skype : semihavci@hotmail.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



Navigasyon
Menü