cannot connect to database
I'm trying to initialize to a database on another server from a mail server. I can telnet to it but cannot initialize the database. The account and user exists in the database and the paasword as I've tried it from the mysql server. Is there another test I can do to find out exactly what is causing the problem? The firewall is set to allow port 3307 (it the port mysql listens on). Thanks !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=us-ascii META content=MSHTML 6.00.2900.2802 name=GENERATOR/HEAD BODY style=MARGIN-TOP: 2px; FONT: 10pt Arial; MARGIN-LEFT: 2px DIVI'm trying to initialize to a database on another server from a mail server.nbsp; I cannbsp;telnet to it but cannot initialize the database./DIV DIVThe account and user exists in the database and the paasword as I've tried it from the mysql server./DIV DIVIs there another test I can do to find out exactly what is causing the problem?nbsp; The firewall is set to allow port 3307 (it the port mysql listens on)./DIV DIVnbsp;/DIV DIVThanks/DIV DIVnbsp;/DIV/BODY/HTML -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: cannot connect to database
add a user in the table for your remote hostname or ip number. On 12/31/05, Jon Miller [EMAIL PROTECTED] wrote: I'm trying to initialize to a database on another server from a mail server. I can telnet to it but cannot initialize the database. The account and user exists in the database and the paasword as I've tried it from the mysql server. Is there another test I can do to find out exactly what is causing the problem? The firewall is set to allow port 3307 (it the port mysql listens on). Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Anthony Ettinger Signature: http://chovy.dyndns.org/hcard.html
re: beginner's question - cannot connect with database
Sistertech, Wednesday, October 23, 2002, 4:11:31 AM, you wrote: S I'm trying to host a discussion forum for my philosophy class...to make a long story short: S I've now got phpBB2 and MySQL on my virtual domain. S My host doesn't offer any MySQL support. I'm installing phpBB and S I receive an error critical error: cannot connect with database. S All the fields appear to be correct (DB name, server, passwords, phpBB__, etc.) S I've search archives and can't find anything that specifically addresses my issue S AND one that compensates for the fact that I've **never used MySQL or done S any programming**. S I've given full permissions to everything (the folder where phpBb is located, cgi-bin, config.php). S It appears that the database is working (status is OK) although I don't know how to run a test query S (or if such a thing is possible without *any* data or tables in the DB. S Question: I need internet access to a beginner's guide that can help me. S The MySQL FAQ and Manual assume far too much background in programming to be of much help. S An e-book or online tutorial (for pay is fine) is better now than a book, although I'll get one, too. There are some articles at: http://www.mysql.com/articles/index.html Hope that helps. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
beginner's question - cannot connect with database
Greetings all, I'm trying to host a discussion forum for my philosophy class...to make a long story short: I've now got phpBB2 and MySQL on my virtual domain. My host doesn't offer any MySQL support. I'm installing phpBB and I receive an error critical error: cannot connect with database. All the fields appear to be correct (DB name, server, passwords, phpBB__, etc.) I've search archives and can't find anything that specifically addresses my issue AND one that compensates for the fact that I've **never used MySQL or done any programming**. I've given full permissions to everything (the folder where phpBb is located, cgi-bin, config.php). It appears that the database is working (status is OK) although I don't know how to run a test query (or if such a thing is possible without *any* data or tables in the DB. Question: I need internet access to a beginner's guide that can help me. The MySQL FAQ and Manual assume far too much background in programming to be of much help. An e-book or online tutorial (for pay is fine) is better now than a book, although I'll get one, too. Thanks! Prof. Pamela Hood San Francisco State University [EMAIL PROTECTED] or [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Cannot connect to database
Hi Folks I am having trouble connecting to a MySQL table using the DBI-connect() call from a Perl CGI script. The error message I get is: Can't connect to database: Access denied for user: 'web504@localhost' (Using password: YES) The web504 account and password are defined in the user table for any host but with no privileges. The web504 account is also defined in the db table for any host but with select and delete privileges for the required database. If I check access rights with mysqlaccess everything is OK. I can also manually access the database from the web server by running mysql as web504. If I change the DBI call to use the root account and password the CGI script runs succesfully. Any help greatly appreciated Cheers Norman Buskell - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
cannot connect to database
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Hello folks, This is probably some very stupid mistake, but I don't know what else to do. I just installed the latest mysql source. Everything compiled nice and without errors and installed correctly. My problem is, I can't connect to the database. Here is the error message: Warning: Access denied for user: 'root@localhost' (Using password: YES) The password is set, but I still get this. Also, is there a way to let other hosts, other than localhost connect to the db? Thanks for any help. Please e-mail any answers to me directly, as I am not on this list. Cheers... -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.4 (OSF1) Comment: http://1086362465/emre-dsa.asc iD8DBQE6jql6UGchLJL+QvQRA6oPAJ9gqNQje7Hf2eKF6K4TU2Tv1rOzDACgqD7t rKSrX4uvKH+tB+4mkDZnKt8= =Kit1 -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: cannot connect to database
just do it using grant statement so that you can connect from another host. use grant to username@'%' instead of localhost - Original Message - From: "Emre Yildirim" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, February 18, 2001 12:40 AM Subject: cannot connect to database -BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Hello folks, This is probably some very stupid mistake, but I don't know what else to do. I just installed the latest mysql source. Everything compiled nice and without errors and installed correctly. My problem is, I can't connect to the database. Here is the error message: Warning: Access denied for user: 'root@localhost' (Using password: YES) The password is set, but I still get this. Also, is there a way to let other hosts, other than localhost connect to the db? Thanks for any help. Please e-mail any answers to me directly, as I am not on this list. Cheers... -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.4 (OSF1) Comment: http://1086362465/emre-dsa.asc iD8DBQE6jql6UGchLJL+QvQRA6oPAJ9gqNQje7Hf2eKF6K4TU2Tv1rOzDACgqD7t rKSrX4uvKH+tB+4mkDZnKt8= =Kit1 -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php