I had MySQL 3.23.56 on my RedHat machine but developed some problems (that were probably my own fault) so I decided to upgrade to 4.0. I downloaded the source rpm and rebuilt it on my system (running a fully updated RedHat 9.0). I removed the old mysql by doing rpm -e on the components; then I installed 4.0.13-2 by doing rpm -ivh on the binaries. I have copied the my-large.cnf.sh (I think that was it) from the support-files folder to /etc/my.cnf. Now when I try to set the root password, or other things, I get this message:
Unknown suffix '@' used for variable 'port' (value '@MYSQL_TCP_PORT@') mysqladmin: Error while setting value '@MYSQL_TCP_PORT@' to 'port'
The problem here is that you used my-large.cnf.sh, rather than my-large.cnf. The former is the source from which the latter is built by making the appropriate substitutions to the @xxx@ sequences. You want to use my-large.cnf instead.
I noticed that several of the options apparently need to have values filled in. Where can I find some good documentation on how to set up the new version? Is the O'Reilly book a good resource? I had been using one of the Red Hat Linux "Bible" books and also "MySQL Bible" by Steve Suehring. Is there something more current that I could get?
Yes. :-)
You may e-mail me directly if you wish: [EMAIL PROTECTED] (or, if you have problems, [EMAIL PROTECTED])
Thanks, Kevin
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
