I am trying to use web-erp which in turn uses mysql. But I can't get mysql
to start. I deinstalled it using pkgrool, then reinstalled it from
Slack-current again using pkgtool. I went to /var/lib and made sure that
everything in /var/lib/mysql belonged to mysql grooup mysql. I changed the
permissions on /var/lib/mysql to 777. I made sure that rc.mysql was
executable and then rebooted.

Mysqld starts and then stops again. Apparently it is trying to restore an
old version of data tables. What I want it to do is just start from
scratch. Here is the tail to /var/lib/mysql/hdb1.err
--------------------------------------------------------------------
050716 08:56:15 mysqld started
050716 8:56:16 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
050716 8:56:16 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43634.
InnoDB: Doing recovery: scanned up to log sequence number 0 43634
050716 8:56:16 InnoDB: Flushing modified pages from the buffer pool...
050716 8:56:16 InnoDB: Started; log sequence number 0 43634
050716 8:56:16 [ERROR] Fatal error: Can't open privilege tables: Table
'mysql.host' doesn't exist
050716 08:56:16 mysqld ended
---------------------------------------------------------------------

How do I convince mysql to just begin as a new install? What do I need to
change or wipe out?
John Culleton
Able Indexers and Typesetters

On 2005-07-16, John Culleton <john@wexfordpress.com> wrote:
> everything in /var/lib/mysql belonged to mysql grooup mysql. I changed the
> permissions on /var/lib/mysql to 777. I made sure that rc.mysql was
> executable and then rebooted.

It's rc.mysqld, and did you follow instructions therein? Did you run:

mysql_install_db

......as user mysql as instructed?

> 'mysql.host' doesn't exist

Doesn't look like it. Also, did you start the server as per the
manual?


---------------

2.4.2

3. Start the MySQL server:

shell> bin/mysqld_safe --user=mysql &


----------------

All the info about starting mysqld and testing it is in the manual on
your system:

file:///usr/doc/mysql-4.0.23a/Docs/manual.html

nb

On 2005-07-16, John Culleton <john@wexfordpress.com> wrote:
> I am trying to use web-erp which in turn uses mysql. But I can't get mysql
> to start. I deinstalled it using pkgrool, then reinstalled it from
> Slack-current again using pkgtool. I went to /var/lib and made sure that
> everything in /var/lib/mysql belonged to mysql grooup mysql. I changed the
> permissions on /var/lib/mysql to 777. I made sure that rc.mysql was
> executable and then rebooted.
>

Without knowing what version of mysql..............

Did you run the script mysql_install_db?

For more info at the command line type

info mysql

Then check out the section on post install.

On my system /var/lib/mysql is 750 not 777.

Regardless, you might be better off installing from scratch, however,
before doing anything else check info mysql....the instructions are complete
and pay attention to the post install instruction.

ken

John Culleton wrote:
<snip>

There was an article on setting up mysyl, on this newsgroup by "Jorey
bump" on the 3rd of April, last which you should be able to find in
Google Groups. I hope that it may of some use.

--
Two Ravens
"...hit the squirrel..."

John Culleton wrote:

>How do I convince mysql to just begin as a new install? What do I need to
>change or wipe out?
>John Culleton
>Able Indexers and Typesetters
>
>
Sounds like you've made a mess, so, first thing, log in as root and

cd /var/log/packages
removepkg mysql*

Then haul out your installation CD-ROM, mount it, get into the packages
directory "ap" and

installpkg mysql*.tgz

Then do this:

cd /var/lib/mysql
mysql_install_db --user=mysql (this initializes MySQL so you can use it)
chmod 755 /etc/rc.d/rc.mysqld
/etc/rc.d/rc.mysqld start

and you should be good to go.

You need to look at the MySQL manual (it's on line) at section 2.9.2
UNIX Post-installation Procedures, particularly 2.9.3 Securing the
Initial MySQL Accounts.