Slow connecting to MySQL from Windows App
Hi, I am hoping someone here can help me. I have an Ubuntu 8.04 server that has worked FINE for months. The other day, the client rebooted it. They shut it down properly and then later started it up again. (The server was not experiencing any problems when they did it, there were other reasons). Ever since then, when I try to connect to the MySQL server it is running dead slow. As in 20-30 seconds to get a connect. By the way, I just tried it with MySQL Administrator and it has problems connecting as well so it is not the connector. The server is located internally on a gigabit network. Any assistance would be greatly appreciated... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Slow connecting to MySQL from Windows App
please follow my earlier suggestion and place long_query_time=NumberOfSecs min_examined_row_limit=MinNumberOfRowsToExamine in my.cnf or my.ini start mysqld --log-slow-queries[=file_name] documentation available at http://dev.mysql.com/doc/refman/5.1/en/slow-query-log.html Shalom Martin Gainty __ Disclaimer and Confidentiality/Verzicht und Vertraulichkeitanmerkung / Note de déni et de confidentialité This message is confidential. If you should not be the intended receiver, then we ask politely to report. Each unauthorized forwarding or manufacturing of a copy is inadmissible. This message serves only for the exchange of information and has no legal binding effect. Due to the easy manipulation of emails we cannot take responsibility over the the contents. Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. Date: Tue, 5 May 2009 08:43:51 -0400 From: gro...@bcconsultingservices.com To: mysql@lists.mysql.com Subject: Slow connecting to MySQL from Windows App Hi, I am hoping someone here can help me. I have an Ubuntu 8.04 server that has worked FINE for months. The other day, the client rebooted it. They shut it down properly and then later started it up again. (The server was not experiencing any problems when they did it, there were other reasons). Ever since then, when I try to connect to the MySQL server it is running dead slow. As in 20-30 seconds to get a connect. By the way, I just tried it with MySQL Administrator and it has problems connecting as well so it is not the connector. The server is located internally on a gigabit network. Any assistance would be greatly appreciated... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com _ Hotmail® goes with you. http://windowslive.com/Tutorial/Hotmail/Mobile?ocid=TXT_TAGLM_WL_HM_Tutorial_Mobile1_052009
Building MySql for Windows with SSL
In the MySql manual section 5.5.7.2 it specifies how to build MySql on a Unix/Linux platform with SSL by using 'configure'. I need to build MySql for Windows with SSL support. In section 2.4.15.6.1 for building MySql for Windows itr specifies the available options for using win/configure, but SSL is not among them. How then can I build MySql for Windows with SSL support ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Install MySQL on Windows XP
Hi all. I am trying install mysql-essential-5.0.67-win32.msi on windows xp. But i can not configure the mysql server successful. I stoped the firewall and anti-virus programs when i install mysql server. there is mysql message: Could not start the service MySQL5.Error:0 Now i do not know what to do,Can someone help me? My english is not well.Do i speak clearly? thanks reply
Re: Install MySQL on Windows XP
Hi there Yuan, Hopefully this article can be of some help to you: http://schalkneethling.alliedbridge.com/php/php-mysql-apache-set-up-how-to/ Regards, Schalk yuan edit wrote: Hi all. I am trying install mysql-essential-5.0.67-win32.msi on windows xp. But i can not configure the mysql server successful. I stoped the firewall and anti-virus programs when i install mysql server. there is mysql message: Could not start the service MySQL5.Error:0 Now i do not know what to do,Can someone help me? My english is not well.Do i speak clearly? thanks reply No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.138 / Virus Database: 270.6.5/1619 - Release Date: 2008/08/18 05:39 PM -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Install MySQL on Windows XP
yuan edit schrieb: Hi all. I am trying install mysql-essential-5.0.67-win32.msi on windows xp. But i can not configure the mysql server successful. I stoped the firewall and anti-virus programs when i install mysql server. there is mysql message: Could not start the service MySQL5.Error:0 Now i do not know what to do,Can someone help me? My english is not well.Do i speak clearly? take a look into your mysql error log, windows event viewer most common reason for not starting mysql is missconfigured InnoDB -- Sebastian Mendel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: locked file mysqld-nt.exe when re-installing mysql on windows server
got to start--run--(type regedit)--HKEY_LOCAL_MACHINE---SOFTWARE folder---delete all mysql folder Then in SYSTEM Folder ---controlset001--services--- delete all mysql entries. Do the same for controlset002 and controlset003 After above is done try to delete the file in C:\mysql\bin folder. regards anandkl On 7/30/08, Johan Gant [EMAIL PROTECTED] wrote: Hi I'm reinstalling an instance of MySQL 4.1 on a Windows Server 2003 machine, but I cannot delete the original installation folder or re-install into it due to the presence of the mysqld-nt.exe file in the C:\mysql\bin folder. I've killed all services relating to MySQL (or those that I can clearly identify using task manager and the services list from admin tools) from all user sessions on that machine, but the file is still locked by some process which I cannot identify. I encountered this problem in the past and got around it by killing all MySQL related processes but this time it's not helping. I've also logged out any other user sessions on this machine to ensure there is nothing idling in the background. Short of rebooting the server - is there any way to find out what might be locking this file, or a way of forcing a release to allow me to reinstall MySQL? I'm happy to hear alternative suggestions as well. Thanks Johan
Re: locked file mysqld-nt.exe when re-installing mysql on windows server
That worked for me, much appreciated. Thanks 2008/7/30 Ananda Kumar [EMAIL PROTECTED] got to start--run--(type regedit)--HKEY_LOCAL_MACHINE---SOFTWARE folder---delete all mysql folder Then in SYSTEM Folder ---controlset001--services--- delete all mysql entries. Do the same for controlset002 and controlset003 After above is done try to delete the file in C:\mysql\bin folder. regards anandkl On 7/30/08, Johan Gant [EMAIL PROTECTED] wrote: Hi I'm reinstalling an instance of MySQL 4.1 on a Windows Server 2003 machine, but I cannot delete the original installation folder or re-install into it due to the presence of the mysqld-nt.exe file in the C:\mysql\bin folder. I've killed all services relating to MySQL (or those that I can clearly identify using task manager and the services list from admin tools) from all user sessions on that machine, but the file is still locked by some process which I cannot identify. I encountered this problem in the past and got around it by killing all MySQL related processes but this time it's not helping. I've also logged out any other user sessions on this machine to ensure there is nothing idling in the background. Short of rebooting the server - is there any way to find out what might be locking this file, or a way of forcing a release to allow me to reinstall MySQL? I'm happy to hear alternative suggestions as well. Thanks Johan
locked file mysqld-nt.exe when re-installing mysql on windows server
Hi I'm reinstalling an instance of MySQL 4.1 on a Windows Server 2003 machine, but I cannot delete the original installation folder or re-install into it due to the presence of the mysqld-nt.exe file in the C:\mysql\bin folder. I've killed all services relating to MySQL (or those that I can clearly identify using task manager and the services list from admin tools) from all user sessions on that machine, but the file is still locked by some process which I cannot identify. I encountered this problem in the past and got around it by killing all MySQL related processes but this time it's not helping. I've also logged out any other user sessions on this machine to ensure there is nothing idling in the background. Short of rebooting the server - is there any way to find out what might be locking this file, or a way of forcing a release to allow me to reinstall MySQL? I'm happy to hear alternative suggestions as well. Thanks Johan
Re: MySQL DBA/Windows Server Administrator opportunity-Kansas City
Good. On Fri, Jun 13, 2008 at 3:23 AM, Lori Kurovski [EMAIL PROTECTED] wrote: We are currently looking for a contractor for 30 days in Kansas City that has experience doing MySQL DBA/Windows Server Administration work. This will be a production support role as the consultant will be covering for someone that will be out on vacation. The consultant needs to be available 24/7 to address any system issues. Our client needs to move quickly on this. Interested candidates should email their resume to Lori Kurovski at [EMAIL PROTECTED] or call at 913-422-0293. Lori Kurovski Solutions Now, Inc. 8695 College Blvd, Suite 220 Overland Park, KS 66210 913-422-0293 [EMAIL PROTECTED] -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
MySQL DBA/Windows Server Administrator opportunity-Kansas City
We are currently looking for a contractor for 30 days in Kansas City that has experience doing MySQL DBA/Windows Server Administration work. This will be a production support role as the consultant will be covering for someone that will be out on vacation. The consultant needs to be available 24/7 to address any system issues. Our client needs to move quickly on this. Interested candidates should email their resume to Lori Kurovski at [EMAIL PROTECTED] or call at 913-422-0293. Lori Kurovski Solutions Now, Inc. 8695 College Blvd, Suite 220 Overland Park, KS 66210 913-422-0293 [EMAIL PROTECTED]
Mysql DBA/Windows Server Administrator opportunity-Kansas City
I am not sure if this is the appropriate place to do this kind of posting but I thought this discussion group might be interested in hearing about this opportunity. I am working with a client in Kansas City that is looking for a contract to hire resource that has experience as a Mysql DBA that has some Windows Server Administration experience. Below are some details about the position. If anyone is interested in hearing more about this opportunity, please contact me at the email address or phone number below. Job description: MySQL DBA/Windows 2003 Server Admin. Responsibilities: * Must be able to respond to operational alerts 24/7. * Responsible for the daily administration of our production database servers and OS. * Assuring the security of all systems. * Installs, maintains, and upgrades database software. * Perform maintenance and upgrade of application schema components and database structures. * Maintain database backup and recovery environment; verify operation of backup strategy and data integrity. * Monitor and manage database replication and failover/recovery as needed. * Run database consistency checks and maintenance procedures and fix as needed. * Monitor and manage database server performance, availability, capacity and error logs. * Identify, troubleshoot and resolve real-time database issues. * Windows administration, security management, patching and performance monitoring. Qualifications: * On-call availability for emergencies and willingness to work non-standard hours. * A degree in Computer Science or related field. * Three or more years relevant experience including implementation, administration and support of production MySQL systems. * Two or more years of experience as both a database administrator and a Windows 2003 server administrator. * Experience in designing, implementing, testing and maintaining data replication services, as well as database backup, security and recovery strategies. * Strong familiarity with database clustering. * Experience with optimization and troubleshooting techniques to address performance problems on MySQL Server. * Proficient with Windows operating system security and utilities. * Experience with MS SQL Server 2005 or Oracle is a strong plus. * Production IIS/Web administration experience a plus. * Programming backgrounds in any .NET language a plus Lori Kurovski Solutions Now, Inc. 8695 College Blvd, Suite 220 Overland Park, KS 66210 913-422-0293 [EMAIL PROTECTED]
Re: max mysql under windows
Hi Charles, The manual has a few options for running multiple mysql instances on windows. See: http://dev.mysql.com/doc/refman/5.0/en/multiple-windows-servers.html On 2/5/07, Brown, Charles [EMAIL PROTECTED] wrote: Hello All. Is it possible to setup two instances of MySQL under windows? I am wondering because I would like to setup and test replication Thanks Charles This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- Eric Bergen [EMAIL PROTECTED] http://www.provenscaling.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MYSQL under windows -- Max number of instances
Hello All. Is it possible to setup two instances of MySQL under windows? I am wondering because I would like to setup and test replication Thanks Charles This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
max mysql under windows
Hello All. Is it possible to setup two instances of MySQL under windows? I am wondering because I would like to setup and test replication Thanks Charles This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you.
Re: MYSQL under windows -- Max number of instances
On 2/5/07, Brown, Charles [EMAIL PROTECTED] wrote: Is it possible to setup two instances of MySQL under windows? I am wondering because I would like to setup and test replication Yes, theoretically you can, it should follow the same way of having two mysql servers running, you just have to give them different TCP ports to listen... -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ --END GEEK CODE BLOCK-- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MYSQL on windows -- Max number
Hello All. Is it possible to setup two instances of MySQL under windows? I am wondering because I would like to setup and test replication Thanks Charles This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Installing MySQL on Windows Server 2003 Standard x64 Edition
I'm having problems with MySQLInstanceConfig.exe - Unable To Locate Component This application has failed to start because LIBMYSQL.dll was not found. Re-installing the application may fix this problem I have tried to re-install, but I get the same message. I read the following related threads but didn't help. http://lists.mysql.com/win32/14799 http://lists.mysql.com/mysql/167676 I looked for the file and it exists in: /mysql/bin/ /mysql/lib/debug/ /mysql/lib/opt/ This is the download I'm using for the installation: Windows Server 2003 (AMD64 / Intel EM64T)5.0.24 Please advise. David. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Installing MySQL on Windows Server 2003 Standard x64 Edition
It could seems stupid, but you tried to put this file on c:\windows\system32 or the similar folder of your system? David Lazo [EMAIL PROTECTED] escreveu na mensagem news:[EMAIL PROTECTED] I'm having problems with MySQLInstanceConfig.exe - Unable To Locate Component This application has failed to start because LIBMYSQL.dll was not found. Re-installing the application may fix this problem I have tried to re-install, but I get the same message. I read the following related threads but didn't help. http://lists.mysql.com/win32/14799 http://lists.mysql.com/mysql/167676 I looked for the file and it exists in: /mysql/bin/ /mysql/lib/debug/ /mysql/lib/opt/ This is the download I'm using for the installation: Windows Server 2003 (AMD64 / Intel EM64T)5.0.24 Please advise. David. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Installing MySQL on Windows Server 2003 Standard x64 Edition
I didn't add it anywhere because the file exists in mysql/bin folder c:/program files/mysql/bin Does it need to be somewhere else?? On 8/25/06 5:03 PM, João Cândido de Souza Neto [EMAIL PROTECTED] wrote: It could seems stupid, but you tried to put this file on c:\windows\system32 or the similar folder of your system? David Lazo [EMAIL PROTECTED] escreveu na mensagem news:[EMAIL PROTECTED] I'm having problems with MySQLInstanceConfig.exe - Unable To Locate Component This application has failed to start because LIBMYSQL.dll was not found. Re-installing the application may fix this problem I have tried to re-install, but I get the same message. I read the following related threads but didn't help. http://lists.mysql.com/win32/14799 http://lists.mysql.com/mysql/167676 I looked for the file and it exists in: /mysql/bin/ /mysql/lib/debug/ /mysql/lib/opt/ This is the download I'm using for the installation: Windows Server 2003 (AMD64 / Intel EM64T)5.0.24 Please advise. David. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Installing MySQL on Windows Server 2003 Standard x64 Edition
On 8/25/06, David Lazo [EMAIL PROTECTED] wrote: I didn't add it anywhere because the file exists in mysql/bin folder c:/program files/mysql/bin Does it need to be somewhere else?? mm.. i don't know, you tell us !!! try it. !!! -- http://www.obed.org.mx --- blog -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Installing MySQL on Windows Server 2003 Standard x64 Edition
Go to Control PanelSystemAdvanced. Click Environmental Variables and Find the PATH variable under System Variables and add the full path, i.e. c:\Program Files\...\mysql\bin to the variable. -Original Message- From: David Lazo [mailto:[EMAIL PROTECTED] Sent: Friday, August 25, 2006 2:54 PM To: mysql@lists.mysql.com Subject: Installing MySQL on Windows Server 2003 Standard x64 Edition I'm having problems with MySQLInstanceConfig.exe - Unable To Locate Component This application has failed to start because LIBMYSQL.dll was not found. Re-installing the application may fix this problem I have tried to re-install, but I get the same message. I read the following related threads but didn't help. http://lists.mysql.com/win32/14799 http://lists.mysql.com/mysql/167676 I looked for the file and it exists in: /mysql/bin/ /mysql/lib/debug/ /mysql/lib/opt/ This is the download I'm using for the installation: Windows Server 2003 (AMD64 / Intel EM64T)5.0.24 Please advise. David. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Installing MySQL on Windows Server 2003 Standard x64 Edition
I still get the same error. Not sure what I'm doing wrong. On 8/25/06 5:49 PM, Greg Joss [EMAIL PROTECTED] wrote: Go to Control PanelSystemAdvanced. Click Environmental Variables and Find the PATH variable under System Variables and add the full path, i.e. c:\Program Files\...\mysql\bin to the variable. -Original Message- From: David Lazo [mailto:[EMAIL PROTECTED] Sent: Friday, August 25, 2006 2:54 PM To: mysql@lists.mysql.com Subject: Installing MySQL on Windows Server 2003 Standard x64 Edition I'm having problems with MySQLInstanceConfig.exe - Unable To Locate Component This application has failed to start because LIBMYSQL.dll was not found. Re-installing the application may fix this problem I have tried to re-install, but I get the same message. I read the following related threads but didn't help. http://lists.mysql.com/win32/14799 http://lists.mysql.com/mysql/167676 I looked for the file and it exists in: /mysql/bin/ /mysql/lib/debug/ /mysql/lib/opt/ This is the download I'm using for the installation: Windows Server 2003 (AMD64 / Intel EM64T)5.0.24 Please advise. David. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql on Windows
Is anyone running mySQL on Windows 2003 server platform. Are there any known problems ? Cheers Neil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql on Windows
[snip] Is anyone running mySQL on Windows 2003 server platform. Are there any known problems ? {/snip] The operating system? Yuck yuck! :) It ran fine for me on 2k3 before I cam back to a *nix shop -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql on Windows
Hi Neil, Neil Tompkins wrote: Is anyone running mySQL on Windows 2003 server platform. Are there any known problems ? There is a known bug for Windows 2003 - bug #12071: http://bugs.mysql.com/bug.php?id=12071 You should use 4.0.19 or 5.0.19. Best regards Mark -- Mark Leith, Support Engineer MySQL AB, Worcester, England, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql on Windows
Apart from this are there any other known issues. When trialing mySQL on my XP machine, I noticed all the tables were created in lower case ? Is this normal ? Cheers Neil From: Mark Leith [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Neil Tompkins [EMAIL PROTECTED] CC: mysql@lists.mysql.com Subject: Re: mysql on Windows Date: Tue, 14 Mar 2006 15:51:48 + Hi Neil, Neil Tompkins wrote: Is anyone running mySQL on Windows 2003 server platform. Are there any known problems ? There is a known bug for Windows 2003 - bug #12071: http://bugs.mysql.com/bug.php?id=12071 You should use 4.0.19 or 5.0.19. Best regards Mark -- Mark Leith, Support Engineer MySQL AB, Worcester, England, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql on Windows
Neil Tompkins [EMAIL PROTECTED] wrote on 03/14/2006 01:42:32 PM: Apart from this are there any other known issues. When trialing mySQL on my XP machine, I noticed all the tables were created in lower case ? Is this normal ? Cheers Neil From: Mark Leith [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Neil Tompkins [EMAIL PROTECTED] CC: mysql@lists.mysql.com Subject: Re: mysql on Windows Date: Tue, 14 Mar 2006 15:51:48 + Hi Neil, Neil Tompkins wrote: Is anyone running mySQL on Windows 2003 server platform. Are there any known problems ? There is a known bug for Windows 2003 - bug #12071: http://bugs.mysql.com/bug.php?id=12071 You should use 4.0.19 or 5.0.19. Best regards Mark -- Mark Leith, Support Engineer MySQL AB, Worcester, England, www.mysql.com Are you MySQL certified? www.mysql.com/certification Yes, all lowercase is normal. http://dev.mysql.com/doc/refman/4.1/en/name-case-sensitivity.html I am running several servers on Win2k and Win2K3 and so far so good. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: what happened to error log in MySQL 4.1x/Windows XP
Hello. Please, CC your answers to the list as well. Put log_error=path_to_error_log in your configuration file (my.ini usually). See: http://dev.mysql.com/doc/refman/5.0/en/error-log.html http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html I'm sorry, but I see no mention in either of those references as to the correct syntax for turning on error messages in the MySQL Windows config file. This isn't surprising, as I had spent some time consulting my existing docs and online. I could, I suppose, extrapolate from revising the command line invocation of mysql, but that was not the question or intent here. What am I missing? Since you chose not to actually provide a context for your invocation of URLs, I have no idea whether you were trying to answer the question I actually asked, or were answering something else, entirely. At 08:18 AM 12/3/2005, you wrote: Hello. See: http://dev.mysql.com/doc/refman/5.0/en/windows-start-service.html http://dev.mysql.com/doc/refman/5.0/en/program-options.html [EMAIL PROTECTED] wrote: Hi, I haven't admin'd MySQL in a couple of years, and I have forgotten and lot (and probably never knew even more.) I recently installed the current 4.1x MySQL release in Windows XP. I am trying to track down problems, and can't seem to get an error log. I expected to see a file, mysql.err in the data directory. Not only isn't it there, but trying to add something like err-log (extrapolating from the --err-log I'd used in Unix) in the mysqld area of the my.ini file prevents the server from launching, so that is clearly either not the correct syntax or not the correct place for such a line (or both). Next, is there supposed to be a way to start/restart MySQL in Windows other than by going to the Services panel for the general computer? Is this something that can be done from the command line? Many thanks, ari [EMAIL PROTECTED] -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: what happened to error log in MySQL 4.1x/Windows XP
Hello. See: http://dev.mysql.com/doc/refman/5.0/en/windows-start-service.html http://dev.mysql.com/doc/refman/5.0/en/program-options.html [EMAIL PROTECTED] wrote: Hi, I haven't admin'd MySQL in a couple of years, and I have forgotten and lot (and probably never knew even more.) I recently installed the current 4.1x MySQL release in Windows XP. I am trying to track down problems, and can't seem to get an error log. I expected to see a file, mysql.err in the data directory. Not only isn't it there, but trying to add something like err-log (extrapolating from the --err-log I'd used in Unix) in the mysqld area of the my.ini file prevents the server from launching, so that is clearly either not the correct syntax or not the correct place for such a line (or both). Next, is there supposed to be a way to start/restart MySQL in Windows other than by going to the Services panel for the general computer? Is this something that can be done from the command line? Many thanks, ari [EMAIL PROTECTED] -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
what happened to error log in MySQL 4.1x/Windows XP
Hi, I haven't admin'd MySQL in a couple of years, and I have forgotten and lot (and probably never knew even more.) I recently installed the current 4.1x MySQL release in Windows XP. I am trying to track down problems, and can't seem to get an error log. I expected to see a file, mysql.err in the data directory. Not only isn't it there, but trying to add something like err-log (extrapolating from the --err-log I'd used in Unix) in the mysqld area of the my.ini file prevents the server from launching, so that is clearly either not the correct syntax or not the correct place for such a line (or both). Next, is there supposed to be a way to start/restart MySQL in Windows other than by going to the Services panel for the general computer? Is this something that can be done from the command line? Many thanks, ari [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: what happened to error log in MySQL 4.1x/Windows XP
[EMAIL PROTECTED] wrote: Hi, I haven't admin'd MySQL in a couple of years, and I have forgotten and lot (and probably never knew even more.) I recently installed the current 4.1x MySQL release in Windows XP. I am trying to track down problems, and can't seem to get an error log. I expected to see a file, mysql.err in the data directory. Not only isn't it there, but trying to add something like err-log (extrapolating from the --err-log I'd used in Unix) in the mysqld area of the my.ini file prevents the server from launching, so that is clearly either not the correct syntax or not the correct place for such a line (or both). Next, is there supposed to be a way to start/restart MySQL in Windows other than by going to the Services panel for the general computer? Is this something that can be done from the command line? Many thanks, ari [EMAIL PROTECTED] Manual: http://dev.mysql.com/doc/refman/5.0/en/error-log.html |log-error in my.ini should work. kgt | -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to test the MySQL Server (windows version) ?
Hi! lu ming wrote: Hi! I tried to run the perl scripts in the windows platform yesterday,but an error occured [[...]] I can just repeat: This script is still under construction, and adaptions are still needed to make tests work correctly on Windows platforms. If you run it, you are on your own, and we are not investing any effort in supporting it externally now; we fully concentrate on improving it for our own internal tests. When this is finished, we can still announce it and then work on the problems which you and other users may experience. Jörg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com Office: (+49 30) 417 01 487 VoIP: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to test the MySQL Server (windows version) ?
Hi, joerg Thanks for your patient answer! I hope that we will have the ability to run the test suite on windows system early. Best regards luming _ 与联机的朋友进行交流,请使用 MSN Messenger: http://messenger.msn.com/cn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to test the MySQL Server (windows version) ?
Hi! I tried to run the perl scripts in the windows platform yesterday,but an error occured as following output info: C:\MySQL\MySQLServer5\mysql-test\perl mysql-test-run.pl mysql-test-run: *** ERROR: Could not find C:/MySQL/MySQLServer5/scripts/mysql_fix_privilege_tables I find that the mysql_fix_privilege_tables file is already exist, why did it occured this error? Is my method wrong? Or the perl test script that is included in the source distribution has some bugs? ( the source distribution i used is mysql-5.0.12-beta-linux ) Best regards lu ming _ 享用世界上最大的电子邮件系统― MSN Hotmail。 http://www.hotmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to test the MySQL Server (windows version) ?
lu ming [EMAIL PROTECTED] wrote on 10/14/2005 12:20:19 AM: Hi, joerg Thank you very much! But i want to know more about this problem. I find a perl script about mysql server's test in the mysql-test subdirectory(/mysql-test/mysql-test-run.pl). Is this the test script written by perl what could replace the shell script(/mysql-test/mysql-test-run.sh) in Windows mentioned in your e-mail? Could it be rightly run in windows now? Or it cann't be run due to the unfinished work? Are the perl scripts that mentioned in your e-mail included in the MySQL Server's Unix source distributions(mysql-5.0.12-beta-linux) ? Are the perl test scripts only used in Mysql's internal works now? Best regards luming The problems are more with Windows than with the script. The testing script was written in BASH (I believe) which does not have an interpreter for Windows (outside of Cygwin. However if you are inside Cygwin, you really aren't working with Windows any more.) Several other scripting languages do have interpreters for Windows: VBScript (d), JScript (d), PHP, Python, PERL, and more. (d) = installed by default. I think that the mysql testing script is being ported from BASH into PERL and when that happens you will have the ability to run it on any Windows system configured to run PERL scripts. Until then, we Win32 people just trust the binaries and avoid compiling our own copies unless we absolutely need to. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: How to test the MySQL Server (windows version) ?
Hi! [EMAIL PROTECTED] wrote: lu ming [EMAIL PROTECTED] wrote on 10/14/2005 12:20:19 AM: Hi, joerg Thank you very much! But i want to know more about this problem. I find a perl script about mysql server's test in the mysql-test subdirectory(/mysql-test/mysql-test-run.pl). Is this the test script written by perl what could replace the shell script(/mysql-test/mysql-test-run.sh) in Windows mentioned in your e-mail? It will be the one. It is not yet finished. Could it be rightly run in windows now? Or it cann't be run due to the unfinished work? You can run it, but you may have problems interpreting the results. Several tests will seem to fail, just because some output differs from the expected one. Obviously, much output is platform dependent (starting with file names, then process or thread IDs, ...), and the tests do not yet allow for the output generated on Windows. Note that I say output, not database result! Are the perl scripts that mentioned in your e-mail included in the MySQL Server's Unix source distributions(mysql-5.0.12-beta-linux) ? Yes, they are included (AFAIK - not checked), but they are under construction even for Unix. Just today, I fixed another problem in them, that had shown up during our internal 5.0 builds. Are the perl test scripts only used in Mysql's internal works now? Obviously, I cannot guarantee that nobody else is using them. But we have not proposed to anybody outside MySQL to do so. The problems are more with Windows than with the script. The testing script was written in BASH (I believe) which does not have an interpreter for Windows (outside of Cygwin. However if you are inside Cygwin, you really aren't working with Windows any more.) Just for completeness: If anybody wants to use Unix style tools (shell, awk, ed, tr, sed, lex/bison/yacc, ...) in a Windows environment, I propose to look at MinGW because these are native Windows binaries. Several other scripting languages do have interpreters for Windows: VBScript (d), JScript (d), PHP, Python, PERL, and more. (d) = installed by default. Right. So for us, Perl is the language of choice, as we can make it available on all platforms. I think that the mysql testing script is being ported from BASH into PERL and when that happens you will have the ability to run it on any Windows system configured to run PERL scripts. Until then, we Win32 people just trust the binaries and avoid compiling our own copies unless we absolutely need to. We will see not to disappoint that trust, and appreciate it. Thanks! Joerg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to test the MySQL Server (windows version) ?
The test system that is included in MySQL Server's Unix source distributions.(/mysql-test/mysql-test-run.sh) We can use the suite to run a test against to the MySQL Server. But these tests only can be run on Unix(linux). If you want to run the tests on Windows, you must use the Cygwin environment, and the server must be compiled under Cygwin environment. Actually, it doesn't test the MySQL Server's Windows version because the Cygwin had make the running environment be equal to the Unix's i think. Is my opinion right? I want to know how to test the MySQL Server's Windows version. Is MySQL AB doesn't provide the test method? Who can give me an answer? _ 与联机的朋友进行交流,请使用 MSN Messenger: http://messenger.msn.com/cn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to test the MySQL Server (windows version) ?
Hi ! lu ming wrote: The test system that is included in MySQL Server's Unix source distributions.(/mysql-test/mysql-test-run.sh) We can use the suite to run a test against to the MySQL Server. But these tests only can be run on Unix(linux). If you want to run the tests on Windows, you must use the Cygwin environment, and the server must be compiled under Cygwin environment. Actually, it doesn't test the MySQL Server's Windows version because the Cygwin had make the running environment be equal to the Unix's i think. Is my opinion right? Well, this is a typical Windows problem (yes, I admit being a Unix guy): Native Windows does not come with a decent portable scripting language. You are right that the MySQL test suite is based on a shell script approach which does not work in (native) Windows. (You might get MinGW, MKS or similar suites to get a shell and try in that environment, but this would be your own personal experiment. If you have looked into that script, you get an idea of the complexity needed, plain batch files will not work for this.) I want to know how to test the MySQL Server's Windows version. Is MySQL AB doesn't provide the test method? Who can give me an answer? MySQL is internally working on replacing the shell script by a set of Perl scripts, which can also be used on Windows (provided you install Perl). However, this work is not yet finished, and several tests will produce different results on Windows from the Unix ones, which the tool considers to be failures - even if it is just the way the result is written,no real database difference. So currently there is no way for you to run the test suite on Windows and get usable results - sorry. We are working on this. Regards, Jörg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to test the MySQL Server (windows version) ?
Hi, joerg Thank you very much! But i want to know more about this problem. I find a perl script about mysql server's test in the mysql-test subdirectory(/mysql-test/mysql-test-run.pl). Is this the test script written by perl what could replace the shell script(/mysql-test/mysql-test-run.sh) in Windows mentioned in your e-mail? Could it be rightly run in windows now? Or it cann't be run due to the unfinished work? Are the perl scripts that mentioned in your e-mail included in the MySQL Server's Unix source distributions(mysql-5.0.12-beta-linux) ? Are the perl test scripts only used in Mysql's internal works now? Best regards luming _ 享用世界上最大的电子邮件系统― MSN Hotmail。 http://www.hotmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can't install Mysql on Windows XP
Hello: I am trying to install mysql on my laptop which is running Windows XP professional. But after installation when trying to connect to the MySQL server I am getting the following error message: Error 2003: Can't connect to MySQL server on 'localhost' (10061). Tried all the options with my knowledge. No luck yet. Can anybody help me out. MySQL installation file/version - mysql4.0.20d-win Regards Sheni R Meledath Assistant Manager - Web Development * Cyber Gear LLC P.O. Box 53735 Dubai, United Arab Emirates Tel: (971 4) 331-2627, Fax: (971 4) 331-8812 Email: [EMAIL PROTECTED], http://www.cyber-gear.com VISIT OUR ASSOCIATE SITES: http://www.Click2Advertising.com http://www.DubaiCityGuide.com http://www.MiddleEastDirectory.com http://www.MiddleEastEvents.com http://www.MiddleEastPostBox.com http://www.PressReleaseNetwork.com * This message has been checked for all known viruses by McAfee. No liability is accepted by virtue of checking this message and you are recommended to have in place your own anti-virus detection procedures.
Re: Can't install Mysql on Windows XP
Did you install MySQL as a service and have you started the service? Sheni R. Meledath wrote: Hello: I am trying to install mysql on my laptop which is running Windows XP professional. But after installation when trying to connect to the MySQL server I am getting the following error message: Error 2003: Can't connect to MySQL server on 'localhost' (10061). Tried all the options with my knowledge. No luck yet. Can anybody help me out. MySQL installation file/version - mysql4.0.20d-win Regards Sheni R Meledath Assistant Manager - Web Development * Cyber Gear LLC P.O. Box 53735 Dubai, United Arab Emirates Tel: (971 4) 331-2627, Fax: (971 4) 331-8812 Email: [EMAIL PROTECTED], http://www.cyber-gear.com VISIT OUR ASSOCIATE SITES: http://www.Click2Advertising.com http://www.DubaiCityGuide.com http://www.MiddleEastDirectory.com http://www.MiddleEastEvents.com http://www.MiddleEastPostBox.com http://www.PressReleaseNetwork.com * This message has been checked for all known viruses by McAfee. No liability is accepted by virtue of checking this message and you are recommended to have in place your own anti-virus detection procedures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mySQL on Windows CE
Hi, Is this supported? I mean I just look at the FAQ and find it is on the list of supported platform (Handheld: Windows CE), but I hardly see any article mention about it. I have downloaded two connector (.NET and ODBC), but which one should I use for Windows CE development? Could someone help clarify? For Embedded Visual C++ 4.0, what connector should I use and does it supported? Or, if I go for .NET Compact Framework with Visual Studio .NET 2003, should I use .NET connector? Or ODBC? I have seen previously someone said connector for .NET Compact Framework is not yet out, but today I see handheld Windows CE on the list of supported platform by mySQL, and I am almost confused. Khan Ming -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Looking to hire someone to configure MySQL on Windows Server 2003
Greetings We have installed MySQL 4.0 on a dedicated Windows Server 2003. I have the MySQL server running and it appears all is set to go minus one problem. We need to move a MySQL database from the old host to this server. To do that, I want to use a GUI - preferably DBACentral. However; I am unable to connect to the mySQL server that I have set-up. I have tried everything but the GUI will not let me connect. I am not convinced that the 3306 port is open because I tried putting the DBACentral GUI on the Web Server which allowed me to connect to the local MySQL database (which I cannot connect to from my desktop) but I then could not connect to the one we need to move (which I can connect to from my desktop). Does anyone have experience with configuring MySQL for Windows 2003? If so, please let me know. I would like to hire you to get this configured correctly so we can connect remotely and move this database. United States people only and you must be able to get it done ASAP - preferably today. Please contact me if you are interested. Thanks, Rob
Re: Looking to hire someone to configure MySQL on Windows Server 2003
At 12:42 2004-09-08, you wrote: Greetings We have installed MySQL 4.0 on a dedicated Windows Server 2003. I have the MySQL server running and it appears all is set to go minus one problem. We need to move a MySQL database from the old host to this server. To do that, I want to use a GUI - preferably DBACentral. However; I am unable to connect to the mySQL server that I have set-up. You mean the new one, right? The one You just set up? I have tried everything but the GUI will not let me connect. If You're _certain_ that it is the DBACentral that does not let You connect, I would presume the misconfiguration is there. I am not convinced that the 3306 port is open Find out. On the 2003 server run netstat and see... If You have the proper tools installed, You can `netstat -an|grep 3306` - that is what I would do first. because I tried putting the DBACentral GUI on the Web Server which allowed me to connect to the local MySQL database (which I cannot connect to from my desktop) but I then could not connect to the one we need to move (which I can connect to from my desktop). OK, so we have _three_ MySQL servers now: 1 old, 1 new and one on the web server, right? And You need to move from old to new, the webserver one does not enter into this, right? The fact that You can connect to the webserver one from localhost is a sensible precaution: after all, only the webserver has a legitimate need to make connections to it. I think You have allowed access to Your database from only the localhost. You need to create user accounts on the DB that are allowed remote access. Of course after You verify that: - the DB starts and does not complain - which port the listener is active on This is all covered in the post-install tasks in the manual and takes but a few minutes (assuming just simple setup). Does anyone have experience with configuring MySQL for Windows 2003? If so, please let me know. I would like to hire you to get this configured correctly so we can connect remotely and move this database. United States people only and you must be able to get it done ASAP - preferably today. Please contact me if you are interested. In a wider scope: what are the MySQL versions of the old and new DBs? Can't You use mysqldump or just set up replication, use the old until You're convinced that new works to Your satisfaction, and cut it over then? Thanks, Rob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Looking to hire someone to configure MySQL on Windows Server 2003
At 13:19 2004-09-08, you wrote: I am going to amalgamate both Your messages. Hi Tomasz There are two MySQL servers - the one at the shared host and the new one that I just set-up on the dedicated. We need to move the MySQL database from the shared host to our dedicated. I am able to connect to the old one but not the new one. Let's give them names: let's call the old one A and the new one B. I believe A lives at the hosting company and B lives in Your office (for now), later You will want to colocate it. Correct so far? Now, to verify the versions, at the mysql prompt execute: SHOW VARIABLES; close to the end of the list there will be a version variable - find it for both hosts - it shouldn't be a problem, but let's try to eliminate that possibility now. Grep is not recognized when I try to do netstat. OK, You might want to install cygwin tools, but let's not worry about this now. Just do 'netstat -an|more' and look for a line that in the second column (local address) has B's IP address, then colon, and 3306. If You only find '127.0.0.1:3306', B is only listening on loopback. If You find no rows with :3306, MySQL is not running (at least not on a standard port). I was told the MySQL database at the shared company is 4.0. Again, I can connect to that one. The new one is 4.0 as well. See above, verify. I have created a user and allowed that user remote access. I presume on B, right? grant all privileges on text.* to 'user'@'%' identified by 'footman's using grant access; 1. You _did_ create database text, right? 2. I do hope that password is a typo: it was 'footmans', right? 3. I'm perplexed by this USING clause... Did You mean WITH GRANT OPTION? I'll assume so. 3. let me rewrite it a bit: is _this_ what You actually issued: mysql GRANT ALL ON text.* TO 'user'@'%' IDENTIFIED BY 'footmans' WITH GRANT OPTION; After You do that, verify: mysql SHOW GRANTS FOR 'user'@'%'; and, more importantly: mysql SHOW GRANTS FOR 'user'@'Your workstation IP, as seen by the server B'; Thanks.Rob At 13:25 2004-09-08, Rob Taylor wrote: And just to clarify. I an connect to MySQL server at the shared hosting company from my desktop. I cannot connect to it from the new server. That probably means that the user You are trying to connect as is not authorized to connect from the machine You are trying to connect from - let's assume the username is kkk, B's IP address is BBB.BBB.BBB.BBB, connect to A then issue: mysql SHOW GRANTS FOR 'kkk'@'BBB.BBB.BBB.BBB'; It says it cannot connect. That leads me to believe that something on the new server (probably the 3306 port) is not letting traffic remotely through it. Remember, B is likely _not_ using port 3306 to connect to DB on A. I'd be very surprised if it did. Consequently this issue is not likely related to B's inability to provide connection to workstation somewhere And a far more general question: any firewalls/NAT between Your workstation and A? What about on Your route to B? Thanks, -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql 4.0 windows XP Downloads
May someone please send me the link to download mysql Binary distribution for the first time on windows XP, I have looked into mysql/downloads and they only have X86. Thanks, Francois A
Re: Mysql 4.0 windows XP Downloads
May someone please send me the link to download mysql Binary distribution for the first time on windows XP, I have looked into mysql/downloads and they only have X86. Windows XP, and every other windows platform, runs on X86 architecture. That is the download you want. Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql 4.0 windows XP Downloads
Francois, You didn't reply to the list, just to me. If you reply to the list, more people will be able to help you. I'm quite new myself. You need to set up user accounts. Download an admin program such as MySQL Control Center. Maybe there are better ones, but that's what I use. You can do a lot of stuff with this and save your self from having to type at the command line. MySql Control Center http://dev.mysql.com/downloads/other/mysqlcc.html Julian Francois A. Atallah wrote: Y I'm getting this error every time I want to access the mysql database ERROR 1044: Access denied for user: '@localhost' to database 'mysql' I can only bypass this error if I use -u root ? Thanks, Francois A -Original Message- From: Julian [mailto:[EMAIL PROTECTED] Sent: Friday, August 20, 2004 12:04 PM To: [EMAIL PROTECTED] Subject: Re: Mysql 4.0 windows XP Downloads That's it. You had it. x86 refers to the Intel chip family not the operating system. I'm using that quite happily on XP. Julian Francois A. Atallah wrote: May someone please send me the link to download mysql Binary distribution for the first time on windows XP, I have looked into mysql/downloads and they only have X86. Thanks, Francois A . -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
installing mySQL on Windows 2000
I'm attempting to install version 4.0.16 When I try to install the software I get an error that reads: An error occurred during the data move process: 103 Can anyone give me any guidance on how to resolve this. Thanks, Ken This e-mail and any files transmitted with it may contain information that is PRIVILEGED, CONFIDENTIAL, and exempt from disclosure under applicable law. It is intended only for the individual(s) or entity named above. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use, dissemination or copying of this e-mail or the information contained in it or attached to it is strictly prohibited. If you have received this e-mail in error, please delete it and immediately notify the person named above by reply e-mail. Thank you.
Re: installing mySQL on Windows 2000
Are you logged on as Administrator? Is there enough disk space free? Does it generate the same error if you try re-installing? Is there an existing installation with the server still running? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: French characters ok with mysql in Windows, nok with mysql in Linux
From: Willy Dockx [EMAIL PROTECTED] Sent: Monday, January 05, 2004 7:23 PM Subject: RE: French characters ok with mysql in Windows, nok with mysql in Linux Hello, etc/sysconfig/i18n contains: LANG=en_US.UTF-8 SUPPORTED=nl_BE.UTF-8:nl_BE:nl:en_US.UTF-8:en_US:en SYSFONT=latarcyrheb-sun16 Is that ok? I can't remenber what was my conf, but google is you friend ... http://groups.google.fr/groups?hl=frie=UTF-8oe=UTF-8q=french+redhat+i18nsa=Ntab=wgmeta= http://groups.google.fr/groups?hl=frlr=ie=UTF-8oe=UTF-8q=accent+redhat+i18n Did you try to connect directly to MySQL through a standard MySQL client and make an insert with é à ù ... and see if the select is ok after the insert ? What concerns the 'driver connection url' : should I leave 'useUnicode=truecharacterEncoding=UTF-8' in it? Don't know, i'm not using java ... Bye David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: French characters ok with mysql in Windows, nok with mysql in Linux
Hello, I changed etc/sysconfig/i18n to: LANG=fr_FR SUPPORTED=fr_FR:fr SYSFONT=lat0-sun16 SYSFONTACM=iso15 and everything works perfectly. Thank you very much for your help. Greetings, Willy Dockx -Original Message- From: David Bordas [mailto:[EMAIL PROTECTED] Sent: dinsdag 6 januari 2004 8:39 To: Willy Dockx Cc: [EMAIL PROTECTED] Subject: Re: French characters ok with mysql in Windows, nok with mysql in Linux From: Willy Dockx [EMAIL PROTECTED] Sent: Monday, January 05, 2004 7:23 PM Subject: RE: French characters ok with mysql in Windows, nok with mysql in Linux Hello, etc/sysconfig/i18n contains: LANG=en_US.UTF-8 SUPPORTED=nl_BE.UTF-8:nl_BE:nl:en_US.UTF-8:en_US:en SYSFONT=latarcyrheb-sun16 Is that ok? I can't remenber what was my conf, but google is you friend ... http://groups.google.fr/groups?hl=frie=UTF-8oe=UTF-8q=french+redhat+i18n; sa=Ntab=wgmeta= http://groups.google.fr/groups?hl=frlr=ie=UTF-8oe=UTF-8q=accent+redhat+i 18n Did you try to connect directly to MySQL through a standard MySQL client and make an insert with é à ù ... and see if the select is ok after the insert ? What concerns the 'driver connection url' : should I leave 'useUnicode=truecharacterEncoding=UTF-8' in it? Don't know, i'm not using java ... Bye David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
French characters ok with mysql in Windows, nok with mysql in Linux
Hello, I already posted this problem end of 2003, but probably, the champagne has troubled the answers. The solution of this problem is really important for me. Can anybody help? I have made a website using jboss, Hibernate, mysql 4.0.16 and mysql-connector-java-3.0.9. In development this is installed on Windows2000 and everything works fine, also when the user inputs characters like é, à, è, In production this is installed on Linux (RedHat 8). There also everything works fine, except for the strange characters é, à, è. I suppose the reason is that RedHat uses UTF-8 as encoding. Ive tried to put useUnicode=truecharacterEncoding=UTF-8 in the driver connection url, but this doesnt help. Can anyone help me on this problem? Greetings, Willy Dockx -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: French characters ok with mysql in Windows, nok with mysql in Linux
From: Willy Dockx [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 05, 2004 3:00 PM Subject: French characters ok with mysql in Windows, nok with mysql in Linux Hello, I already posted this problem end of 2003, but probably, the champagne has troubled the answers. The solution of this problem is really important for me. Can anybody help? I have made a website using jboss, Hibernate, mysql 4.0.16 and mysql-connector-java-3.0.9. In development this is installed on Windows2000 and everything works fine, also when the user inputs characters like é, à, è, . In production this is installed on Linux (RedHat 8). There also everything works fine, except for the strange characters é, à, è. I suppose the reason is that RedHat uses UTF-8 as encoding. I've tried to put 'useUnicode=truecharacterEncoding=UTF-8' in the driver connection url, but this doesn't help. Can anyone help me on this problem? Hi, I'm storing french characters with MySQL under Linux RedHat. Hox did you export your data to Linux ? Did you look to the file /etc/sysconfig/i18n ? The default file is quite buggy under RedHat 8. Bye David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: French characters ok with mysql in Windows, nok with mysql in Linux
Hello, Thank you for your quick response. I start with an empty database. So the data isn't exported. Then users enter data in a web-page. It is this data that can contain French characters and that is added by the java servlet to the database. I will look at the file /etc/sysconfig/i18n this evening (I can not get on the Linux system at this moment). I'm not a linux-expert. I didn't change anything in that file until now. Greetings, Willy Dockx -Original Message- From: David Bordas [mailto:[EMAIL PROTECTED] Sent: maandag 5 januari 2004 15:18 To: Willy Dockx Cc: [EMAIL PROTECTED] Subject: Re: French characters ok with mysql in Windows, nok with mysql in Linux From: Willy Dockx [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 05, 2004 3:00 PM Subject: French characters ok with mysql in Windows, nok with mysql in Linux Hello, I already posted this problem end of 2003, but probably, the champagne has troubled the answers. The solution of this problem is really important for me. Can anybody help? I have made a website using jboss, Hibernate, mysql 4.0.16 and mysql-connector-java-3.0.9. In development this is installed on Windows2000 and everything works fine, also when the user inputs characters like é, à, è, . In production this is installed on Linux (RedHat 8). There also everything works fine, except for the strange characters é, à, è. I suppose the reason is that RedHat uses UTF-8 as encoding. I've tried to put 'useUnicode=truecharacterEncoding=UTF-8' in the driver connection url, but this doesn't help. Can anyone help me on this problem? Hi, I'm storing french characters with MySQL under Linux RedHat. Hox did you export your data to Linux ? Did you look to the file /etc/sysconfig/i18n ? The default file is quite buggy under RedHat 8. Bye David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: French characters ok with mysql in Windows, nok with mysql in Linux
Both are the same: Character-set : latin1 Character-sets : a long list Convert_Character_set : Is that like it should be? Greetings, Willy Dockx -Original Message- From: Oriol [mailto:[EMAIL PROTECTED] Sent: maandag 5 januari 2004 15:55 To: Willy Dockx Subject: Re: French characters ok with mysql in Windows, nok with mysql in Linux Have you looked at character set options in MySQL config files? You can see the differences between the servers executing the query: show variables like '%character_set%'; Bye Oriol - Original Message - From: Willy Dockx [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 05, 2004 3:00 PM Subject: French characters ok with mysql in Windows, nok with mysql in Linux Hello, I already posted this problem end of 2003, but probably, the champagne has troubled the answers. The solution of this problem is really important for me. Can anybody help? I have made a website using jboss, Hibernate, mysql 4.0.16 and mysql-connector-java-3.0.9. In development this is installed on Windows2000 and everything works fine, also when the user inputs characters like é, à, è, . In production this is installed on Linux (RedHat 8). There also everything works fine, except for the strange characters é, à, è. I suppose the reason is that RedHat uses UTF-8 as encoding. I've tried to put 'useUnicode=truecharacterEncoding=UTF-8' in the driver connection url, but this doesn't help. Can anyone help me on this problem? Greetings, Willy Dockx -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: French characters ok with mysql in Windows, nok with mysql in Linux
Hello, etc/sysconfig/i18n contains: LANG=en_US.UTF-8 SUPPORTED=nl_BE.UTF-8:nl_BE:nl:en_US.UTF-8:en_US:en SYSFONT=latarcyrheb-sun16 Is that ok? What concerns the 'driver connection url' : should I leave 'useUnicode=truecharacterEncoding=UTF-8' in it? Greetings, Willy Dockx -Original Message- From: David Bordas [mailto:[EMAIL PROTECTED] Sent: maandag 5 januari 2004 15:18 To: Willy Dockx Cc: [EMAIL PROTECTED] Subject: Re: French characters ok with mysql in Windows, nok with mysql in Linux From: Willy Dockx [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 05, 2004 3:00 PM Subject: French characters ok with mysql in Windows, nok with mysql in Linux Hello, I already posted this problem end of 2003, but probably, the champagne has troubled the answers. The solution of this problem is really important for me. Can anybody help? I have made a website using jboss, Hibernate, mysql 4.0.16 and mysql-connector-java-3.0.9. In development this is installed on Windows2000 and everything works fine, also when the user inputs characters like é, à, è, . In production this is installed on Linux (RedHat 8). There also everything works fine, except for the strange characters é, à, è. I suppose the reason is that RedHat uses UTF-8 as encoding. I've tried to put 'useUnicode=truecharacterEncoding=UTF-8' in the driver connection url, but this doesn't help. Can anyone help me on this problem? Hi, I'm storing french characters with MySQL under Linux RedHat. Hox did you export your data to Linux ? Did you look to the file /etc/sysconfig/i18n ? The default file is quite buggy under RedHat 8. Bye David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
French characters ok with mysql in Windows, nok with mysql in Linux
Hello, I have made a website using jboss, Hibernate, mysql 4.0.16 and mysql-connector-java-3.0.9. In development this is installed on Windows2000 and everything works fine, also when the user inputs characters like é, à, è, In production this is installed on Linux (RedHat 8). There also everything works fine, except for the strange characters é, à, è. I suppose the reason is that RedHat uses UTF-8 as encoding. Ive tried to put useUnicode=truecharacterEncoding=UTF-8 in the driver connection url, but this doesnt help. Can anyone help me on this problem? Greetings, Willy Dockx
MySQL on Windows 2000 Server
Hi to all, I'm implementing a database in MySQL runnig on Windows 2000 Server. It's working fine. I'm wondering what kind of rights do need MySQL Server to run on Windows 2000. Now its runnig as service with administrator rights. But I am affraid that seriosly effect the security of this server. Thanks in advence, Bela Kocsis -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Does MySQL for windows support base 64 encoding ?
Does anyone know if MySQL for windows support base 64 encoding ? Or where this documented ? Jeff Stout CSG Systems, Inc. 303-200-3204 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL on Windows 2000
Hi, We have installed PHP/MySQL on a Windows 2000 server. PHP MySQL are working fine on the server. We also require to connect ASP to MySQL database. How can we do that? Currently the MySQL/ODBC driver is not available on Windows 2000 server. How can we add that and proceed with ASP/MySQL? Sheni R Meledath [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL on Windows
Hi, I'm sure I'm missing something simple. I've searched the doc but can't find an answer. I downloaded and installed MySQL for Windows this morning, V4.1. Unzipped, installed and started the server as a service, no problems. Installed the ODBC driver. A-OK But, the DOC tells me I have to run mysql_install_db.sh. So, the question is, how am I supposed to run shell scripts on Windows? Thanks Arnie Mauer Application Architect Valassis Relationship Marketing Systems, LLC A Valassis Company 6 Armstrong Rd, Shelton CT 06484 Tel 1-203-225-1359 Fax 1-203-925-0188 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL on Windows
This script is run on *nix machines only. It installs the mysql and test databases into mysql. Windows installation does this by default. BTW, these *.sh are BASh scripts. Scott -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 10:50 AM To: [EMAIL PROTECTED] Subject: MySQL on Windows Hi, I'm sure I'm missing something simple. I've searched the doc but can't find an answer. I downloaded and installed MySQL for Windows this morning, V4.1. Unzipped, installed and started the server as a service, no problems. Installed the ODBC driver. A-OK But, the DOC tells me I have to run mysql_install_db.sh. So, the question is, how am I supposed to run shell scripts on Windows? Thanks Arnie Mauer Application Architect Valassis Relationship Marketing Systems, LLC A Valassis Company 6 Armstrong Rd, Shelton CT 06484 Tel 1-203-225-1359 Fax 1-203-925-0188 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Re[2]: Can run two versions of MySQL in Windows 2000?
-Original Message- From: Stefan Hinz [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 5:15 PM To: Degan, George E, JR, MGSVC Cc: Paul DuBois; [EMAIL PROTECTED] Subject: Re[2]: Can run two versions of MySQL in Windows 2000? Degan, jumping in to try and solve some problems that look pretty obvious to me ... #options for default service (mysqld2) (mysqld2) It should be [mysqld2], not (mysqld2). (thanks -- did this) basedir = c:\4.1 Alpha\mysql As Paul pointed out, the blank in the path name is likely to cause problems (see below). my-opts2.cnf: [mysqld2] basedir = c:\4.1 Alpha\mysql Again, don't use a path that contains blanks. socket = mypipe2 As opposed to Unix, Windows doesn't know the concept of sockets (it uses named pipes instead). Named pipes, however, might cause problems with MySQL under Windows, so it's recommended not to use them, but rather use tcp/ip instead (that is why named pipes are disabled by default). You don't have to specify anything to use tcp/ip -- it's the default under Windows. (The above line in your configuration file is syntactically okay, but I'd recommend to delete it for the mentioned reasons. For MySQL 4.1, that should be protocol=mypipe2, anyway.) (thanks -- removed the two lines in the [mysqld] section: enable-named-pipes and socket = mypipe1 in the [mysqld2] section I removed enable-named-pipes and amended second line to protocol = mypipe2 Did I understand you correctly?) mysqld --defaults-file=C:\my-opts1.cnf response: mysqld: ERROR: unknown option '--enable-named-pipe' For the above given reasons, you shouldn't use named pipes. Get rid of the appropriate lines in your configuration files, and you'll get rid of that problem. (amended the Opts#.cnf files similar to the my.cnf file above) 030723 15:09:02 Error message file 'C:\mysql\share\english\errmsg.sys' had only 237 error messages, but it should contain at least 255 error messages. Check that the above file is the right version for this program! 030723 15:09:02 when I invoke it from the folder of the old version. and: mysqld-max: Can't change dir to 'C:\4.1 Alpha\mysql\data\' (Errcode:2) Well, that error message says it, doesn't it? Avoid having blanks in your pathnames. (changed live folder to c:\mysql-4.0.13 and the alpha folder to c:\mysql-4.1.0\) Okay, that looks good. When you open the Services Manager, I assume it shows lines for services named MySQL and mysqld2 and that they both have a status showing them to be running? (Sorry, the Services Manager? I'm not sure what that is.) On Windows 2000, you can open the Services Manager window as follows: Start Settings Control Panel Administration Services In that window you see a list of Windows services, and you should find two MySQL-related services running. (I think I messed up here. I decided to start from scratch, I removed MySQL Servers and Clients 4.0.13 from the program list (as it appears when I run the setup.exe it installs MySQL software in Windows) and deleted all the folders (which included the old c:\mysql\ directory with mysqld in the \bin folder) before performing the remove instructions below. So now I can't get to the correct mysqld service to remove it. It also appears that I can't remove it in windows as I don't see a remove or delete option in the Services area where you directed me. Will that be stuck there, now? MySQL and mysqld2 still appear in the services list.) But when I attempt to invoke MySQL the response is: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) Okay. What was the command you used here? (just the same as before: mysql or mysql -h localhost -u root What happens if you use this command: mysql -h localhost -P 3308 or this one: mysql -h . -S mypipe2 (both give the following response: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061), and I tried several Ports, 3308, 3307, 3306, and 3309 in this order) All that means that the MySQL server you are trying to connect to isn't running. You can check in the Services Manager window, now that you know how to find that :) (BTW. When I came in today I found out that I could no longer connect to 4.1.0 either. When I left last night, I could connect to 4.1.0, but could no longer connect to 4.0.13. According to windows explorer the database files are still there, but for some reason mySQL can no longer point to them.) Once again, check in the Services Manager window and make sure the MySQL servers are actually running. I can only guess, but it looks as though they are not started at system startup (Start type: automatic). net stop svc-name-1 net stop svc-name-2 (by svs-name-1 and -2 do you refer to mysqld and mysqld2? If not, to what services do you refer?) To remove them: mysqld --remove svc-name-1 mysqld --remove svc-name-2 (it appears that you do not as mysqld --remove mysqld doesn't seem to make sense. To what services do you refer
Re[4]: Can run two versions of MySQL in Windows 2000?
Degan, On Windows 2000, you can open the Services Manager window as follows: Start Settings Control Panel Administration Services In that window you see a list of Windows services, and you should find two MySQL-related services running. (I think I messed up here. I decided to start from scratch, I removed MySQL Servers and Clients 4.0.13 from the program list (as it appears when I run the setup.exe it installs MySQL software in Windows) and deleted all the folders (which included the old c:\mysql\ directory with mysqld in the \bin folder) before performing the remove instructions below. So now I can't get to the correct mysqld service to remove it. It also appears that I can't remove it in windows as I don't see a remove or delete option in the Services area where you directed me. Will that be stuck there, now? MySQL and mysqld2 still appear in the services list.) I had the same kind of problem before. I don't know why that is so, but Windows doesn't provide a remove option in the Services Manager window. You can, however, edit the properties of a service and set it to Disabled. After re-booting the system, that service should have gone. If it's still there, you can only remove it by hacking the Windows registry (Start Run regedit), looking for mysql... entries, delete them, and reboot. Maybe there's a more proper way of doing this, and if someone on this list knows, I'd be interested in how that would look like. (And, yes, I can hear all you Unix guys on this list chuckling.) Regards, -- Stefan Hinz [EMAIL PROTECTED] iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re[4]: Can run two versions of MySQL in Windows 2000?
At 14:47 24/7/2003 +0200, Stefan Hinz wrote: Hi, (I think I messed up here. I decided to start from scratch, I removed MySQL Servers and Clients 4.0.13 from the program list (as it appears when I run the setup.exe it installs MySQL software in Windows) and deleted all the folders (which included the old c:\mysql\ directory with mysqld in the \bin folder) before performing the remove instructions below. So now I can't get to the correct mysqld service to remove it. It also appears that I can't remove it in windows as I don't see a remove or delete option in the Services area where you directed me. Will that be stuck there, now? MySQL and mysqld2 still appear in the services list.) I had the same kind of problem before. I don't know why that is so, but Windows doesn't provide a remove option in the Services Manager window. You can, however, edit the properties of a service and set it to Disabled. After re-booting the system, that service should have gone. If it's still there, you can only remove it by hacking the Windows registry (Start Run regedit), looking for mysql... entries, delete them, and reboot. Maybe there's a more proper way of doing this, and if someone on this list knows, I'd be interested in how that would look like. (And, yes, I can hear all you Unix guys on this list chuckling.) Yes the currently installer doesn't remove the service during the un-install process. This deficiency should be fixed in the new installer which is developed by Mark ( I am cc this for him for to me correct if I am wrong). However in the today behavior I don't recommend to play with the registry. The situation is: - Before to un-install remove the service using the server binary with mysqld --remove or mysqld --remove service-name. - If you don't have anymore any server for to perform the remove service, you don't need to reboot, just re-install the new stuff and do the service remove. -- Regards, For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ Miguel Angel Solórzano [EMAIL PROTECTED] São Paulo - Brazil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Re[4]: Can run two versions of MySQL in Windows 2000?
That did it! I tried disabling and rebooting and that didn't work, but I went into the new folders and simply removed the services as indicated and they are now gone. Thanks!! George -Original Message- From: miguel solórzano [mailto:[EMAIL PROTECTED] Sent: Thursday, July 24, 2003 9:45 AM To: Stefan Hinz; Degan, George E, JR, MGSVC Cc: Paul DuBois; [EMAIL PROTECTED]; Mark Matthews Subject: Re[4]: Can run two versions of MySQL in Windows 2000? At 14:47 24/7/2003 +0200, Stefan Hinz wrote: Hi, (I think I messed up here. I decided to start from scratch, I removed MySQL Servers and Clients 4.0.13 from the program list (as it appears when I run the setup.exe it installs MySQL software in Windows) and deleted all the folders (which included the old c:\mysql\ directory with mysqld in the \bin folder) before performing the remove instructions below. So now I can't get to the correct mysqld service to remove it. It also appears that I can't remove it in windows as I don't see a remove or delete option in the Services area where you directed me. Will that be stuck there, now? MySQL and mysqld2 still appear in the services list.) I had the same kind of problem before. I don't know why that is so, but Windows doesn't provide a remove option in the Services Manager window. You can, however, edit the properties of a service and set it to Disabled. After re-booting the system, that service should have gone. If it's still there, you can only remove it by hacking the Windows registry (Start Run regedit), looking for mysql... entries, delete them, and reboot. Maybe there's a more proper way of doing this, and if someone on this list knows, I'd be interested in how that would look like. (And, yes, I can hear all you Unix guys on this list chuckling.) Yes the currently installer doesn't remove the service during the un-install process. This deficiency should be fixed in the new installer which is developed by Mark ( I am cc this for him for to me correct if I am wrong). However in the today behavior I don't recommend to play with the registry. The situation is: - Before to un-install remove the service using the server binary with mysqld --remove or mysqld --remove service-name. - If you don't have anymore any server for to perform the remove service, you don't need to reboot, just re-install the new stuff and do the service remove. -- Regards, For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ Miguel Angel Solórzano [EMAIL PROTECTED] São Paulo - Brazil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Re[2]: Can run two versions of MySQL in Windows 2000?
At 6:23 -0500 7/24/03, Degan, George E, JR, MGSVC wrote: (I think I messed up here. I decided to start from scratch, I removed MySQL Servers and Clients 4.0.13 from the program list (as it appears when I run the setup.exe it installs MySQL software in Windows) and deleted all the folders (which included the old c:\mysql\ directory with mysqld in the \bin folder) before performing the remove instructions below. So now I can't get to the correct mysqld service to remove it. It also appears that I can't remove it in windows as I don't see a remove or delete option in the Services area where you directed me. Will that be stuck there, now? MySQL and mysqld2 still appear in the services list.) You need to remove the services using a MySQL server. You can use any of mysqld, mysqld-nt, mysqld-max, or mysql-max-nt to do this. Suppose you use mysqld. This command removes the service having the default name (MySQL): mysqld --remove And this one removes a service named mysqld2: mysqld --remove mysqld2 net stop svc-name-1 net stop svc-name-2 (by svs-name-1 and -2 do you refer to mysqld and mysqld2? If not, to what services do you refer?) MySQL (the default name) and mysqld2 (your second service name) To remove them: mysqld --remove svc-name-1 mysqld --remove svc-name-2 (it appears that you do not as mysqld --remove mysqld doesn't seem to make sense. To what services do you refer?) See above. Then start from the beginning, using the mysqld --install instructions in the manual. (So I don't have to Uninstall them in windows since they are now services? Or does this have the same effect?) I'd suggest you to get familiar with the Windows services concept. Services are, uh, services that can start and stop software programs (like the MySQL server). Rather than starting the software manually, you'd set up a service that does that (and can do that automatically, e.g. at system startup). Windows (NT, 2000, XP) usually uses services to start software that runs in the background, like the MySQL server. Unlike software, you don't uninstall a service, you _remove_ it, so it won't be there anymore to start the software program it's supposed to start. For the MySQL server, that's done with the mysqld --remove servicename command. (How do we remove the mysqld service?) You don't have a service named mysqld, do you? -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Re[2]: Can run two versions of MySQL in Windows 2000?
Successfully removed the services. I rechecked and, no mysqld, just MySQL and mysqld2. Thanks! That should close out this thread! -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Thursday, July 24, 2003 11:30 AM To: Degan, George E, JR, MGSVC; Stefan Hinz Cc: [EMAIL PROTECTED] Subject: RE: Re[2]: Can run two versions of MySQL in Windows 2000? At 6:23 -0500 7/24/03, Degan, George E, JR, MGSVC wrote: (I think I messed up here. I decided to start from scratch, I removed MySQL Servers and Clients 4.0.13 from the program list (as it appears when I run the setup.exe it installs MySQL software in Windows) and deleted all the folders (which included the old c:\mysql\ directory with mysqld in the \bin folder) before performing the remove instructions below. So now I can't get to the correct mysqld service to remove it. It also appears that I can't remove it in windows as I don't see a remove or delete option in the Services area where you directed me. Will that be stuck there, now? MySQL and mysqld2 still appear in the services list.) You need to remove the services using a MySQL server. You can use any of mysqld, mysqld-nt, mysqld-max, or mysql-max-nt to do this. Suppose you use mysqld. This command removes the service having the default name (MySQL): mysqld --remove And this one removes a service named mysqld2: mysqld --remove mysqld2 net stop svc-name-1 net stop svc-name-2 (by svs-name-1 and -2 do you refer to mysqld and mysqld2? If not, to what services do you refer?) MySQL (the default name) and mysqld2 (your second service name) To remove them: mysqld --remove svc-name-1 mysqld --remove svc-name-2 (it appears that you do not as mysqld --remove mysqld doesn't seem to make sense. To what services do you refer?) See above. Then start from the beginning, using the mysqld --install instructions in the manual. (So I don't have to Uninstall them in windows since they are now services? Or does this have the same effect?) I'd suggest you to get familiar with the Windows services concept. Services are, uh, services that can start and stop software programs (like the MySQL server). Rather than starting the software manually, you'd set up a service that does that (and can do that automatically, e.g. at system startup). Windows (NT, 2000, XP) usually uses services to start software that runs in the background, like the MySQL server. Unlike software, you don't uninstall a service, you _remove_ it, so it won't be there anymore to start the software program it's supposed to start. For the MySQL server, that's done with the mysqld --remove servicename command. (How do we remove the mysqld service?) You don't have a service named mysqld, do you? -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Can run two versions of MySQL in Windows 2000?
I'm sorry, I'm very new at this. I only downloaded the live version last week. Where do I find the setting you are referring to? By attempt to run the servers, perhaps this is a correct answer to your question: I am only using this for learning purposes. I am hoping to attain new skills and thought that SQL was a good place to start (since I believe it to be the base for many database languages (DBIV (or whatever version they're up to today, Oracle, Sybase, Peoplesoft, etc.) and perhaps if I lose my job this will broaden my choices in looking for a new position/career. If this is not a correct answer to your question, please clarify. Finally, thank you, I will change the name of the folder as you suggest. George -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 4:42 PM To: Degan, George E, JR, MGSVC; [EMAIL PROTECTED] Subject: RE: Can run two versions of MySQL in Windows 2000? At 14:15 -0500 7/22/03, Degan, George E, JR, MGSVC wrote: Thanks. I have been fighting with this all afternoon, now it seems I can get to 4.1.0 and not 4.0.13. My databases still seem to be there but I can't point to them either in mysql or in mysqlcc/DBManager. I guess I have moved port 3306 to the 4.1.0 database. How do I name, say, 3307 as the 4.0.13 database? First, you're better off not installing 4.1 (or any version) in a directory with a pathname that contains spaces. I suggest renaminng c:\4.1 Alpha to c:\4.1-Alpha. Second, tell us more about your setup. You're asking us to diagnose the problem with little more information than it doesn't work. What are your settings? How are you attempting to run the servers? Thanks. -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 12:00 PM To: [EMAIL PROTECTED] Subject: Re: Can run two versions of MySQL in Windows 2000? Degan, George E, JR, MGSVC [EMAIL PROTECTED] wrote: I have been running 4.0.13 for several weeks now and though I'd like to test 4.1.0. 4.0.13 is under c:\MySQL. I downloaded 4.1.0 under c:\4.1 Alpha\MySQL. When I try to launch mysql it brings me to the old version, how do I access the new one without killing the old one? (I have also tried putting 4.1.0 on a totally different machine and linking to it also.) Yes, you can find info about it at: http://www.mysql.com/doc/en/Multiple_Windows_servers.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Can run two versions of MySQL in Windows 2000?
At 6:32 -0500 7/23/03, Degan, George E, JR, MGSVC wrote: I'm sorry, I'm very new at this. I only downloaded the live version last week. Where do I find the setting you are referring to? By attempt to run the servers, perhaps this is a correct answer to your question: I am only using this for learning purposes. I am hoping to attain new skills and thought that SQL was a good place to start (since I believe it to be the base for many database languages (DBIV (or whatever version they're up to today, Oracle, Sybase, Peoplesoft, etc.) and perhaps if I lose my job this will broaden my choices in looking for a new position/career. If this is not a correct answer to your question, please clarify. It's not. I'll attempt to rephrase my questions. However, I will also suggest that if, as you say, you're very new at this, attempting to run multiple servers before you are comfortable with running a single server is not likely to be very easy. re: your setup: What version of Windows do you have? re: your settings: What options are you using to start the servers? (for example, are you passing options on the command line or storing them in an option file? If an option file, which one and what do its contents look like?) re: how you're running the servers: What command do you use to invoke the servers? Are you starting them from the command line, or installing them as services and running them that way? It is a good idea to explain exactly what you're doing, and to provide any relevant error messages that occur. (By that I mean the text of the error messages themselves -- not just a general description of the failure.) Thanks. Finally, thank you, I will change the name of the folder as you suggest. George -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 4:42 PM To: Degan, George E, JR, MGSVC; [EMAIL PROTECTED] Subject: RE: Can run two versions of MySQL in Windows 2000? At 14:15 -0500 7/22/03, Degan, George E, JR, MGSVC wrote: Thanks. I have been fighting with this all afternoon, now it seems I can get to 4.1.0 and not 4.0.13. My databases still seem to be there but I can't point to them either in mysql or in mysqlcc/DBManager. I guess I have moved port 3306 to the 4.1.0 database. How do I name, say, 3307 as the 4.0.13 database? First, you're better off not installing 4.1 (or any version) in a directory with a pathname that contains spaces. I suggest renaminng c:\4.1 Alpha to c:\4.1-Alpha. Second, tell us more about your setup. You're asking us to diagnose the problem with little more information than it doesn't work. What are your settings? How are you attempting to run the servers? Thanks. -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 12:00 PM To: [EMAIL PROTECTED] Subject: Re: Can run two versions of MySQL in Windows 2000? Degan, George E, JR, MGSVC [EMAIL PROTECTED] wrote: I have been running 4.0.13 for several weeks now and though I'd like to test 4.1.0. 4.0.13 is under c:\MySQL. I downloaded 4.1.0 under c:\4.1 Alpha\MySQL. When I try to launch mysql it brings me to the old version, how do I access the new one without killing the old one? (I have also tried putting 4.1.0 on a totally different machine and linking to it also.) Yes, you can find info about it at: http://www.mysql.com/doc/en/Multiple_Windows_servers.html -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Can run two versions of MySQL in Windows 2000?
SETUP Windows 2000, Version 5.0 (build 2195, Service Pack 2) (In case it matters, I have about 20 GB available on my 40GB hard drive and 192MB of RAM) SETTINGS Prior to attempting to put on the second server, I wasn't using any options, which was logging me in as [EMAIL PROTECTED] (or more likely [EMAIL PROTECTED]), later I invoked mysql as follows: mysql -h localhost -u root to log in as the root. If you see my treads I was having problems with building temporary tables and was advised to set up a root user, turned out one was set up with the installation so I began using it.). When I started attempting to set up the multiple versions, Victoria Reznichenko directed me to the user manual and was attempting to set it up that way. I shut down the original mysql server and installed the mysql in the 4.1 Alpha folder group with the option mysqld-nt --install mysqld2 which was referenced per the manual in a file called my.cnf as follows: # options for mysqld2 service [mysqld2] basedir = C:/mysql-4.0.14 port = 3308 enable-named-pipe socket = mypipe2 It installed with no errors. Then it instructed I startup the servers as follows: NET START mysql NET START mysqld2 when I did that I got the response: The MySQL service started succesfully. and The mysqld2 service started succesfully. respectively. But when I attempt to invoke MySQL the response is: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) (BTW. When I came in today I found out that I could no longer connect to 4.1.0 either. When I left last night, I could connect to 4.1.0, but could no longer connect to 4.0.13. According to windows explorer the database files are still there, but for some reason mySQL can no longer point to them.) How I'm running the servers: they are services in Windows. Though I had nothing to do with that. The setup/install utility handled that for 4.0.13. Do I have to give them a unique name for 4.1.0 so Windows can distinguish 4.1 from 4.0? Better detail? Thanks for not giving up on me! George -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 12:59 PM To: Degan, George E, JR, MGSVC Cc: [EMAIL PROTECTED] Subject: RE: Can run two versions of MySQL in Windows 2000? At 6:32 -0500 7/23/03, Degan, George E, JR, MGSVC wrote: I'm sorry, I'm very new at this. I only downloaded the live version last week. Where do I find the setting you are referring to? By attempt to run the servers, perhaps this is a correct answer to your question: I am only using this for learning purposes. I am hoping to attain new skills and thought that SQL was a good place to start (since I believe it to be the base for many database languages (DBIV (or whatever version they're up to today, Oracle, Sybase, Peoplesoft, etc.) and perhaps if I lose my job this will broaden my choices in looking for a new position/career. If this is not a correct answer to your question, please clarify. It's not. I'll attempt to rephrase my questions. However, I will also suggest that if, as you say, you're very new at this, attempting to run multiple servers before you are comfortable with running a single server is not likely to be very easy. re: your setup: What version of Windows do you have? re: your settings: What options are you using to start the servers? (for example, are you passing options on the command line or storing them in an option file? If an option file, which one and what do its contents look like?) re: how you're running the servers: What command do you use to invoke the servers? Are you starting them from the command line, or installing them as services and running them that way? It is a good idea to explain exactly what you're doing, and to provide any relevant error messages that occur. (By that I mean the text of the error messages themselves -- not just a general description of the failure.) Thanks. Finally, thank you, I will change the name of the folder as you suggest. George -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 4:42 PM To: Degan, George E, JR, MGSVC; [EMAIL PROTECTED] Subject: RE: Can run two versions of MySQL in Windows 2000? At 14:15 -0500 7/22/03, Degan, George E, JR, MGSVC wrote: Thanks. I have been fighting with this all afternoon, now it seems I can get to 4.1.0 and not 4.0.13. My databases still seem to be there but I can't point to them either in mysql or in mysqlcc/DBManager. I guess I have moved port 3306 to the 4.1.0 database. How do I name, say, 3307 as the 4.0.13 database? First, you're better off not installing 4.1 (or any version) in a directory with a pathname that contains spaces. I suggest renaminng c:\4.1 Alpha to c:\4.1-Alpha. Second, tell us more about your setup. You're asking us to diagnose the problem with little more information than it doesn't work. What are your settings? How are you attempting to run the servers? Thanks. -Original
RE: Can run two versions of MySQL in Windows 2000?
At 13:01 -0500 7/23/03, Degan, George E, JR, MGSVC wrote: SETUP Windows 2000, Version 5.0 (build 2195, Service Pack 2) (In case it matters, I have about 20 GB available on my 40GB hard drive and 192MB of RAM) SETTINGS Prior to attempting to put on the second server, I wasn't using any options, which was logging me in as [EMAIL PROTECTED] (or more likely [EMAIL PROTECTED]), ODBC is the default user name that clients use on Windows. later I invoked mysql as follows: mysql -h localhost -u root to log in as the root. If you see my treads I was having problems with building temporary tables and was advised to set up a root user, turned out one was set up with the installation so I began using it.). When I started attempting to set up the multiple versions, Victoria Reznichenko directed me to the user manual and was attempting to set it up that way. I shut down the original mysql server and installed the mysql in the 4.1 Alpha folder group with the option mysqld-nt --install mysqld2 which was referenced per the manual in a file called my.cnf as follows: # options for mysqld2 service [mysqld2] basedir = C:/mysql-4.0.14 port = 3308 enable-named-pipe socket = mypipe2 Okay. You don't have any [mysqld] group for the other server, I take it? But that configuration is odd. It appears to apply to a 4.0.14 installation, yet you state that you're using it for your 4.1 installation. What installation directories are you now using for your two MySQL versions? It installed with no errors. Then it instructed I startup the servers as follows: NET START mysql NET START mysqld2 when I did that I got the response: The MySQL service started succesfully. and The mysqld2 service started succesfully. respectively. Okay, that looks good. When you open the Services Manager, I assume it shows lines for services named MySQL and mysqld2 and that they both have a status showing them to be running? But when I attempt to invoke MySQL the response is: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) Okay. What was the command you used here? What happens if you use this command: mysql -h localhost -P 3308 or this one: mysql -h . -S mypipe2 (BTW. When I came in today I found out that I could no longer connect to 4.1.0 either. When I left last night, I could connect to 4.1.0, but could no longer connect to 4.0.13. According to windows explorer the database files are still there, but for some reason mySQL can no longer point to them.) How I'm running the servers: they are services in Windows. Though I had nothing to do with that. The setup/install utility handled that for 4.0.13. Do I have to give them a unique name for 4.1.0 so Windows can distinguish 4.1 from 4.0? Yes. The Services Manager will show what the service names are. You may want to shut them down, remove them, and then start over. It may be that the presence of existing services is what's messing things up. To stop the services (assuming service names of svc-name-1 and svc-name-2): net stop svc-name-1 net stop svc-name-2 To remove them: mysqld --remove svc-name-1 mysqld --remove svc-name-2 Then start from the beginning, using the mysqld --install instructions in the manual. Better detail? Thanks for not giving up on me! Yes, much better detail. Thanks. George -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Can run two versions of MySQL in Windows 2000?
My responses are parenthesied in the text below. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 2:56 PM To: Degan, George E, JR, MGSVC Cc: [EMAIL PROTECTED] Subject: RE: Can run two versions of MySQL in Windows 2000? At 13:01 -0500 7/23/03, Degan, George E, JR, MGSVC wrote: SETUP Windows 2000, Version 5.0 (build 2195, Service Pack 2) (In case it matters, I have about 20 GB available on my 40GB hard drive and 192MB of RAM) SETTINGS Prior to attempting to put on the second server, I wasn't using any options, which was logging me in as [EMAIL PROTECTED] (or more likely [EMAIL PROTECTED]), ODBC is the default user name that clients use on Windows. (Thanks for the input) later I invoked mysql as follows: mysql -h localhost -u root to log in as the root. If you see my treads I was having problems with building temporary tables and was advised to set up a root user, turned out one was set up with the installation so I began using it.). When I started attempting to set up the multiple versions, Victoria Reznichenko directed me to the user manual and was attempting to set it up that way. I shut down the original mysql server and installed the mysql in the 4.1 Alpha folder group with the option mysqld-nt --install mysqld2 which was referenced per the manual in a file called my.cnf as follows: # options for mysqld2 service [mysqld2] basedir = C:/mysql-4.0.14 port = 3308 enable-named-pipe socket = mypipe2 Okay. You don't have any [mysqld] group for the other server, I take it? But that configuration is odd. It appears to apply to a 4.0.14 installation, yet you state that you're using it for your 4.1 installation. What installation directories are you now using for your two MySQL versions? (Sorry for the confusion, the my.cnf file had two parts to it, I only copied the part about mysqld2, didn't realize the first one was relevant. Here is the entire file (I copied the previous one from the manual, but I did actually run it with the correct directory names): # options for default service (MySql) [mysqld] basedir = C:/mysql port = 3306 enable-named-pipe socket = mypipe1 #options for default service (mysqld2) (mysqld2) basedir = c:\4.1 Alpha\mysql port = 3307 enable-named-pipe socket = mypipe2 It didn't seem to understand the line enable-named-pipe though as when I tried running the following files: my-opts1.cnf: [mysqld] basedir = C:/mysql port = 3306 enable named-pipe socket = mypipe1 my-opts2.cnf: [mysqld2] basedir = c:\4.1 Alpha\mysql port = 3307 enable-named-pipe socket = mypipe2 With these commands: mysqld --defaults-file=C:\my-opts1.cnf response: mysqld: ERROR: unknown option '--enable-named-pipe' mysqld-max --defaults-file=C:\my-opts2.cnf response: yesterday it gave a similar one to the above, though when I do it now it responds: 030723 15:09:02 Error message file 'C:\mysql\share\english\errmsg.sys' had only 237 error messages, but it should contain at least 255 error messages. Check that the above file is the right version for this program! 030723 15:09:02 when I invoke it from the folder of the old version. and: mysqld-max: Can't change dir to 'C:\4.1 Alpha\mysql\data\' (Errcode:2) 030723 15:15:06 Aborting 030723 15:15:06 mysqld-max: Shutdown Complete again per instructions from the manual. I have included the error messages when I attempted them above.) It installed with no errors. Then it instructed I startup the servers as follows: NET START mysql NET START mysqld2 when I did that I got the response: The MySQL service started succesfully. and The mysqld2 service started succesfully. respectively. Okay, that looks good. When you open the Services Manager, I assume it shows lines for services named MySQL and mysqld2 and that they both have a status showing them to be running? (Sorry, the Services Manager? I'm not sure what that is.) But when I attempt to invoke MySQL the response is: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) Okay. What was the command you used here? (just the same as before: mysql or mysql -h localhost -u root What happens if you use this command: mysql -h localhost -P 3308 or this one: mysql -h . -S mypipe2 (both give the following response: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061), and I tried several Ports, 3308, 3307, 3306, and 3309 in this order) (BTW. When I came in today I found out that I could no longer connect to 4.1.0 either. When I left last night, I could connect to 4.1.0, but could no longer connect to 4.0.13. According to windows explorer the database files are still there, but for some reason mySQL can no longer point to them.) How I'm running the servers: they are services in Windows. Though I had nothing to do with that. The setup/install utility handled that for 4.0.13. Do I have to give them a unique name for 4.1.0 so Windows can distinguish 4.1 from 4.0? Yes. The Services Manager will show what
Re[2]: Can run two versions of MySQL in Windows 2000?
Degan, jumping in to try and solve some problems that look pretty obvious to me ... #options for default service (mysqld2) (mysqld2) It should be [mysqld2], not (mysqld2). basedir = c:\4.1 Alpha\mysql As Paul pointed out, the blank in the path name is likely to cause problems (see below). my-opts2.cnf: [mysqld2] basedir = c:\4.1 Alpha\mysql Again, don't use a path that contains blanks. socket = mypipe2 As opposed to Unix, Windows doesn't know the concept of sockets (it uses named pipes instead). Named pipes, however, might cause problems with MySQL under Windows, so it's recommended not to use them, but rather use tcp/ip instead (that is why named pipes are disabled by default). You don't have to specify anything to use tcp/ip -- it's the default under Windows. (The above line in your configuration file is syntactically okay, but I'd recommend to delete it for the mentioned reasons. For MySQL 4.1, that should be protocol=mypipe2, anyway.) mysqld --defaults-file=C:\my-opts1.cnf response: mysqld: ERROR: unknown option '--enable-named-pipe' For the above given reasons, you shouldn't use named pipes. Get rid of the appropriate lines in your configuration files, and you'll get rid of that problem. 030723 15:09:02 Error message file 'C:\mysql\share\english\errmsg.sys' had only 237 error messages, but it should contain at least 255 error messages. Check that the above file is the right version for this program! 030723 15:09:02 when I invoke it from the folder of the old version. and: mysqld-max: Can't change dir to 'C:\4.1 Alpha\mysql\data\' (Errcode:2) Well, that error message says it, doesn't it? Avoid having blanks in your pathnames. Okay, that looks good. When you open the Services Manager, I assume it shows lines for services named MySQL and mysqld2 and that they both have a status showing them to be running? (Sorry, the Services Manager? I'm not sure what that is.) On Windows 2000, you can open the Services Manager window as follows: Start Settings Control Panel Administration Services In that window you see a list of Windows services, and you should find two MySQL-related services running. But when I attempt to invoke MySQL the response is: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) Okay. What was the command you used here? (just the same as before: mysql or mysql -h localhost -u root What happens if you use this command: mysql -h localhost -P 3308 or this one: mysql -h . -S mypipe2 (both give the following response: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061), and I tried several Ports, 3308, 3307, 3306, and 3309 in this order) All that means that the MySQL server you are trying to connect to isn't running. You can check in the Services Manager window, now that you know how to find that :) (BTW. When I came in today I found out that I could no longer connect to 4.1.0 either. When I left last night, I could connect to 4.1.0, but could no longer connect to 4.0.13. According to windows explorer the database files are still there, but for some reason mySQL can no longer point to them.) Once again, check in the Services Manager window and make sure the MySQL servers are actually running. I can only guess, but it looks as though they are not started at system startup (Start type: automatic). net stop svc-name-1 net stop svc-name-2 To remove them: mysqld --remove svc-name-1 mysqld --remove svc-name-2 Then start from the beginning, using the mysqld --install instructions in the manual. (So I don't have to Uninstall them in windows since they are now services? Or does this have the same effect?) I'd suggest you to get familiar with the Windows services concept. Services are, uh, services that can start and stop software programs (like the MySQL server). Rather than starting the software manually, you'd set up a service that does that (and can do that automatically, e.g. at system startup). Windows (NT, 2000, XP) usually uses services to start software that runs in the background, like the MySQL server. Unlike software, you don't uninstall a service, you _remove_ it, so it won't be there anymore to start the software program it's supposed to start. For the MySQL server, that's done with the mysqld --remove servicename command. Hope that helps. Regards, -- Stefan Hinz [EMAIL PROTECTED] iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can run two versions of MySQL in Windows 2000?
I have been running 4.0.13 for several weeks now and though I'd like to test 4.1.0. 4.0.13 is under c:\MySQL. I downloaded 4.1.0 under c:\4.1 Alpha\MySQL. When I try to launch mysql it brings me to the old version, how do I access the new one without killing the old one? (I have also tried putting 4.1.0 on a totally different machine and linking to it also.) George -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can run two versions of MySQL in Windows 2000?
Degan, George E, JR, MGSVC [EMAIL PROTECTED] wrote: I have been running 4.0.13 for several weeks now and though I'd like to test 4.1.0. 4.0.13 is under c:\MySQL. I downloaded 4.1.0 under c:\4.1 Alpha\MySQL. When I try to launch mysql it brings me to the old version, how do I access the new one without killing the old one? (I have also tried putting 4.1.0 on a totally different machine and linking to it also.) Yes, you can find info about it at: http://www.mysql.com/doc/en/Multiple_Windows_servers.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Can run two versions of MySQL in Windows 2000?
Thanks. I have been fighting with this all afternoon, now it seems I can get to 4.1.0 and not 4.0.13. My databases still seem to be there but I can't point to them either in mysql or in mysqlcc/DBManager. I guess I have moved port 3306 to the 4.1.0 database. How do I name, say, 3307 as the 4.0.13 database? -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 12:00 PM To: [EMAIL PROTECTED] Subject: Re: Can run two versions of MySQL in Windows 2000? Degan, George E, JR, MGSVC [EMAIL PROTECTED] wrote: I have been running 4.0.13 for several weeks now and though I'd like to test 4.1.0. 4.0.13 is under c:\MySQL. I downloaded 4.1.0 under c:\4.1 Alpha\MySQL. When I try to launch mysql it brings me to the old version, how do I access the new one without killing the old one? (I have also tried putting 4.1.0 on a totally different machine and linking to it also.) Yes, you can find info about it at: http://www.mysql.com/doc/en/Multiple_Windows_servers.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Can run two versions of MySQL in Windows 2000?
At 14:15 -0500 7/22/03, Degan, George E, JR, MGSVC wrote: Thanks. I have been fighting with this all afternoon, now it seems I can get to 4.1.0 and not 4.0.13. My databases still seem to be there but I can't point to them either in mysql or in mysqlcc/DBManager. I guess I have moved port 3306 to the 4.1.0 database. How do I name, say, 3307 as the 4.0.13 database? First, you're better off not installing 4.1 (or any version) in a directory with a pathname that contains spaces. I suggest renaminng c:\4.1 Alpha to c:\4.1-Alpha. Second, tell us more about your setup. You're asking us to diagnose the problem with little more information than it doesn't work. What are your settings? How are you attempting to run the servers? Thanks. -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 12:00 PM To: [EMAIL PROTECTED] Subject: Re: Can run two versions of MySQL in Windows 2000? Degan, George E, JR, MGSVC [EMAIL PROTECTED] wrote: I have been running 4.0.13 for several weeks now and though I'd like to test 4.1.0. 4.0.13 is under c:\MySQL. I downloaded 4.1.0 under c:\4.1 Alpha\MySQL. When I try to launch mysql it brings me to the old version, how do I access the new one without killing the old one? (I have also tried putting 4.1.0 on a totally different machine and linking to it also.) Yes, you can find info about it at: http://www.mysql.com/doc/en/Multiple_Windows_servers.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql and windows 2003
Wy can't I start the service in windows 2003 server have any one a solusion? Pleas help Ivo tompert
Compiling MySQL on Windows
I get the last bk tree of mysql and want to compile on windows... i have the VC++ 6.0 whith SP5 and PROCESSOR PACK... but i try to compile using the Vc++Files directory and the MySQL print an error... what is the steps to compile on windows the LAST BK TREE ? Tnks... - ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento - E S C R I B A I N F O R M A T I C A - The only stupid question is the unasked one (somewhere in Linux's HowTo) Linux registred user : #230601 --ICQ : 1647350 $ look into my eyes Phone : +55 041 296-2311 look: cannot open my eyes Fax : +55 041 296-6640 - Reply: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Compiling MySQL on Windows
At 10:40 07-07-2003 -0300, Dyego Souza do Carmo wrote: Hi, I get the last bk tree of mysql and want to compile on windows... i have the VC++ 6.0 whith SP5 and PROCESSOR PACK... but i try to compile using the Vc++Files directory and the MySQL print an error... what is the steps to compile on windows the LAST BK TREE ? - First compile it on Linux. - If you are compiling the 4.1 tree there is a script for to prepare the Windows source scripts/make_win_src_distribution.sh otherwise copy the tree on windows drive and rename the files *.cc to *.cpp and put in place the VC++ *.dsw and *.dsp projects files. - Left blank the innobase\ib_config.h file. - Compile it. -- Regards, For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ Miguel Angel Solórzano [EMAIL PROTECTED] São Paulo - Brazil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Latest version of MySQL for windows
What's the latest version of MySQL for windows? Mysql.com says it's 4.1 alpha but the download that reads 4.1 alpha is actually 4.0.12. Is there no version 4.1 available for Windows? Many thanks, rajendra Unless expressly stated to the contrary, the views expressed in this email are not necessarily the views of National Grid Transco plc or any of its subsidiaries or affiliates (Group Companies), and the Group Companies, their directors, officers and employees make no representation and accept no liability for its accuracy or completeness. This e-mail, and any attachments are strictly confidential and intended for the addressee(s) only. The content may also contain legal, professional or other privileged information. If you are not the intended recipient, please notify the sender immediately and then delete the e-mail and any attachments. You should not disclose, copy or take any action in reliance on this transmission. You may report the matter by calling us on + 44(0) 1455 230999 Please ensure you have adequate virus protection before you open or detach any documents from this transmission. The Group Companies do not accept any liability for viruses. An e-mail reply to this address may be subject to monitoring for operational reasons or lawful business practices. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Latest version of MySQL for windows
Losing your mind, perhaps? http://www.mysql.com/downloads/download.php?file=Downloads%2FMySQL-4.1%2Fmysql-4 .1.0-alpha.zipmirror=http%3A%2F%2Fmysql.secsup.org%2F Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, 13 June, 2003 11:57 Subject: Latest version of MySQL for windows What's the latest version of MySQL for windows? Mysql.com says it's 4.1 alpha but the download that reads 4.1 alpha is actually 4.0.12. Is there no version 4.1 available for Windows? Many thanks, rajendra Unless expressly stated to the contrary, the views expressed in this email are not necessarily the views of National Grid Transco plc or any of its subsidiaries or affiliates (Group Companies), and the Group Companies, their directors, officers and employees make no representation and accept no liability for its accuracy or completeness. This e-mail, and any attachments are strictly confidential and intended for the addressee(s) only. The content may also contain legal, professional or other privileged information. If you are not the intended recipient, please notify the sender immediately and then delete the e-mail and any attachments. You should not disclose, copy or take any action in reliance on this transmission. You may report the matter by calling us on + 44(0) 1455 230999 Please ensure you have adequate virus protection before you open or detach any documents from this transmission. The Group Companies do not accept any liability for viruses. An e-mail reply to this address may be subject to monitoring for operational reasons or lawful business practices. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mySQL on Windows 2000 Server
Not only is MySQL a native Win2k app, but it also runs as a NT-Service... Bernhard - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 28, 2003 2:34 PM Subject: re: mySQL on Windows 2000 Server On Friday 28 March 2003 11:23, Neil Tompkins wrote: Has anyone installed mySQL on Windows 2000 server, can you tell me your experiences, or should I look for another option ? MySQL is a native win32 application and runs excellent on Win2k. It's a good choice. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mySQL on Windows 2000 Server
I am running MySQL on both NT4 and Win2K servers across a 64k WAN with over 600 users at 60 geographical sites - It rocks !!! Jeff - Original Message - From: Bernhard Döbler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 7:34 PM Subject: Re: mySQL on Windows 2000 Server Not only is MySQL a native Win2k app, but it also runs as a NT-Service... Bernhard - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 28, 2003 2:34 PM Subject: re: mySQL on Windows 2000 Server On Friday 28 March 2003 11:23, Neil Tompkins wrote: Has anyone installed mySQL on Windows 2000 server, can you tell me your experiences, or should I look for another option ? MySQL is a native win32 application and runs excellent on Win2k. It's a good choice. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mySQL on Windows 2000 Server
Hi, I'm looking to purchase my own dedicated server. As standard it doesn't come with any database support. I was considering installing mySQL. At the moment I have mySQL running on Windows 2000 professional and everything looks OK at the moment. Has anyone installed mySQL on Windows 2000 server, can you tell me your experiences, or should I look for another option ? At the moment we use mySQL on linux, but my linux knowledge is limited and Win2K server is my best option. Thanks for any comments. Kind regards, Neil Tompkins _ Get Hotmail on your mobile phone http://www.msn.co.uk/msnmobile/mobilehotmail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re: mySQL on Windows 2000 Server
On Friday 28 March 2003 11:23, Neil Tompkins wrote: Has anyone installed mySQL on Windows 2000 server, can you tell me your experiences, or should I look for another option ? MySQL is a native win32 application and runs excellent on Win2k. It's a good choice. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mySQL on Windows 2000 Server
Neil: MySQL on Windows 2000 Server is excellent. We have installed about client 80 systems that incorporate MySQL. Some are running on Unix, some Linux, about a third on Windows NT Server, and the balance (40+ systems) are running on either Windows 2000 Server or Win2K Advanced Server. We have never had a burp that was traceable to MySQL. If we encounter any problems (which occurs seldom), it is almost always traceable to poor network administration, lack of proper network security, or failure to follow instructions. Gerald Jensen - Original Message - From: Neil Tompkins [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 28, 2003 3:23 AM Subject: mySQL on Windows 2000 Server Hi, I'm looking to purchase my own dedicated server. As standard it doesn't come with any database support. I was considering installing mySQL. At the moment I have mySQL running on Windows 2000 professional and everything looks OK at the moment. Has anyone installed mySQL on Windows 2000 server, can you tell me your experiences, or should I look for another option ? At the moment we use mySQL on linux, but my linux knowledge is limited and Win2K server is my best option. Thanks for any comments. Kind regards, Neil Tompkins _ Get Hotmail on your mobile phone http://www.msn.co.uk/msnmobile/mobilehotmail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mySQL on Windows 2000 Server
Hi, I have MySQL running on a machine at work and a (dev) machine at home. Both machines are running W2K. The machine at home is an old PIII with 256Meg of memory, the machine at work is a new P4 2.0GHz with 512Meg of memory. My home machine also has a heavier load relative to the CPU than my machine at work. However, my machine at home executes MySQL faster than my machine at work. In my case it is not the W2K environment itself that is the problem it is another component interfering with MySQL. I suggest that if you ever have problems with MySQL performance on W2K you look to see what you can uninstall as MySQL on W2K is not the issue. BTW, I eventually solved my problem at work by moving MySQL over to a Linux box. That actually gave me better performance than my W2K box at home. John Griffin -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2003 7:34 AM To: [EMAIL PROTECTED] Subject: re: mySQL on Windows 2000 Server On Friday 28 March 2003 11:23, Neil Tompkins wrote: Has anyone installed mySQL on Windows 2000 server, can you tell me your experiences, or should I look for another option ? MySQL is a native win32 application and runs excellent on Win2k. It's a good choice. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL on windows
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi I am used to using/accessing MySQL on Unix, but I have to write a small client application on Windows, to record and log activity to a remote MySQL database. The options that I have appear to be - - Perl + DBI+DBD-ODBC - - Perl + DBI+DBD-mysql - - Visual C++ + ODBC - - Visual C++ + MySQL++ can anyone advice me on the best to use, for stability, and no memory leaks etc. Many thanks Simon - -- Simon Windsor Email: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07720 447385 -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE+Wg/bSJvgVrMNWjYRAkNvAJ0VKk1D0t7EOEigG3FssqK1ahEz3wCdEvXd H7oZniZ/Ay5Yyk/jPMbAhUE= =rOZS -END PGP SIGNATURE- - 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 windows
Hi Simon, The options that I have appear to be - - Perl + DBI+DBD-ODBC - - Perl + DBI+DBD-mysql - - Visual C++ + ODBC - - Visual C++ + MySQL++ What about Java + JDBC? Rob :) - 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 windows
Depends on what you are experienced with on win platform I would of thought. Something like vB or Delphi is very quick and easy to use. Jerry - Original Message - From: Simon Windsor [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 24, 2003 12:28 PM Subject: MySQL on windows -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi I am used to using/accessing MySQL on Unix, but I have to write a small client application on Windows, to record and log activity to a remote MySQL database. The options that I have appear to be - - Perl + DBI+DBD-ODBC - - Perl + DBI+DBD-mysql - - Visual C++ + ODBC - - Visual C++ + MySQL++ can anyone advice me on the best to use, for stability, and no memory leaks etc. Many thanks Simon - -- Simon Windsor Email: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07720 447385 -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE+Wg/bSJvgVrMNWjYRAkNvAJ0VKk1D0t7EOEigG3FssqK1ahEz3wCdEvXd H7oZniZ/Ay5Yyk/jPMbAhUE= =rOZS -END PGP SIGNATURE- - 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://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 windows
In my experience, Perl + DBD-mysql will be the most easy tool for UNIXer (Linuxer). Especially, if you plan to write some non-GUI based system service program. Best regards, KH Depends on what you are experienced with on win platform I would of thought. Something like vB or Delphi is very quick and easy to use. Jerry - Original Message - From: Simon Windsor [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 24, 2003 12:28 PM Subject: MySQL on windows -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi I am used to using/accessing MySQL on Unix, but I have to write a small client application on Windows, to record and log activity to a remote MySQL database. The options that I have appear to be - - Perl + DBI+DBD-ODBC - - Perl + DBI+DBD-mysql - - Visual C++ + ODBC - - Visual C++ + MySQL++ can anyone advice me on the best to use, for stability, and no memory leaks etc. Many thanks Simon - -- Simon Windsor Email: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07720 447385 -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE+Wg/bSJvgVrMNWjYRAkNvAJ0VKk1D0t7EOEigG3FssqK1ahEz3wCdEvXd H7oZniZ/Ay5Yyk/jPMbAhUE= =rOZS -END PGP SIGNATURE- - 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://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Yours, KH Chiu CA Computer Consultants Ltd. Tel: 3104 2070 Fax: 3010 0896 Email: [EMAIL PROTECTED] Website: www.caconsultant.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
Re: MySQL on windows
As I said, all depends on what you are used to , as to which is going to be the least painful path. Jerry - Original Message - From: KH Chiu [EMAIL PROTECTED] To: Jerry [EMAIL PROTECTED]; Simon Windsor [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, February 24, 2003 1:18 PM Subject: Re: MySQL on windows In my experience, Perl + DBD-mysql will be the most easy tool for UNIXer (Linuxer). Especially, if you plan to write some non-GUI based system service program. Best regards, KH Depends on what you are experienced with on win platform I would of thought. Something like vB or Delphi is very quick and easy to use. Jerry - Original Message - From: Simon Windsor [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 24, 2003 12:28 PM Subject: MySQL on windows -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi I am used to using/accessing MySQL on Unix, but I have to write a small client application on Windows, to record and log activity to a remote MySQL database. The options that I have appear to be - - Perl + DBI+DBD-ODBC - - Perl + DBI+DBD-mysql - - Visual C++ + ODBC - - Visual C++ + MySQL++ can anyone advice me on the best to use, for stability, and no memory leaks etc. Many thanks Simon - -- Simon Windsor Email: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07720 447385 -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE+Wg/bSJvgVrMNWjYRAkNvAJ0VKk1D0t7EOEigG3FssqK1ahEz3wCdEvXd H7oZniZ/Ay5Yyk/jPMbAhUE= =rOZS -END PGP SIGNATURE- - 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://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Yours, KH Chiu CA Computer Consultants Ltd. Tel: 3104 2070 Fax: 3010 0896 Email: [EMAIL PROTECTED] Website: www.caconsultant.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 - 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 Windows XP (Pro)
Dan Cumpian [EMAIL PROTECTED], Do you think the following links may help? * http://www.mysql.com/doc/en/ODBC.html * http://www.mysql.com/doc/en/Contrib.html * http://www.mysql.com/doc/en/Windows_client_compiling.html * http://www.mysql.com/doc/en/Windows.html * http://www.mysql.com/doc/en/Win95_start.html This was an automated response to your email 'MySQL and Windows XP (Pro)'. Final search keyword used to query the manual was 'Windows XP (Pro)'. Feedbacks, suggestions and complaints about me should be directed to [EMAIL PROTECTED] - 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 Windows XP (Pro)
I have an application that works just fine on a local MySQL database when it is running on W2K or Windows XP Home. However, on Windows XP Pro, the application has problems keeping its connection to the server. Has anyone else seen this and is there a known cause or fix? Weve tried this on more than one XP Pro setup and have seen the same results. MySQL versions: 3.23.52, 3.23.53, 3.23.54 Database connection is using Zeos Database Objects through a Delphi application. The application has five separate database connections each in individual threads. Thank you, Dan Cumpian - 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
setting up mysql for windows...
i'm trying to set mysql up on windows 2000, and having some problems. i download file and installed. what do i have to do to get it running. never done it on windows just linux _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail - 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: setting up mysql for windows...
try running winmysqladmin.exe under mysql folder lewell The content of this email when sent is as full as practical. Due to the settling of the words the contents might not appear as full as it was but the weight remains the same. The contents is being sent by weight and not by volume. - Original Message - From: Stick Dragon [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 30, 2003 9:28 AM Subject: setting up mysql for windows... i'm trying to set mysql up on windows 2000, and having some problems. i download file and installed. what do i have to do to get it running. never done it on windows just linux _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail - 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://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