i can't connect remote to my mysql server
vladone
vladone at spaingsm.com
Thu Aug 18 10:52:44 GMT 2005
I have instaled mysql server succcesfull and started. I set root
password, i can login to my server from console but i can't login
remote (i use Mysql Control Center for win, for quickly management).
I receive this error: "host 192.168.100.4 is not allowed to connect to
this Mysql server"
I dont know why, server is up and running.
#ps aux|grep mysql
mysql 11706 0.0 0.4 1660 1060 p0 I 1:37PM 0:00.01 /bin/sh /usr/local/bin/mysqld_safe --defaults-extra-file=/var/db/mysql/my.cnf --user=mysql --da
mysql 11726 0.0 9.7 57136 25064 p0 S 1:37PM 0:00.81 /usr/local/libexec/mysqld --defaults-extra-file=/var/db/mysql/my.cnf --basedir=/usr/local --dat
#sockstat -4
USER COMMAND PID FD PROTO LOCAL ADDRESS FOREIGN ADDRESS
mysql mysqld 11726 3 tcp4 *:3306 *:*
Another question is about config files. I dont know where is config
file for mysql on freebsd. In linux exist mysql.cnf but here ... i
dont see anything.
More information about the freebsd-questions
mailing list