i can't connect remote to my mysql server

[jdyke]

vladone wrote:
> 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.

you need to connect to mysql locally and ...
grant PRIVILEGES on database.table to user@'192.168.100.4' identifed by 'password'

the PRIVILEGES part can be SELECT,INSERT,UPDATE, etc or 'all'
database.table can be *.* or *.table etc

then FLUSH PRIVILEGES

there is a great section on access on the mysql.com site, i'd check that out for 
the myriad of toher options you can limit/allow with the GRANT/REVOKE statements
> 
> #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.

your config file is in the ps output above, in your case /var/db/mysql/my.cnf. 
if you want it elsewhere change that line in /usr/local/etc/rc.d/mysql-server.sh


> 
> _______________________________________________
> freebsd-questions at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to "freebsd-questions-unsubscribe at freebsd.org"
>