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?
View Complete Forum Thread with Replies
Related Forum Messages:
Windows 2003 To Windows XP Pro Secure Communications...
I have a Windows 2003 Server running a Coldfusion app that needs to constantly update a MySQL database on a Windows XP Pro machine. These machines are not on a LAN and are physically separate. I'm trying to find a way to establish secure communications between them since I do not want port 3306 open to the entire internet. What I've Tried So far I tried CopSSH with Putty but this did not work because I need to manually initiate all sessions and enter passwords by hand. Since there aren't any SSH solutions that allow persistent, automatic connections, it appears I need to go with VPN. The VPN Dilemma I tried creating a VPN server on the WinXP MySQL machine but I cannot get ODBC to work remotely. How do you get the ODBC on the local (Win 2003) machine to recognize the MySQL database on the remote (WinXP Pro) server? Note: I also understand that getting SSL working on Windows is a pain in the butt. I'm trying to steer completely clear of that. I don't have the tools to recompile, etc.
View Replies !
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:
View Replies !
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"
View Replies !
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.
View Replies !
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.
View Replies !
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.)
View Replies !
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.
View Replies !
Installing MySQL V4.0.14b For Windows
I have just downloaded MySQLv4.0.14b for windows and 21% through the installation, it displays the following error: An error occurred during the move dataq process: -132 Component: File Group: File: The MD5 hash matches the one on your website and I have spent another 5 hours or so downloading it again from your main site instead of a mirror site, but it stills does the same thing. I'm installing it into the the same folder as the previous version (3.23.49).
View Replies !
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?
View Replies !
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.
View Replies !
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.
View Replies !
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.
View Replies !
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?
View Replies !
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
View Replies !
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?
View Replies !
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.
View Replies !
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.
View Replies !
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.
View Replies !
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."
View Replies !
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.
View Replies !
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.
View Replies !
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:
View Replies !
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? :)
View Replies !
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.
View Replies !
Mysql Services Windows 2003
------=_NextPart_000_0001_01C34BC2.26B3C4C0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Why can't I start the service in windows 2003 server have any one a solution?
View Replies !
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 = AlphaMySQL. 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.)
View Replies !
MySQL & Windows 2003 Server
I have a windows 2003 server running a MySQL server on it presently. This is a Test Box. Is it possible that I can also have an instance of Microsoft SQL Server 2000 running along side the MySQL Server at the same time?
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 !
Is MySql Syntax Different On Windows Vs. Linux?
On our team, we're working on a database. One copy is on the PC. The other copy is on Linux. I wanted to send a new table to the Linux guy. I went into MySQL Query Browser, did a "Copy CREATE statement to clipboard", and pasted the SQL code into a new email and sent it to my Linux guy. He tells me that the code fails every time. Here's what It looks like:
View Replies !
MySQL On Windows And OpenBSD At The Same Time
I have a client who desires to use MySQL on his server to service his web-application hosted by an OpenBSD machine. No problem so far. He also desires to run a client-side application that needs to access a local copy of the data on a Windows machine. The intention is a one-way briefcase model, where he updates the data on his Windows machine and once a week uploads/updates the data on the server from his local master copy - which updates the web-app. Of course I could probably program a client app that would store the data locally and then just by using SQL statements do updates and inserts into the server database through ODBC (or other supported mechanism). BUT - my intention is to write as little code as possible and make this super dead simple for this guy to maintain. So a ready-to-use client-side GUI is necessary. My first instict (cause i'm a Windows guy) was to use MSAccess (its a very small DB) on both ends, and all the guy has to do it copy the file (mdb) to the server.
View Replies !
MySQL On Windows 2000 Server
I want to install MySQL on to a Windows 2000 Server, I also want to remotely manage it using MySQL administrator, so connecting to the server using its IP Adderss, On windows workstations if you try and connect to the MySQL database from a remote mechine it does not allow you to do it (I have disabled all firewall's etc.). Do you have to install a server version and not LOCAL version of the MySQL server?
View Replies !
Windows SQL Services And Removing MySQL
I had installed mySQL when a programmer wanted to use it for a project. Then i uninstalled it. Now the MS SQL services (SQLserver, sql server activation directory helper, sql server browser, and sql server vss writer), cannot be started. The error messages seem to indicate that there are some files missing in order to run the services. I tried to re-install MySQL, but not it is giving me error zero when i run the configurator.
View Replies !
Windows Command From Within The MySQL Console
Is it possible to execute an MS-DOS command from within the MySQL console? I know that the Linux version of MySQL contains the SYSTEM command to execute shell commands, but there doesn't seem to be anything similar in the Windows version. Futhermore, is it possible to run mysqldump from the MySQL console?
View Replies !
|
TRACKER
