MySQL from network [solved]

mezcal · 2006-01-31 13:40:28

Hi,
I have installed php and mysql. I can connect to mysql from localhost but I cant connect to mysql from network. I try to connect to ip.

#hosts.deny

ALL: ALL: DENY

#hosts.allow

sshd: ALL: ALLOW
mysqld: ALL : ALLOW

#rc.conf

eth0="dhcp"
DAEMONS=(syslog-ng network crond sshd httpd mysqld)

#hosts
127.0.0.1 localhost.localdomain localhost filip

I have commneted
skip-networking in the my.cnf.

if I write: netstat -al
I see port 3306 listening

I need connect to mysql from network.
Can anybody advice me whats wrong?

Filip

mezcal · 2006-01-31 13:48:46

my user in phpmyadmin

Host User Password Select_priv Insert_priv Update_priv Delete_priv Create_priv Drop_priv Reload_priv Shutdown_priv Process_priv File_priv Grant_priv References_priv Index_priv Alter_priv Show_db_priv Super_priv Create_tmp_table_priv Lock_tables_priv Execute_priv Repl_slave_priv Repl_client_priv Create_view_priv Show_view_priv Create_routine_priv Alter_routine_priv Create_user_priv ssl_type ssl_cipher x509_issuer x509_subject max_questions max_updates max_connections max_user_connections
% ddd password Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y [BLOB - 0 bajtů] [BLOB - 0 bajtů] [BLOB - 0 bajtů] 0 0 0 0

juergen · 2006-01-31 21:15:42

What kind of error message do you get if you connect from a remove host via

mysql -u test -p -h YOUR_IP YOUR_DB

mezcal · 2006-02-01 08:01:44

ERROR:
Client does not support authentication protocol requested
by server; consider upgrading MySQL client

I solved. I added to /etc/rc.d/mysqld

/usr/bin/mysqld_safe --old-passwords &>/dev/null &

http://dev.mysql.com/doc/refman/5.0/en/old-client.html

Thanks juergen

Arch Linux

#1 2006-01-31 13:40:28

MySQL from network [solved]

#2 2006-01-31 13:48:46

Re: MySQL from network [solved]

#3 2006-01-31 21:15:42

Re: MySQL from network [solved]

#4 2006-02-01 08:01:44

Re: MySQL from network [solved]

Board footer