Access Linux Mysql Server From Windows?
Can I run a Mysql server on a linux box, and access the databases belonging to it over a lan from a machine running windows xp?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
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.
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?
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)
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:
Moving MySQL From Windows To Linux
Is it possible to develop a database on Windows and then copy it to Linux? In Oracle it's not possible to simply copy the database between platforms, I just wondered if MySQL is the same.
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!
Moving Mysql Database From Linux To Windows
I have to move my mysql 5 database from linux to windwos system. Can this be done by moving files from data folder or do I have to dump the data then import it back to new system?
Linux And MySQL Access
I know MySQL account has nothing to do with Linux system account. I just wondering is there a way when I creates a new Linux account it will automatically creates a MySQL database account? Or do I have to write my own shell script to do that?
Java In Linux (Redhat 9) To Access MySQL
Using a Java program, I can connect to the test database in MySQL. The test database is installed using a MySQL utility, and it can be accessed by any user without supplying a password. The relevant lines in my Java (Java version 1.4.1) code are: Connection con = null; String url = "jdbc:mysql:///test"; // <== no user or password specified con = DriverManager.getConnection(url); However, when I try to connect to the accounting database (built as one follows the Larry Ullman's "MySQL" book), the program fails. I need to supply a user and a password. The relevant lines are now: Connection con = null; String url = "jdbc:mysql:///accounting?user=root&password=pswd"; // <== con = DriverManager.getConnection(url); I cannot get a connection. The error message is: "Invalid authorization specification: Access denied for user: 'root@thorvald' (Using password: YES)" (thorvald is my machine name.) I have tried all sorts of variations on the url, trying to access the accounting database, with no success. I can use the same user/password of root/pswd within the mysql monitor to access anything I want. Any ideas? Again, I am using Linux (Redhat 9) , Java 1.4.1, MySQL 4.0.13, and the MySQL ConnectorJ 3.0.8 (for Java access to MySQL).
Hou Use MySql On Linux Web Server
Now the problum is that when i Host complete web site to linux server then my all web page is running but i dont no how use MySql database on Net. Through cPanel i creat MySql database but i cant find database root i m not able to Host or copy my existing MySql database with table which is running on my Computer very fine So please tell me process 1 have to simply upload my mySql database in Public Html folder or else where i m using cPanel file manager to upload files
MYSQL Server In Linux
I have a SQL server on a Linux Fedora machine and I try to use a GUI to connect to database I used different GUI like "Toad for MySQL" in connection page I put Linux IP address as "Server host" and username/password I keep getting error: Error No. 2003 Can't connect to MySQL server on '192.168.0.121' (10061) My question is: Do I need a client installation or configuration on Windows machine?
MySQL Server On Linux
I have MySQL server running fine on Linux Server(Ubuntu 6.06LTS). I need to connect Windows workstations to the MySQL server. I installed MySQL ODBC 3.51.14 driver on it. When i try to connect the ODBC allways returns the following error: [MySQL][ODBC 3.51 Driver]Unknown MySQL server host 'mysql' (11001) I tried server names like 'mysqld', 'MySQL', ip address, combinations of linux server name and mysql name, and other characters like *.*, *:*, *:mysql, etc... The MySql server is running fine on linux server, port=3306(default). The 'bind-address = 127.0.0.1' parameter on 'my.cnf' file is marked as comment.
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?
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?
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.
Upgrading MySQL On Linux Server
I need to upgrade MySQL on my server. I've tried to find some tutorial, but Google found nothing interesting. I wonder what is the easiest and most safe way to upgrade MySQL? I'd like to keep configuration (./configure params, configuration files etc) as is and to not hurt anything.
I Can't Start Mysql Server On Linux.
I'm triyng to install mysql server with rpm on a linux red hat 9.0 machine. The installation was succesfully, but now I can't start the server. I think the right command is mysqld_safe --user=mysql but during the starting procedure the server shutdown, it reports: [root@psiche root]# mysqld_safe --user=mysql Starting mysqld daemon with databases from /var/lib/mysql 040525 09:32:25 mysqld ended If I try to rebuilt the grant tables using the mysql_install_db it reports some errors: "asked for 196608 thread stack, but got 126976" and "to start mysql at boot time you have to copy support-files/mysql.server to the right place for your system".
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.
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.
Windows And Linux Versions
I would like to know what are the main differences between windows and linux versions of this DB system. I´m using it on linux but i´m planning to migrate to windows... Is there any performance difference? Is it as solid as linux version? It´s of free use (under GPL) ? I made a test here in windows and it seems to work well..
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.
How Do You Install MySQL 5.0 Server And Administrator On Red Hat Enterprise Linux 3 WS
Could someone point me to instructions for installing MySQL 5.0 server and administrator on a Red Hat Enterprise Linux 3 WS system? I just freshly installed the system and deliberately did not select MySQL serveras part of the installation I downloaded the 5.0 rpm Community Server edition, and that installed fine. My problems came while trying to build the administrator. Basically, I got caught up in a loop of incompatable modules: # rpm -i mysql-3.23.58-16.RHEL3.1.i386.rpm warning: mysql-3.23.58-16.RHEL3.1.i386.rpm: V3 DSA signature: NOKEY, key ID 025e513b error: Failed dependencies: perl-DBD-MySQL is needed by mysql-3.23.58-16.RHEL3.1 MySQL conflicts with mysql-3.23.58-16.RHEL3.1 Suggested resolutions: /var/spool/up2date/perl-DBD-MySQL-2.1021-3.i386.rpm If up2date the suggested resolution, it says I need a library from mysql-3.23.58-16.RHEL3.1.i386.rpm. I will gladly read the "manual" or docs, and would love a pointer to them.
How To Copy InnoDB From Linux To Windows
I am trying to copy an InnoDB Database (mysql) from a linux system to a Windows XP machine.. I copied the files under /mysql/data/mydatabase/ files to the same one on my windows machine, and I copied anotehr 3 files from the the /data folder which I read about in mysql.com (indata1, and two log files)... All the database worked expect for the child tables (that has relation with other tables).. Did I do anything wrong, or is there another way to transfer the database..
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.
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.
Connect From Unix Mysql Server To Ms Access Server
Im wondering is it possible to connect through my mysql db (running on fedora core 4) and access the ms access tables on the ms access server? I have a connection setup the other way around using an odbc bridge, is it possible to do this the other way around enabling me to view / edit the access tables through mysql.
How Can I Access Mysql Database Running On Windows Pc
How can i access mysql database running on windows pc from linux server, on both machine i am using mysql 5 and perl 5.8.8 , ip of windows machine ie. 192.168.0.50 and linux server has 192.168.0.10 on single LAN.
Testing Access To MySQL-DB In Windows-Network
Background: I am writing in C# a program, which reads data out of a MySQL-DB. When the DB is on my local developer PC everything is fine. But when trying to access the MySQL-DB on a server in our Windowsnetwork, I receive the message: "Host '**' is not allowed to connect to this MySQL server".
Integrating Mysql, @mail, And Suse Linux Enterprise Server 9
I have recently received a admin job at a small web hosting company (small) and the current platform is windows and I will be responsible for creating a linux based platform and eventually moving all information over to linux form the windows setup. The idea is like this run Suse Linux Enterprise Server 9 using 2 web server running apache, 2 email servers using @mail, and having 2 front end servers with 4 storage nodes clustered. This company also has some custom database query programs to retrieve information. I might be in a tad over my head at this point, but that is ok there isnt an immediate rush on integration. I am looking for any other admins that might be able to offer any opions regarding this basic setup or that might have this setup and offer any suggestions concerning the actual construction of this type of platform.
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
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.
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 On Windows Server 2003
Is it a good idea to use MySQL on Windows Server 2003 as a good alternate than Microsoft's SQL Server? I've never used MySQL before, could someone tell me how close it is to SQL?
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?
Installing Mysql On Windows Server 2003
i have installed mysql 5 on windows server 2003 and when i want to connect to the database throgh my script it gave me this error Warning: mysql_pconnect() [function.mysql-pconnect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:Inetpubwwwroot estdefault.php on line 9 Couldn't connect to server. why it is like this. what i have to do and also i can access the database from Mysql command line client....
MySQL Installation On Windows 2003 Server
I recently downloaded mysql-4.0.18-win.zip and my plans were to install it on my Windows 2003 Server. After unpacking the files, and clicking on Setup.exe, I get the following errormessage: "C:WINDOWSSYSTEM32CONFIG.NT. The system file is not suitable for running MS-DOS and Microsoft Windows applications. Choose 'Close' to terminate application."
MySQL Service Keeps Shutting Down In Windows Server
Strange, MySQL has been running smoothly for almost a year on this server, and just recently it shuts down after boot up. Running Windows 2003 with all patches. Any attempts to restart MySQL results in shutdown of the service. This is the Event error message: "TCP/IP, --shared-memory, or --named-pipe should be configured on NT OS" Here is the log that shows the shutdown... Code:
How Do I Start Logging On Windows Live MySQL Server?
As I understand it, the server has to be shut down for the logging to be successfully started. Is this correct? I have been experimenting on a local MySQL server to make sure I know what to do on the production server. My production server has a my.ini file at the location c:Program FilesMySQLMySQL Server 4.1my.ini with various config stuff in it. Would it be ok for me to add the following under the [mysqld] part of the file: log=/logs/mysqld.log Thus creating a file named 'mysqld.log' in the folder 'logs'. The main things I need to log are the SQL Statements being executed and the IP Addresses/hostname of the connections. What type of log would be best for this? Also how do I make it so that the log doesn't grow ridiculously large?
Trouble Connecting To MySQL On Windows Server 2003
Fatal error: Call to undefined function mysql_pconnect() <?php # FileName="Connection_php_mysql.htm" # Type="MYSQL" # HTTP="true" $hostname_connMySQL = "localhost"; $database_connMySQL = "database"; $username_connMySQL = "root"; $password_connMySQL = "mypassword"; $connMySQL = mysql_pconnect($hostname_connMySQL, $username_connMySQL, $password_connMySQL) or trigger_error(mysql_error(),E_USER_ERROR); ?> I installed the ODBC drivers as an optional solution, and that appears to be working when I test it within the program, but I don't know how to get my .php website to connect to it. .php files are working correctly on the server, but it's just not connecting to the database.
Lower Case MySQL Table Names On Windows Server 2003....
I currently administer our MySQL db version 3.23.56 on a Linux Cobalt Qube server via an external fron-end piece of software. My Table Names have capital letters at the beginning, i.e. StockMovements, OrderLines..... We are now implementing a cross-over to a Windows Server 2003 machine. I have installed MySQL version 4.0.20a and initially it was stated as 4.0.20a-debug. I managed to find another piece of software to take it out of debug mode as I thought this would help with the table names. The version is now 4.0.20a-max. If I rename the imported tables say from orderlines to OrderLines, it stays, but if I refresh or close/re-open my fron-end, all the table names have reverted back to lower case ? I have lots of .asp apps which are currently working of my Linux MySQL db using Capitals in the table names and fields. Obviously I do not wish to start re-coding all my web pages once I move accross to Windoes Server 2003 ...
Problem With MySQL On A Dell PowerEdge 1850 Running Windows 2K Server
I have 3 friends that installed MySQL 4.0.24 on their Windows 2000 Server platforms all on Dell PowerEdge 1850's. After one to two days - Windows gives an error that the EVENT LOG IS FULL and the applications lose connectivity to the DB. I have to restart the system in order to bring it back up. THis does not happen on Win 2003 nor 2000 Pro nor XP Pro. Only on Win 2k server on Dell PowerEdge 1850.
Installing MySQL On Windows Server 2003 (Intel Xeon Processors)
I am having troubles installing MySQL on my server, which has Windows Server 2003 as an OS. After downloading a package from dev.mysql, I tried to install it, but a message came up saying that this package doesn't support my Processors. Where can I get a package that does support my Xeon processors?
In My Linux Server
What is the default server SQL mode when My SQL 5.0 is installed? Is there any available modes.
|
TRACKER
