   MySQL + RedHat 9 problem
  Hey allI just installed MySQL 4.0 over the previosu version, via the RPM. Now, i thought that it''d be all nice to me, and shut down MySQL, upgrade, then strat it up. Well, actually i don''t know if it did. Anyway, it now refuses to start when i start the machine. Instead, i need to goto the services manager, stop it and restart it.I tried installing MySQL 3.23 (what i had before), in the hope that it''d put things back the way they were. No such luck.The reason i think that MySQL doesn''t start with the system is that in the services config theres two entries: "mysql" and "mysqld". I don''t know if there was 2 there before, but i have a feeling that one of them was put there by MySQL 4.0, and MySQL gets started twice, and dies (or something).So, does anyone know whats wrong with this mess, and if it is something to do with having "mysql" and "mysqld", can i just delete /etc/init.d/mysql* ?Cheers,Steve 
  No, I don''t think you can delete any of them. I don''t have mysql on my RedHat8 system chkconfig list (only mysqld).Did you make sure mysqld is being loaded at boot time? Try:chkconfig mysqld true   "Finishing in second place, simply means you are the first loser." - PouyaCat;  I get:"mysqld 0:off 1:off 2:off 3:off 4:off 5:on 6:off"from "chkconfig --list mysqld" ("chkconfig mysqld true" gave the help screen) ;  Hmm - looks okay. Does it start successfully (eg is there a green OK next to it at start up)? If so, I think I can''t help you much further since I''m a noob@linux.com myself, so don''t bash me to hard  "Finishing in second place, simply means you are the first loser." - PouyaCat;  Heh, join the club. Yeah, it starts up fine at system startup, but phpBB2 and my blog both fail to connect to the database until i restart MySQL from the services window... ;quote:Original post by Evil Steve   Heh, join the club. Yeah, it starts up fine at system startup, but phpBB2 and my blog both fail to connect to the database until i restart MySQL from the services window...   That's weirdish. Are you sure you selected the correct database version in the phpBB installation?I personally had some trouble with privileges whens etting it up, but none with MySQL itself...   edit: you could also download phpMyAdmin to have better control over the database."Finishing in second place, simply means you are the first loser." - PouyaCat   [edited by - crispy on February 9, 2004 4:40:30 PM];  Actually, i installed phpBB2, and then MySQL 4.0, so phpBB is probably still using MySQL 3 stuff. I just tried changing config.php to use MySQL 4, but it doesn''t make any difference... 