Thread: MYSQL 's fault?
View Single Post
  #3   (View Single Post)  
Old 14th October 2008
disappearedng disappearedng is offline
Shell Scout
 
Join Date: May 2008
Posts: 128
Default

Quote:
Originally Posted by TerryP View Post
Oddly, you don't mention anything about your network.


It might just have been my time spent shouting WTH are these exceptions from when using Rubies Net::* classes under Win32 with a restrictive firewall; but I would be inclined to believe either your system is refusing the connection or mysqld is spiting on you.
Why though? How would I be able to check if my system is actually refusing the connection?


Quote:
Originally Posted by TerryP View Post
Out of curiosity, what happens when you try to connect via a mysql client?
Code:
$ mysql -u youruser -h yourdbhost -p yourdb
   ...
Code:
[disappearedng@miuky1 /usr/home/disappearedng]$ mysql -u disappearedng -h localhost -p books
Enter password: 
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.22-rc FreeBSD port: mysql-server-5.1.22

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>
Quote:
Originally Posted by TerryP View Post
Does the user/db combo you have set in your program have the necessary access rights? As my Grandfather would probably say... If the lamp won't turn on, check if it's unplugged before you throw out the lightbulb.
I would like to check that. I have even ran as root to access my java class file so I don't know whether that's the issue.
Reply With Quote