i can't connect remote to my mysql server

jdyke jdyke at azimainc.com
Thu Aug 18 11:13:28 GMT 2005

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 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@'' identifed by 'password'

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


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
> 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"

More information about the freebsd-questions mailing list