[digitaloracle]

When I try to start my MySQL server, I recieve an error 13 (permmission denied) from innodb. BUT, the user mysql owns the directory, and I have set it so that the directory is writable by all users and groups (permissions 666).

So how do I fix this? Or can I turn off innoDB alltogether (how do I do this). All I need is for it to act as a forum database server, so
I do not think I really need all the features InnoDB prvides.

[brady]

After installing MySQL, did you run the mysql_install_db script to set up the initial grant table contents?

[digitaloracle]

It says I should do a "make install" before running the script. However, I did do so, and to no avail. I also tried using the rpm install, but it had several dozen dependency errors that I don't want to sort out. I am currently recompiling the source and reinstalling it. Do you know where exactly "make install" puts everything? Is it the same location that the rpm uses? I am on slackware BTW.

[digitaloracle]

Status : EXTREMELY ANNOYED

Ok, as per MySQL's site instrauctions(these, I have done:
./confgiure --prefix=/usr/local/mysql
make
make install
cp support-files/my-medium.cnf /etc/my.cnf
cd /usr/local/mysql
bin/mysql_install_db --user=mysql

here it gives me this error:

Didn't find /root/mysql/bin/mysqld
You should do a 'make install' before executing this script

that should NOT happen, since I ran make install earilier (in fact I have run it twice). To fix it,. I copied the entire bin directory from /usr/local/mysql to /root/mysql/bin and it still did not work. Then I looked at the bin directory and THERE IS NOT EVEN A FILE CALLED "mysqld" So I remaned mysqld_safe mysqld thinking that they do the same thing anyway. Well, the script finally worked after this, but since I did it in such a terrible fasion I don't think it worked properly. Here is the out put of the script:

Installing all prepared tables
Starting mysqld daemon with databases from /root/mysql/data
STOPPING server from pid file /root/mysql/data/darkstar.pid
060101 18:14:59 mysqld ended

/root/mysql/bin/mysql_create_system_tables: line 766: 13032 Broken pipe cat <<END_OF_DATA
use mysql;
set table_type=myisam;
$c_d
$i_d

$c_h
$i_h

$c_u
$i_u

$c_f
$i_f

$c_t
$c_c

$c_ht
$c_hc
$c_hr
$c_hk

$c_tzn
$i_tzn
$c_tz
$i_tz
$c_tzt
$i_tzt
$c_tztt
$i_tztt
$c_tzls
$i_tzls

$c_p
$c_pp

END_OF_DATA

Fill help tables
Starting mysqld daemon with databases from /root/mysql/data
STOPPING server from pid file /root/mysql/data/darkstar.pid
060101 18:14:59 mysqld ended


To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/root/mysql/bin/mysqladmin -u root password 'new-password'
/root/mysql/bin/mysqladmin -u root -h darkstar password 'new-password'
See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr/local ; /root/mysql/bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the /usr/local/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com

Now, when I run this command:

/usr/local/mysql/bin/mysqld_safe --user=mysql&

It says there was an error. Errors are written to /root/mysql/data/darkstar.err, so I read that file and see this:

060101 18:07:47 mysqld started
060101 18:07:47 [ERROR] Can't find messagefile '/root/mysql/share/mysql/english/
errmsg.sys'
060101 18:07:47 [ERROR] Aborting

060101 18:07:47 mysqld ended

I intend to copy the files it needs, bt is this indicative of some kind of catastophic error with my installation? I mean it did not even copy the friggin help files (which right now I cannot find)

I apologize for my anger, but I have been trying for several days to get this to work with no sucsess.

[shan]

what distro are you installing on?

[JasonMichael]

You can configure mysql to not use InnoDB or even Berkley. I think MySQL uses these two other DB's in order to do its functions of what's called MySQL-Max (transactions, etc.).

So... if you're using RPM's, get MySQL standard...

If you're compiling (the best way)...
when you're configuring, simply put:

./configure --without-innodb
make
make install

Try this...if you want InnoDB, I would recompile that, before compiling MySQL... not sure what pains you'll run into in the process, but there's always something...