LinuxQuestions.org
LinuxAnswers - the LQ Linux tutorial section.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Ubuntu
User Name
Password
Ubuntu This forum is for the discussion of Ubuntu Linux.

Notices

Reply
 
Search this Thread
Old 05-20-2008, 03:11 PM   #1
jedimastermopar
Member
 
Registered: Jun 2004
Distribution: fedora core 1 and core 2
Posts: 178

Rep: Reputation: 30
Unable to connect to MySQL remotly ubuntu 8.04


Well I just installed ubuntu 8.04 and I commented out the bind address line and I still can't connect remotly to the MySQL server.

Here is my.cnf

Code:
root@intranet:/etc/mysql# cat my.cnf
[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock

[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0

[mysqld]
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
language        = /usr/share/mysql/english
#skip-external-locking
#bind-address           = 192.168.0.203
key_buffer              = 16M
max_allowed_packet      = 16M
thread_stack            = 128K
thread_cache_size       = 8
query_cache_limit       = 1M
query_cache_size        = 16M
expire_logs_days        = 10
max_binlog_size         = 100M
skip-bdb

[mysqldump]
quick
quote-names
max_allowed_packet      = 16M

[isamchk]
root@intranet:/etc/mysql# netstat -tap
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 *:mysql                 *:*                     LISTEN      5266/mysqld
tcp        0      0 *:www                   *:*                     LISTEN      4423/apache2
tcp6       0      0 [::]:ssh                [::]:*                  LISTEN      4216/sshd
tcp6       0      0 192.168.0.203%13464:ssh 192.168.0.213%819:53055 ESTABLISHED 5952/0
root@intranet:/etc/mysql#

I get Host '192.168.0.213' is not allowed to connect to the MySQL Server

when I try and login with MySQL Administrator from a winblows box.


Is there another thing to do differently on ubuntu8.04 that I am missing?
 
Old 05-20-2008, 11:31 PM   #2
dkm999
Member
 
Registered: Nov 2006
Location: Seattle, WA
Distribution: Fedora
Posts: 407

Rep: Reputation: 35
Are you sure that you cannot even connect to mysqld? This message might merely mean that you have not set up a GRANT for any remote user. I think mysqld comes stock with only some localhost users defined in the grant tables.
 
Old 05-21-2008, 06:58 AM   #3
jedimastermopar
Member
 
Registered: Jun 2004
Distribution: fedora core 1 and core 2
Posts: 178

Original Poster
Rep: Reputation: 30
Ahh yes my bad. I jumped the gun. Thanks
 
  


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
vpopmail - mysql unable to connect euphoriaburn Debian 3 04-01-2011 04:37 AM
unable to connect to mysql djib Linux - Software 7 03-08-2007 09:03 PM
i cannot connect mysql remotly psuresh Linux - Networking 2 04-15-2006 09:34 AM
mysql 4.0.20 CLIENT unable to connect. fritz001 Linux - Networking 5 12-23-2004 05:48 AM
Not able to remotly connect using SSH or Samba Danielallan Slackware 2 12-07-2003 02:55 PM


All times are GMT -5. The time now is 01:49 AM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration