List:General Discussion« Previous MessageNext Message »
From:Rich Duzenbury Date:April 12 2006 9:43pm
Subject:MySql Error Number 1130
View as plain text  
Hi all,

I am setting up two additional instances of mysql on my mysql server,
which is running version 5.0.18-standard-log.

I've got the additional instances set up, and they are running.  I can
see that they are bound to the proper ports.  

I can connect to them locally like
mysql -p --port=3306
mysql -p --port=3307
mysql -p --port=3320

I have always been able to connect remotely from my workstation to the
base server on 3306.  

My problem is that I cannot connect remotely to either of the new
additional instances running on 3307 or 3320.  Anytime I attempt to do
so, I receive MySQL Error Number 1130, Host 'nnn.nnn.nnn.nnn' is not
allowed to connect to this MySQL server.  

I've been googling and reading manuals all day, and haven't made a dent.


User Table
*************************** 1. row ***************************
                 Host: %
                 User: root
             Password: (redacted)
          Select_priv: Y
          Insert_priv: Y
          Update_priv: Y
          Delete_priv: Y
          Create_priv: Y
            Drop_priv: Y
          Reload_priv: Y
        Shutdown_priv: Y
         Process_priv: Y
            File_priv: Y
           Grant_priv: Y
      References_priv: Y
           Index_priv: Y
           Alter_priv: Y
         Show_db_priv: Y
           Super_priv: Y
Create_tmp_table_priv: Y
     Lock_tables_priv: Y
         Execute_priv: Y
      Repl_slave_priv: Y
     Repl_client_priv: Y
             ssl_type:
           ssl_cipher:
          x509_issuer:
         x509_subject:
        max_questions: 0
          max_updates: 0
      max_connections: 0
*************************** 2. row ***************************
                 Host: localhost
                 User: root
             Password: (redacted)
          Select_priv: Y
          Insert_priv: Y
          Update_priv: Y
          Delete_priv: Y
          Create_priv: Y
            Drop_priv: Y
          Reload_priv: Y
        Shutdown_priv: Y
         Process_priv: Y
            File_priv: Y
           Grant_priv: Y
      References_priv: Y
           Index_priv: Y
           Alter_priv: Y
         Show_db_priv: Y
           Super_priv: Y
Create_tmp_table_priv: Y
     Lock_tables_priv: Y
         Execute_priv: Y
      Repl_slave_priv: Y
     Repl_client_priv: Y
             ssl_type:
           ssl_cipher:
          x509_issuer:
         x509_subject:
        max_questions: 0
          max_updates: 0
      max_connections: 0


db Table:
*************************** 1. row ***************************
                 Host: %
                   Db: mysql
                 User: root
          Select_priv: Y
          Insert_priv: Y
          Update_priv: Y
          Delete_priv: Y
          Create_priv: Y
            Drop_priv: Y
           Grant_priv: Y
      References_priv: Y
           Index_priv: Y
           Alter_priv: Y
Create_tmp_table_priv: Y
     Lock_tables_priv: Y

Host table is empty.

Here is one of the processes:
mysql     5972  5960  0 16:17 pts/0    00:00:00 /usr/sbin/mysqld
--no-defaults -
-port=3307 --socket=/srv/mysql/lx07/mysql.sock
--pid-file=/srv/mysql/lx07/lx09.p
id07 --datadir=/srv/mysql/lx07/data --log=/srv/mysql/lx07/mysql.log
--skip-locki
ng --key_buffer=256M --max_allowed_packet=16M --table_cache=256
--sort_buffer_si
ze=16M --read_buffer_size=8M --read_rnd_buffer_size=4M
--myisam_sort_buffer_size
=64M --thread_cache_size=8 --query_cache_size=16M --thread_concurrency=8
--tmpdi
r=/tmp/ --innodb_file_per_table --innodb_data_home_dir=/srv/mysql/lx07
--innodb_
data_file_path=ibdata1:100M:autoextend
--innodb_log_group_home_dir=/srv/mysql/lx
07/ --innodb_log_arch_dir=/srv/mysql/lx07/
--innodb_buffer_pool_size=128M --inno
db_additional_mem_pool_size=20M --innodb_log_file_size=32M
--innodb_log_buffer_s
ize=8M --innodb_flush_log_at_trx_commit=1 --innodb_lock_wait_timeout=50

I have made sure to flush privileges, and I've restarted the server
several times, to no avail.  I am running out of things to try, and
hoping someone can see my (what is most likely) obvious error.

Thank you.

Regards,
Rich
Thread
MySql Error Number 1130Rich Duzenbury12 Apr
  • Re: MySql Error Number 1130mysql13 Apr
RE: MySql Error Number 1130Rich Duzenbury13 Apr
  • Re: MySql Error Number 1130gerald_clark13 Apr
RE: MySql Error Number 1130Rich Duzenbury13 Apr
  • Re: MySql Error Number 1130Barry13 Apr
RE: MySql Error Number 1130Rich Duzenbury13 Apr
  • RE: MySql Error Number 1130Shawn Green13 Apr
RE: MySql Error Number 1130Rich Duzenbury13 Apr