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]
