LinuxQuestions.org
Latest LQ Deal: Latest LQ Deals
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Debian
User Name
Password
Debian This forum is for the discussion of Debian Linux.

Notices


Reply
  Search this Thread
Old 06-29-2008, 11:56 PM   #1
ajaxer
LQ Newbie
 
Registered: Jun 2008
Posts: 2

Rep: Reputation: 0
can access to mysql from remote,help!!!


can access to mysql from remote,help!!!


i do like this.

apt-get install mysql-server mysql-client

mysql -uroot -p

mysql>use mysql;
mysql>UPDATE user SET host='%' WHERE user='root';

and on other pc

mysql -h192.168.2 -uroot -proot


ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.1.2' (10061)
only accept the connect from localhost;
why?
thanks.
 
Old 06-30-2008, 03:17 AM   #2
j-ray
Senior Member
 
Registered: Jan 2002
Location: germany
Distribution: ubuntu, mint, suse
Posts: 1,577

Rep: Reputation: 141Reputation: 141
welcome, i think the default configuration for mysql is to use unix sockets that cant be accessed from a different ip. There are several options to allow from 1 different machine (bind-address) or from all in my.cnf (probably located in /etc/mysql or /usr/local/mysql). Take a look at that.

Last edited by j-ray; 06-30-2008 at 03:18 AM.
 
Old 06-30-2008, 03:52 AM   #3
ajaxer
LQ Newbie
 
Registered: Jun 2008
Posts: 2

Original Poster
Rep: Reputation: 0
thanks a lot !! it's works.
^_^
i'm from china glad to meet u.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mysql remote access dereko Linux - Server 10 04-22-2008 07:46 PM
remote mysql access in slackware? Shioni Linux - Networking 8 11-29-2006 05:58 PM
Remote MySQL access gauge73 Linux - Software 2 03-05-2006 08:24 AM
MySQL 4.1 remote access james.reid Linux - Software 0 01-03-2006 05:55 AM
can't get remote access to mysql server hughes28105 SUSE / openSUSE 6 09-17-2005 09:07 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Debian

All times are GMT -5. The time now is 07:44 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration