Minha interface (eth0) tem ip real!!!
2006/2/9, Rodrigo Carvalho <[EMAIL PROTECTED]>:
A sua interface tem ip real?!?? ou o ip 200.131.219.7 é do teu modem?!?!?
caso vc tenha um ip classe C que esteja ligado em um modem, algo tipo 192.168.1.2tente colocar ele no bind-address ... algo tipo
bind-address = 192.168.1.2veja o q q deu e depois nos retorne pra dizer se tah td ok...blz?[]'s
2006/2/9, andnovelli <[EMAIL PROTECTED]>:Olá Élder!
Dê um grant no usuario que voce quer acessar pelo ip do servidor
no prompt do mysql, digite:
#mysql> GRANT SELECT,INSERT,UPDATE ON [nomedobanco ou "*" pra todos os
bancos ] TO [EMAIL PROTECTED] IDENTIFIED BY "senha_entre_aspas"
ex: GRANT SELECT,INSERT,UPDATE ON mambo_db TO [EMAIL PROTECTED]
IDENTIFIED BY "123456"
Neste caso voce só vai ter como inserir selecionar e atualizar, provavelmente
o mambo deve precisar de mais privilegios, (ex: criar e dropar tabelas)
entao vc pode colocar ALL PRIVILEGES no lugar das opções SELECT,INSERT,UPDATE
espero ter ajudado!
[]'s
On Wednesday 08 February 2006 18:03, elderjmp wrote:
> Pessoal...
>
> Tow com o seguinte problema em meu servidor... instalei o debian 3.1 +
> mysql-4.1 + mambo (programa php p/ desenvolvimento de site... tipow
> phpnuke)...
>
> Bom... o mambo naw consegue acessar o mysql a naw ser pelo localhost...
>
> Andei dando uma olhada e vi algo relacionado ao parametro "bind-address =
> 127.0.0.1"... mas soh q eu jah tentei trocar pelo endereço do ip do
> servidor e deixar comentando... soh q continua naw acessando... alguém
> poderia me ajudar?
>
>
> #/etc/mysql/my.cnf
> #
> # The MySQL database server configuration file.
> #
> # You can copy this to one of:
> # - "/etc/mysql/my.cnf" to set global options,
> # - "/var/lib/mysql/my.cnf" to set server-specific options or
> # - "~/.my.cnf" to set user-specific options.
> #
> # One can use all long options that the program supports.
> # Run program with --help to get a list of available options and with
> # --print-defaults to see which it would actually understand and use.
> #
> # For explanations see
> # http://dev.mysql.com/doc/mysql/en/server-system-variables.html
>
> # This will be passed to all mysql clients
> # It has been reported that passwords should be enclosed with ticks/quotes
> # escpecially if they contain "#" chars...
> # Remember to edit /etc/mysql/debian.cnf when changing the socket location.
> [client]
> port = 3306
> socket = /var/run/mysqld/mysqld.sock
>
> # Here is entries for some specific programs
> # The following values assume you have at least 32M ram
>
> # This was formally known as [safe_mysqld]. Both versions are currently
> parsed.
> [mysqld_safe]
> socket = /var/run/mysqld/mysqld.sock
> nice = 0
>
> [mysqld]
> #
> # * Basic Settings
> #
> user = mysql
> pid-file = /var/run/mysqld/mysqld.pid
> socket = /var/run/mysqld/mysqld.sock
> port = 3306
> basedir = /usr
> datadir = /var/lib/mysql
> tmpdir = /tmp
> language = /usr/share/mysql/english
> skip-external-locking
> #
> # For compatibility to other Debian packages that still use
> # libmysqlclient10 and libmysqlclient12.
> old_passwords = 1
> #
> # Instead of skip-networking the default is now to listen only on
> # localhost which is more compatible and is not less secure.
> #bind-address = 127.0.0.1
> #bind-address = 200.131.219.7
> #
> # * Fine Tuning
> #
> key_buffer = 16M
> max_allowed_packet = 16M
> thread_stack = 128K
> #
> # * Query Cache Configuration
> #
> query_cache_limit = 1048576
> query_cache_size = 16777216
> query_cache_type = 1
> #
> # * Logging and Replication
> #
> # Both location gets rotated by the cronjob.
> # Be aware that this log type is a performance killer.
> #log = /var/log/mysql.log
> #log = /var/log/mysql/mysql.log
> #
> # Error logging goes to syslog. This is a Debian improvement :)
> #
> # Here you can see queries with especially long duration
> #log-slow-queries = /var/log/mysql/mysql-slow.log
> #
> # The following can be used as easy to replay backup logs or for
> replication.
> #server-id = 1
> log-bin = /var/log/mysql/mysql-bin.log
> # See /etc/mysql/debian- log-rotate.conf for the number of files kept.
> max_binlog_size = 104857600
> #binlog-do-db = include_database_name
> #binlog-ignore-db = include_database_name
> #
> # * BerkeleyDB
> #
> # According to an MySQL employee the use of BerkeleyDB is now discouraged
> # and support for it will probably cease in the next versions.
> skip-bdb
> #
> # * InnoDB
> #
> # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
> # Read the manual for more InnoDB related options. There are many!
> #
> # * Security Features
> #
> # Read the manual, too, if you want chroot!
> # chroot = /var/lib/mysql/
> #
> # If you want to enable SSL support (recommended) read the manual or my
> # HOWTO in /usr/share/doc/mysql-server/SSL-MINI-HOWTO.txt.gz
> # ssl-ca=/etc/mysql/cacert.pem
> # ssl-cert=/etc/mysql/server-cert.pem
> # ssl-key=/etc/mysql/server-key.pem
>
>
>
> [mysqldump]
> quick
> quote-names
> max_allowed_packet = 16M
>
> [mysql]
> #no-auto-rehash # faster start of mysql but no tab completition
>
> [isamchk]
> key_buffer = 16M
>
>
>
>
>
>
>
>
>
>
>
>
> --
> Élder José Marcelino de Paula - "Bisturi"
> ICQ - 304799257
> GoogleTalk - [EMAIL PROTECTED]
> MSN - [EMAIL PROTECTED]
>
> "A preguiça é a mãe de todos os vícios, e uma mãe é uma mãe e é preciso
> respeitá-la"
--
Andre Novelli
[EMAIL PROTECTED]
--
Grato!
Rodrigo C. Carvalho
========================================
= SO: Debian Sarge Iptables 1.3.1 SQUID 2.5 (STABLE 9) =
========================================
--
Élder José Marcelino de Paula - "Bisturi"
ICQ - 304799257
GoogleTalk - [EMAIL PROTECTED]
MSN - [EMAIL PROTECTED]
"A preguiça é a mãe de todos os vícios, e uma mãe é uma mãe e é preciso respeitá-la"
