List:General Discussion« Previous MessageNext Message »
From:Franck Houssen Date:November 17 2011 2:02pm
Subject:Can't run MySQL under Cygwin : connect to server at 'localhost'
failed (only when using password)
View as plain text  




Hello mysql-list, 
I try to install MySQL under Cygwin : I can build (mysql-5.5.17 on windows 7 using
Cygwin), I can start and stop the server (only using mysqld.server - mysqladmin fails to
connect).
I can not connect to the server when I want to use a password (if I don't use any password
the connection to the server succeeds).
 
I need client AND server. I followed the on line mysql doc. Some comments about the
installation / running process that I would underline :I do NOT use --without-server
option in configure (I need the server)I use readline (ccmake configuration) and not
libedit : could this be a problem ?I used  mysql_install_db with --basedir, --datadir and
--skip-name-resolve optionsI use a user "dummy" (that belongs to the mysql group) : I can
not create the mysql user (Windows prevent me from creating a mysql user for a reason I
can't figure out : I stopped fighting with Windows. As mentionned in the on line doc,
MySQL should work with any user : "dummy" is my user and the password is "dummy")the root
user doesn't exist in Cygwin (as far as Iunderstand) : I can't use any "mysqlamdin -u root
..."  
When I use "mysql" or "mysqladmin" triggering a connection using a password, the
connection fails (but succeeds if no password is used). May be someone could find a clue
to solve this problem !... Could someone help me ?
 
Thanks
 
F.
 
Here after is a detailed description of the problem :  My configuration file my.cnf is (I
tried to put the minimum things to make it work) : [client]
password = dummyport  = 3306
socket  = /tmp/mysql.sock
[mysqld]
port  = 3306
socket  =  /tmp/mysql.sock
datadir  =  /usr/local/mysql/datatmpdir = /tmp/
Here is a command line description of the problem : $ mkgroup -l > /etc/group (update
groups Windows -> Cygwin)

 

$ mkpasswd -l > /etc/passwd (update passwords Windows -> Cygwin) $ more etc/group |
grep mysql (check OK)
mysql:S-1-5-21-4028741454-3406211479-1246761672-1004:1004:

$ more passwd | grep dummy (check OK)
dummy:unused:1000:513:dummy,U-dummy-PC\dummy,S-1-5-21-4028741454-3406211479-1246761672-1000:/home/dummy:/bin/bash

$ chgrp -R None /tmp (give read / write access to all users)

 

$ chgrp -R None /var (give read / write access to all users)

  

$ ll (check OK)

total 229

drwxrwxrwt+ 1 dummy None               0 Nov 14 11:57 tmp

drwxr-xr-x+ 1 dummy None               0 Aug 17 20:58 var

 

$ chgrp -R mysql /usr/local/mysql (give read / write access to users of mysql group)

 

$ chown -R dummy /usr/local/mysql (give read / write access to users of mysql group)

  

$ ps (check : no server)

      PID    PPID    PGID     WINPID  TTY  UID    STIME COMMAND

     3400       1    3400       3400  con 1000 11:10:39 /usr/bin/bash

     6756    3400    6756       5400  con 1000 12:14:46 /usr/bin/ps

 

$ ll /tmp (check : no mysql.sock)

total 12

drwxrwxrwt+ 1 dummy None              0 Nov 14 11:57 .

drwxr-xr-x+ 1 dummy Administrateurs   0 Nov  5 00:37 ..

drwxrwxrwt+ 1 dummy None              0 Nov  9 18:40 .X11-unix

drwxr-xr-x+ 1 dummy None              0 Aug 18 00:00 hsperfdata_dummy

-rw-r--r--  1 dummy None            316 Oct 26 09:13 xkb_4Di75h

-rw-r--r--  1 dummy None            316 Oct 27 00:08 xkb_4NrKCL

-rw-r--r--  1 dummy None            316 Oct 27 00:09 xkb_ThcsMy

-rw-r--r--  1 dummy None            316 Oct 27 00:10 xkb_shbOiY

 

$ mysqld --user=dummy & (launch server : OK)

111114 12:15:54 InnoDB: The InnoDB memory heap is disabled

111114 12:15:54 InnoDB: Mutexes and rw_locks use GCC atomic builtins

111114 12:15:54 InnoDB: Compressed tables use zlib 1.2.5

111114 12:15:54 InnoDB: Initializing buffer pool, size = 128.0M

111114 12:15:54 InnoDB: Completed initialization of buffer pool

111114 12:15:54 InnoDB: highest supported file format is Barracuda.

111114 12:15:54  InnoDB: Waiting for the background threads to start

111114 12:15:55 InnoDB: 1.1.8 started; log sequence number 1595675

111114 12:15:55 [Note] Event Scheduler: Loaded 0 events

111114 12:15:55 [Note] mysqld: ready for connections.

Version: '5.5.17'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution



$ ll /tmp (check: mysql.sock is created and can be accessed - read / write permissions)

total 13

drwxrwxrwt+ 1 dummy None              0 Nov 14 12:15 .

drwxr-xr-x+ 1 dummy Administrateurs   0 Nov  5 00:37 ..

srwxrwxrwx  1 dummy None              0 Nov 14 12:15 mysql.sock

 

$ ps (check: server launched OK) 

      PID    PPID    PGID     WINPID  TTY  UID    STIME COMMAND

     4720    3400    4720       6576  con 1000 12:15:53 /usr/local/mysql/bin/mysqld

 $ mysql -u dummy -p (when I hit "return" as a password => connection OK)
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
mysql> show tables;
ERROR 1046 (3D000): No database selected
mysql> quit
Bye
 
$ mysql -u dummy -p (when I type a real password : dummy, YES... or anything else)
ERROR 1045 (28000): Access denied for user 'dummy'@'localhost' (using password: YES) $
mysqladmin -u dummy version (try without password => KO)

mysqladmin: connect to server at 'localhost' failed

error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (4)'

Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!

 

$ mysqladmin -u dummy -p version (try with password => KO whatever password may be
typed : dummy, YES, ...)

Enter password:

mysqladmin: connect to server at 'localhost' failed

error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (4)'

Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!

 

$ ./usr/local/mysql/support-files/mysql.server stop (stop server with mysql.server is OK)

Shutting down MySQL11.1114 12:25:21 [Note] mysqld: Normal shutdown............ SUCCESS!

 

$ ps (check: server is stopped)

      PID    PPID    PGID     WINPID  TTY  UID    STIME COMMAND

     3400       1    3400       3400  con 1000 11:10:39 /usr/bin/bash

     7052    3400    7052       7072  con 1000 12:26:50 /usr/bin/ps

 

$ ll /tmp (check: mysql.sock is gone)

total 12

drwxrwxrwt+ 1 dummy None              0 Nov 14 13:13 .

drwxr-xr-x+ 1 dummy Administrateurs   0 Nov  5 00:37 ..

drwxrwxrwt+ 1 dummy None              0 Nov  9 18:40 .X11-unix

drwxr-xr-x+ 1 dummy None              0 Aug 18 00:00 hsperfdata_dummy

-rw-r--r--  1 dummy None            316 Oct 26 09:13 xkb_4Di75h

-rw-r--r--  1 dummy None            316 Oct 27 00:08 xkb_4NrKCL

-rw-r--r--  1 dummy None            316 Oct 27 00:09 xkb_ThcsMy

-rw-r--r--  1 dummy None            316 Oct 27 00:10 xkb_shbOiY




 		 	   		   		 	   		   		 	   		  
Thread
Can't run MySQL under Cygwin : connect to server at 'localhost'failed (only when using password)Franck Houssen17 Nov
  • Re: Can't run MySQL under Cygwin : connect to server at 'localhost'failed (only when using password)Reindl Harald17 Nov
  • Can't run MySQL under Cygwin : connect to server at 'localhost'failed (only when using password)Franck Houssen18 Nov
    • Re: Can't run MySQL under Cygwin : connect to server at 'localhost'failed (only when using password)Reindl Harald18 Nov
    • Re: Can't run MySQL under Cygwin : connect to server at 'localhost'failed (only when using password)Basil Daoust19 Nov
      • Re: Can't run MySQL under Cygwin : connect to server at 'localhost'failed (only when using password)Bruce Ferrell19 Nov