Why MySQL daemon (Red Hat Linux Pro 7.3) stops right away after it starts?
Posted on 2003-03-13
I tried to start MySQL daemoon on Red Hat Linux Pro 7.3 (already updated with the latest updates and fixes). I've also checked to be sure
-- that a group: mysql and a unique user: mysql are already created for MySQL
-- that all necessary RPM packages already installed correctly
-- that in the file ld.so.conf, a line to specify the lib of MySQL already exists (/usr/lib/mysql)
I already run the command mysql_install_db to create MySQL tables successfully
However, when I started MySQL with the command: safe_mysqld --user=mysql &, the daemon started and then ended right away. The logs are something like this:
.... Starting mysql daemon from the database /var/lib/mysql.
.... mysql daemon ended.
I already checkec to see if a mysql process is alive with
ps -ef | grep mysqld
but I cannot see any process of mysql. I read into many books and different articles on webs but I couldn't find anything that can help me to solve this yet. One thing is this: in all the books and articles, they always mentioned the approach of installing MySQL by myself into /usr/local/mysql. In my case, I install Red Hat Linux Pro 7.3 and then update it. So all the packages are already installed and there is no central directory for MySQL like discussed in books and articles. For example, exec. programs like mysql_install_db is in /usr/bin where others programs also exist.
Please give some help by showing me how to successfully start MySQL daemon on Red Hat Linux Pro 7.3 (using the packages already installed. I don't want to remove MySQL and then re-installed it). You can give me a bonus if you explain to me why this situation occurs.
Thanks a lot