Running MySQL Win32
I'm an absolute beginner and would really like to read something in the manual to solve this problem, but the manual just take care of Unix and Linux users.
Because we develop on NT we wanted to install MySQL with Apache and PHP3 on a NT workstation for faster testing beside our Linux station.
But I have problem to start the program (mysql.exe). It just gives back an error:
Error 2003: can't connect to MySQL server on localhost 10061
Network is running, I can ping localhost. I don't know what to do to get it running.
View Complete Forum Thread with Replies
Related Forum Messages:
MYSQL + Win32 = Difficulties
I've a newbie to MySQL. I've installed it on Windows and assigned a password to the root user. Now when I log in I do the following: C:mysqlin>mysql -u root -p Enter password: ***** But all I get is: ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) I can't seem to find an answer as to why i'm hitting this problem. Can someone please explain?
View Replies !
MySQL Win32 Install
I've downloaded MySQL community server, the one without the installer, and I've unzipped it into c:. The last time I tried, I downloaded the one with the installer, and well.. I'm entirely newbie so once I did the installation and configuration, the computer start progressively work strange until I had to install windows xp again from zero. I need to install and configure the MySQL database locally, I mean I don't want it to connect to internet. I'm trying to install a weblog server application in this computer but I don't need the weblog to connect to internet, just work into the computer. I don't know nothing about server configuration, databases and things related. Therefore I would like some help configuring MySQL to work locally so the computer OS wont be in danger.
View Replies !
Installing Mysql-noinstall-4.1.11-win32.zip On Windows XP
I unzip the file "mysql-noinstall-4.1.11-win32.zip" and extracted to " C"/mysql then, i did a "c:mysqlinmysqld --console" The "red light turned to green light on the mysqladmin" so, i assume mysql is connected. when i try to test the mysql by "phpinfo() " The information about mysql didnt not show up on the firefox. Does anybody know why? any configuration that i should do?
View Replies !
Mysql Mysql-4.1.10-win32 Problem
I installed <b> mysql-4.1.10-win32</b>in the place of mysql 4 beta ..after my installation i am getting the message which when i try to connect php into mysql the message is Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client
View Replies !
Free Mysql GUI Mysql "client" For Win32
I'm currently working on re-engineering a web stack completely to use mysql as a back end instead of (shiver) a bunch of Access files. I've used mysql for years both personally and professionally, but being a UNIX dork I've almost exclusively done so from the command line. Whenever I've needed something a little more user-friendly than that, I've installed a web tool like phpmyadmin. However in this case, I'm working in an all-Windows shop (mostly server 2003) and I know that I'm going to be passing this on to someone in a couple years. As I document various tasks, I'd like to use a desktop client with a GUI interface for doing things like "browsing" the database, modifying stuff now and then, etc. I see that mysql.com has a nice "administrator" and "query browser" available and they're pretty nice - but neither is really what I'm looking for in terms of something that has a GUI interface and actually manipulates the data itself. Unfortunately I cannot count on a successor knowing much SQL or being comfortable on the command line. I'm guessing there are many free tools out there but would love to start out on whatever people who already love to use such things find the most mature, featureful, easy to use, etc. So, suggestions?
View Replies !
SQL Query Works Only In Win32!
I use MySQL from my php page and from phpMyAdmin. In Windows Server, following query works fine. In Linux Server instead it returns error. The SQL Query is: SELECT DISTINCT a.id, a.container, b.container FROM folder AS a JOIN folder AS b ON a.container=b.id The PHP error is: You have an error in your SQL syntax near 'ON a.container=b.id' at line 1 So, I ask: If in Windows this query work fine, where is the error in the Linux version?
View Replies !
Make Win32 Installer NOT Always-on-top ?
I noticed that the windows installer wizard window is always-on-top, which I find very annoying. Other install wizard don't behave like this. Is there a way to turn it off ? I used the file mysql-essential-5.1.12-beta-win32.msi on WinXPproSP2.
View Replies !
Troyan.Win32.Zapchast.d
my antivirus (kaspersky) say: c:mysqldatahvocd.dll is a Troyan: Troyan.Win32.Zapchast.d i have winXP home and mysql Ver 12.22 Distrib 4.0.18, for Win95/Win98 (i32) can this file be infected by this troyan? can someone send me the original file hvocd.dll?
View Replies !
Secure Backup On Win32 Systems?
mostly for unix platforms. On win32, what is the best way to run a secure mysqldump so that my password doesn't have to live in a script somewhere? I'm using perl scripts to kick off my backup commands.
View Replies !
Upgrade WIN32: From 5.0.x To 5.1.x -- Easiest Path?
i tried to upgrade a 5.0.x to 5.1.x on win xp pro box. i read mysql's online docs. but apparently, the data directory didnt copy over nor did the important users info... what is the easiest way to do this? here what i did: 1. stop mysql5.0 service 2. run the 5.1 install wizard. 3. but it fails. so i manually start 5.1 service. reboot machine. but non of the data is moved over. is there a simple to do this without me reinventing the wheel?
View Replies !
Service Isn't Starting. Unhandled Win32 Exception
So I have tried uninstalling, deleting the mysql folder, deleting registry entries and reinstalling about 4 times now. It worked the first time around. And even after doing all of this, somewhere it is still keeping my old password after reinstalling, and everytime i try and run mysqld or the service it gives me a Unhandled Win32 Exception. I'm trying to figure out why it might be giving me this exception, as well as why my old password keeps being asked for when I try and resintall. I understand that somewhere its being logged but where I have no idea. I've deleted the registry entry under HKEY_LOCAL_MACHINE >> SYSTEM >> CurrentControlSet >> Services >> [MySql] <<<<< Thats the file I deleted under the registry after the uninstall. I also deleted the C:Program FilesMySQL Folder completely. So where it's logging that information I have no idea. Any help on this matter would be great.
View Replies !
Running MySQL
I have installed mysql-3.23.54-win and it all seems to have gone OK .... now i want to run it and setup a database. I dont have an icon on the desktop and there is nothing in Start - Programs ..... start it from DOS prompt via C:> C:mysqlinmysql.exe and i get error 2003 cant connect to MySQL server on localhost <10061>
View Replies !
Running MySQL 5.0
I've just downloaded and installed 5.0 on my Pc/ win 98se. When I run the program MySQL Command Line Client, it appears to run for a second then disappears. I see the program flash open for a second and then it is gone.Complete newb needs some help.
View Replies !
MySQL 4.1 Running
I've been running mysql 4.1 for sometime and using phpMyAdmin (v2.6.2) to administer the databases. Using php scripts I can also update/insert etc the databases (maintained on my laptop Mac OS X Tiger). Suddenly, I can't get phpMyAdmin to load in the browser. I've also tried other MySQL GUI tools like CocoaMySQL and Navicat....they won't run either. I downloaded and installed phpMyAdmin 2.6.3-pl1 as well but no improvement. Why would mysql run but the admin apps not work?
View Replies !
Running MySQL From A CD-ROM?
I have used PHP and MySQL for a few years now. Just today I can across an application that had a MySQL database running locally off a CD ROM. I did not know this was posible. When the application runs it starts up the MySQL database without the user even knowing they are running it. It is pretty amazing. So I want to do the same thing. Is there any documentation on how to run MySQL locally. I would like to know how to build the database and create tables under these curcumstances.
View Replies !
Could Not Get MySQL Running
I went to MS-DOS to start the MySQL application by typing mysqld into the bin directory of where I installed MySQL but once I did typed the command and pressed enter this is all I got : A moment passed before I am shown the path of bin with no indication of MySQL server started. And also I have installed this as a window service.
View Replies !
Help Please Running Mysql On Os X
I am very new to mysql. I am using the sitepoint book 'Build your own Database Driven Website using PHP and MYSQL. I have installed mysql mysql-5.0.41-osx10.3-powerpc. Under preferences/mysql it indicates that the mysql server is running. When I try to access mysql through the terminal window I get a message - command not found. Or no permissions. I can go to the bin directory and list the contents - they seem to be there. I can't get past page 21/22 Post-installation setup tasks. I am also new to using the terminal window. I suspect I have missed something really basic - any suggestions on how I can get up and running would be much appreciated!
View Replies !
Running MySQL In RAMDisk
Have a very large database and due to performance requirements it seems that running MySQL in RAMDisk might be a good solution. Access to the database is through PHP.
View Replies !
Running Backup For Mysql
Can anyone suggest a reliable and inexpensive backup service for mysql? I have about 50 tables, of which I've been doing database backups daily on the server, then downloading the backup every couple days or so. The backup files are starting to get relatively large, and I'd like to find a service to backup to off site.
View Replies !
Running Mysql From Shell
I need to run this sort of querys from shell: delete from 3dinformatica where preco = " " ; CREATE TABLE tudotest AS SELECT DISTINCT * FROM 3dinformatica; DELETE FROM 3dinformatica; INSERT INTO 3dinformatica (cr_datetime,produto,vendedor,preco,link) SELECT DISTINCT cr_datetime,produto,vendedor,preco,link FROM tudotest; DROP TABLE tudotest; i wanted to put the mysql cmd in a file like mysql.sh and run it from crontab. i have about 100 querys like that i need to run at the same time.
View Replies !
MySQL Config Not Running
i'm trying to set up MySQL with IIS 7.0 on Windows Vista Home Premium. After you install MySQL, there's a check box to launch the config app. if i leave it checked, the app does not load. if i try to run the app by double-clicking its icon it gives me an error saying, "The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log for more detail." I cannot find the application event log, though.
View Replies !
MySQL Running Very Slow
I have the following INSERT SQL, which runs very slow (For 2 full days it had not done anything) on a 2 processor Compaq machine running Suse Linux. Code:
View Replies !
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.
View Replies !
Slow Running MySQL?
I'm hoping someone may have an idea what could be causing the slow loading pages of my web-site. I'm not positive, but I'm relatively sure that it's related to a problem with MySQL database. I purchased a program called Sam3 for broadcasting our radio signal over the internet. The software requires the use of MySql in order to set up web pages for our web site. The problem is, that while everything works GREAT (requests can be made from the site, songs can be searched, the history of what we've played shows up) the pages load PAINFULLY slow. Other users of this software have had no such problems so I'm at a loss. I know from testing that the PHP script for the web pages is fine, I have plenty of bandwith both upload and download available on my DSL line, and while the computer running MySQL is behind a router I have tried plugging the DSL line DIRECTLY into the host computer and it makes no difference. For all appearances it seems the problem is that it takes MySQL forever to gather and provide the information needed for these pages. Does anyone have any idea what I should be looking at to solve this problem? I do not know the MySQL program at all, so I get somewhat lost when people start throwing out technical terms, but this has been really frustrating because no one else seems to have the problem and everyone so far has just told me to check the things I've already checked.
View Replies !
On What Port Is MySQL Running?
I'm running MySQL on my Mac, and I'm trying to figure out on what port MySQL is running. What can I type into Unix terminal to figure this out? Or can I find out some other way?
View Replies !
How To Use A Copy Of A MYSQL 4.1 Database In MYSQL 5 Running On Ubuntu Linux
We had a "permanent world" game server running on an older PC, under Ubuntu 5.10, using a MYSQL 4.1 database to store persistent data for the players, then the hard disk quit. We did back up our data on a regular basis, but didn't use MYSQL to do the backups, we simply copied the MYSQL/data/ folder to disk. So now we have a new hard disk, with Ubuntu 7.10 and MYSQL 5 installed. We have everything working, in that we have created the appropriate database and, using a simple test module of our game which will create some of the tables if they don't exist in the database, we can store and retrieve data from the database tables. The problem we have is how in the world do we get the data from the backup copy of the MYSQL 4.1 created database into the new MYSQL 5 database correctly? With 4.1 we could copy the contents of the database folder right into the database folder in the /var/lib/MYSQL/ folder, but this procedure didn't work with MYSQL 5. The files seemed to copy, as in the copy operation gave no errors, but we get an error that says the database is unavailable and to make sure the MYSQL server is running - it is, so we're stumped, and our game server is offline.
View Replies !
Running MySQL Using A Dos Batch File
I am used to use MySQL on Unix, now I have to do some development for MySQL running on Windows machine. The following script works well in Unix but I am unable to run it on Windows. "MY_FLAG" is the one which is causing issue. Due to certain restriction in my framework, I can use the normal batch by supplying the .sql file while opening the mysql connection ( infact i need to run multiple source files) Code:
View Replies !
Error Running MySQL Administrator On RH8
I have downloaded the latest version of mysql administrator 1.0.18. I followed the installation instructions, but when i am unable to run the program. I get an error saying: ./mysql-administrator-bin: relocation error: ./mysql-administrator-bin: undefined symbol: gdk_display_get_type Do you have any clue about what is happening?
View Replies !
How To Verify If MySQL Is Running On My Windows XP?
I uninstalled that and reinstalled that. Then it doesn't work anymore... I check the process of the "Windows Task Manager", but I couldn't find the fimilar mysql-nt.exe... Do you have any idea how should I fix this problem? Should I reinstall the whole XP system?
View Replies !
MySQL Administrator GUI Running Slowly... WHY?
We have created an instance or schema that contains over 14000 tables. It is a lot of tables. When we attempt to browse the tables in the GUI it literally takes 5 minutes or more for it to come back. Granted when using the Microsoft SQL Server Management Studio it is slow but doesn't take that long. After about a minute or so it gives the list and is kind of slow to scroll. Can this be fixed by optimizing the database? Is this just too many tables for mySQL to handle?
View Replies !
Running Mysql Code Within A Php File?
I have been given a some mysql code that I have to run within a website - I am familiar with mysql in terms of insert info and querying a database but I at a loss as to how to make this work. the mysql code works in mysqladmin, but how do I call it into my php code? BTW the mysql code creates a new record in the database ....... Also, I need to tweak the code so it runs in a loop for different variables - in php I would run a FOREACH query, how do I do it in mysql?
View Replies !
Detecting If MySQL Server Is Running
I write an application which saves/loads data to/from database. I created a table and I'm reading an informations from it. The problem is when server is stopped and my application tries to connect to database it terminates. I think it shouldn't happen. I want my application not to terminate while it can't to connect but give me some kind of error and continue its run. How can I do that? And at the end I would like to say that I'm writing my program in c++ using .net. My piece of code: ....
View Replies !
MySQL Running In Linux With Apache2
I have Fedora Linux running on my box. I have installed Apache2, PHP, MySQL. I used YUM to install everything. yum install httpd yum install php yum install mysql-server mysql yum instal php-mysql What I want to know is that how can I start playing around with all this cool programs. I want to learn as much about all these awesome programs. I would like to install some kind of control center for MySQL. I heard MyPHPadmin is good. But how do I install it? Can I do it through yum? Where can I find a good newbie guide? thanks in advance :-) Fedora Project Information is Power! I am doing this for the love of MySQL.
View Replies !
MySQL + SQL Server 2000 Both Running On XP Pro?
I've had mysql on my machine plenty of times with no trouble currently i have SQL Server 2000 Trial running but never both at once. Unfortunately i have to have them both on at the moment. So before i install and mess everything up, Does anyone here have this setup? I basically want to get php/mySQL/MSSQL running with IIS
View Replies !
MYSQL Running Query On Data Through Php...
I am trying to take address info from 5 different fields in mysql, concatenate them into one string of text and have then run through a POST, like you would in a form, and have them spit out on the other end into the database the Lat and Lon of the address... I can do it manually, but I would like to do it automatically... I would like to know if I am going at this right... Psuedo QUERY=SELECT addressNumber, addressStreet, city, state, zip FROM table $addressStr=addressNumber + " " + addressStreet + ", " + city + ", " + state RUN IT THROUGH A POST SOMEHOW??? and call GEOCODER from my manual insert script... $sql=INSERT INTO table SET lat='$lat', lon='$lon'
View Replies !
Mysql Running Slow On Mandrake Linux 10.0 For AMD 64
I'm having a problem with a new machine running Mysql version 4.0.18 on the AMD64 version of Mandrake 10.0. The new machine has got 64bit AMD processor and 2GB of RAM. Nearly all queries(updates are especially slow) are running 20/30 or more times slower than on an inferior(32 bit processor, 1.5GB RAM) machine runnning Mysql 3.23.56 on mandrake 9.0. As far as I can tell mysql is configured correctly for the power of the machine. The my.cnf file looks like this: Code:
View Replies !
How To Determine Which Port MySQL Is Running On (LocalHost)?
I tried running "mysqladmin variables -u root -p" and seeing what it lists, the only things that seemed relevant are: | hostname | MyComputer (valid machine name) | named_pipe | ON | port | 0 | report_port | 3306 | report_user | Is there anything else I should get? Is there anyway to confirm which MY.INI it is loading? Why is PORT 0? And what is REPORT_PORT? When I start the MySQL database and check the DataMachineName.err file I see the following: 090327 22:06:45 InnoDB: Started; log sequence number 0 46409 090327 22:06:45 [Note] Event Scheduler: Loaded 0 events 090327 22:06:45 [Note] H:DevelMySQLMySQL Server 5.1inmysqld: ready for connections. Version: '5.1.32-community' socket: '' port: 0 MySQL Community Server (GPL) I assume this means it is running on PORT 0? How does that make any sense? Some of the things I've already tired (maybe it will help you guys figure out what my next step should be): C:>telnet localhost 3306 Connecting To localhost...Could not open connection to the host, on port 3306: Connect failed C:>telnet localhost 0 Connecting To localhost...Could not open connection to the host, on port 0: Connect failed MySQL runs fine from the command line And the User is "root" with password "pass" Service is running (started it manually - and console application works) mysqladmin.exe -u root -p ping Enter password: ** mysqld is alive I added BINMySQLd.exe to the firewall options @ opened port 3306 on the Firewall - didn't touch my router (using localhost - I imagine I don't need to go that far). Running it in PHP5 always gives me the following error: $this->connection_id = @mysql_connect('localhost', 'root', 'pass'); >> Can't connect to MySQL server on 'localhost' (10061)
View Replies !
Access Violation On Running MYSQL MORE INFO
I have an application written in Delphi 7 it runs perfectly on my laptop but when copied onto three other machines the program crashes with Access Violation at 004A60C3 before doing it's first mysql action which is "create database if not exists". The version of MYSQL was downloaded with Fireserv. Which is running right out of the box (no mods to .ini files). All the Fireserv tests work OK. The program will not run without first connecting to MYSQL (which it does OK). Click button to create DB ...Access Violation!!! the actual commands are:- CREATE TABLE IF NOT EXISTS Milk.YRWK (ID INT NOT NULL, WKYEARCOUNT TINYTEXT, PRIMARY KEY(ID) ) no problems sofar...but both of the following commands cause program to crash REPLACE INTO Milk.YRWK values ( 1 , '1234567890' ) or INSERT INTO Milk.YRWK values ( 1 , '1234567890' )
View Replies !
Mysql Stops Running Queries After Approx 1 Day
I have a PHP script that runs 24x7 and reads then deletes from a table about once every couple of seconds. However, after about a day, I start getting the error "$result is not a valid mysql resource etc..". Looking in the query log, mysql has stopped logging the queries - so I presume they are not being run/received by the daemon. If I restart the script, it will work fine again for around a day. Does anybody know what would be causing this? Are there any logs than can help? Having run the script for about 5 minutes, I'm already up to "mysql resource id #180" so I guess by the time the script stops working, we could be up to the tens of thousands. Could mysql be running out of resource IDs? Once the query has been execute, I don't need to store it any more so can I somehow get it to start re-using some of the old resource IDs?
View Replies !
|
TRACKER
