Connection Problem !!! Windows To Linux
I wrote a program application for windows which can add and delete data
from this application, it working fine with my own MySQL install on the
same windows OS.. Now I try to change the connection this dayabase to
the server whihc runnign under linux, and create the same database, same
user and password. But when I connect the error message said:
[MySQL][ODBC 3.51 Driver] Host'219.95.155.119' is not allowed to
connect to this MYSQL Server.
But form the database, I added the host "%", means hsould be allow any
host... anyone can help me on this? the application I wrote will be
using with dynamic IP everytime user dial-up to the internet connect.
View Complete Forum Thread with Replies
Related Forum Messages:
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?
View Replies !
Using Database In Windows By Linux
I am hosting an intranet on a machine with dual boot in both win98 and RH9 Linux. the intranet was first set up and running in win98. I have a mysql database in the win98 . The win98 partition is mounted in Linux and is accessible. I am duplicating the intranet in Linux. the HTML pages are accessing from the win98 partition. Is there a way to use the database as such by the intranet in the Linux.
View Replies !
Windows To Linux Server
I am trying to set up a a Mysql driver on a linux server from a windows machine. I get the following error. [MySQL][ODBC 3.51 Driver]Host '(server number)' is not allowed to connect to this MySQL server Is it likely that the windows-linux combination is causing a problem here?
View Replies !
Updates Invisible - Windows Only (Linux OK)
I have one Java app writing records to a database (App A) and another, a Java web application running under Tomcat, displaying the records. Call this App B. When I first log into App B and get a connection, all records in the database at that point get displayed OK. But after that, any new records inserted by App A do not get displayed when I refresh (running the query again). If I log out of App B and log in again, getting a new conection, I see all the new records. This behaviour only occurs if I'm running on Windows. If I run the database on my Linux box with the same application code, new records inserted by App B are immediately visible to App B with no need to close the connection and open a new one.
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 !
Connection To MySQL On Linux
I am New to Linux PHP apache and MySQL (following the Book, Begining.PHP, Apache, MySQL Web Development). Got as far as chapter 3 without too many problems. Well no I'm stuck. I get the following error Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /usr/local/apache2/test/createmovie.php on line 4 Database connection error, check your server connection when then following piece of code is executed $connect = mysql_connect("localhost", "mysql", "mysql" ) or die ("Database connection error, check your server connection" ); I'm, A bit lost about which file the path is stored.Has anyone came across this similar problem and found a fix for it?
View Replies !
Slow Connect Linux To Windows MySql
I have a Linux box with the latest MySql and another box (Windows 2003 Server) with the latest Mysql. From the unix prompt I do this: mysql -uroot -pmypass -h windowsserver mydbname this take about 4 seconds to connect I do the exact same thing on a windows workstation and its connected instantly.
View Replies !
Sharing Database Tables Between Windows & Linux
I'm new to MySQL (using v4.1) and have a dual boot machine with Windows and Debian Linux (Etch). My goal is to share a table named "wordpress" between Linux and Windows by storing it on a FAT32 mount (I realise this limits me to 4GB in total). From what I can see at the moment, the "wordpress" tables live under /var/lib/mysql/wordpress. Numerous searches have revealed how to backup data, but I haven't seen any clues on how to permanently reloate a database to another location.
View Replies !
Can A MySQL Database Be Shared Between Windows And Linux?
I've got Windows and Linux running on my computer, on seperate partitions. I also have a shared partition for stroing files, and can be read and written by either system. I also have MySQL installed on both systems. When I make changes to the database in Windows, I have to do a dump of the database (or single tables) to a text file on my shared partition. I then have to switch into Linux and load that file into MySQL there. This is a bit of a hassle. Is it possible to somehow store the database file on the shared partition, and use the same database from both OSes? This would be very convenient, since I wouldn't have to maintain two copies of the same database!
View Replies !
Query Behaving Differently In Windows And Linux
I have a query to find the blog entries that are most commented: SELECT blog.*, COUNT(blogcomment.id) AS cnt FROM blog, blogComment WHERE blog.ID=blogComment.BLOG_ID GROUP BY blogComment.BLOG_ID ORDER BY cnt DESC The query works fine on my development machine running Windows mysql 5.0.22 but on my Linux server running the same version of mysql (5.0.22) I get the following error: #1054 - Unknown column 'blogcomment.id' in 'field list' Any ideas why it works differently on the two servers? Suggestions on a better written query is ofcourse welcome too
View Replies !
Lost Connection To Mysql Server During Query (Windows XP)
I have following problem: when I try to connect from Windows XP to mysql server (linux computer), I get the following error: Lost connection to mysql server during query. This happens when I test the connection. I have firewall in linux, so I opened the port 3306. Is there something else I need to change to make sure that the connection will work properly?
View Replies !
Linux Server V/s Windows Server ( WebServer - LAMP V/s WAMP)
My client wants to use WAMP ( Windows + apache + MySQL + PHP ). But the site performance is very slow on windows. I dont know the exact reasons. I have seen some benchmark details on internet. But still they are not having concrete facts to support LAMP as a better alternative to WAMP. Allmost all the search done on google melts down to IIS vs Apache, My main concern is "Apache on LINUX" v/s "Apache on Windows" and similarly for PHP/MySQL.
View Replies !
JOIN Issue On WIndows Install But Not Linux Install
I am using MySQL 5.0.15 on windows and cannot run this query: SELECT a.*,b.name, c.fullname,d.fullname FROM access_authorization a, building b LEFT JOIN users c ON a.createdby=c.id LEFT JOIN users d ON a.modifiedby=d.id WHERE a.sortcode=b.sortcode AND a.sortcode like '1,2,1,6%' LIMIT 0, 25 I receive: ERROR 1054 (42S22): Unknown column 'a.createdby' in 'on clause' But this query DOES work under my linux 5.0.0-alpha! I can modify the SQL Statement to the following and it works fine: SELECT a.*,b.name, c.fullname,d.fullname FROM access_authorization a LEFT JOIN users c ON a.createdby=c.id LEFT JOIN users d ON a.modifiedby=d.id RIGHT JOIN building b ON a.sortcode=b.sortcode WHERE a.sortcode like '1,2,1,6%' LIMIT 0, 25 .
View Replies !
Mysql Linux To Mysql Windows
i have been running mysql on rehl4 and now the powers that be want to move the databases to a central windows 2003 server running the windows version of mysql. how on earth do i import my dump file in the window version? i am familiar with doing it in linux but i cannot figure out the mysql command line tool that comes with the windows package.
View Replies !
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 !
ODBC Connection :: Unable To Create DSN Connection
This is my first task with MySQL. We have a site with php as front end MySql as back end. The remote database is on Linux. Now my task is to update some data to MySql database (on the web server) from VB. My operating system id Windows. I installed the MySQL ODBC 3.51 driver on my system. Now when i'm trying to create a DSN with the above driver, I'm getting an error ' Lost connection to MySQL server during query'. What could be the reason...the same error is coming when tried to create a ADO connection from VB.. and the same error when tried to create a service from MySQL front end.
View Replies !
Changes Made In One Connection Does Not Reveal In Another Connection At Once.
I use many connection and the same as many threads in my server app to gain performance on a multicpu machine. Firstlly i call "set autocommit=0" and wrap every statements with "start transaction " and "commit". i use mysql_stmt_execute for every statement rather than mysql_real_execute except those that can't be prepared. The version of mysql is 4.1.11 under Debian linux. In one connection of one THREAD i insert a row into a table. After i got the sucess code and the last insert id, i then do a "select" from another connection in another THREAD with the "last insert id" return by the previous insert . I expect the select can fetch the row that i have just insert , but some time it does and some time it doesn't. is there any funtion like "mysql_....flush...cache.." to make the changes from one connection to be reveal to the global at once?
View Replies !
Win To Linux
I have set up a website on a windows machine using PHP MySQL but I want to port this over to a Linux machine. Is it possible for me to simply copy over the MySQL data files e.g. .frm .myi .myd files over to the Linux machine and place them in the appropriate folder after creating the database?
View Replies !
GUI For Linux
suggest the best GUI of MySQL for Linux with Store Procedure support(Create/Update). Better if also supports triggers etc.
View Replies !
Linux
i installed mysql(usr/local/mysql) on linux but its not starting showing me error like Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) though mysql.sock file exists(linked) in tmp directory wont helped me.
View Replies !
Running 4.1 And 5.0 On Linux
Question: How can I run 4.1 and 5.0 simultaneously on linux - Suse 9.3 in particular? My goal is to do no harm to my current 4.1 setup. Can the 4.1 and 5.0 rpm's play nice together? Can I use the rcmysql commands for running multiple versions?
View Replies !
Upgrade From 3.23 To 4 In Linux
I have an installation of MySQL 3.23 located in /usr/local/mysql.3.23.51, which is working perfectly. Now I installed in /usr/local/mysql.4.0.14 the binaries for a new version (4.0.14 of course), and don't know how to start using it instead of the older one. I have a link: /usr/local/mysql pointing to /usr/local/mysql.3.23.51 and some few databases in that directory. My data files are in MyISAM format. How do I migrate the database files? How do I tell Linux to use this version? I never did a task like this in Linux, for I always used MS Operating Systems, so please be as clear as possible... In fact, I didn't understand the MySQL manual about this topic.
View Replies !
MySQL V4.0 -> Red Hat Linux 9
I'm having great problems trying to install the latest MySQl RPM package onto my Red Hat Linux OS. There is already MySQL v 3.0 pre-installed with the RH Linux distribution disk but I can not seem to get any of the functions working on it. So I have now dopwnloaded the latest version hoping that this will fix the error. I have managed to install the MySQL-shared-compat-4.0.1-0.i386.rpm but i'm getting the following error message when I install MySQL-server-4.0.1-0.i386.rpm : Code:
View Replies !
Low Performance With Linux SMP
I use #mysql -V mysql Ver 12.21 Distrib 4.0.15, for suse linux (i686) with a SMP-kernel When I used this version with a kernel not SMP mysql was very very fast but now with the SMP-kernel the mysql is very very slow. I takes several minutes to make an INSERT on a table with near 50.000 Records Is there any problem with mysql an SMP? is a problem of the version I have installed?
View Replies !
Mysql On Linux
I am interested in connecting to my MySql database that is running (default install) on FC4. I want to connect to the db with my Windoze machine using MySql Query Browser. Both machines are behind a router; the gateway is 192.168.0.1. The Linux ip address is 192.168.0.50 and the windows is 192.168.0.11 (both static). I guess I need to learn how to determine the mysql host and port when connecting. I thought it would just be 192.168.0.50 and 3306 respectively, it's not working.
View Replies !
MySQL And Linux
I am pretty new to the MySQL/Linux worlds. Each time I want to use MySQL, I have to start the program under the root account. Are users other than "root" allowed to access the program? If so, how is it done? It would be nice if I didn't have to continuously log into root every time I would like to use MySQL.
View Replies !
Debian Linux
I have mysql 4.1.8 from backports.org running on stable debian linux. I have 3 medium-scale web apps running off this same db server. the log files on this machine are becoming larger every day. finally this morning the db server hung up and after some detective work i found the culprit was the log files. they are huge, 3 gigs sometimes, and when logrotate tries to zip them the whole thing geeks up. in the /etc/mysql/ directory there is a logrotate.conf file that contains the following comment : # Configuring /etc/logrotate.d/mysql-server does not yet work. which is the logrotate config for mysql on that machine. I need to rotate those log files much much sooner than they are being rotated now. does anyone have any experience with a similar setup?
View Replies !
Linux Version
I have a need to setup a MYSQL cluster, however, I do not have ANY experience of Linux and you cannot set up the cluster on Windows currently. I learn fairly fast, but would like someone to recomend a version of Linux that would happliy support the MYSQL cluster and also has some good installation instuctions!
View Replies !
Mysql In Linux
I have installed MySQl in linux and its working properly. I wrote an c++ program to connect to mysql database, which is capable of retrieving, deleting the values from database table. The problem i am facing is i am unable to insert values into the table at runtime. Can anyone please help me as to how to write the query?
View Replies !
Linux To Install
I am creating a dedicated DB server running mysql. What is the best linux to install for this?Also the db server will have its own ip is there any other additional security measures that should be taken?
View Replies !
Mysqli.dll In Linux
We have developed and application using mysqli.dll and the following functions: mysqli_connect() mysqli_query mysqli_result() The platform was: Windows 2003 / IIS 6.0 / PHP 5 / MySQL 5 Now we need to port over the application to Linux - Red Hat Enterprise Server / Apache / PHP 5 / MySQL 5 Does anyone has an idea what to use instead of mysqli.dll in Linux servers.
View Replies !
DML Of On Linux Server
We have MySQL 5 installed on Linux server. If I defined a table and fields in mixed cases, the table name will be stored in lower case, how about the fields? In the case of SELECT, UPDATE or other DML, do I need to use lower case for the table name and field names? Or do they matter?
View Replies !
Db Migration From Linux To Xp Sp2
db migration from linux to xp sp2 -- can't read I want reinstall my bbs program from fedora 3 to xp sp2 apm. The apm version is apache 2.0.54,php 4.3.11 mysql 4.1.11.(linux and xp) And backup the data and restore on xp machine. ( I tried db copy) The problem is I can't log in my bbs program with migrated ids. But, i made another id and tried to log in, this worked. At phpmyqadmin, I can see the whole records including new id. But bbs program could not read the other migrated records.
View Replies !
MySQL On Redhat Linux
To make a long story short, let me say I had MySQL working on Windows 98 and everything was fine. Well, I took the big leap and removed all traces of Windows and Microsoft from the computer. (hooray!) Once I had Linux running OK, I downloaded and installed MySQL using an RPM package. I guess the server is running (it says it is every time the computer starts and it stops successfully every time the computer shuts down) however, I cannot figure out how to get the MySQL prompt. I've searched the entire hard drive for MySQL, mysql, MySQL*, mysql* and probably some others, too. The only thing I found was a shell script called mysql that starts or stops the server if I am logged in to Linux as root. I cannot figure out how to start the interactive program that allows me to make select statements, inserts, updates, etc. I'm wondering about some things: Did I download and install the wrong thing? Am I just not looking for the correct thing? Did I install it incorrectly?
View Replies !
|
TRACKER
