Date: Thu, 18 Aug 2005 11:12:17 +0000 From: jdyke <jdyke@azimainc.com> To: vladone <vladone@spaingsm.com> Cc: freebsd-questions@freebsd.org Subject: Re: i can't connect remote to my mysql server Message-ID: <43046D11.1010104@azimainc.com> In-Reply-To: <571953085.20050818135236@spaingsm.com> References: <571953085.20050818135236@spaingsm.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org" >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?43046D11.1010104>