Gossamer Forum
Home : General : Databases and SQL :

Mysql startup problems

Quote Reply
Mysql startup problems
Today I restarted the server and I can't start my mysql server!
I tried with the root account, the sudo, but nothing... If I type sudo /usr/bin/safe_mysqld --user=mysql
I get:

Starting mysqld daemon with databases from /var/mysql
020913 20:47:59 mysqld ended

Why this?
Please help
Thanks
Max
The one with Mac OS X Server 10.4 :)
Quote Reply
Re: [maxpico] Mysql startup problems In reply to
You need to look in the error log (probably /var/mysql/somefile.err).

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] Mysql startup problems In reply to
I've found this

020913 20:43:37 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist
Max
The one with Mac OS X Server 10.4 :)
Quote Reply
Re: [maxpico] Mysql startup problems In reply to
Sounds like either:

1. You are starting mysql with the wrong path to the data directory
2. You are starting mysql as the wrong user
3. Your mysql data directories files are not owned by the proper user
4. You are missing your mysql database which contains your access control.

Hope that helps,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] Mysql startup problems In reply to
And what can be the solution?
It worked normally... A day I restarted and now I get this error Unsure
Max
The one with Mac OS X Server 10.4 :)
Quote Reply
Re: [maxpico] Mysql startup problems In reply to
Hi,

This may or may not help, but when installing 3.23.51 on my Mac I had to actually change the permissions manually to allow the user 'mysql' access to mysql.

I installed it as root, but the pkg did not automatically give permissions to mysql the user. It all worked fine after that.

The sql pkg was a straight download from www.entropy.ch

Not sure if that helps.


http://www.iuni.com/...tware/web/index.html
Links Plugins