Description:
mySQL ver 5.0.2 on Windows XP.
I tried to make a database table accodnibg to MySQL documentation. That's what
I have:
Enter password: xxxxxx
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.2-alpha-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer-mysql>
show databases;
+----------+
! Database !
+----------+
! mysql !
! test !
+----------+
2 rows in set (0.11 sec)
mysql> use test
Database changed
mysql> show tables;
Empty set <0.01 sec>
mysql> create table photos (паmе varchar(20), path varchar(256),
-> persones varchar(256), shot date);
Query OK, 0 rows affected, 2 warnings (0.15 sec)
mysql> show tables;
+----------------+
! Tables_in_test !
+----------------+
! photos !
+----------------+
1 row in set (0.00 sec)
mysql> describe photos;
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql>
I also tried to use PremiunSoft Navicat 2004 and failed to open the database. Server crashes.
That's what I have in the appcompat.txt file.
<?xml version="1.0" encoding="UTF-16"?>
<DATABASE>
<EXE NAME="mysqld-nt.exe" FILTER="GRABMI_FILTER_PRIVACY">
<MATCHING_FILE NAME="comp-err.exe" SIZE="954368" CHECKSUM="0x53D9AA8C" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 07:58:33" UPTO_LINK_DATE="12/01/2004 07:58:33" />
<MATCHING_FILE NAME="cygwinb19.dll" SIZE="669150" CHECKSUM="0x64393755" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x10000" LINK_DATE="07/15/1998 17:51:01" UPTO_LINK_DATE="07/15/1998 17:51:01" />
<MATCHING_FILE NAME="isamchk.exe" SIZE="1073152" CHECKSUM="0x5C86E5FC" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 08:06:19" UPTO_LINK_DATE="12/01/2004 08:06:19" />
<MATCHING_FILE NAME="libmySQL.dll" SIZE="1069056" CHECKSUM="0x448E9548" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x60000" LINK_DATE="12/01/2004 09:37:34" UPTO_LINK_DATE="12/01/2004 09:37:34" />
<MATCHING_FILE NAME="myisamchk.exe" SIZE="1196032" CHECKSUM="0xE573386" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 09:38:20" UPTO_LINK_DATE="12/01/2004 09:38:20" />
<MATCHING_FILE NAME="myisamlog.exe" SIZE="1114112" CHECKSUM="0x3A16A72C" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 09:38:22" UPTO_LINK_DATE="12/01/2004 09:38:22" />
<MATCHING_FILE NAME="myisampack.exe" SIZE="1118208" CHECKSUM="0x9AA00BB1" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 09:38:23" UPTO_LINK_DATE="12/01/2004 09:38:23" />
<MATCHING_FILE NAME="myisam_ftdump.exe" SIZE="1093632" CHECKSUM="0x900D94E9" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 08:25:26" UPTO_LINK_DATE="12/01/2004 08:25:26" />
<MATCHING_FILE NAME="mysql.exe" SIZE="1110123" CHECKSUM="0x99159742" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 09:38:24" UPTO_LINK_DATE="12/01/2004 09:38:24" />
<MATCHING_FILE NAME="mysqladmin.exe" SIZE="1048576" CHECKSUM="0x486BF79C" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 09:38:26" UPTO_LINK_DATE="12/01/2004 09:38:26" />
<MATCHING_FILE NAME="mysqlbinlog.exe" SIZE="1069056" CHECKSUM="0xABD78034" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 09:38:27" UPTO_LINK_DATE="12/01/2004 09:38:27" />
<MATCHING_FILE NAME="mysqlc.exe" SIZE="334712" CHECKSUM="0xBC927342" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x10000" LINK_DATE="10/29/1998 19:27:56" UPTO_LINK_DATE="10/29/1998 19:27:56" />
<MATCHING_FILE NAME="mysqlcheck.exe" SIZE="1044480" CHECKSUM="0x1418D430" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 09:38:28" UPTO_LINK_DATE="12/01/2004 09:38:28" />
<MATCHING_FILE NAME="mysqld-debug.exe" SIZE="5779559" CHECKSUM="0x6371BDDF" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 08:56:00" UPTO_LINK_DATE="12/01/2004 08:56:00" />
<MATCHING_FILE NAME="mysqld-max-nt.exe" SIZE="4120576" CHECKSUM="0xC74B69B" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 08:50:13" UPTO_LINK_DATE="12/01/2004 08:50:13" />
<MATCHING_FILE NAME="mysqld-max.exe" SIZE="4116480" CHECKSUM="0x10EB13C2" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 08:47:11" UPTO_LINK_DATE="12/01/2004 08:47:11" />
<MATCHING_FILE NAME="mysqld-nt.exe" SIZE="3649536" CHECKSUM="0x4AF3B33A" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 08:53:11" UPTO_LINK_DATE="12/01/2004 08:53:11" />
<MATCHING_FILE NAME="mysqld.exe" SIZE="3645440" CHECKSUM="0xBE6615B" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 08:40:11" UPTO_LINK_DATE="12/01/2004 08:40:11" />
<MATCHING_FILE NAME="mysqldump.exe" SIZE="1064960" CHECKSUM="0xAABD0F6E" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 09:38:30" UPTO_LINK_DATE="12/01/2004 09:38:30" />
<MATCHING_FILE NAME="mysqlimport.exe" SIZE="1044480" CHECKSUM="0xD5081825" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 09:38:31" UPTO_LINK_DATE="12/01/2004 09:38:31" />
<MATCHING_FILE NAME="MySQLInstanceConfig.exe" SIZE="1496576" CHECKSUM="0x8295B586" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="06/19/1992 22:22:17" UPTO_LINK_DATE="06/19/1992 22:22:17" />
<MATCHING_FILE NAME="mysqlshow.exe" SIZE="1040384" CHECKSUM="0x7DDCD597" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 09:38:32" UPTO_LINK_DATE="12/01/2004 09:38:32" />
<MATCHING_FILE NAME="mysqlshutdown.exe" SIZE="40960" CHECKSUM="0x39044159" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 09:05:33" UPTO_LINK_DATE="12/01/2004 09:05:33" />
<MATCHING_FILE NAME="mysqlwatch.exe" SIZE="45056" CHECKSUM="0x38ECF10E" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 09:05:34" UPTO_LINK_DATE="12/01/2004 09:05:34" />
<MATCHING_FILE NAME="my_print_defaults.exe" SIZE="122880" CHECKSUM="0x6B5AF9EA" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 08:24:40" UPTO_LINK_DATE="12/01/2004 08:24:40" />
<MATCHING_FILE NAME="pack_isam.exe" SIZE="1024000" CHECKSUM="0x42260FAF" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 09:07:43" UPTO_LINK_DATE="12/01/2004 09:07:43" />
<MATCHING_FILE NAME="perror.exe" SIZE="110592" CHECKSUM="0x8396569F" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 09:07:48" UPTO_LINK_DATE="12/01/2004 09:07:48" />
<MATCHING_FILE NAME="replace.exe" SIZE="122880" CHECKSUM="0xD6A451F2" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 08:28:00" UPTO_LINK_DATE="12/01/2004 08:28:00" />
</EXE>
<EXE NAME="kernel32.dll" FILTER="GRABMI_FILTER_THISFILEONLY">
<MATCHING_FILE NAME="kernel32.dll" SIZE="932864" CHECKSUM="0x8CEAD581" BIN_FILE_VERSION="5.1.2600.0" BIN_PRODUCT_VERSION="5.1.2600.0" PRODUCT_VERSION="5.1.2600.0" FILE_DESCRIPTION="Библиотека клиента Windows NT BASE API" COMPANY_NAME="Корпорация Майкрософт" PRODUCT_NAME="Операционная система Microsoft® Windows®" FILE_VERSION="5.1.2600.0 (xpclient.010817-1148)" ORIGINAL_FILENAME="kernel32" INTERNAL_NAME="kernel32" LEGAL_COPYRIGHT="© Корпорация Майкрософт. Все права защищены." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x2" MODULE_TYPE="WIN32" PE_CHECKSUM="0xEA66C" LINKER_VERSION="0x50001" UPTO_BIN_FILE_VERSION="5.1.2600.0" UPTO_BIN_PRODUCT_VERSION="5.1.2600.0" LINK_DATE="08/18/2001 05:33:02" UPTO_LINK_DATE="08/18/2001 05:33:02" VER_LANGUAGE="Русский [0x419]" />
</EXE>
</DATABASE>
What is the problem ?
How to repeat:
Enter password: xxxxxx
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.2-alpha-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer-mysql>
show databases;
+----------+
! Database !
+----------+
! mysql !
! test !
+----------+
2 rows in set (0.11 sec)
mysql> use test
Database changed
mysql> show tables;
Empty set <0.01 sec>
mysql> create table photos (паmе varchar(20), path varchar(256),
-> persones varchar(256), shot date);
Query OK, 0 rows affected, 2 warnings (0.15 sec)
mysql> show tables;
+----------------+
! Tables_in_test !
+----------------+
! photos !
+----------------+
1 row in set (0.00 sec)
mysql> describe photos;
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql>