Hi, i have successfully installed PHP on my web server and now i want to install mysql on the web server, but i am having problems.

i did ./configure and then i tried the following and got the error as below:

root@localhost mysql-5.0.24]# Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysqld/mysqld.pid
060829 15:39:15 mysqld ended


i tried make but it is also unsuccessful.
make
make: *** No targets specified and no makefile found. Stop.
[1]+ Done ./bin/mysqld_safe

It'll be easier if you install a precompiled package using apt-get or yum. All you have to do is type 'apt-get install mysql-server' or 'yum install mysql-server' and let the package installer do the work for you.

There should be an error log somewhere that will show you why mysql failed to start properly. Its location will depend on your installation e.g. on mine its in /var/log/mysql.

I successfully installed mysql, this was output on the terminal:

Installed: mysql-server.i386 0:4.1.20-1.RHEL4.1
Complete!

However i am typing cd /usr ; /usr/bin/mysqld_safe & and the error still comes up:
STOPPING server from pid file /var/run/mysqld/mysqld.pid
060830 08:23:29 mysqld ended

brad

i also tried this, and it failed:

# cd /etc/rc.d/init.d/
# ./mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]


i have followed instructions on the web and advise given here, but I dont know whether i have installed mysql properly, or what to do now. furthermore i cannot find the mysql error log.

please help

Did you look at the error log like I suggested?

i dont know where to find the error log

i found this:

/var/log/mysqld.log

060830 08:23:29 mysqld started
060830 8:23:29 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
060830 8:23:29 [ERROR] Do you already have another mysqld server running on port: 3306 ?
060830 8:23:29 [ERROR] Aborting

060830 8:23:29 [Note] /usr/libexec/mysqld: Shutdown complete

060830 08:23:29 mysqld ended

060830 08:40:40 mysqld started
060830 8:40:40 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
060830 8:40:40 [ERROR] Do you already have another mysqld server running on port: 3306 ?
060830 8:40:40 [ERROR] Aborting

060830 8:40:40 [Note] /usr/libexec/mysqld: Shutdown complete

060830 08:40:40 mysqld ended

060830 08:42:49 mysqld started
060830 8:42:49 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
060830 8:42:49 [ERROR] Do you already have another mysqld server running on port: 3306 ?
060830 8:42:49 [ERROR] Aborting

060830 8:42:49 [Note] /usr/libexec/mysqld: Shutdown complete

060830 08:42:49 mysqld ended

Some app is already using that port, most likely another mysql process. Try uninstalling all mysql packages and just install a single instance.

Try doing this:

and see if it returns any results.
Kill whatever is running on port 3306 with killall, and then try to start mysqld again.