I am trying to use mysql 5.0.45 on VL5.9 and I can't install a database.
There was already a user and group mysql so I executed the command
mysql_install_db (enter)
and there was no error message but I can't find the data dir and files
it was supposed to create
According to /usr/ports/opt/mysql/README
README for mysql 5.0.xx
REQUIREMENTS
PRE-INSTALL
POST-INSTALL
1. append /usr/lib/mysql to ld.so.conf and run ldconfig
2. run 'mysql_install_db' to build the system database
in /var/lib/mysql
3. run 'mysql_upgrade' to add new privileges and features
to the MySQL privilege tables if you have 4.x or 3.x
databases
4. Set a password for the mysql root user:
mysqladmin -u root password <mysql_root_password>
There is no /var/lib/mysql directory. I noticed that the package doesn't
include this but I checked the slackware package mysql-5.0.51a-i486-1.tgz
and it does include some extras in /var that the VL5.9 package is missing.
/var/log/packages/mysql-5.0.45-i586-1vl59
usr/include/mysql/mysqld_error.h
usr/include/mysql/mysql_time.h
usr/include/mysql/my_alloc.h
usr/include/mysql/m_string.h
install/
install/doinst.sh
install/slack-desc
install/slack-required
tar -tvzf mysql-5.0.51a-i486-1.tgz
-rw-r--r-- root/root 2313 2008-02-15 00:49 usr/man/man1/mysql-stress-test.pl.1.gz
drwxr-xr-x root/root 0 2008-02-15 00:49 install/
-rw-r--r-- root/root 816 2008-02-15 00:49 install/slack-desc
-rw-r--r-- root/root 1505 2008-02-15 00:49 install/doinst.sh
drwxr-xr-x root/root 0 2008-02-15 00:49 var/
drwxr-xr-x root/root 0 2008-02-15 00:49 var/lib/
drwxr-x--- mysql/mysql 0 2008-02-15 00:49 var/lib/mysql/
drwxr-xr-x root/root 0 2008-02-15 00:49 var/run/
drwxr-xr-x mysql/mysql 0 2008-02-15 00:49 var/run/mysql/
Edit:
I uninstalled the version of mysql that came with VL5.9 and installed the one available for Slackware12
mysql-5.0.51a-i486-1.tgz
I no longer get database install and daemon startup errors. These may have been due to missing
directories /var/lib/mysql and /var/run/mysql but it seems cleaner to install a new package.
