Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
 
  HOME    TRACKER    MYSQL




MySQL On Windows


when i try to install mysql on my pc it works just fine until i'm near the end of the installation, the installer writes:

the security settings could not be applied
error number 2003
can't connect to mysql server on 'localhost' (10061)

i have disable my firewall... so whats the problem then..? please make an easy explanation... i'm not that good at english so i hope that you understand me...




View Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread
MySQL On Windows
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?

Mysql 4.0.20a For Windows
i installed just a few days ago the new my sql 4.0.20a server on a Windows Machine

and heart about that the feature "auto_increment = default value" will work now

now i created a new table added some fields and one field shoud be auto_increment and shoud have a default value (which means, mysql shoud then auto_increment up from the given value), but this doesn't work

i can only choose between default value or auto_increment but not both any ideas ?

MySQL 4 And Windows XP
I am having problems running mysql 4 on windows xp. Mysql 3 works fine.
However version 4 won't run. Even if I start the server with the admin panel
it shuts down again after a couple of seconds. This has only been a problem
since I wiped my hard drive and did a clean install of everything.

MySQL 5.0 On Windows 98 SE
I just downloaded MySQL 5.0 and installed it on a machine that I just did a fresh install of Windows 98 Second Edition on.

The install seemed to go smoothly, and when it was done I try to start mysqld from the command line and get this:

C:Program FilesMySQLMySQL Server 5.0in>mysqld --console
051125 21:04:07 [ERROR] Can't find messagefile 'C:Program FilesMySQLMySQL Ser
ver 5.0shareenglisherrmsg.sys'
051125 21:04:07 [ERROR] Aborting

Also, when I look in the above referenced directory, the file errmsg.sys is there: Code:

Mysql On IIS Windows
I very new to mysql. I would like to get some advise on which release i should install in my windows 2000 server using IIS.

MYSQL In Windows XP Pro Sp2
i get a ERROR 0 when loading the program into my computer. and the servise could not be started, if i go into cmd and type "Net start MYSQL" it says sucsessfull

but when i go into Contrl panel > Administrtor tools > Servise's and click MYSQL it says "error 1067 could be be started"

Can I Use MySQL With A Mac And Windows
I need to share a MySQL database with a guy that uses a Mac, but I don't know anything about the Mac environment. I use WinXP. He has a server that has MySQL loaded on it. I want to create the database, then both of us want to be able to access it or make changes to it via the web.

What type of products do I need? I figure a good MySQL reference book is a necessity. Is there some type of front end application that he can run. I think I can run Access as a front end once it is set up properly. Am I making sense?

MySQL 4 And Windows XP
I am having problems running mysql 4 on windows xp. Mysql 3 works fine.
However version 4 won't run.

Even if I start the server with the admin panel
it shuts down again after a couple of seconds. This has only been a problem
since I wiped my hard drive and did a clean install of everything.

MySQL On Windows
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?.tw

Mysql On A Windows Box
there are two options for mysql when it comes to windows...there is a 'windows essentials' and then there is the normal download.
the documentation says the essentials package, (it's almost half the size) is the recommended one because it has all that is needed.
i don't really care if i download the biggest file size, but if i don't need to, i'll take the smaller package.

Upgrading MySQL On Windows/IIS- Help?
I am running MysQL Version 3.23.49 on a Windows IIS machine. I need to upgrade it to at least 4.0.16 (to install vBulletin 3.6).

Is there a good tutorial on how to do this? I look at the documentation on the MySQL site but I'm hoping there is more out there to help me.

As well, the docs say instead of upgrading to V5 I should upgrade to V4 instead. I'd like to have the most up to date MySQL if I can so I won't have to do the another upgrade for a while.

Mysql, Linux Or Windows?
Does mysql work on windows or it has to be on linux only?

MySQL / Windows XP SP2 Incompatibility
I've been posting the problem earlier on Microsoft newsgroups (cannot use support, because of using OEM Windows):

Windows XP SP2 Security Center stops recognizing antivirus and firewall software when I install MySQL server and GUI tools (MySQL Administrator and MySQL Query Browser).

The only way to make the Security Center recognize the software again is to restart it using Services snap-in.

Is it a bug on Microsoft side or on MySQL team side? Are there any solutions for the problem?

Configuration:
Intel Celeron 1200 MHz / 512 MB RAM
Windows XP Home Edition with Service Pack 2
MySQL 4.1 with the latest versions of GUI tools

Cannot Get MYSQL To Start In Windows
Here are some of the errors I receive when trying to start mysql under windows xp home edition:

When I goto mysql command line client the client start but If I hit a button it shuts down.

When I type this:
C:>"C:Program FilesMySQLMySQL Server 5.0inmysql" test
ERROR 2013 (HY000): Lost connection to MySQL server during query

Or I try this:
C:>"C:Program FilesMySQLMySQL Server 5.0inmysqld" --console
060323 12:18:24 InnoDB: Operating system error number 32 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/mysql/en/Operating_System_error_codes.html
InnoDB: File name .ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
C:>

Also while trying to install I cannot get the security setting to go thru, it give me the error 2013, lost server during query, I've tried to shut off my firewall and still the same, given access to port 3306 and still nothing.

Mysql And Windows 2003
does the latest versions of Mysql work with windows 2003.

Used Mysql On Windows Now Im On Linux Need Help!
Ok iv changed over to linux running ubuntu 6.06 after installing mysql i tried create a database i did "CREATE DATABASE forums" and got this:

./mysqladmin: CREATE DATABASE failed; error: 'Access denied for user ''@'localhost' to database 'DATABASE''

so how do i logging as root? on windows i just used the terminal thing but now i dont have that (well to the point where it asks you to login)

Does MySQL Work On Windows?
I've been trying to get 3.23 to behave on '98. MATCH seems very erratic, and FULLTEXT never works. RELOAD silently fails. Is it worth it to pursue MySQL on Windows?

Install MySQL 4.1 On Windows
I'm trying to install the 4.1 alpha binary version on Windows.

After unzipping the download I don't find a setup.exe file.

MySQL 5.0.45 Windows Install
I am having an issue installing MySQL 5.0.45 on Windows 2003 (VMware). Basically, I extracted the contents of "mysql-5.0.45-win32.zip" to c: emp and double-clicked the setup.exe. However, the install wizard doesn't launch. I get a window with the install options via CLI.

Mysql Dump And Windows
I have installed mysql on windows.

However, due to database corruption issues I would like to perform a backup every hour or so. As a result I plan to schedule a mysql dump at regular intervals(for example using the AT command). The problem is that the user that runs mysql dump has to supply the password. ie: myslqdump -u user -p databasename > backup.sql

My question is: how do I specify (in a .cmd file) the password to enter after the mysql command above? I do not think "echo password" is enough for mysql to pick up the password.

MySQL Server For Windows
I have Windows-2000 Server with IIS-5.0, PHP (4.3.0) and MySQL (3.23.55).
There are about 4000 users with their MySQL databases. Users can access databases using their PHP scripts. Only local users are allowed.

To create a user I use this command:
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON `User_database` . * TO 'User'@'localhost' IDENTIFIED BY 'Pass';

The problem: after 3-4 hours of work, all users getting the error message: "Can't connect to MySQL database at localhost (10061)".

I can't connect to MySQL using mysql.exe with admin username and password too!
But MySQL service is still running! Restarting of MySQL service gives no result. Restarting of IIS gives no result. Code:

MySQL 3.23 Windows Access
I am trying to set up an Invision Board forum on my windows 2003 RC2 server. I have already set up and configured PHP4. I am now in the process of setting up mySQL. I have never used it, so you can imagine how confused I feel right now.

I installed the 3.23 windows version on C:mySQL
I do not know how to access it, nor really how to use it.

The invision board is asking me to input

SQL Database Name
SQL Username
SQL Password

How do I createaccess this information.
Thank you for your help.

BTW: I recive this error while attempting to connect to my sql via cmd.exe

"ERROR 2003: Cant connect to my SQL server on Local Host (10061)"

I have two firewalls, XP's built in one and Norton Internet Security. Could this be the reason.

Windows App To MySql Table
I have a C++ Builder APP that uses the Advantage database. I want to export
data from the Advantage tables to a MySQL database on my website.

What is the best way to get my data into the MySQL table ? I am only
looking at 10-15 records, but I would be updating every 10 seconds or so.

I could create a text file and upload it via FTP, and then a PHP script
could load the text file into MySQL, but I am sure you guys know a better
way to do it.

MySQL Slow In Windows NT4
I am running the Apache web server, MySQL v4, and PHP on an NT4 server.
Apache runs great, but the auction software I am using (Web2035 Auction
software written in PHP) is very, very slow.

Sometimes it takes 20-30 seconds to bring up an auction page from the items
table which has less than 200 records in it.

Can anyone can give me some pointers on where to start looking? (I don't
know if the bottleneck is with MySQL or PHP or what I might need to look at
to enhance the performance of either package.)

Is Mysql For Windows Free?
I saw in a site that says "mysql for windows is free for one month to continue using it you must get a license". I was planning to use mysql on windows for company database I thought mysql windows version is free. Am I have to use on the linux for free solution?

Windows MySQL Questions
After installing on Windows XP, is WinMySQLAdmin.exe (WMA) the only way to start MySQL?

WMA is supposed to add a user and password to the "grant" tables. Altho it does appear in the My.ini file, if I do this:

Mysql -u root
Use mysql;
Select user,host from user;
it prints:

USER--------HOST      
(blank)     build
root        build
(blank)     localhost
root        localhost

Why does the user name that shows in My.ini not show here?
(I cannot connect with that user name.)

What is the "build" host?

If MySQL is on a pc for development, and it has access to the internet, does the internet have access to the server? Do I need to be concerned about security in the same way as a web hosting server? I'm the only person who operates this pc.

Does the statement "The MySQL server should not run as the root user." refer to Windows? If yes, how is it run as a non-root user?

Loading Mysql On A Windows - IIS
I have a personal web server (IIS) that i am trying to install mysql with...or install mysql so that it is available through my IIS server.

I d/l it...now what? is there a GUI for mysql that i can use? a gui like access or something. if i create databases in mysql at home, how do i get them on a ISP server...

MySQL 4.1 Windows Binary
I can't seem to find a binary distribution of mysql 4.1. Can some one
tell me if there is one and where to get it? Or is it not as simple as
finding a setup.exe?

Installation Of Mysql 4.0.14 On Windows Xp
I am new to mysql server and trying to install the mysql server on my
windows xp home edition. I have downloaded 4.0.14 zip file on my computer.
I can unzip the file and it generates 10-15 files. When I do double click on
the setup.exe it loads for 5 seconds and then stops. No window is displayed.
No error message is generated.

I thought may be I should try some other version. I downloaded older version
4.0.13 and same thing here. I downloaded 3.23.57 and same thing here.
I am logged in as administrator. I can install other softwares without any
problem. Can you please suggest any thing I should try to install the mysql
server.

Mysql On Windows Servers
Will mysql work with microsoft server products? Does it lose any funtionality? Would it be better to use mssql?

Mysql, Linux Or Windows
Does mysql work on windows or it has to be on linux only?

Doubt In MySQL Windows
I tried to insert some large amount of text in mysql and used "Long Text" data type.

But I am not able to insert a text that is having about 1.2 million characters in it.

It is showing an error: "DBD::mysql::st execute failed: Got a packet bigger than
'max_allowed_packet' bytes".

I used PERL script for database population and using Windows 2000 OS with pentium 2.4 Ghz Processor and 512 MR RAM.

Anyone kindly tell me how to change the value for the max_allowed_packets variable in windows environment.

MySQL 4.1 With OpenSSL On Windows
trying to setup MySQL with OpenSSL support, I realized that I have to compile it my-
self from the src package - where I've already glanced inside but found that there is
very few info on how to build against OpenSSL libraries (planned to use v0.9.8a).

Especially, I'm missing any Win32-related topics that are equivalent to the
"./configure --with-openssl --with-vio" advice as required when building under Linux.

2 little questions:

Will it be sufficient to put the OpenSSL .lib and .include folders into the compiler
environment to obtain an SSL-ready version of MySQL?

And, is there a chance to compile it with MS VC++ 6.0 Enterprise Edition (patched
with all available support packs)? If not, I'll have to ask my colleagues if anybody
has VC++ 7 on his machine.

Mysql And Windows 2003
------=_NextPart_000_0001_01C34BC2.26B3C4C0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Wy can't I start the service in windows 2003 server have any one a solusion?

MySQL For Windows Problems
I need help installing MySQL on my Windows XP Home computer.

I use the Apache 2 server and i have the newest version of PHP already installed, but I cant get MySQL to work. I used to get the error message about the 3.51 Driver being missing, so I installed the ODBCConnector 3.51 Driver, and now it says the Driver Version, Driver, API Level, Setup, and SQL Level on winmysqladmin instead of the error. But, when I go to start the server, the light goes green for about 4 seconds and then goes red again. I found an article here that said something about a connection string ( http://www.codingforums.com/showthread.php?t=22671&page=2&pp=15 ) but I cant figure out where that is or how I change it. Can someone please help me figure this out? :)

MySQL On Windows 2000
I am migrating my web enabled Access dbs to MySQL.
I am using ASP on my development machine running Win 2000 professional with IIS and MySQL.When I attempt to run queries on my development machine, against the MySQL databases they run like a dog!! My Access databases flew compared to MySQL. I'm not expecting blistering performance, but it's taking minutes to access tables with under 20 rows.However, when I upload to my hosting company, everything is fine.
Can anyone give my ideas how I can tune my developmet machine speed up the queries?

Compiling MySQL On Windows With Gcc
Simple question: Can you complile and run MySQL on windows using gcc? Why/why not and what problems would I encounter if successful?

MySQL And Windows Firewall
I have a small network with a handful of workstations running off one server. (It's an older tower powered currently by Win XP...Upgrading soon to a new server, but until then I have to use what I have)All stations need and have access to MySQL. I use the default Windows Firewall install to help filter traffic to all other ports not needed. I also run our webserver (pages built with php and powered by MySQL) and SSL server from the same tower. So currently the only open 2 ports are 80 and 443.
From both a networking and security standpoint, should I add MySQL to the exceptions list? Connections seem to work fine without it added.

Need MYSQL Software For Windows
could anyone please send me the mysql download links for windows xp.

MySQL 4.1 Windows Binary
I can't seem to find a binary distribution of mysql 4.1. Can some one
tell me if there is one and where to get it? Or is it not as simple as
finding a setup.exe?

Windows Mysql Backup
what the command is to backup a mysql database on windows.  I tried to do a search for this in the forms but I kept getting error 404.

MySQL MS Windows GUI Data
I am learning starting to learn the MySQL software. I need to know is there a end user interface tool, like MS Access, which I can use to create/delete tables, generate reports, and allow end user to input datas in GUI application.

MySQL Compile On Windows
First time I entered in VS as a VC++ 2005 workspace.
I opened mysql.dsw from the source package version 5.0.19 [general release]. At the beginning, it asked me if I want to convert this project from an earlier version (2003 I suppose) to VS 2005, I sayed OK... then, all kinds of error messages appeared:

Cannot load the project due to a corrupt project file.

Installation Of Mysql 4.0.14 On Windows Xp
I have downloaded 4.0.14 zip file on my computer.
I can unzip the file and it generates 10-15 files. When I do double click on
the setup.exe it loads for 5 seconds and then stops. No window is displayed.
No error message is generated.
I thought may be I should try some other version. I downloaded older version
4.0.13 and same thing here. I downloaded 3.23.57 and same thing here.
I am logged in as administrator. I can install other softwares without any
problem. Can you please suggest any thing I should try to install the mysql
server.

Windows Service For MySQL
Im trying to install MySQL on a XP Pro SP1a machine. It wont start the service from the installer. I go to start the service manually, and it fails as well. It says "Error 1067. The process terminated unexpectedly."

How To Run MYSQL Script Like Mysql.sql From The Command Line In Windows
Can anyone tell me how to run a script from the command line in Windows?

I was able to create a database and would like to run the script to add the tables from the command line.

Import Dump From Unix Mysql To Windows Mysql
I am trying to load a dump from a MySQL database on my ISP's server to my development environment on a Win 2K machine (running MySQL). When I run the mysql command to run the load script, MySQL gives the following complaint:

"ERROR 1064 at line 21: You have an error in your SQL syntax. Check the manual t
hat corresponds to your MySQL server version for the right syntax to use near 'D
EFAULT CHARSET=latin1' at line 7"

The dump from the ISP's server is created using mysqldump. The ISP is running MySQL 4.1.20. My development environment is MySQL 4.0.26. I have no problem loading dumps made from my development environment usng phpmyadmin.

Migrating Data From MySql(Windows) To Mysql (Solaris)
I am running mySql 5.0 on windows and i plan to migrate to Solaris, i have install the MySql 5 on solaris 10. Please how do i transfer all my Data, and i was wondering if there is a Data File That includes all my data that i can just copy over to the new system.

How To Set Affinity For MySQL On Windows Server
Is there a way to permanently set the affinity of mysql on a Windows Server?


Copyright © 2005-08 www.BigResource.com, All rights reserved