Hi Jude,

This is most likely a permission error. I've always found the default
mysql install script rarely worked 100% according to plan and always
needed a few helpful nudges to get it in working order:

After installing the package:

1) make sure the mysql user and group have been added and the mysql user
is assigned to the mysql group:

grep mysql /etc/passwd
grep mysql /etc/group

if not, add either or both manually (I like to make the GID and UID
the same value as the TCP/IP port):

groupadd -g 3306 sql
useradd -u 3306 -g mysql mysql

2) make sure the mysql directory is owned by the mysql user/group

chown -R mysql:mysql /var/lib/mysql

3) make the init script executable

chmod 0744 /etc/rc.d/rc.mysqld

4) initialize the mysql database:

su - mysql
/usr/bin/mysql_install_db
exit

6) make sure the proper .cnf file has been copied over to /etc/my.cnf:

cp /etc/my-medium.cnf /etc/my.cnf

7) start the mysql daemon and check to make sure you can connect to it

/etc/rc.d/rc.mysqld start

8) verify the process launched successfully:

ps waux | grep mysql
ls -l /var/run/mysql

9) set the root user password

/usr/bin/mysqladmin -u root password '**************'

10) log in to mysql and set the root privileges:

mysql -u root -p
grant ALL privilegeS ON *.* TO 'root'@'localhost' IDENTIFIED BY
'**************';

You should now be able to create your working databases and your
unprivileged user.

Hope this helps,


Jason

--- In linux-slackware@yahoogroups.com, Jude DaShiell <jdashiel@...>
wrote:
>
> My installation procedure no longer works. mysql can't find a
host.frm
> file so can't start up. I figure to be running all of this on a
localhost
> without network interaction and the program is still looking for
> mysql.sock even though I told it to skip networking in the my.cnf
file.
> I understand getting mysql to start up and get running gets even
harder in
> slackware 12.1 if the changelogs are to be believed. Has anyone
got
> around these obstacles and can share the missing installation steps?
>