List:General Discussion« Previous MessageNext Message »
From:Basil Daoust Date:November 18 2011 11:30pm
Subject:Re: Can't run MySQL under Cygwin : connect to server at 'localhost'
failed (only when using password)
View as plain text  
Maybe this is the wrong place to ask, but why would you want to do this?
Mysql has binaries for Windows, just use one of them?

On Fri, Nov 18, 2011 at 4:16 PM, Franck Houssen <fh_p@stripped> wrote:

>
> 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 -
> "dummy" belongs to the group "mysql" - and the password is "dummy")the root
> user doesn't exist in Cygwin (as far as I understand) : I can't use any
> "mysqlamdin -u root ..." as described in the on-line mysql doc
> 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
>
> Franck
>
> Here after is a detailed 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
>
> My configuration file my.cnf is (I tried to put the minimum things to make
> it work) : [client]password = dummyport  = 3306socket  =
> /tmp/mysql.sock[mysqld]port  = 3306socket  =  /tmp/mysql.sockdatadir  =
>  /usr/local/mysql/datatmpdir = /tmp/
>
>
>
>

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