Solved

mysql startup issue

Posted on 2006-06-13
5
547 Views
Last Modified: 2008-01-09
hi,
I have installed mysql, but unable to start it up. I am getting the following error. any help is appreciated. Thanks!

discovery# bin/mysqld_safe
ld.so.1: ./bin/my_print_defaults: fatal: libm.so.2: open failed: No such file or directory
ld.so.1: ./bin/my_print_defaults: fatal: libm.so.2: open failed: No such file or directory
Starting mysqld daemon with databases from /opt/mysql/mysql/data
Killed
STOPPING server from pid file /opt/mysql/mysql/data/discovery.pid
060613 15:41:32  mysqld ended

discovery# pwd
/opt/mysql/mysql
0
Comment
Question by:mytilig
5 Comments
 
LVL 19

Accepted Solution

by:
Kim Ryan earned 250 total points
ID: 16898637
What version omf MySQL and how was it installed and any warnings created?

The error shows that a MySQL utility (my_print_defaults) cannot find a shared library, so my guess is that something has gone wrong during the install process.
0
 

Author Comment

by:mytilig
ID: 16904618
I downloaded mysql 5.0 Solaris version from here
http://dev.mysql.com/downloads/mysql/5.0.html

Installed per instructions here
http://dev.mysql.com/doc/refman/5.0/en/solaris-installation.html

One possiblity is maybe the server already had a prior instance of mysql installed.

How can I uninstall it on solaris and start the process from fresh?

Thanks!
0
 
LVL 22

Assisted Solution

by:NovaDenizen
NovaDenizen earned 250 total points
ID: 16907707
libm.so is the standard floating-point library (with sin(), cos(), ceil(), etc).  It's a standard library, you definitely ought to have it.  You probably have the wrong version.

I think you downoaded a binary build of mysql for the wrong version of solaris.  Look for libraries like 'libm.*' in /lib and /usr/lib.

ldd is a useful utility to find problems with shared-library dependencies.  Run:
ldd /usr/bin/my_print_defaults
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question