vicidial.org

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

Linux distro?

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

Linux Slackware 11

thanks

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

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.*....)

also I am using mySQL 4.0.27 as per the scratch doc

sorry I never put

create database asterisk;


cheers

its works