First I want to thank all of you guys for responding. I feel a new sense of confidence that I will be able to get this thing going!
However, my problems have compounded. We now have a new problem. I took the advice of one archived postings and dragged the four files seemingly installed by the mysql package at the location (in Mac language) users:johnmistler:<the four files> to the trash. That didn't feel right to me once I did it, so I dragged them back. They were named: 1. cd 2. md5 3. md5 sum 4. mysql Now, when I go to the terminal and type: /usr/local/mysql/bin/mysql I get: tcsh: /usr/local/mysql/bin/mysql: Command not found This suggests to me that the mysql file it is being directed to is not there. However, I can verify that the file "mysql" exists at this path (in Mac Language): users:johnmistler:mysql It is listed as a document with Zero KB for its size (?). It definitely is one of the files that I dragged back from the trash. Should I attempt to fix all of this, or go ahead with an uninstall? If I do need to uninstall, how do I do it? I installed the latest PACKAGE from the MySQL.com site 4.0.18-standard along with the startup item package. If you guys still think I need to tough it out, what is the next step? Once again (embarrassingly) -- THANK YOU! John on 3/12/04 7:22 PM, Paul DuBois at [EMAIL PROTECTED] wrote: > At 18:33 -0800 3/12/04, John Mistler wrote: >> I am two days into troubleshooting this. I need some help badly. >> >> I installed MySQL 4.0.18 for Mac. I was able to get in at first: >> >> Welcome to MySQL monitor. Commands end with ; or \g. >> Your MySQL connection id is 14 to server version: 4.0.18-standard > > Please show us the command you entered to start the mysql program. > >> >> then I would type mysql> create database mytest; >> >> and get: ERROR 1044: Access denied for user: '@localhost' to database >> 'mytest' > > The account name (@localhost) has no username before the '@' character, > which indicates that you have connected as the anonymous user. This > user has no privileges to create the mytest database. > >> >> I tried all kinds of commands to change the root password, and every single >> one would result in "Access denied for user . . . " > > Please show what these commands were. No one can help you diagnose > the problem without information to go on. > >> >> I would like to install, instead, CompleteMySQL from the >> serverlogisitics.com site, which has interfaces to help newbies like me. >> However, it is only at version 4.0.15. So my question is: >> >> How can I UNINSTALL the current 4.0.18 version I already have, before >> installing the other one? > > Well ... I'm afraid we cannot tell you that, either, because although > you've indicated that you installed MySQL 4.0.18 for Mac, you haven't > told us how you installed it. Did you use the PKG distribution? Did you > install from source? > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
