MYSQL :: Connect From Windows Computers

Mysql Windows Connect Error 2003
i installed mysql 4 on windows xp. everything is working quite well except to one thing:

connecting to the server using "mysql administrator" works with any computer on the lan, but using the wan ip (or trying to connect from a remote computer) doens't work . the client prompts "connection error 2003". i already checked the complete network parameter and port forwarding works normally. so you can see the mysql server from outside but it seems to deny the connections.

Copying Databases Between Computers
I was working on a database on my old desktop PC but it died on thursday evening, I`ve managed to get the .frm table files from the data folder from the desktop machine and copied them over to my laptop. I installed mysql onto the laptop and started the service. I then copied my old database folder into the data folder of the mysql install and tried to access it.

MySql managed to realise the database was there and return the table names but it could not access the table whenever i asked it to describe it. As you would then suspect trying to run any queries also failed. the error code was continuously

table:'databasename.tablename' doesnn`t exist

Can anyone shed some light on this or will i need to restart my DB from scratch?

Running Mysql On Old Computers
IÂ´m running mysql on a Pentium 166 Mhz with 16 Mb of RAM. Pretty old, right?

I want to know if there is a way to improve performance. I donÂ´t know, something about reducing the number of queries that it will respond or cutting out some features.

Set MySQL To Listen From Other Computers
I have a problem connecting to MySQL server! The server is working on the other computer than my scrpit(my web page). The IP of MYSQL computer is 10.0.0.2. and port 3306! When i try to connect like this :

$link=mysql_connect("10.0.0.2.", "user", "password");
$db ="database_name";

... I get the folowing massage:

Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on '10.0.0.2' (10061) in D:InetpubwwwROOT.......

The ip, username, password and database name are all correct! It is said, that it's possible, that the MySQL is set to work on localhost! If this is the problem, where to configure mySQL, to be able to connect from other computer?

Selecting Record From Multiple Computers
multiple client computers and 1 server computer - server holds a 'jobs' database with records that need to be processed

The client computer connects to server, and requests the next record. After it does the select statement to get the next record it does an update to mark that record as 'in progress' and no other client computer are supposed to take that record.

Before that can happen the second client also requests a job and gets the same one (the update has not happened yet or too slow and each client gets the same record) and each client is supposed to get a unique record.

Does anyone know if it's possible to prevent this? mysql table locking or row locking?

Unable To Connect To Database Server. Can't Connect To MySQL Server On 'localhost' (10055)
I am running a PHP application with mySQL . Some times it gives the following error.
I do not understrand why this error occures .

today i am using the application but it is not giving the error but error occures yested day .

Unable to connect to Database Server. Can't connect to MySQL server on 'localhost' (10055).

"Connect By" / Connect By Prior Clause
One thing that very annoying me in SQL SERVER is the lack of the "connect by" support. The other thing is that in order to take advantage of multi-processors/cores system, you have to pay a good deal of money.

Therefore, I'm examining MySQL now & wanted to know if there is a "Connect by" support in MySQL? It's not just syntax issue, but also performance issue. Anyhow, it's far more comfortable.

QNX To Windows
I have a MySQL database configured on a Windows machine and I need to connect into that machine from a QNX machine. Does anyone know if there is available a MySQL connection driver for QNX? I haven't found anything in the web site.

Windows XP
I just installed MySQL on Windows XP.

I have the most basic questions:
1] How do I start and stop MySQL.
2] How do I connect.
3] How do I create a user, set password and privaledges.
4] How do I create a table, set column, set column attributes.

Basically, is their any tutorial for the absolute beginner in MySQL on Windows XP.

UDF On Windows
Does anyone have a windows version of MyXML? Or hints to compile it? Quote: About MyXML is an UDF extension to the MySQL database. It provides a set of utilities to make generating XML from the database a simple task. It provides routines to encode XML, create tags and return entire queries in XML.

Windows GUI
Does anyone know how to read SLAVE STATUS and other mysql monitor results within a Windows Program? Is there a way to execute MySql commands within Visual Basic?

Windows Box
I am trying to connect from a windows box to a mysql database that is on
a unix box and it's coming back with an error. this is via a migration
wizard. I decided to install mysql client on the windows box and start
mysql and see if I will be able to connect to the database. I have
downloaded the code but I don't know how to go from there

Windows UDF
Just a warning - there is currently a worm doing the rounds attacking MySQL servers running on Windows. Linux / *BSD / OSX are not affected.
It doesn't exploit any MySQL security holes, but attempts to brute force the password. Once in it installs a bot (W00t bot), and connects to a number of IRC channels, advertises it's presence and recieves IP subnets to attack.
Solution:
1) Use a STRONG root password. 'root', 'mysql' or 'secret' doesn't cut it.
2) Limit root connects to certain IP addresses (ONLY 'localhost' is the best). Don't let root connect from '%'.
3) MySQL should RARELY be exposed to the network. Use a firewall and MySQL's skip-networking command.

Mysqlclient On Windows
I'm using the command line client for mysql quite a lot on windows, and it really annoys me that I can't use tabstop to complete table/column names, like I can on our *nix machines. Is there something obvious I'm missing (like a config setting somewhere) or is this just the curse of using Windows, which I must learn to live with?

My.cnf Is Not Available Under Windows 2000
according to the manual,

There are two option files with the same function:
`C:my.cnf', and the `my.ini' file in the Windows directory.

Is it sufficient with only one of the files ?

I have only my.ini

For which purpose is my.cnf , please?

Windows Vs Linux
We currently run our MySQL on linux. Could someone advise me on the watch outs on moving MySQL to windows and also if there is any performance loss as a result?

Install On Windows XP
I cant get mysql to run on my winXP computer. I have downloaded it and
installed , unzipped and run setup.exe and placed it in c:mysql.
I type the command to start the mysql server
c:mysqli mysqld --console

It opens the console and then the console shows some inoDB commands and the
console hangs.

I followed the mysql manual and i cant find the answer
there is no command prompt and nothing...how do I run mysql?

Getting Started With 4.1 On Windows Xp Sp2
Has anyone had a problem trying to start the service ?? for some reason it will not let me start up the service and gives me an error message of " server could not be started ". I am running this on my desktop which is a fairly high end machine with a gig of ram P4 3.4, 40 gigs of free space.

Windows Gui & Mysql5.0.2
know anybody a successfuel working gui
which working with mysql5.0.2.

I'm getting allways a crash with query-browser and others.

Versions Of AMP On Windows?
I am somewhat concerned that i have the right versions
of AMP on my Win XP system so it will all work together...
Is there some link that (in simple terms!) tells which versions are safe
together?

I currently have MySQL version 4.0.20d, with Apache 2.0.52 and php
4.3.10. Is this the best combination?

From Windows To Linux
I've got a production MySQL database running on a Linux server, but do my development on a Windows laptop.

I recently overhauled an existing app and needed to write data conversion routines in order for my existing data to map to some new data layouts.

I'm running the conversion on my laptop, so I don't mess up the existing production data. I will be running some tests in parallel before going live with the new app.

When I run the conversion, Windows sets all the table names to all lower case. So when I load the data to my Linux box, the table names are all wrong.

Is there anyway to force MySQL to maintain it's case on a Windows machine so that I don't have discrepancies from one OS to another?

Two Windows Problems
When I try to transfer data to the sampdb by using the < sign
i.e mysql> sampdb < insert_student.sql

I get an error.

Question one, what am i doing wong, source insert_student.sql works.

The windows dos window is only a few inches wide and I cannot
read the entire error message. How do I get te dos window open
all the way? The little square button in the upper right doesn't do
anything at all.

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.

Setup Under Windows Xp Sp1
I need to upgrade my current mysql installation . But now there is a problem
to run the setup.exe of installshield 5.x under windows xp sp1 or sp2. The
program hung after few seconds. In the memory remain active woexec, ntvdm
and setup, but the process is freezed. It is possibile to convert the
current setup mode of mysql4.014 in other install system, as for in
mysqlcc092 ?

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:

Windows Or Linux?
I am developing a website using php, MySQL and Apache on my home pc which uses WinXP. I am pretty sure that I will not be able to find a web host who will support Apache on Windows, so I guess I will have to go for one that uses Linux. If I do this, is there a serious difference between the way I need to write the PHP code, or is it just the same.

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.

Setting Up On Windows XP
1) I can run MySQL in a command prompt and create databases when I am logged into it at root happily. But then my application which hasnt got root access cannot see the database. How do I set up MySQL such that myApp can access a database created by root?
At present if I log in to MySQL using MySQL -u MyAPP
I cannot access the database that I created when I logged in as MYSQL -u root

MS Visual Studio 6 question.
2) I have copied all the .h files into my include directory, and the lib files to the library directory. I have fixed the slight bug in the header files that means the system cant define SOCKET (#define __LCC__)

If I just include the headers and compile it all works well. As soonas I try to use some of the C API commands I get linker errors which implies that the library is not loaded. I have added the library and I still get errors. What am I doing wrong here (or more likely, any suggestions for other things I can try?)

4.0.22standard For Windows
I am looking for version 4.0.22standard for windows.

The web server that I am developing on is 4.0.22standard and I would like to upgrade my local version which is currently 4.0.14 to the same version as the remote web server.

Or is there a way that I can upgrade my current version.

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?

Windows Crash
I have one computer where I cannot startup the windows operating system.
In that computer I had installed the MySQL Server.

Putting the hard drive has a slave on a computer with MySQL Server installed, how can I access the databases?

Install My SQL In Windows XP?
Can we install MY SQL in Windows XP? I tried to install but it gave error "This enterprise server sersion is not supported by this OS. Only Client version will be installed".

Problem With Windows XP
I have just installed MySQL4.1 and the querry browser. I am using windows XP (home adition). I chose to run MySQL as a service so it is running automatically each time windows is on.

However, I have trouble to log in mysql and the querry browser. The strange thing is that the problem is on and off for no reason. Sometime everything is fine.

Windows XP Servicepack2
i installed mysql 4.1 under windowsxp sp2, installation works, i also can log in using root passwrd, but i can not add new users (neither in shell nor in admintool).

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.

Windows Date
How can I convert a windows date stored in Mysql (ie 38397 for today) to something I can use in a where clause?

Windows Authentication
I would like to a Windows Authentication with MySQL (similar to the Windows Authentication available for SQL Server).

Does anyone knows how it can be done?

Utf8 In 4.1 For Windows
------=_NextPart_000_008D_01C355F5.DA1B8150
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I have read in past postings that UTF8 is not yet working with MySQL 4.1 =
on the Windows build.
Can anyone verify this?
If it is not yet working, can anyone give an estimate when a build will =
be available that should work?

My.cnf Is Not Available Under Windows 2000
There are two option files with the same function:
`C:my.cnf', and the `my.ini' file in the Windows directory.

Is it sufficient with only one of the files ?

I have only my.ini

For which purpose is my.cnf.

Replication On Windows
I want an urgent help for mysql replication running on 4.16 version does replication works on windows or linux only if it is pls give me minimal steps just first to start it replicatiing.i want it on windows box.

Windows Client 4.1.14
I know that I have exhausted my budget of MySQL questions for the day, but I have one more and promise that I won't ask anymore today.I must install MySQL 4.1.14 client only on Windows XP 2002 SP2.Does anyone have guidance for me for downloading just the 4.1.14 client for Windows XP 2002 SP2? I would also be obliged if there are also warnings of foxholes on MySQL client-only installs.

Backing Up On Windows
How do I back up files on Windows? I know how to do it on the *NIX platform.
Whenever I run mysqldump, it doesn't export them in sql files to a place that I designate. It goes somewhere else, and I have no clue where that is.

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...

Windows Authentication
Can MySQL use windows authentication?
If so, what are the changes to the connection string for this?

Windows Essentials
i installed the mysql-essential-4.1.12a-win32
and after installation i went to the mysql application which should open a black window (monitor), but it doesnt, it opens the window and quickly closes it.
im running winxp sp2 version 2002