You ought to conect on localhost and create a new user with the specific ip in the Host field.
<[EMAIL PROTECTED]> escreveu na mensagem news:[EMAIL PROTECTED] > what I have to do to be able to access to mysql on my web server from > other computer? > e.g., I want to access to web server using MySQL Administrator? > I have root access to web server. > As far as I know, mysql server is set up by edfault to be acessed only > through "localhost" and I have to add permission to specific IP to be able > to access it. > > please, how? > > on google I found this: > > "If you CAN connect to the databse from the local host, but you get a > can't connect message from a remote host, > you meight want to check, if the "skip-networking" option in > /etc/mysql/my.conf is enabled. > > the access from a remote host is disabled by default using: > > bind-address = 127.0.0.1 > > If the the access from a remote host is needed you should comment this > line and also: > > skip-networking" > > first, I dont have /etc/mysql/my.conf file (mandrake 10.0) but have > /etc/my.cnf and there skip-networking is already commented. and there is > no line with bind-address? > > Found this too: > "To restrict the access to port 3306 you may use in /etc/hosts.deny: > > mysql: ALL > > and in /etc/hosts.allow: > > mysql: IP_ADDRESS_ALLOWED_1 IP_ADDRESS_ALLOWED_2" > > is this enough? > > thanks for any help. > > -afan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
