Bravo Basil! I've been looking at this all day and wondering myself. Now that I've said that.. And now for something terribly evil, is there an strace for cygwin?
On 11/18/2011 03:30 PM, Basil Daoust wrote: > 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 <f...@hotmail.com> 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/ >> >> >> >> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
