I can simulate the problem manually. I start the database with 

Code:
--------------------
    
  /usr/sbin/mysqld --defaults-file=/var/lib/squeezecenter/cache/my.cnf
  
--------------------

Then when I issue

Code:
--------------------
    
  mysql --port=9092 --host 127.0.0.1 
--socket=/var/lib/squeezecenter/cache/squeezecenter-mysql.sock
  
--------------------

the command displays

Code:
--------------------
    
  ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial 
communication packet', system error: 0
  
--------------------

and /var/log/auth.log has "mysqld[20748]: refused connect from
127.0.0.1", as before.

If I omit the --host option, I can connect successfully:

Code:
--------------------
    
  mysql --socket=/var/lib/squeezecenter/cache/squeezecenter-mysql.sock
  Welcome to the MySQL monitor.  Commands end with ; or \g.
  Your MySQL connection id is 2
  Server version: 5.0.45-Debian_1ubuntu3.3 Debian etch distribution
  
  Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
  
  mysql> show databases;
  +--------------------+
  | Database           |
  +--------------------+
  | information_schema |
  | mysql              |
  | slimserver         |
  +--------------------+
  3 rows in set (0.04 sec)
  
  mysql> use slimserver
  Database changed
  mysql> show tables;
  Empty set (0.00 sec)
  
  mysql>
  
--------------------


-- 
Graeme Hewson
------------------------------------------------------------------------
Graeme Hewson's Profile: http://forums.slimdevices.com/member.php?userid=17138
View this thread: http://forums.slimdevices.com/showthread.php?t=46851

_______________________________________________
unix mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/unix

Reply via email to