Solved

mysql startup issue

Posted on 2006-06-13
5
542 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MySQL Server 5.5.36 Tuning 9 50
how do i form the query to get different columns total count 13 42
Amazon Redshift 2 25
MySqlDump not dumping triggers 1 15
All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

911 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now