Re: mysqld ended Can't get mysql running

[Whil Hentzen]

[EMAIL PROTECTED] wrote:
We need more details in order to help:
What operating system are you on?
Which version of MySQL are you attempting to run?
How are you attempting to start the MySQL server?
Has it worked before or is this a new installation?
What errors are being reported to your error log? The default location of 
the error logs is <mysql installation folder/data/*.err
 

I'm running into the same problem. (And what's really aggravating is 
that this happened to me 6 months ago and I didn't write down the 
solution! Jeesh!)

- Installed 5.0 on FCore3.
- Installed both the server and the client on the same box, via rpms.
- The mysql and test databases were NOT created under /var/lib/mysql, 
though.
- So I ran mysql_install_db as root.
- ran '/usr/bin/mysqld_safe &' as root and got the same error as Deborah.
- read the doc, and ran /usr/bin/mysqld_safe & as an regular user and 
got a permission problem:

[EMAIL PROTECTED] /tmp] Dude? Starting mysqld daemon with databases from 
/var/lib/mysql
/usr/bin/mysqld_safe: line 302: /var/lib/mysql/mybox.err: Permission denied
/usr/bin/mysqld_safe: line 308: /var/lib/mysql/mybox.err: Permission denied
STOPPING server from pid file /var/lib/mysql/mybox.com.pid
tee: /var/lib/mysql/mybox.err: Permission denied
050201 14:47:40  mysqld ended
tee: /var/lib/mysql/mybox.err: Permission denied
[1]+  Exit 1                  mysqld_safe --user=mysql

- the permissions
[EMAIL PROTECTED] /var/lib/mysql] I AM ROOT: ls -al
total 40
drwxr-xr-x   4 mysql root 4096 Feb  1 13:45 .
drwxr-xr-x  35 root  root 4096 Feb  1 13:45 ..
-rw-rw----   1 mysql root  693 Feb  1 14:45 mybox.err
drwx--x--x   2 mysql root 4096 Feb  1 13:45 mysql
drwxr-xr-x   2 mysql root 4096 Feb  1 13:45 test
[EMAIL PROTECTED] /var/lib/mysql] I AM ROOT:
And I think those are OK.
So, I can tell that:
1. mysql isn't running, and I can't get it to run
2. it isn't writing to the permissions file, but I don't know why
Whil
We would love to help but your message is just not specific enough.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"Debora Gomes.unitech" <[EMAIL PROTECTED]> wrote on 02/01/2005 05:43:02 
PM:

 

Hi ALL
it reports back
# Starting mysqld daemon with databases from /opt/mysql/data
STOPPING server from pid file /opt/mysql/data/acetona.anp.net.pid
050201 02:43:51  mysqld ended
Att.
Débora S. Gomes
Analista de Tecnologia  - Redes
Agência Nacional do Petróleo - ANP
Tel.: 21 3804-0786
   


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]