New Mysql related problem

[ssin14]

Hi
when I keyed :

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

its says

cannot touch `/usr/local/mysql/var/MySQL/Apache.err': No such file or directory
chown: cannot access `/usr/local/mysql/var/MySQL/Apache.err': No such file or directory
Starting mysqld daemon with databases from /usr/local/mysql/var
/usr/local/mysql/bin/mysqld_safe: line 302: /usr/local/mysql/var/MySQL/Apache.err: No such file or directory
/usr/local/mysql/bin/mysqld_safe: line 310: /usr/local/mysql/var/MySQL/Apache.err: No such file or directory




and when I do :

ln -s /tmp/mysql.sock /var/run/mysql/mysql.sock

its says

File exists

Whats wrong wid this and how can we solve this.

using as per scratch. Mysql 4.0.27

[mflorell]

Linux distro?

[ramindia]

Hi

If you are using Centos

no need to run manual

there is already deamon,

you simply reboot server

and then run /etc/rc.d/init.d/mysqld restart

ram

[ssin14]

Linux Slackware 11

thanks

[mflorell]

I use Slackware a lot and I've never seen that kind of error after installing MySQL. Do you have an Apache database?

[ssin14]

Yes ........this server has MySQL, apache vici installed.

I think my database got corrupted. So I have formatted my server. so starting all again now. I couldnt figure out what was the prob..

I got another myslq related prob... (when created database Asterisk)

SUBPHASE 6.1

After this:

GRANT SELECT,INSERT,UPDATE,DELETE on asterisk.* TO cron@'%' IDENTIFIED BY '1234';
GRANT SELECT,INSERT,UPDATE,DELETE on asterisk.* TO cron@localhost IDENTIFIED BY '1234';

when I do this:

use asterisk;

it says ERROR 1049: Unknown database 'asterisk'


On the grant select part do i have to put the dot after keying asterk ( delete on asterisk.*....)

[ssin14]

also I am using mySQL 4.0.27 as per the scratch doc

[ssin14]

sorry I never put

create database asterisk;


cheers

its works