Unable To Access Mysql

by Nov 8, 2011

So, either I am woefully looking in the wrong folder or just blind, but is the MySQL that comes bundled with uptime an embedded database?

The current issue I'm having is installing uptime. I've tried a Windows 2003 RS system, a Windows XP system, and a RedHat 6.0. I've encountered the same error each time, which is that after uptime is installed and I open it in a web browser, it tells me that the “up.time Data Collector is unavailable” and that I need to restart it. However, I've checked from the Control Panel and the command box/terminal (depending on the system) that the data collector and all other components were up and running. For good measure, I also stopped and restarted them just in case, but that didn't work.

So after which, I tried the RedHat system to access MySQL from the terminal after I was in /uptime/mysql/bin with “mysql -uuptime -puptime -P3308 –protocol=tcp uptime” or “mysql -uroot -puptimerocks -P3308 –protocol=tcp”

where I got “ERROR 1130 (00000): Host 'localhost.localdomain' is not allowed to connect to this MySQL server”, so obviously it's there and this is a connection error. Likewise, I tried accessing it directly (not through uptime) and got

“ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)”

The main reason why I'm asking if the database is embedded is because I was hoping to run a simple test to see if this really is an access issue. I was just going to make a simple website or java applet and see if it shows up in the database. If it doesn't, I've got a bigger issue on my hands.

The only(?) other possible reason I can think of is if my computer is somehow magically trying to access it with an ODBC driver, although I can't for the life of me imagine how that could happen. This is a completely blank unused system which we just want to use as a monitoring station.

For reference, my knowledge of Linux is vastly lacking so if anyone could help me more with the Windows Server 2003 system instead, that would be much appreciated. Likewise, I think I should mention before I annoy countless people with my lack of knowledge that network and database management isn't my specialty. I'm interning here and my boss basically summed this whole experience up with “It's a learning experience. Figure out how to make it work.” so I'll apologize ahead of time if my level of understanding is below everyone else's.

EDIT: After some more prodding, I'd like to retract my first comment, but the rest stands. On Linux, when I just try to check the status of uptime “mysqladmin -u root -p status” it dumped the same error on me, which makes me assume that the server is not running. Except that all other sources indicate that it is.

Please note that the above is only for Linux. On the Windows cmd “mysqladmin -u root -p status” returns the status of mySQL just fine, so it's definitely up and running. Why it won't connect is another story.