aspose file tools
The moose likes JDBC and the fly likes Problem running MySql Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Problem running MySql" Watch "Problem running MySql" New topic
Author

Problem running MySql

Mark Lau
Ranch Hand

Joined: Dec 15, 2001
Posts: 120
My system in my lab is a Sun Sparc SunBlade 100.
I am running Win2K *inside* Solaris 8 on this machine.
I downloaded mysql-3.23.49-win.zip and installed under the Win2K system. Every time, when I run mysql.exe at c:\mydql\bin, I get such an error message.

ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)
I run the same version of MySql at home with my PC which runs Win2K. I don't have this problem at home. Can anybody kindly educate me please?
Thanks a lot.
Gregg Bolinger
Ranch Hand

Joined: Jul 11, 2001
Posts: 15229

The problem is that the mysql daemon is not running. you need to type mysqld --port=whatever port you want. I usually use 3306. I think that is the default if you don't specify a port, though it may force you to specify a port. My win2K Server box did. mysql.exe is the client for the mysql server. If the server daemon is not running, the client can't run. Hope that helps.
Mark Lau
Ranch Hand

Joined: Dec 15, 2001
Posts: 120
No, I got the same error message even after I run mysqld.exe, which seems to work well, at least I did not see any error message.
I also downloaded the MySql package from sunfreeware.com and pkgadded it to my Solaris 8 system. Every time I run safe_mysqld, I get the following error message:
# ./safe_mysqld
chown: unknown user id mysql
Starting mysqld daemon with databases from
/usr/local/mysql/var
Killed
020308 22:12:04 mysqld ended
#
How do I handle this then?
Thanks.
Gregg Bolinger
Ranch Hand

Joined: Jul 11, 2001
Posts: 15229

Sounds to me like you need to start mysql.exe by passing it a username and password. Usually, when you install Mysql there is a default username called root. And the password is blank. Some versions of MySQL require passing those parameters into the client when starting it. It is late here and I know that on www.mysql.com there is a ton of documentation as to what the options are when passing in params to the client. I however can't remember them off hand. On Monday, if you still haven't got it running, I will do my best to resolve this further with you. But for now, it is late, and I am tired. Good luck this weekend with it.
Mark Lau
Ranch Hand

Joined: Dec 15, 2001
Posts: 120
OK, great. I'll try my best, will return to this forum, successful or not.
Mark Lau
Ranch Hand

Joined: Dec 15, 2001
Posts: 120
Yes, can somebody else help setting up MySql on my Solaris 8? Please refer to my previous posts for the problem which I encountered. Thanks a lot.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Problem running MySql
 
Similar Threads
Problem launching MySql under Solaris 8
Tomcat gets crazy...
MySQL is driving me nuts
Tomcat installation problems!
Exception Occurred when I added policy file