Can't run MySQL under Cygwin : connect to server at 'localhost' failed (only when using password)
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) PIDPPIDPGID WINPID TTY UIDSTIME COMMAND 3400 13400 3400 con 1000 11:10:39 /usr/bin/bash 675634006756 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 None316 Oct 26 09:13 xkb_4Di75h -rw-r--r-- 1 dummy None316 Oct 27 00:08 xkb_4NrKCL -rw-r--r-- 1 dummy None316 Oct 27 00:09 xkb_ThcsMy -rw-r--r-- 1 dummy None316 Oct 27 00:10 xkb_shbOiY $ mysqld --user=dummy (launch server : OK) 14 12:15:54 InnoDB: The InnoDB memory heap is disabled 14 12:15:54 InnoDB: Mutexes and rw_locks use GCC atomic builtins 14 12:15:54 InnoDB: Compressed tables use zlib 1.2.5 14 12:15:54 InnoDB: Initializing buffer pool, size = 128.0M 14 12:15:54 InnoDB: Completed initialization of buffer pool 14 12:15:54 InnoDB: highest supported file format is Barracuda. 14 12:15:54 InnoDB: Waiting for the background threads to start 14 12:15:55 InnoDB: 1.1.8 started; log sequence number 1595675 14 12:15:55 [Note] Event Scheduler: Loaded 0 events 14 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) PIDPPIDPGID WINPID TTY UIDSTIME COMMAND 472034004720 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
Re: Can't run MySQL under Cygwin : connect to server at 'localhost' failed (only when using password)
Am 18.11.2011 23:16, schrieb Franck Houssen: $ 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) and if you submit the same post every day you will get the same anser as some days before - try to understand how mysql-privileges are working signature.asc Description: OpenPGP digital signature
Re: Can't run MySQL under Cygwin : connect to server at 'localhost' failed (only when using password)
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) PIDPPIDPGID WINPID TTY UIDSTIME COMMAND 3400 13400 3400 con 1000 11:10:39 /usr/bin/bash 675634006756 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 None316 Oct 26 09:13 xkb_4Di75h -rw-r--r-- 1 dummy None316 Oct 27 00:08 xkb_4NrKCL -rw-r--r-- 1 dummy None316 Oct 27 00:09 xkb_ThcsMy -rw-r--r-- 1 dummy None316 Oct 27 00:10 xkb_shbOiY $ mysqld --user=dummy (launch server : OK) 14 12:15:54 InnoDB: The InnoDB memory heap is disabled 14 12:15:54 InnoDB: Mutexes and rw_locks use GCC atomic builtins 14 12:15:54 InnoDB: Compressed tables use zlib 1.2.5 14 12:15:54 InnoDB: Initializing buffer pool, size = 128.0M 14 12:15:54 InnoDB: Completed initialization of buffer pool 14 12:15:54 InnoDB: highest supported file format is Barracuda. 14 12:15:54 InnoDB: Waiting for the background threads to start 14 12:15:55 InnoDB: 1.1.8 started; log sequence number 1595675 14 12:15:55 [Note] Event Scheduler: Loaded 0 events 14 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) PIDPPIDPGID WINPID TTY UIDSTIME COMMAND 472034004720 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
Re: Can't run MySQL under Cygwin : connect to server at 'localhost' failed (only when using password)
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) PIDPPIDPGID WINPID TTY UIDSTIME COMMAND 3400 13400 3400 con 1000 11:10:39 /usr/bin/bash 675634006756 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 None316 Oct 26 09:13 xkb_4Di75h -rw-r--r-- 1 dummy None316 Oct 27 00:08 xkb_4NrKCL -rw-r--r-- 1 dummy None316 Oct 27 00:09 xkb_ThcsMy -rw-r--r-- 1 dummy None316 Oct 27 00:10 xkb_shbOiY $ mysqld --user=dummy (launch server : OK) 14 12:15:54 InnoDB: The InnoDB memory heap is disabled 14 12:15:54 InnoDB: Mutexes and rw_locks use GCC atomic builtins 14 12:15:54 InnoDB: Compressed tables use zlib 1.2.5 14 12:15:54 InnoDB: Initializing buffer pool, size = 128.0M 14 12:15:54 InnoDB: Completed initialization of buffer pool 14 12:15:54 InnoDB: highest supported file format is Barracuda. 14 12:15:54 InnoDB: Waiting for the background threads to start 14 12:15:55 InnoDB: 1.1.8 started; log sequence number 1595675 14 12:15:55 [Note] Event Scheduler: Loaded 0 events 14 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) PIDPPIDPGID WINPID TTY UIDSTIME COMMAND 472034004720 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
Can't run MySQL under Cygwin : connect to server at 'localhost' failed (only when using password)
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) PIDPPIDPGID WINPID TTY UIDSTIME COMMAND 3400 13400 3400 con 1000 11:10:39 /usr/bin/bash 675634006756 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 None316 Oct 26 09:13 xkb_4Di75h -rw-r--r-- 1 dummy None316 Oct 27 00:08 xkb_4NrKCL -rw-r--r-- 1 dummy None316 Oct 27 00:09 xkb_ThcsMy -rw-r--r-- 1 dummy None316 Oct 27 00:10 xkb_shbOiY $ mysqld --user=dummy (launch server : OK) 14 12:15:54 InnoDB: The InnoDB memory heap is disabled 14 12:15:54 InnoDB: Mutexes and rw_locks use GCC atomic builtins 14 12:15:54 InnoDB: Compressed tables use zlib 1.2.5 14 12:15:54 InnoDB: Initializing buffer pool, size = 128.0M 14 12:15:54 InnoDB: Completed initialization of buffer pool 14 12:15:54 InnoDB: highest supported file format is Barracuda. 14 12:15:54 InnoDB: Waiting for the background threads to start 14 12:15:55 InnoDB: 1.1.8 started; log sequence number 1595675 14 12:15:55 [Note] Event Scheduler: Loaded 0 events 14 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) PIDPPIDPGID WINPID TTY UIDSTIME COMMAND 472034004720 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
Re: Can't run MySQL under Cygwin : connect to server at 'localhost' failed (only when using password)
Am 17.11.2011 15:02, schrieb Franck Houssen: $ 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) $ well this is not a connection problem your permissions in the mysql-user-tables are wrong remember that localhost is not the same as 127.0.0.1 and acess is granted by user/host/password combinations or not since you have in all permissions records a field for host signature.asc Description: OpenPGP digital signature
mysql under cygwin
Hi, has anybody any experience with mysql in cygwin (on a windows xp computer). I was able to compile the binary, apache is present in cygwin, but mysql does not work. The newest version of cygwin inc. the xserver ist installed already. Many thanks, Jan Virus checked by G DATA AntiVirusKit Version: AVK 15.0.5403 from 10.06.2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Please. i need help compiling mysql under CYGWIN
Can you send me the configure file + makefile configured for cygwin ? Version 3.23.58 please thanks alot!
perl's DBD::mysql on Cygwin
hello robert, you might want to try it without any options to Makefile.pl. if you installed mysql on cygwin, put the mysql bin dir on your path so mysql_config can be found, then the correct flags should be there. even with flags, you should write --libs='...' instead of --libs= make was ok then for me, still some tests failed ... regards, tom -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL on CYGWIN installtion
Hi, On Thu, 2002-05-23 at 13:29, [EMAIL PROTECTED] wrote: Anybody has tried installing MySQL on CygWin? Not to evade your question, but... why would you want this, since there are native Windows binaries? Faster and more reliable. Regards, Arjen. -- MySQL Training in Australia: 9-13 Sep 2002, https://order.mysql.com/?marl __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL on CYGWIN installtion
Anybody has tried installing MySQL on CygWin? R.B.Roa Traffic Management Engineer PhilCom Corporation Tel. No.(Office) 858-1028 (Home) 858-8889 Mobile No. (63) (919-3085267) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mySQL under cygwin : mysql_install_db does not create host.frm
Dear all, I've installed Cygwin and CAMP and I'm now looking for guidelines to build/install mysql under cygwin and XPpro. Sorry for that question but I tried during severals days with no luck. I'm using the scripts provided by Gerrit P. Haase in http://sources.redhat.com/ml/cygwin/2001-12/msg00025.html with mysql-3.23.49.tar.gz At the end of the installation process, I get the following error when starting mysql deamon : /src/mysql/mysql-3.23.49 Starting mysqld daemon with databases from /var/mysql/data 020503 7:15:49 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 0) 020503 07:15:49 mysqld ended This error has been already discussed in several mailing lists, the solution was to chown /var/mysql/data with user mysql, but it does not work here. I used the following procedure : - add user mysql and group cyg_mysql in XP (I log with username 'Administrateur') - add user and group to cygwin files with mkpasswd -l /etc/passwd mkgroup -l /etc/group - installation in /scr/mysql - mysql.build prep = ok - patch -p0 ../mysql.patch = ok - mysql.build conf = ok - mysql.build build stops with errors in make info : make[1]: Leaving directory `/src/mysql/mysql-3.23.49/bdb' make: *** [info-recursive] Error 1 - mysql.build install = ok - mysql.build initdb = ok, but ./scripts/mysql_install_db says : Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ERROR: 1033 Incorrect information in file: './mysql/db.frm' ... 020503 8:16:00 /usr/libexec/mysqld: Shutdown Complete - mysql.build startdb = stops with 'mysqld ended' : cat /var/mysql/data/EXBRAYAT.err /src/mysql/mysql-3.23.49 Starting mysqld daemon with databases from /var/mysql/data 020503 7:15:49 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 0) 020503 07:15:49 mysqld ended Of course, there is no file in /var/mysql/data/mysql/ ... when I cp /dev/null to mysql/host.frm the deamon can access the file and the error become : 020503 8:28:58 /usr/libexec/mysqld: Incorrect information in file: './mysql/host.frm' 020503 08:28:58 mysqld ended So, the installation process did not create the mysql database. but why ? Is there a patch to apply in ./scripts/mysql_install_db ? Fortunately, I have also installed mysql under XP, and when I copy the XP/mySQL databases to the CygWin/mySQL ones, everything (camp mysqld) is working perfectly, except it is a mess with usernames ... Mr Haase, could you help ? :-) thanks, Olivier. - Olivier Delrieu [EMAIL PROTECTED] Phone : +33 1 44 89 77 59 : +33 1 44 89 77 50 (secretariat) Mobile : +33 6 64 63 00 15 - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQL under cygwin : mysql_install_db does not create host.frm
hi, where are you running the server from? you might wanna try running from the base dir ./bin/safe_mysqld i used to have the same problem. on a linux machine though. regards, On Fri, 3 May 2002, Olivier Delrieu wrote: Dear all, I've installed Cygwin and CAMP and I'm now looking for guidelines to build/install mysql under cygwin and XPpro. Sorry for that question but I tried during severals days with no luck. I'm using the scripts provided by Gerrit P. Haase in http://sources.redhat.com/ml/cygwin/2001-12/msg00025.html with mysql-3.23.49.tar.gz At the end of the installation process, I get the following error when starting mysql deamon : /src/mysql/mysql-3.23.49 Starting mysqld daemon with databases from /var/mysql/data 020503 7:15:49 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 0) 020503 07:15:49 mysqld ended This error has been already discussed in several mailing lists, the solution was to chown /var/mysql/data with user mysql, but it does not work here. I used the following procedure : - add user mysql and group cyg_mysql in XP (I log with username 'Administrateur') - add user and group to cygwin files with mkpasswd -l /etc/passwd mkgroup -l /etc/group - installation in /scr/mysql - mysql.build prep = ok - patch -p0 ../mysql.patch = ok - mysql.build conf = ok - mysql.build build stops with errors in make info : make[1]: Leaving directory `/src/mysql/mysql-3.23.49/bdb' make: *** [info-recursive] Error 1 - mysql.build install = ok - mysql.build initdb = ok, but ./scripts/mysql_install_db says : Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ERROR: 1033 Incorrect information in file: './mysql/db.frm' ... 020503 8:16:00 /usr/libexec/mysqld: Shutdown Complete - mysql.build startdb = stops with 'mysqld ended' : cat /var/mysql/data/EXBRAYAT.err /src/mysql/mysql-3.23.49 Starting mysqld daemon with databases from /var/mysql/data 020503 7:15:49 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 0) 020503 07:15:49 mysqld ended Of course, there is no file in /var/mysql/data/mysql/ ... when I cp /dev/null to mysql/host.frm the deamon can access the file and the error become : 020503 8:28:58 /usr/libexec/mysqld: Incorrect information in file: './mysql/host.frm' 020503 08:28:58 mysqld ended So, the installation process did not create the mysql database. but why ? Is there a patch to apply in ./scripts/mysql_install_db ? Fortunately, I have also installed mysql under XP, and when I copy the XP/mySQL databases to the CygWin/mySQL ones, everything (camp mysqld) is working perfectly, except it is a mess with usernames ... Mr Haase, could you help ? :-) thanks, Olivier. - Olivier Delrieu [EMAIL PROTECTED] Phone : +33 1 44 89 77 59 : +33 1 44 89 77 50 (secretariat) Mobile : +33 6 64 63 00 15 - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- _ TP R Murthy (Systems Analyst) Cerulean Information Technology Pvt. Ltd. #24, floor#2, 5th Main, 5th Block, Koramangala, Bangalore-560 095. Phone: 299-1886, 299-1897 web:http://www.ceruleaninfotech.com _ Life is a Dream. Dont Wake up. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQL under cygwin : mysql_install_db does not create host.frm
Hi, I think you must run the db_install script. Good luck, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: TP R Murthy [EMAIL PROTECTED] To: Olivier Delrieu [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, May 03, 2002 1:27 PM Subject: Re: mySQL under cygwin : mysql_install_db does not create host.frm hi, where are you running the server from? you might wanna try running from the base dir ./bin/safe_mysqld i used to have the same problem. on a linux machine though. regards, On Fri, 3 May 2002, Olivier Delrieu wrote: Dear all, I've installed Cygwin and CAMP and I'm now looking for guidelines to build/install mysql under cygwin and XPpro. Sorry for that question but I tried during severals days with no luck. I'm using the scripts provided by Gerrit P. Haase in http://sources.redhat.com/ml/cygwin/2001-12/msg00025.html with mysql-3.23.49.tar.gz At the end of the installation process, I get the following error when starting mysql deamon : /src/mysql/mysql-3.23.49 Starting mysqld daemon with databases from /var/mysql/data 020503 7:15:49 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 0) 020503 07:15:49 mysqld ended This error has been already discussed in several mailing lists, the solution was to chown /var/mysql/data with user mysql, but it does not work here. I used the following procedure : - add user mysql and group cyg_mysql in XP (I log with username 'Administrateur') - add user and group to cygwin files with mkpasswd -l /etc/passwd mkgroup -l /etc/group - installation in /scr/mysql - mysql.build prep = ok - patch -p0 ../mysql.patch = ok - mysql.build conf = ok - mysql.build build stops with errors in make info : make[1]: Leaving directory `/src/mysql/mysql-3.23.49/bdb' make: *** [info-recursive] Error 1 - mysql.build install = ok - mysql.build initdb = ok, but ./scripts/mysql_install_db says : Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ERROR: 1033 Incorrect information in file: './mysql/db.frm' ... 020503 8:16:00 /usr/libexec/mysqld: Shutdown Complete - mysql.build startdb = stops with 'mysqld ended' : cat /var/mysql/data/EXBRAYAT.err /src/mysql/mysql-3.23.49 Starting mysqld daemon with databases from /var/mysql/data 020503 7:15:49 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 0) 020503 07:15:49 mysqld ended Of course, there is no file in /var/mysql/data/mysql/ ... when I cp /dev/null to mysql/host.frm the deamon can access the file and the error become : 020503 8:28:58 /usr/libexec/mysqld: Incorrect information in file: './mysql/host.frm' 020503 08:28:58 mysqld ended So, the installation process did not create the mysql database. but why ? Is there a patch to apply in ./scripts/mysql_install_db ? Fortunately, I have also installed mysql under XP, and when I copy the XP/mySQL databases to the CygWin/mySQL ones, everything (camp mysqld) is working perfectly, except it is a mess with usernames ... Mr Haase, could you help ? :-) thanks, Olivier. - Olivier Delrieu [EMAIL PROTECTED] Phone : +33 1 44 89 77 59 : +33 1 44 89 77 50 (secretariat) Mobile : +33 6 64 63 00 15 - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- _ TP R Murthy (Systems Analyst) Cerulean Information Technology Pvt. Ltd. #24, floor#2, 5th Main, 5th Block, Koramangala, Bangalore-560 095. Phone: 299-1886, 299-1897 web:http://www.ceruleaninfotech.com _ Life is a Dream. Dont Wake up. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http
RE: mySQL under cygwin : mysql_install_db does not create host.frm
sorry, no effect, the deamon could not be started anyway as there is no mysql database ... moreover, mysql_install_db lauch : /usr/libexec/mysqld --bootstrap --skip-grant-tables --basedir=/usr --datadir=/var/mysql/data --skip-innodb --skip-gemini --skip-bdb sql... and the sql statement include only reference to 'root' user in autorisation table. may be that is the problem ? olivier -Message d'origine- De : TP R Murthy [mailto:[EMAIL PROTECTED]] Envoye : ven. 3 mai 2002 12:28 A : Olivier Delrieu Cc : [EMAIL PROTECTED] Objet : Re: mySQL under cygwin : mysql_install_db does not create host.frm hi, where are you running the server from? you might wanna try running from the base dir ./bin/safe_mysqld i used to have the same problem. on a linux machine though. regards, On Fri, 3 May 2002, Olivier Delrieu wrote: Dear all, I've installed Cygwin and CAMP and I'm now looking for guidelines to build/install mysql under cygwin and XPpro. Sorry for that question but I tried during severals days with no luck. I'm using the scripts provided by Gerrit P. Haase in http://sources.redhat.com/ml/cygwin/2001-12/msg00025.html with mysql-3.23.49.tar.gz At the end of the installation process, I get the following error when starting mysql deamon : /src/mysql/mysql-3.23.49 Starting mysqld daemon with databases from /var/mysql/data 020503 7:15:49 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 0) 020503 07:15:49 mysqld ended This error has been already discussed in several mailing lists, the solution was to chown /var/mysql/data with user mysql, but it does not work here. I used the following procedure : - add user mysql and group cyg_mysql in XP (I log with username 'Administrateur') - add user and group to cygwin files with mkpasswd -l /etc/passwd mkgroup -l /etc/group - installation in /scr/mysql - mysql.build prep = ok - patch -p0 ../mysql.patch = ok - mysql.build conf = ok - mysql.build build stops with errors in make info : make[1]: Leaving directory `/src/mysql/mysql-3.23.49/bdb' make: *** [info-recursive] Error 1 - mysql.build install = ok - mysql.build initdb = ok, but ./scripts/mysql_install_db says : Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ERROR: 1033 Incorrect information in file: './mysql/db.frm' ... 020503 8:16:00 /usr/libexec/mysqld: Shutdown Complete - mysql.build startdb = stops with 'mysqld ended' : cat /var/mysql/data/EXBRAYAT.err /src/mysql/mysql-3.23.49 Starting mysqld daemon with databases from /var/mysql/data 020503 7:15:49 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 0) 020503 07:15:49 mysqld ended Of course, there is no file in /var/mysql/data/mysql/ ... when I cp /dev/null to mysql/host.frm the deamon can access the file and the error become : 020503 8:28:58 /usr/libexec/mysqld: Incorrect information in file: './mysql/host.frm' 020503 08:28:58 mysqld ended So, the installation process did not create the mysql database. but why ? Is there a patch to apply in ./scripts/mysql_install_db ? Fortunately, I have also installed mysql under XP, and when I copy the XP/mySQL databases to the CygWin/mySQL ones, everything (camp mysqld) is working perfectly, except it is a mess with usernames ... Mr Haase, could you help ? :-) thanks, Olivier. - Olivier Delrieu [EMAIL PROTECTED] Phone : +33 1 44 89 77 59 : +33 1 44 89 77 50 (secretariat) Mobile : +33 6 64 63 00 15 - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- _ TP R Murthy (Systems Analyst) Cerulean Information Technology Pvt. Ltd. #24, floor#2, 5th Main, 5th Block, Koramangala, Bangalore-560 095. Phone: 299-1886, 299-1897 web:http://www.ceruleaninfotech.com _ Life is a Dream. Dont Wake up. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL using Cygwin DLL on Windows?
Hi, all: I read the document, it says MySQL Server runs as a native Windows application and You will need VC++ 6.0 compiler for MySQL Windows source distribution. But we I try to download Windows binary package, it says Since mysqlc contains Cygwin runtime DLLs, we also offer you the Cygwin sourcecode for compliance with GPL. What does this mean? If I install MySQL as native application, Do I still need to use Cygwin DLL? Thanks! Zengfa __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL and Cygwin
Are there c libraries that for mySQL (connecting, query and sort) that the Cygwin compiler is compatible with? Kate - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL and Cygwin
Katelyn Sweet writes: Are there c libraries that for mySQL (connecting, query and sort) that the Cygwin compiler is compatible with? Kate Hi! Somewhere on Contrib or Link pages on our site there is a link to the site devoted to building MySQL with Cygwin. Also, after 3.23.37, there should not be any problem that you build it yourself, provided you upgrade to gcc 2.95.2. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php