mySQL starts then Stops, no 'mysql.host'

DavidHB · 05-10-2006, 01:43 PM

I installed mySQL in the initial installation. When I boot it starts but then in a few seconds stops. An error log indicates that it "Can't open privelege tables: 'mysql.host' doesn't exist.

Where should it be, where can I find it?

I eventually want to use a C++ API to connect to and interact with the DataBase.

Dave

DavidHB · 05-10-2006, 02:44 PM

Looking at other threads, Iwent and installed an initial DataBase, while got me half a step further. But now the log says /usr/libexec/mysqld: Can't find file './mysql/host.frm'

My database is in /var/lib/mysql and in that directory is a directory mysql which has the database files. 'host.frm' is there along with host.MY1 and host.MYD. The access rights seem to be OK, why can't it be seen.

DaveHB

Wim Sturkenboom · 05-11-2006, 09:00 AM

You're using slackware? In versions 10.0 and 10.1 (can't speak for other versions):
Check the file /etc/rc.mysqld to check where it expects the database.

Code:

# Start mysqld:
mysqld_start() {
  if [ -x /usr/bin/mysqld_safe ]; then
    # If there is an old PID file (no mysqld running), clean it up:
    if [ -r /var/run/mysql/mysql.pid ]; then
      if ! ps axc | grep mysqld 1> /dev/null 2> /dev/null ; then
        echo "Cleaning up old /var/run/mysql/mysql.pid."
        rm -f /var/run/mysql/mysql.pid
      fi
    fi
    /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/run/mysql/mysql.pid $SKIP &
  fi
}

Correct if necessary. Restart mysql server so changes take effect.

It might be the solution.

wchild · 05-11-2006, 09:17 AM

It is not enough to install the mysql package.
After installation you have to run as root a certain script from that package which creates the system tables.

Wim Sturkenboom · 05-12-2006, 01:12 AM

He did that (and hopefully not as root but as user mysql).

BCarey · 05-12-2006, 12:18 PM

Wim's parenthetic comment is important! This happened to me once, and it was because I initialized the databases as root rather than as mysql user.

Brian

DavidHB · 05-13-2006, 09:38 AM

Yeah, I did it as root. That's probably the problem then. Also I'll check rc.mysql and let you all know how it came out

DavidHB

DavidHB · 05-15-2006, 08:01 AM

Thanks All,

That was the key, to install the mysql database as user mysql.

Start as root, su to mysql, execute the script and roboot!

Thanx
DavidHB

wchild · 05-15-2006, 10:17 AM

Hehe I forgot the middle step
su mysql

Iketani · 08-08-2006, 04:38 AM

I have the same problem, i am trying su mysql but then i am asked for a password and it is allways incorrect

Iketani · 08-08-2006, 05:11 AM

Quote:

Originally Posted by Iketani

I have the same problem, i am trying su mysql but then i am asked for a password and it is allways incorrect

Ok problem solved

i just had to "su root" and then "su mysql" and now my mysql is working fine