Re: Windows - logging into MySQL
His answer was correct, and somewhat politer than "RTFM". As for finding your "own damn answers", see again Mr. Green's original reply. Beauford wrote: Sorry, but I don't take kindly to idiots. I don't care if he's gods gift to MySQL. If there isn't enough info for him to give an informed answer then he should either ask for more or shut up. I'm just simply trying to resolve a problem, and flip answers aren't needed or appropriate. I don't send emails to the list at the first sign of problem, this is probably the first in over a year and a half. When I do however, it is because the manual or other attempts have not provided me the answers I need. In any event I will move on and find my answers elsewhere. -Original Message- From: J.R. Bullington [mailto:[EMAIL PROTECTED] Sent: November 30, 2005 6:37 PM To: mysql@lists.mysql.com Subject: RE: Windows - logging into MySQL You need to be careful what you write. I have found that Shawn is one of the best guys on this list. His answers are 99% right on target (1% because not enough information was given) and can help on every version of db out there. Don't start a flame war because your feelings were hurt. Grow up. J.R. -Original Message- From: Beauford [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 30, 2005 6:05 PM To: 'Logan, David (SST - Adelaide)' Cc: mysql@lists.mysql.com Subject: RE: Windows - logging into MySQL There are always idots like Shawn Green that give BS answers just for the sake of responding, and for me it just reflects badly on the group as a whole. There are many others that help, but when I open my email and this is the first response I see, it just gets under my skin. FYI. I have posted some information in another response as to the problems with later versions etc. -Original Message- From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Sent: November 30, 2005 5:57 PM To: Beauford; [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: RE: Windows - logging into MySQL Sorry Beauford, The url that Shawn gave you is valid for the version you quoted. There hasn't been much change and they work just as well. This is also the earliest documentation that now exists on the website. What is the bad name this list has gained? I've found it helpful on numerous occasions. I think a reconsideration of your opinions would result in a change of heart. The documentation states the defaults that the mysql client program would accept, it also details how to set users and passwords exactly as you requested. These all work on 3.23.58 (I have this version installed at a customer site as we write). Perhaps if you detail the problems you had installing the later versions, somebody may be able to help. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Beauford [mailto:[EMAIL PROTECTED] Sent: Thursday, 1 December 2005 9:21 AM To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: RE: Windows - logging into MySQL This is why lists like this get a bad name. First off, these instructions are for 4.1. Secondly. What makes you think I haven't read the instructions or searched extensively on Google etc. Either give a proper answer or just shut your mouth. Never mind anyone responding, I'll find my own damn answers. Thanks for the help. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: November 30, 2005 12:16 AM To: Beauford Cc: mysql@lists.mysql.com Subject: Re: Windows - logging into MySQL "Beauford" <[EMAIL PROTECTED]> wrote on 11/29/2005 11:31:24 PM: I just installed MySQL 3.23 (the only one I could get to work) and I find that I can log into the server just by typing mysql at the DOS prompt. Ho do make it so you have to use a user name and password to get in. Thanks Running on Win2k Advance Server. You could try following the installation instructions in the manual http://dev.mysql.com/doc/refman/4.1/en/windows-installation.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Windows - logging into MySQL
Clearly you don't read instructions as well as you'd like us to think. As has been pointed out by numerous people, the instructions that were suggested to are applicable to the version of MySQL that you are running (3.2.3) I followed the link suggested to you, and it took me a whole second to discern that the instructions are applicable to 3.2.3. (Hint: look at the title of the page, namely 'MySQL 3.23, 4.0, 4.1 Reference Manual. So your entire arguement about giving this list a bad name is fallacious. You complained that people should give proper answers or shut their mouths. Well, if you had taken ANY time to really look at the FREE advice that someone kindly gave you, perhaps you'd realize that the answer is fine. Not to mention that in your complaint you end up doing the same thing that you are complaining about, namely giving yourself a bad name. I don't watch this list religiously but happened to check this thread. I will remember your name, and it will be a cold day in hell before i give you any help. Furthermore, when i read your statement of "Never mind anyone responding, I'll find my own damn answers" it sure implied to me that you wouldn't be back to this list, considering its horrible reputation and all. But not more than 10 minutes later, you are back posting to the list again. That really reminds me of small children saying things like "I hate you, im never talking to you again" and then ten minutes later are asking you for help. If you're coming to a free source for help, at least be gracious and realize that people are helping you for no gain of their own. Not to mention that EVERYONE makes mistakes, including you. You made the mistake of thinking that the answer you received didn't apply to the MySQL version that you're using. Also, if you're going to make an ultimatum (such as never returning to this list), at least stick with it. Don't come back ten minutes later. On Wednesday 30 November 2005 16:50, Beauford wrote: > This is why lists like this get a bad name. First off, these instructions > are for 4.1. Secondly. What makes you think I haven't read the instructions > or searched extensively on Google etc. Either give a proper answer or just > shut your mouth. Never mind anyone responding, I'll find my own damn > answers. Thanks for the help. > > > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: November 30, 2005 12:16 AM > To: Beauford > Cc: mysql@lists.mysql.com > Subject: Re: Windows - logging into MySQL > > "Beauford" <[EMAIL PROTECTED]> wrote on 11/29/2005 11:31:24 PM: > > I just installed MySQL 3.23 (the only one I could get to work) and I > > find that I can log into the server just by typing mysql at the DOS > > prompt. Ho do make it so you have to use a user name and password to get > > in. > > > Thanks > > > > Running on Win2k Advance Server. > > You could try following the installation instructions in the manual > http://dev.mysql.com/doc/refman/4.1/en/windows-installation.html > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine -- Sean Peters Senior Programmer, WIREData Inc. [EMAIL PROTECTED] "The software required Windows 2000 or better, so i Downloaded Linux" -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Windows - logging into MySQL
Sorry, but I don't take kindly to idiots. I don't care if he's gods gift to MySQL. If there isn't enough info for him to give an informed answer then he should either ask for more or shut up. I'm just simply trying to resolve a problem, and flip answers aren't needed or appropriate. I don't send emails to the list at the first sign of problem, this is probably the first in over a year and a half. When I do however, it is because the manual or other attempts have not provided me the answers I need. In any event I will move on and find my answers elsewhere. -Original Message- From: J.R. Bullington [mailto:[EMAIL PROTECTED] Sent: November 30, 2005 6:37 PM To: mysql@lists.mysql.com Subject: RE: Windows - logging into MySQL You need to be careful what you write. I have found that Shawn is one of the best guys on this list. His answers are 99% right on target (1% because not enough information was given) and can help on every version of db out there. Don't start a flame war because your feelings were hurt. Grow up. J.R. -Original Message- From: Beauford [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 30, 2005 6:05 PM To: 'Logan, David (SST - Adelaide)' Cc: mysql@lists.mysql.com Subject: RE: Windows - logging into MySQL There are always idots like Shawn Green that give BS answers just for the sake of responding, and for me it just reflects badly on the group as a whole. There are many others that help, but when I open my email and this is the first response I see, it just gets under my skin. FYI. I have posted some information in another response as to the problems with later versions etc. -Original Message- From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Sent: November 30, 2005 5:57 PM To: Beauford; [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: RE: Windows - logging into MySQL Sorry Beauford, The url that Shawn gave you is valid for the version you quoted. There hasn't been much change and they work just as well. This is also the earliest documentation that now exists on the website. What is the bad name this list has gained? I've found it helpful on numerous occasions. I think a reconsideration of your opinions would result in a change of heart. The documentation states the defaults that the mysql client program would accept, it also details how to set users and passwords exactly as you requested. These all work on 3.23.58 (I have this version installed at a customer site as we write). Perhaps if you detail the problems you had installing the later versions, somebody may be able to help. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Beauford [mailto:[EMAIL PROTECTED] Sent: Thursday, 1 December 2005 9:21 AM To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: RE: Windows - logging into MySQL This is why lists like this get a bad name. First off, these instructions are for 4.1. Secondly. What makes you think I haven't read the instructions or searched extensively on Google etc. Either give a proper answer or just shut your mouth. Never mind anyone responding, I'll find my own damn answers. Thanks for the help. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: November 30, 2005 12:16 AM To: Beauford Cc: mysql@lists.mysql.com Subject: Re: Windows - logging into MySQL "Beauford" <[EMAIL PROTECTED]> wrote on 11/29/2005 11:31:24 PM: > I just installed MySQL 3.23 (the only one I could get to work) and I > find that I can log into the server just by typing mysql at the DOS > prompt. Ho do make it so you have to use a user name and password to get in. > > Thanks > > Running on Win2k Advance Server. > > > You could try following the installation instructions in the manual http://dev.mysql.com/doc/refman/4.1/en/windows-installation.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Windows - logging into MySQL
You need to be careful what you write. I have found that Shawn is one of the best guys on this list. His answers are 99% right on target (1% because not enough information was given) and can help on every version of db out there. Don't start a flame war because your feelings were hurt. Grow up. J.R. -Original Message- From: Beauford [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 30, 2005 6:05 PM To: 'Logan, David (SST - Adelaide)' Cc: mysql@lists.mysql.com Subject: RE: Windows - logging into MySQL There are always idots like Shawn Green that give BS answers just for the sake of responding, and for me it just reflects badly on the group as a whole. There are many others that help, but when I open my email and this is the first response I see, it just gets under my skin. FYI. I have posted some information in another response as to the problems with later versions etc. -Original Message- From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Sent: November 30, 2005 5:57 PM To: Beauford; [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: RE: Windows - logging into MySQL Sorry Beauford, The url that Shawn gave you is valid for the version you quoted. There hasn't been much change and they work just as well. This is also the earliest documentation that now exists on the website. What is the bad name this list has gained? I've found it helpful on numerous occasions. I think a reconsideration of your opinions would result in a change of heart. The documentation states the defaults that the mysql client program would accept, it also details how to set users and passwords exactly as you requested. These all work on 3.23.58 (I have this version installed at a customer site as we write). Perhaps if you detail the problems you had installing the later versions, somebody may be able to help. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Beauford [mailto:[EMAIL PROTECTED] Sent: Thursday, 1 December 2005 9:21 AM To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: RE: Windows - logging into MySQL This is why lists like this get a bad name. First off, these instructions are for 4.1. Secondly. What makes you think I haven't read the instructions or searched extensively on Google etc. Either give a proper answer or just shut your mouth. Never mind anyone responding, I'll find my own damn answers. Thanks for the help. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: November 30, 2005 12:16 AM To: Beauford Cc: mysql@lists.mysql.com Subject: Re: Windows - logging into MySQL "Beauford" <[EMAIL PROTECTED]> wrote on 11/29/2005 11:31:24 PM: > I just installed MySQL 3.23 (the only one I could get to work) and I > find that I can log into the server just by typing mysql at the DOS > prompt. Ho do make it so you have to use a user name and password to get in. > > Thanks > > Running on Win2k Advance Server. > > > You could try following the installation instructions in the manual http://dev.mysql.com/doc/refman/4.1/en/windows-installation.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] smime.p7s Description: S/MIME cryptographic signature
RE: Windows - logging into MySQL
There are always idots like Shawn Green that give BS answers just for the sake of responding, and for me it just reflects badly on the group as a whole. There are many others that help, but when I open my email and this is the first response I see, it just gets under my skin. FYI. I have posted some information in another response as to the problems with later versions etc. -Original Message- From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Sent: November 30, 2005 5:57 PM To: Beauford; [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: RE: Windows - logging into MySQL Sorry Beauford, The url that Shawn gave you is valid for the version you quoted. There hasn't been much change and they work just as well. This is also the earliest documentation that now exists on the website. What is the bad name this list has gained? I've found it helpful on numerous occasions. I think a reconsideration of your opinions would result in a change of heart. The documentation states the defaults that the mysql client program would accept, it also details how to set users and passwords exactly as you requested. These all work on 3.23.58 (I have this version installed at a customer site as we write). Perhaps if you detail the problems you had installing the later versions, somebody may be able to help. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Beauford [mailto:[EMAIL PROTECTED] Sent: Thursday, 1 December 2005 9:21 AM To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: RE: Windows - logging into MySQL This is why lists like this get a bad name. First off, these instructions are for 4.1. Secondly. What makes you think I haven't read the instructions or searched extensively on Google etc. Either give a proper answer or just shut your mouth. Never mind anyone responding, I'll find my own damn answers. Thanks for the help. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: November 30, 2005 12:16 AM To: Beauford Cc: mysql@lists.mysql.com Subject: Re: Windows - logging into MySQL "Beauford" <[EMAIL PROTECTED]> wrote on 11/29/2005 11:31:24 PM: > I just installed MySQL 3.23 (the only one I could get to work) and I > find that I can log into the server just by typing mysql at the DOS > prompt. Ho do make it so you have to use a user name and password to get in. > > Thanks > > Running on Win2k Advance Server. > > > You could try following the installation instructions in the manual http://dev.mysql.com/doc/refman/4.1/en/windows-installation.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Windows - logging into MySQL
I have already changed the PW for root and I can log in no problem with mysql -p root, but I can also get in with just mysql. Someone mentioned about anonymous access, I'll have to check on that. 4.0 and above give me an error that permission is denied for [EMAIL PROTECTED] I am not using an external database so not sure why this is. Thanks to all that posted legitimate answers. SGreen can biteme however. -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED] Sent: November 30, 2005 12:08 AM To: Beauford Cc: mysql@lists.mysql.com Subject: Re: Windows - logging into MySQL Hi, If you've just installed it then the root user has no password. Change the root user to have a password then you will have to specify the -p parameter on the command line before you can log in. (Or you can put it in your local my.cnf file) =C= www.calevans.com Beauford wrote: > I just installed MySQL 3.23 (the only one I could get to work) and I > find that I can log into the server just by typing mysql at the DOS > prompt. Ho do make it so you have to use a user name and password to get in. > > Thanks > > Running on Win2k Advance Server. > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Windows - logging into MySQL
Sorry Beauford, The url that Shawn gave you is valid for the version you quoted. There hasn't been much change and they work just as well. This is also the earliest documentation that now exists on the website. What is the bad name this list has gained? I've found it helpful on numerous occasions. I think a reconsideration of your opinions would result in a change of heart. The documentation states the defaults that the mysql client program would accept, it also details how to set users and passwords exactly as you requested. These all work on 3.23.58 (I have this version installed at a customer site as we write). Perhaps if you detail the problems you had installing the later versions, somebody may be able to help. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Beauford [mailto:[EMAIL PROTECTED] Sent: Thursday, 1 December 2005 9:21 AM To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: RE: Windows - logging into MySQL This is why lists like this get a bad name. First off, these instructions are for 4.1. Secondly. What makes you think I haven't read the instructions or searched extensively on Google etc. Either give a proper answer or just shut your mouth. Never mind anyone responding, I'll find my own damn answers. Thanks for the help. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: November 30, 2005 12:16 AM To: Beauford Cc: mysql@lists.mysql.com Subject: Re: Windows - logging into MySQL "Beauford" <[EMAIL PROTECTED]> wrote on 11/29/2005 11:31:24 PM: > I just installed MySQL 3.23 (the only one I could get to work) and I > find that I can log into the server just by typing mysql at the DOS > prompt. Ho do make it so you have to use a user name and password to get in. > > Thanks > > Running on Win2k Advance Server. > > > You could try following the installation instructions in the manual http://dev.mysql.com/doc/refman/4.1/en/windows-installation.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Windows - logging into MySQL
Well stupid questions are usually responded to with simple answers like rtfm. You'd think you'd be able to at least be able to install a version of the daemon that's still supported before you get into advanced topics like mysql -h ""Beauford"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > This is why lists like this get a bad name. First off, these instructions > are for 4.1. Secondly. What makes you think I haven't read the > instructions > or searched extensively on Google etc. Either give a proper answer or just > shut your mouth. Never mind anyone responding, I'll find my own damn > answers. Thanks for the help. > > > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: November 30, 2005 12:16 AM > To: Beauford > Cc: mysql@lists.mysql.com > Subject: Re: Windows - logging into MySQL > > > > "Beauford" <[EMAIL PROTECTED]> wrote on 11/29/2005 11:31:24 PM: > >> I just installed MySQL 3.23 (the only one I could get to work) and I >> find that I can log into the server just by typing mysql at the DOS >> prompt. Ho do make it so you have to use a user name and password to get > in. >> >> Thanks >> >> Running on Win2k Advance Server. >> >> >> > > You could try following the installation instructions in the manual > http://dev.mysql.com/doc/refman/4.1/en/windows-installation.html > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Windows - logging into MySQL
This is why lists like this get a bad name. First off, these instructions are for 4.1. Secondly. What makes you think I haven't read the instructions or searched extensively on Google etc. Either give a proper answer or just shut your mouth. Never mind anyone responding, I'll find my own damn answers. Thanks for the help. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: November 30, 2005 12:16 AM To: Beauford Cc: mysql@lists.mysql.com Subject: Re: Windows - logging into MySQL "Beauford" <[EMAIL PROTECTED]> wrote on 11/29/2005 11:31:24 PM: > I just installed MySQL 3.23 (the only one I could get to work) and I > find that I can log into the server just by typing mysql at the DOS > prompt. Ho do make it so you have to use a user name and password to get in. > > Thanks > > Running on Win2k Advance Server. > > > You could try following the installation instructions in the manual http://dev.mysql.com/doc/refman/4.1/en/windows-installation.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Windows - logging into MySQL
"Beauford" <[EMAIL PROTECTED]> wrote on 11/29/2005 11:31:24 PM: > I just installed MySQL 3.23 (the only one I could get to work) and I find > that I can log into the server just by typing mysql at the DOS prompt. Ho do > make it so you have to use a user name and password to get in. > > Thanks > > Running on Win2k Advance Server. > > > You could try following the installation instructions in the manual http://dev.mysql.com/doc/refman/4.1/en/windows-installation.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: Windows - logging into MySQL
Hi, If you've just installed it then the root user has no password. Change the root user to have a password then you will have to specify the -p parameter on the command line before you can log in. (Or you can put it in your local my.cnf file) =C= www.calevans.com Beauford wrote: I just installed MySQL 3.23 (the only one I could get to work) and I find that I can log into the server just by typing mysql at the DOS prompt. Ho do make it so you have to use a user name and password to get in. Thanks Running on Win2k Advance Server. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]