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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
