Re: Access Local CentOS Testing server from Windows 7 Machine

[Lloyd Codrington]

Mike,
The hostname does resolve ok as I use it for ftp and ssh access as it is easier to remember than using the numbers. I edited my host file in Windows and hard wired it there.

The rest of the message reads:
Connecting to MySQL server 192.168.1.20...
Host '192.168.1.5' is not allowed to connect to this MySQL server

bluesands resolves to 192.168.1.20 which is also hard wired into my Netgear Router so that it does not change if I switch things on in a different order. All my machines are given IP addresses in the router's LAN settings.

As you suggest I did try though using the IP address as you can see above but again it says my machine ending .1.5 is not allowed.

This is the current edit of my.cnf configuration file:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
safe-show-database
query_cache_limit=1M
query_cache_size=32M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=30
max_connections=500
interactive_timeout=10
wait_timeout=20
connect_timeout=20
thread_cache_size=128
key_buffer=32M ## 32MB for every 1GB of RAM
join_buffer=1M
max_connect_errors=20
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=1M ## 1MB for every 1GB of RAM
read_buffer_size=1M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=1M ## 1MB for every 1GB of RAM
myisam_sort_buffer_size=64M
port = 3306

collation_server=utf8_unicode_ci
character_set_server=utf8
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


Thanks for the suggestions.



Edited 1 time(s). Last edit at 02/03/2011 06:17AM by Lloyd Codrington.