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
Related Forum Messages:
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 !
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 !
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 !
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 !
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 !
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?
View Replies !
Mysql Access Yellow Dog Linux
i have a problem similar to others in this group but this is a little bit different. i am running mysql on my yellow dog linux server, but for some reason whenever i try to connect, it gives this error: [root@powerpig root]# telnet localhost 3306 Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. NHost 'localhost.localdomain' is not allowed to connect to this MySQL serverConnection closed by foreign host. [root@powerpig root]# .
View Replies !
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).
View Replies !
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?
View Replies !
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.
View Replies !
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
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 !
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".
View Replies !
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.
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 !
Unable To Connect To Mysql Server(Linux)
i have problem om my sevrer ( linux ) WHM 11.11.0 cPanel 11.16.0-S18450 REDHAT Enterprise 4 i686 on standard - WHM X v3.1.0 after update apache then all websites on server can not connect mysql from WHM > Tweak Settings > Mysql > 5.0 and used old style (4.0) passwords with MySQL® 4.1+ also command /scripts/mysqlup but no way still same error can not connect to Mysql
View Replies !
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 !
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".
View Replies !
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.
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 !
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.
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 !
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 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 !
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 !
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 !
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 !
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 !
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?
View Replies !
Connecting To Mysql Server On Windows
I am trying to use mysql on win98 I downloaded mysql control center. I fill out the info it asks for and it shows it registers the the server but then I cannot connect to setup my db. heres the info I put in. name:upload host:localhost username:root password:****** Ihave tried stopping and restarting everything. I used the default install settings for mysql.
View Replies !
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:
View Replies !
Cannot Start MySQL Server Other Than Using Windows Service
I already learn how to install, starting and stopping server using Windows service, as well as the SQL query. I couldn't start the MySQL server using command-line. I could stop it using command-line by invoking "mysqladmin -u root -p shutdown". When invoking "mysqld --console" There was an error code number 5 that said "InnoDB operating system error number 5 in a file operation". What happened ? As an Additional information, I use Windows Vista SP1 and MySQL 5.1.30-community
View Replies !
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....
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 !
ERROR 2006: MySQL Server Has Gone Away On Dos Windows Client
I keep getting connection lost errors from a DOS windows mysql client on Windows 2000 from which I access a MySQL server (3.23.58) on RH9 (located on a dedicated server outside the country). ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... SQL statements are okay, tables are okay but whenever I stay idle for a few seconds, I get an error. If I retry, I get a reconnect and everything goes well... Then the same thing happens again.
View Replies !
|
TRACKER
