mysql Hi Doug, I am not sure what you want to tell me. But you may be right about shell available for Windows. I assume it is an add-on program. I have not used this shell prompt either; it may be available on Windows XP.
But may I ask you one question? Do you think I can find mysql_install_db script in mysql directory or subdirectories for windows XP? I aint find it. By the way, the c:> prompt does not show on the first page of the troubleshooting at all. The partial copy and paste will save our time. See below. ================================================================ 4.2.11 Causes of Access denied Errors If you encounter Access denied errors when you try to connect to the MySQL server, the list below indicates some courses of action you can take to correct the problem: a.. After installing MySQL, did you run the mysql_install_db script to set up the initial grant table contents? If not, do so. See section 4.3.4 Setting Up the Initial MySQL Privileges. Test the initial privileges by executing this command: shell> mysql -u root test The server should let you connect without error. You should also make sure you have a file `user.MYD' in the MySQL database directory. Ordinarily, this is `PATH/var/mysql/user.MYD', where PATH is the pathname to the MySQL installation root. b.. After a fresh installation, you should connect to the server and set up your users and their access permissions: shell> mysql -u root mysql The server should let you connect because the MySQL root user has no password initially. That is also a security risk, so setting the root password is something you should do while you're setting up your other MySQL users. If you try to connect as root and get this error: ========================================================= I would like to hear your reply. Then we discuss on it. But my mysql now is working fine. It appears that a script is not needed for installation. I always thought that script is for UNIX. ----- Original Message ----- From: "Doug Thompson" <[EMAIL PROTECTED]> To: "alan4100" <[EMAIL PROTECTED]> Sent: Wednesday, March 20, 2002 8:36 PM Subject: Re: Access denied on use mysql; > Generally, yes. I have used the procedures to troubleshoot win98 and linux problems. Certainly some of the items are > particular to one OS or another, but that's usually pretty well identified. I have no practical experience with XP, > so I cannot provide much help that's specific to that OS. > > For example, your problem is symptomatic of not having installed the mysql database. That's the first item on the > troubleshooting page. It's accomplished by running the mysql_install_db script. > > The "c:\>" prompt in windows is a shell prompt, btw. In this context, "shell" is a generic term referring to whatever > command line prompt your system provides. > > Doug > > On Wed, 20 Mar 2002 11:16:48 -0500, alan4100 wrote: > > >Does it apply to windows xp? > > > >It applies only to unix because of shell prompt: shell> > > > >I am using windows XP. > > > >----- Original Message ----- > >From: "Doug Thompson" <[EMAIL PROTECTED]> > >To: "alan4100" <[EMAIL PROTECTED]>; "Joel Rees" <[EMAIL PROTECTED]> > >Cc: <[EMAIL PROTECTED]> > >Sent: Wednesday, March 20, 2002 10:48 AM > >Subject: Re: Access denied on use mysql; > > > > > >> Odd, I think it does a very good job of helping troubleshoot: > >> > >> http://www.mysql.com/doc/A/c/Access_denied.html > >> > >> > >> On Wed, 20 Mar 2002 09:30:48 -0500, alan4100 wrote: > >> > >> >And does not explain at all when mysql -u root -p does not work. > >> > > >> > >> > >> > > > > > ----- Original Message ----- From: "Doug Thompson" <[EMAIL PROTECTED]> To: "alan4100" <[EMAIL PROTECTED]> Sent: Wednesday, March 20, 2002 8:36 PM Subject: Re: Access denied on use mysql; > Generally, yes. I have used the procedures to troubleshoot win98 and linux problems. Certainly some of the items are > particular to one OS or another, but that's usually pretty well identified. I have no practical experience with XP, > so I cannot provide much help that's specific to that OS. > > For example, your problem is symptomatic of not having installed the mysql database. That's the first item on the > troubleshooting page. It's accomplished by running the mysql_install_db script. > > The "c:\>" prompt in windows is a shell prompt, btw. In this context, "shell" is a generic term referring to whatever > command line prompt your system provides. > > Doug > > On Wed, 20 Mar 2002 11:16:48 -0500, alan4100 wrote: > > >Does it apply to windows xp? > > > >It applies only to unix because of shell prompt: shell> > > > >I am using windows XP. > > > >----- Original Message ----- > >From: "Doug Thompson" <[EMAIL PROTECTED]> > >To: "alan4100" <[EMAIL PROTECTED]>; "Joel Rees" <[EMAIL PROTECTED]> > >Cc: <[EMAIL PROTECTED]> > >Sent: Wednesday, March 20, 2002 10:48 AM > >Subject: Re: Access denied on use mysql; > > > > > >> Odd, I think it does a very good job of helping troubleshoot: > >> > >> http://www.mysql.com/doc/A/c/Access_denied.html > >> > >> > >> On Wed, 20 Mar 2002 09:30:48 -0500, alan4100 wrote: > >> > >> >And does not explain at all when mysql -u root -p does not work. > >> > > >> > >> > >> > > > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
