Allow private networked server access to MySQL server

[Hobbyist_PHPer]

MySQL Version --> 5.0.76-standard

 

Hi everyone again... So I have this MySQL dedicated server and I found this best practices for MySQL online somewhere and I ran this thing inside after starting the MySQL service, that turned off a bunch of things and deleted a test database and other stuff like that... Well, one of the things that it did, that I liked, was make it so all connections to the MySQL database server had to be that of the localhost, I figured that I'd figure out later how to make an exception to my application front end server...

 

So that's where I am today... I need to make an allowance exception for my other server, to access my MySQL server...

 

Here's what I get when I try as it is right now...

Host '192.168.1.2' is not allowed to connect to this MySQL server

 

The MySQL database server is 192.168.1.3

[Hobbyist_PHPer]

I thought I found a solution... I opened /etc/my.cnf and edited it to this...

 

[mysqld]

user=mysql

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

bind-address=192.168.1.2

 

Now, I can't restart MySQL

 

The entire file looks like this...

[mysqld]

user=mysql

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

bind-address=192.168.1.2

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

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

"/etc/my.cnf" 21L, 571C

[fenway]

Huh?