Oct 20, 2012, 7:04 PM
Re: [FishMonger] Need help writing a script that interacts with a MySQL DB
Did you try connecting from the command line using the same params as in the script? If that fails, then there is no reason to expect it to work in the Perl script. Once you're able to connect from the command line, then we can work on using those params in the script.
I guess the connection is successful.
Here is what is I get in Debian:
root@MDTech:~# mysql -h instance28854.db.xeround.com -P 18847 -u maxwell175 -p
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is *num_removed_by_me*
Server version: 5.1.42 Source distribution
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
(This post was edited by MDTech.us_MAN on Oct 20, 2012, 7:05 PM)