Looking to hire someone to configure MySQL on Windows Server 2003
Greetings We have installed MySQL 4.0 on a dedicated Windows Server 2003. I have the MySQL server running and it appears all is set to go minus one problem. We need to move a MySQL database from the old host to this server. To do that, I want to use a GUI - preferably DBACentral. However; I am unable to connect to the mySQL server that I have set-up. I have tried everything but the GUI will not let me connect. I am not convinced that the 3306 port is open because I tried putting the DBACentral GUI on the Web Server which allowed me to connect to the local MySQL database (which I cannot connect to from my desktop) but I then could not connect to the one we need to move (which I can connect to from my desktop). Does anyone have experience with configuring MySQL for Windows 2003? If so, please let me know. I would like to hire you to get this configured correctly so we can connect remotely and move this database. United States people only and you must be able to get it done ASAP - preferably today. Please contact me if you are interested. Thanks, Rob
Re: Looking to hire someone to configure MySQL on Windows Server 2003
At 12:42 2004-09-08, you wrote: Greetings We have installed MySQL 4.0 on a dedicated Windows Server 2003. I have the MySQL server running and it appears all is set to go minus one problem. We need to move a MySQL database from the old host to this server. To do that, I want to use a GUI - preferably DBACentral. However; I am unable to connect to the mySQL server that I have set-up. You mean the new one, right? The one You just set up? I have tried everything but the GUI will not let me connect. If You're _certain_ that it is the DBACentral that does not let You connect, I would presume the misconfiguration is there. I am not convinced that the 3306 port is open Find out. On the 2003 server run netstat and see... If You have the proper tools installed, You can `netstat -an|grep 3306` - that is what I would do first. because I tried putting the DBACentral GUI on the Web Server which allowed me to connect to the local MySQL database (which I cannot connect to from my desktop) but I then could not connect to the one we need to move (which I can connect to from my desktop). OK, so we have _three_ MySQL servers now: 1 old, 1 new and one on the web server, right? And You need to move from old to new, the webserver one does not enter into this, right? The fact that You can connect to the webserver one from localhost is a sensible precaution: after all, only the webserver has a legitimate need to make connections to it. I think You have allowed access to Your database from only the localhost. You need to create user accounts on the DB that are allowed remote access. Of course after You verify that: - the DB starts and does not complain - which port the listener is active on This is all covered in the post-install tasks in the manual and takes but a few minutes (assuming just simple setup). Does anyone have experience with configuring MySQL for Windows 2003? If so, please let me know. I would like to hire you to get this configured correctly so we can connect remotely and move this database. United States people only and you must be able to get it done ASAP - preferably today. Please contact me if you are interested. In a wider scope: what are the MySQL versions of the old and new DBs? Can't You use mysqldump or just set up replication, use the old until You're convinced that new works to Your satisfaction, and cut it over then? Thanks, Rob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Looking to hire someone to configure MySQL on Windows Server 2003
At 13:19 2004-09-08, you wrote: I am going to amalgamate both Your messages. Hi Tomasz There are two MySQL servers - the one at the shared host and the new one that I just set-up on the dedicated. We need to move the MySQL database from the shared host to our dedicated. I am able to connect to the old one but not the new one. Let's give them names: let's call the old one A and the new one B. I believe A lives at the hosting company and B lives in Your office (for now), later You will want to colocate it. Correct so far? Now, to verify the versions, at the mysql prompt execute: SHOW VARIABLES; close to the end of the list there will be a version variable - find it for both hosts - it shouldn't be a problem, but let's try to eliminate that possibility now. Grep is not recognized when I try to do netstat. OK, You might want to install cygwin tools, but let's not worry about this now. Just do 'netstat -an|more' and look for a line that in the second column (local address) has B's IP address, then colon, and 3306. If You only find '127.0.0.1:3306', B is only listening on loopback. If You find no rows with :3306, MySQL is not running (at least not on a standard port). I was told the MySQL database at the shared company is 4.0. Again, I can connect to that one. The new one is 4.0 as well. See above, verify. I have created a user and allowed that user remote access. I presume on B, right? grant all privileges on text.* to 'user'@'%' identified by 'footman's using grant access; 1. You _did_ create database text, right? 2. I do hope that password is a typo: it was 'footmans', right? 3. I'm perplexed by this USING clause... Did You mean WITH GRANT OPTION? I'll assume so. 3. let me rewrite it a bit: is _this_ what You actually issued: mysql GRANT ALL ON text.* TO 'user'@'%' IDENTIFIED BY 'footmans' WITH GRANT OPTION; After You do that, verify: mysql SHOW GRANTS FOR 'user'@'%'; and, more importantly: mysql SHOW GRANTS FOR 'user'@'Your workstation IP, as seen by the server B'; Thanks.Rob At 13:25 2004-09-08, Rob Taylor wrote: And just to clarify. I an connect to MySQL server at the shared hosting company from my desktop. I cannot connect to it from the new server. That probably means that the user You are trying to connect as is not authorized to connect from the machine You are trying to connect from - let's assume the username is kkk, B's IP address is BBB.BBB.BBB.BBB, connect to A then issue: mysql SHOW GRANTS FOR 'kkk'@'BBB.BBB.BBB.BBB'; It says it cannot connect. That leads me to believe that something on the new server (probably the 3306 port) is not letting traffic remotely through it. Remember, B is likely _not_ using port 3306 to connect to DB on A. I'd be very surprised if it did. Consequently this issue is not likely related to B's inability to provide connection to workstation somewhere And a far more general question: any firewalls/NAT between Your workstation and A? What about on Your route to B? Thanks, -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
