We have just upgraded our system from MySQL 3.23 (the package that comes with RH 9) to MySQL 4.0 using binaries. I hope somebody would take their time to enlighten me on this...

Our current databases are made from MySQL 3.23. We've restored them to MySQL 4.0 hoping to make use of the new fncs provided in this version. We've read somewhere that we have to run the script mysql_fix_privelege_tables to add new priveleges and features. But everytime we do we'd get this error msg...Access denied to root@localhost. We have already given access to my root user.

How do I create new users to MySQL?

How do we start the msql daemon at boot?

Thanks again for all the help.