LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices


Reply
  Search this Thread
Old 02-24-2005, 05:02 PM   #1
GUIPenguin
Member
 
Registered: Aug 2004
Location: Maine
Distribution: Gentoo Linux
Posts: 239

Rep: Reputation: 30
Help starting mysql


Ok I setup mysql using this totural
http://dev.mysql.com/doc/mysql/en/multi-install.html

yes it is originaly for a person setting up a cluster, but mysql-standard-4.1.10-pc-linux-gnu-i686.tar.gz is a precompiled binary tree should work with the setup. I just dont have to compile it.

Anyways I did Everything in the totural.
I have serached the internet for this problem, and it looks like it is one of the biggest problems when first setting up and starting mysql.

if I run /usr/local/mysql/bin/mysqld_safe it looks like it is going to start but just says

Starting mysqld deamon with databases from /var/lib/mysql and thats it, I never get a prompt back.

I am running Fedora core 3 and dont know where to go from here. I have also tryed setting mysql with this totural http://www.hostlibrary.com/installin...l_php_on_linux

and I cant compile the config it becouse it starts and stops sql like before.

probably I am doing something really dumb. do you know of another good totural that I could go by for fedora core 3? I would really like to get mysql working so I can go on to setting up php with it and apache.

Thanks alot!

Last edited by GUIPenguin; 02-24-2005 at 05:12 PM.
 
Old 02-24-2005, 05:09 PM   #2
Matir
LQ Guru
 
Registered: Nov 2004
Location: San Jose, CA
Distribution: Debian, Arch
Posts: 8,507

Rep: Reputation: 128Reputation: 128
mysqld_safe does not fork into the background automatically. It's generally intended to be run by an init script. You could do mysqld_safe & yourself, of course. Then you should be able to connect with the client.
 
Old 02-24-2005, 05:17 PM   #3
GUIPenguin
Member
 
Registered: Aug 2004
Location: Maine
Distribution: Gentoo Linux
Posts: 239

Original Poster
Rep: Reputation: 30
that doesnt work, it still says 'starting mysqld deamon with databases from /var/lib/mysql

and doesnt return a prompt, I am not running a gui, so maybe it doesnt return a prompt, but just continues to run in the prompt untill I terminate it, but using & should make it run in the background with that user if I'm correct.

EDIT: well when I then goto terminate it then I do

/bin/ps -ax | grep 'mysqld'

I get returned a hudge list of running pids so it looks like it is running, I dunno

becouse when I goto /usr/local/mysql/bin/mysqladmin -u root password new_password to setup a new mysql password it returns to me this error:

cannot connect to local MySql server through socket /tmp/mysql.sock
check that mysqld is running and that socket exists, I checked and it isnt there, so I ether have to put it there, or is should created it its self, but I search with updatedb then locate and cant find mysql.sock anywhere

Last edited by GUIPenguin; 02-24-2005 at 05:26 PM.
 
Old 02-24-2005, 05:36 PM   #4
Matir
LQ Guru
 
Registered: Nov 2004
Location: San Jose, CA
Distribution: Debian, Arch
Posts: 8,507

Rep: Reputation: 128Reputation: 128
mysqld should create mysql.sock, though in some systems, it's in a non-standard location. find / -name 'mysql.sock'
 
Old 02-24-2005, 05:40 PM   #5
GUIPenguin
Member
 
Registered: Aug 2004
Location: Maine
Distribution: Gentoo Linux
Posts: 239

Original Poster
Rep: Reputation: 30
that find command didnt return any results
I would like to get this thing working, maybe I should just try an install from rpm

Last edited by GUIPenguin; 02-24-2005 at 05:41 PM.
 
Old 02-24-2005, 06:00 PM   #6
e-dynamics
LQ Newbie
 
Registered: Feb 2005
Location: Belgium
Distribution: Fedora/Solaris
Posts: 1

Rep: Reputation: 0
What files are in the /var/lib/mysql directory and what are the permissions?
You could also try strace -e trace=file /usr/local/mysql/bin/mysqld_safe to find out what files
are accessed by the process. You can send me the output of you want.
 
Old 02-25-2005, 12:39 AM   #7
J.W.
LQ Veteran
 
Registered: Mar 2003
Location: Boise, ID
Distribution: Mint
Posts: 6,642

Rep: Reputation: 87
Just my 2 cents but I consider this tutorial to be top notch. Good luck with it -- J.W.
 
Old 03-10-2005, 10:40 PM   #8
cloudsweng
LQ Newbie
 
Registered: Mar 2005
Posts: 1

Rep: Reputation: 0
I got the same problem

here's the trace of mysqld_safe, please see if there's something wrong with the startup of mysql server, cheers

execve("/usr/bin/mysqld_safe", ["mysqld_safe"], [/* 32 vars */]) = 0
access("/etc/ld.so.preload", R_OK) = -1 ENOENT (No such file or directory)
open("/etc/ld.so.cache", O_RDONLY) = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=50221, ...}) = 0
open("/lib/libtermcap.so.2", O_RDONLY) = 3
fstat64(3, {st_mode=S_IFREG|0755, st_size=12592, ...}) = 0
open("/lib/libdl.so.2", O_RDONLY) = 3
fstat64(3, {st_mode=S_IFREG|0755, st_size=16908, ...}) = 0
open("/lib/tls/libc.so.6", O_RDONLY) = 3
fstat64(3, {st_mode=S_IFREG|0755, st_size=1512400, ...}) = 0
open("/dev/tty", O_RDWR|O_NONBLOCK|O_LARGEFILE) = 3
open("/usr/lib/locale/locale-archive", O_RDONLY|O_LARGEFILE) = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=38649280, ...}) = 0
open("/etc/mtab", O_RDONLY) = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=321, ...}) = 0
open("/proc/meminfo", O_RDONLY) = 3
fstat64(3, {st_mode=S_IFREG|0444, st_size=0, ...}) = 0
stat64("/usr/bin", {st_mode=S_IFDIR|0755, st_size=57344, ...}) = 0
stat64(".", {st_mode=S_IFDIR|0755, st_size=57344, ...}) = 0
open("/usr/lib/gconv/gconv-modules.cache", O_RDONLY) = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=21544, ...}) = 0
open("/usr/bin/mysqld_safe", O_RDONLY|O_LARGEFILE) = 3
fstat64(255, {st_mode=S_IFREG|0755, st_size=10860, ...}) = 0
--- SIGCHLD (Child exited) @ 0 (0) ---
stat64("./share/mysql/english/errmsg.sys", 0xfef2ada0) = -1 ENOENT (No such file or directory)
access("./bin/mysqld", X_OK) = -1 ENOENT (No such file or directory)
stat64("./share/mysql/english/errmsg.sys", 0xfef2aca0) = -1 ENOENT (No such file or directory)
access("./libexec/mysqld", X_OK) = -1 ENOENT (No such file or directory)
access("/usr/sbin/mysqld-max", X_OK) = -1 ENOENT (No such file or directory)
access("./bin/my_print_defaults", X_OK) = -1 ENOENT (No such file or directory)
access("/usr/bin/my_print_defaults", X_OK) = 0
--- SIGCHLD (Child exited) @ 0 (0) ---
--- SIGCHLD (Child exited) @ 0 (0) ---
--- SIGCHLD (Child exited) @ 0 (0) ---
--- SIGCHLD (Child exited) @ 0 (0) ---
--- SIGCHLD (Child exited) @ 0 (0) ---
--- SIGCHLD (Child exited) @ 0 (0) ---
access("/usr/sbin/mysqld", X_OK) = 0
stat64(".", {st_mode=S_IFDIR|0755, st_size=57344, ...}) = 0
stat64("/usr/kerberos/sbin/nohup", 0xfef2ad70) = -1 ENOENT (No such file or directory)
stat64("/usr/kerberos/bin/nohup", 0xfef2ad70) = -1 ENOENT (No such file or directory)
stat64("/usr/local/bin/nohup", 0xfef2ad70) = -1 ENOENT (No such file or directory)
stat64("/usr/bin/nohup", {st_mode=S_IFREG|0755, st_size=17624, ...}) = 0
access("/usr/bin/nohup", X_OK) = 0
stat64("/usr/bin/nohup", {st_mode=S_IFREG|0755, st_size=17624, ...}) = 0
access("/usr/bin/nohup", X_OK) = 0
--- SIGCHLD (Child exited) @ 0 (0) ---
--- SIGCHLD (Child exited) @ 0 (0) ---
--- SIGCHLD (Child exited) @ 0 (0) ---
--- SIGCHLD (Child exited) @ 0 (0) ---
access("/", W_OK) = 0
stat64(".", {st_mode=S_IFDIR|0755, st_size=57344, ...}) = 0
stat64("/usr/kerberos/sbin/touch", 0xfef2a4a0) = -1 ENOENT (No such file or directory)
stat64("/usr/kerberos/bin/touch", 0xfef2a4a0) = -1 ENOENT (No such file or directory)
stat64("/usr/local/bin/touch", 0xfef2a4a0) = -1 ENOENT (No such file or directory)
stat64("/usr/bin/touch", 0xfef2a4a0) = -1 ENOENT (No such file or directory)
stat64("/bin/touch", {st_mode=S_IFREG|0755, st_size=35164, ...}) = 0
access("/bin/touch", X_OK) = 0
stat64("/bin/touch", {st_mode=S_IFREG|0755, st_size=35164, ...}) = 0
access("/bin/touch", X_OK) = 0
--- SIGCHLD (Child exited) @ 0 (0) ---
stat64(".", {st_mode=S_IFDIR|0755, st_size=57344, ...}) = 0
stat64("/usr/kerberos/sbin/chown", 0xfef2a6e0) = -1 ENOENT (No such file or directory)
stat64("/usr/kerberos/bin/chown", 0xfef2a6e0) = -1 ENOENT (No such file or directory)
stat64("/usr/local/bin/chown", 0xfef2a6e0) = -1 ENOENT (No such file or directory)
stat64("/usr/bin/chown", 0xfef2a6e0) = -1 ENOENT (No such file or directory)
stat64("/bin/chown", {st_mode=S_IFREG|0755, st_size=37704, ...}) = 0
access("/bin/chown", X_OK) = 0
stat64("/bin/chown", {st_mode=S_IFREG|0755, st_size=37704, ...}) = 0
access("/bin/chown", X_OK) = 0
--- SIGCHLD (Child exited) @ 0 (0) ---
stat64("/var/run/mysqld/mysqld.pid", 0xfef2ade0) = -1 ENOENT (No such file or directory)
fstat64(1, {st_mode=S_IFCHR|0620, st_rdev=makedev(136, 1), ...}) = 0
Starting mysqld daemon with databases from /var/lib/mysql
--- SIGCHLD (Child exited) @ 0 (0) ---
open("/var/log/mysqld.log", O_WRONLY|O_APPEND|O_CREAT|O_LARGEFILE, 0666) = 3
stat64(".", {st_mode=S_IFDIR|0755, st_size=57344, ...}) = 0
stat64("/usr/kerberos/sbin/rm", 0xfef2a470) = -1 ENOENT (No such file or directory)
stat64("/usr/kerberos/bin/rm", 0xfef2a470) = -1 ENOENT (No such file or directory)
stat64("/usr/local/bin/rm", 0xfef2a470) = -1 ENOENT (No such file or directory)
stat64("/usr/bin/rm", 0xfef2a470) = -1 ENOENT (No such file or directory)
stat64("/bin/rm", {st_mode=S_IFREG|0755, st_size=34920, ...}) = 0
access("/bin/rm", X_OK) = 0
stat64("/bin/rm", {st_mode=S_IFREG|0755, st_size=34920, ...}) = 0
access("/bin/rm", X_OK) = 0
--- SIGCHLD (Child exited) @ 0 (0) ---
stat64("/usr/bin/nohup", {st_mode=S_IFREG|0755, st_size=17624, ...}) = 0
access("/usr/bin/nohup", X_OK) = 0
--- SIGCHLD (Child exited) @ 0 (0) ---
stat64("/var/run/mysqld/mysqld.pid", 0xfef2a630) = -1 ENOENT (No such file or directory)
STOPPING server from pid file /var/run/mysqld/mysqld.pid
050311 12:34:56 mysqld ended
--- SIGCHLD (Child exited) @ 0 (0) ---

--- SIGCHLD (Child exited) @ 0 (0) ---
 
Old 04-05-2005, 09:23 AM   #9
cb8100
LQ Newbie
 
Registered: Feb 2004
Location: Monterey, CA USA
Distribution: Slackware
Posts: 20

Rep: Reputation: 0
Sorry to bump, but I'm having the same problem. mysqld_safe spawns the MySQL daemon, but hangs in the terminal. I had put mysqld_safe in my rc.local and had to boot in single user since my system stopped booting after that line.

Even if I run "mysqld_safe &" from a console, the console window still hangs.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Starting MySQL OLD Error : imeout error occurred trying to start MySQL Daemon Fr33B5D Linux - Software 9 10-28-2006 06:23 AM
Help starting up mysql . rullman Linux - Software 4 05-24-2004 05:00 AM
Starting up MySQL bwreath Linux - Software 2 01-20-2004 03:20 PM
starting mysql apax Linux - Newbie 4 12-28-2003 07:50 AM
starting mysql studentforever Linux - Software 10 09-18-2003 04:34 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - General

All times are GMT -5. The time now is 09:14 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration