RE: new install - command prompt doesn't work
someone's the man... and i think we all KNOW who it is... :oD thanks a lot Bob...it works...finally... thanks to everyone...again Bob Loeffler <[EMAIL PROTECTED]> wrote: If you are using Windows 2000, do the following to set the path. If you have Windows NT, the steps are similar, but slightly different after the "System icon" part (I can't remember exactly). START -> Settings -> Control Panel -> System icon -> Advanced tab -> Environment Variables button Then, in the System Variables section, double-click on the "Path" entry. A little dialog should appear so you can edit the Path entry. In the Variable Value field, add the following (the semicolon separate each individual path, so you need it): ;c:\mysql\bin Now click on the OK button in each of those dialogs to save the info. Now you shouldn't have a problem the next time you open a command prompt window and type in 'mysql' to run the mysql client application. Bob Loeffler :) -Original Message- From: Betta Jazzy Brown [mailto:[EMAIL PROTECTED] Sent: Saturday, December 13, 2003 12:10 PM To: [EMAIL PROTECTED] Subject: Re: new install - command prompt doesn't work ok...i set the path properly... in the command line, i did this: C:\>C:\mysql\bin;C:\WINNT;C:\WINNT\COMMAND then, i am able to just type in "mysql" and it will begin... BUT...after i close the command prompt, once i reopen it, and type in "mysql", it goes and says that "mysql" is not a command or recognizable... is there something that i'm still missing? Paul DuBois wrote: At 6:48 -0800 12/13/03, Betta Jazzy Brown wrote: >i have done that > >C:\>mysql > >but it will say > >'mysql' is not recognized as an internal or external command, >operable program or batch file > >there must be something else i'm missing... This is not a MySQL issue. It's a PATH issue. Either set your PATH to include the directory where the MySQL programs are located (likely C:\mysql\bin, though that depends on your installation), or invoke mysql from within that directory, or invoke mysql using its full pathname. Setting your PATH is the best option, because then you can invoke MySQL programs from within any directory and the command interpreter will find them. > > > >Paul DuBois wrote: > >At 18:21 -0800 12/12/03, Betta Jazzy Brown wrote: >>I have installed MySql on my PC and I was trying to run the program >>by going to the command prompt typing: >> >>C:\>net start mysql >> >>it says >> >>The MySql service has started successfully. >> >>the problem is that the command prompt doesn't read >>mysql> >> >>but still reads >>C:\> >> >>What is the problem here and how can I correct it... > >There is no problem. The server has started successfully. > >But you need to *connect* to the server using a client program. >Try running mysql from the C prompt, for example: > >C:\> mysql > >> >>i have installed MySql Database Server & Standard Clients (4.0) >> >>and MySql Control Center >> >>and I'm using Win2K OS... >> >>-- >> >>As well...what specifically can I use MySql for? I have a website >>that I'm trying to learn a lot of things through to make my resume >>more beefy and to make myself more marketable...What do you all >>suggest? >> >>Thanks, > >b-jazzy -- 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]
Re: new install - command prompt doesn't work
Why don't you check the Help utility for your particular operatiing system? This is not a MySQL issue, and there are several ways you can accomplish it depending on which version of the Microsoft Windows O/S you have. - Original Message - From: "Betta Jazzy Brown" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, December 13, 2003 1:09 PM Subject: Re: new install - command prompt doesn't work ok...i set the path properly... in the command line, i did this: C:\>C:\mysql\bin;C:\WINNT;C:\WINNT\COMMAND then, i am able to just type in "mysql" and it will begin... BUT...after i close the command prompt, once i reopen it, and type in "mysql", it goes and says that "mysql" is not a command or recognizable... is there something that i'm still missing? Paul DuBois <[EMAIL PROTECTED]> wrote: At 6:48 -0800 12/13/03, Betta Jazzy Brown wrote: >i have done that > >C:\>mysql > >but it will say > >'mysql' is not recognized as an internal or external command, >operable program or batch file > >there must be something else i'm missing... This is not a MySQL issue. It's a PATH issue. Either set your PATH to include the directory where the MySQL programs are located (likely C:\mysql\bin, though that depends on your installation), or invoke mysql from within that directory, or invoke mysql using its full pathname. Setting your PATH is the best option, because then you can invoke MySQL programs from within any directory and the command interpreter will find them. > > > >Paul DuBois wrote: > >At 18:21 -0800 12/12/03, Betta Jazzy Brown wrote: >>I have installed MySql on my PC and I was trying to run the program >>by going to the command prompt typing: >> >>C:\>net start mysql >> >>it says >> >>The MySql service has started successfully. >> >>the problem is that the command prompt doesn't read >>mysql> >> >>but still reads >>C:\> >> >>What is the problem here and how can I correct it... > >There is no problem. The server has started successfully. > >But you need to *connect* to the server using a client program. >Try running mysql from the C prompt, for example: > >C:\> mysql > >> >>i have installed MySql Database Server & Standard Clients (4.0) >> >>and MySql Control Center >> >>and I'm using Win2K OS... >> >>-- >> >>As well...what specifically can I use MySql for? I have a website >>that I'm trying to learn a lot of things through to make my resume >>more beefy and to make myself more marketable...What do you all >>suggest? >> >>Thanks, > >b-jazzy -- 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]
RE: new install - command prompt doesn't work
If you are using Windows 2000, do the following to set the path. If you have Windows NT, the steps are similar, but slightly different after the "System icon" part (I can't remember exactly). START -> Settings -> Control Panel -> System icon -> Advanced tab -> Environment Variables button Then, in the System Variables section, double-click on the "Path" entry. A little dialog should appear so you can edit the Path entry. In the Variable Value field, add the following (the semicolon separate each individual path, so you need it): ;c:\mysql\bin Now click on the OK button in each of those dialogs to save the info. Now you shouldn't have a problem the next time you open a command prompt window and type in 'mysql' to run the mysql client application. Bob Loeffler :) -Original Message- From: Betta Jazzy Brown [mailto:[EMAIL PROTECTED] Sent: Saturday, December 13, 2003 12:10 PM To: [EMAIL PROTECTED] Subject: Re: new install - command prompt doesn't work ok...i set the path properly... in the command line, i did this: C:\>C:\mysql\bin;C:\WINNT;C:\WINNT\COMMAND then, i am able to just type in "mysql" and it will begin... BUT...after i close the command prompt, once i reopen it, and type in "mysql", it goes and says that "mysql" is not a command or recognizable... is there something that i'm still missing? Paul DuBois <[EMAIL PROTECTED]> wrote: At 6:48 -0800 12/13/03, Betta Jazzy Brown wrote: >i have done that > >C:\>mysql > >but it will say > >'mysql' is not recognized as an internal or external command, >operable program or batch file > >there must be something else i'm missing... This is not a MySQL issue. It's a PATH issue. Either set your PATH to include the directory where the MySQL programs are located (likely C:\mysql\bin, though that depends on your installation), or invoke mysql from within that directory, or invoke mysql using its full pathname. Setting your PATH is the best option, because then you can invoke MySQL programs from within any directory and the command interpreter will find them. > > > >Paul DuBois wrote: > >At 18:21 -0800 12/12/03, Betta Jazzy Brown wrote: >>I have installed MySql on my PC and I was trying to run the program >>by going to the command prompt typing: >> >>C:\>net start mysql >> >>it says >> >>The MySql service has started successfully. >> >>the problem is that the command prompt doesn't read >>mysql> >> >>but still reads >>C:\> >> >>What is the problem here and how can I correct it... > >There is no problem. The server has started successfully. > >But you need to *connect* to the server using a client program. >Try running mysql from the C prompt, for example: > >C:\> mysql > >> >>i have installed MySql Database Server & Standard Clients (4.0) >> >>and MySql Control Center >> >>and I'm using Win2K OS... >> >>-- >> >>As well...what specifically can I use MySql for? I have a website >>that I'm trying to learn a lot of things through to make my resume >>more beefy and to make myself more marketable...What do you all >>suggest? >> >>Thanks, > >b-jazzy -- 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]
Re: new install - command prompt doesn't work
ok...i set the path properly... in the command line, i did this: C:\>C:\mysql\bin;C:\WINNT;C:\WINNT\COMMAND then, i am able to just type in "mysql" and it will begin... BUT...after i close the command prompt, once i reopen it, and type in "mysql", it goes and says that "mysql" is not a command or recognizable... is there something that i'm still missing? Paul DuBois <[EMAIL PROTECTED]> wrote: At 6:48 -0800 12/13/03, Betta Jazzy Brown wrote: >i have done that > >C:\>mysql > >but it will say > >'mysql' is not recognized as an internal or external command, >operable program or batch file > >there must be something else i'm missing... This is not a MySQL issue. It's a PATH issue. Either set your PATH to include the directory where the MySQL programs are located (likely C:\mysql\bin, though that depends on your installation), or invoke mysql from within that directory, or invoke mysql using its full pathname. Setting your PATH is the best option, because then you can invoke MySQL programs from within any directory and the command interpreter will find them. > > > >Paul DuBois wrote: > >At 18:21 -0800 12/12/03, Betta Jazzy Brown wrote: >>I have installed MySql on my PC and I was trying to run the program >>by going to the command prompt typing: >> >>C:\>net start mysql >> >>it says >> >>The MySql service has started successfully. >> >>the problem is that the command prompt doesn't read >>mysql> >> >>but still reads >>C:\> >> >>What is the problem here and how can I correct it... > >There is no problem. The server has started successfully. > >But you need to *connect* to the server using a client program. >Try running mysql from the C prompt, for example: > >C:\> mysql > >> >>i have installed MySql Database Server & Standard Clients (4.0) >> >>and MySql Control Center >> >>and I'm using Win2K OS... >> >>-- >> >>As well...what specifically can I use MySql for? I have a website >>that I'm trying to learn a lot of things through to make my resume >>more beefy and to make myself more marketable...What do you all >>suggest? >> >>Thanks, > >b-jazzy -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/
Re: new install - command prompt doesn't work
At 6:48 -0800 12/13/03, Betta Jazzy Brown wrote: i have done that C:\>mysql but it will say 'mysql' is not recognized as an internal or external command, operable program or batch file there must be something else i'm missing... This is not a MySQL issue. It's a PATH issue. Either set your PATH to include the directory where the MySQL programs are located (likely C:\mysql\bin, though that depends on your installation), or invoke mysql from within that directory, or invoke mysql using its full pathname. Setting your PATH is the best option, because then you can invoke MySQL programs from within any directory and the command interpreter will find them. Paul DuBois <[EMAIL PROTECTED]> wrote: At 18:21 -0800 12/12/03, Betta Jazzy Brown wrote: I have installed MySql on my PC and I was trying to run the program by going to the command prompt typing: C:\>net start mysql it says The MySql service has started successfully. the problem is that the command prompt doesn't read mysql> but still reads C:\> What is the problem here and how can I correct it... There is no problem. The server has started successfully. But you need to *connect* to the server using a client program. Try running mysql from the C prompt, for example: C:\> mysql i have installed MySql Database Server & Standard Clients (4.0) and MySql Control Center and I'm using Win2K OS... -- As well...what specifically can I use MySql for? I have a website that I'm trying to learn a lot of things through to make my resume more beefy and to make myself more marketable...What do you all suggest? Thanks, >b-jazzy -- 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]
Re: new install - command prompt doesn't work
nevermind...i figured it out :oD thanks for all the help... MANY MANY MANY more questions to come -b-jazzy Betta Jazzy Brown <[EMAIL PROTECTED]> wrote: KEWL...that worked... one more question... to "put" it into the system's path, do i just type at the command prompt C:\>put c:\mysql\bin ??? if not...how do i do that??? "Gerald R. Jensen" wrote: Try c:\mysql\bin\mysql.exe If that works, then put c:\mysql\bin the system's path. - Original Message - From: "Betta Jazzy Brown" To: "Paul DuBois" ; "Betta Jazzy Brown" ; Sent: Saturday, December 13, 2003 8:48 AM Subject: Re: new install - command prompt doesn't work i have done that C:\>mysql but it will say 'mysql' is not recognized as an internal or external command, operable program or batch file there must be something else i'm missing... Paul DuBois wrote: At 18:21 -0800 12/12/03, Betta Jazzy Brown wrote: >I have installed MySql on my PC and I was trying to run the program >by going to the command prompt typing: > >C:\>net start mysql > >it says > >The MySql service has started successfully. > >the problem is that the command prompt doesn't read >mysql> > >but still reads >C:\> > >What is the problem here and how can I correct it... There is no problem. The server has started successfully. But you need to *connect* to the server using a client program. Try running mysql from the C prompt, for example: C:\> mysql > >i have installed MySql Database Server & Standard Clients (4.0) > >and MySql Control Center > >and I'm using Win2K OS... > >-- > >As well...what specifically can I use MySql for? I have a website >that I'm trying to learn a lot of things through to make my resume >more beefy and to make myself more marketable...What do you all >suggest? > >Thanks, >b-jazzy -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/
Re: new install - command prompt doesn't work
KEWL...that worked... one more question... to "put" it into the system's path, do i just type at the command prompt C:\>put c:\mysql\bin ??? if not...how do i do that??? "Gerald R. Jensen" <[EMAIL PROTECTED]> wrote: Try c:\mysql\bin\mysql.exe If that works, then put c:\mysql\bin the system's path. - Original Message - From: "Betta Jazzy Brown" To: "Paul DuBois" ; "Betta Jazzy Brown" ; Sent: Saturday, December 13, 2003 8:48 AM Subject: Re: new install - command prompt doesn't work i have done that C:\>mysql but it will say 'mysql' is not recognized as an internal or external command, operable program or batch file there must be something else i'm missing... Paul DuBois wrote: At 18:21 -0800 12/12/03, Betta Jazzy Brown wrote: >I have installed MySql on my PC and I was trying to run the program >by going to the command prompt typing: > >C:\>net start mysql > >it says > >The MySql service has started successfully. > >the problem is that the command prompt doesn't read >mysql> > >but still reads >C:\> > >What is the problem here and how can I correct it... There is no problem. The server has started successfully. But you need to *connect* to the server using a client program. Try running mysql from the C prompt, for example: C:\> mysql > >i have installed MySql Database Server & Standard Clients (4.0) > >and MySql Control Center > >and I'm using Win2K OS... > >-- > >As well...what specifically can I use MySql for? I have a website >that I'm trying to learn a lot of things through to make my resume >more beefy and to make myself more marketable...What do you all >suggest? > >Thanks, >b-jazzy -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/
Re: new install - command prompt doesn't work
have you changed the directory to the mysql/bin directory? normally when you get this error you're not in the correct directory. if mysql is in C:\mysql you'll need to be in the c:\mysql\bin and then excecute C:\>mysql HTH Jeff Betta Jazzy Brown <[EMAIL PROTECTED]To: Paul DuBois <[EMAIL PROTECTED]>, Betta Jazzy Brown <[EMAIL PROTECTED]>, ybrown.com> [EMAIL PROTECTED] cc: 12/13/2003 09:48 Subject: Re: new install - command prompt doesn't work AM i have done that C:\>mysql but it will say 'mysql' is not recognized as an internal or external command, operable program or batch file there must be something else i'm missing... Paul DuBois <[EMAIL PROTECTED]> wrote: At 18:21 -0800 12/12/03, Betta Jazzy Brown wrote: >I have installed MySql on my PC and I was trying to run the program >by going to the command prompt typing: > >C:\>net start mysql > >it says > >The MySql service has started successfully. > >the problem is that the command prompt doesn't read >mysql> > >but still reads >C:\> > >What is the problem here and how can I correct it... There is no problem. The server has started successfully. But you need to *connect* to the server using a client program. Try running mysql from the C prompt, for example: C:\> mysql > >i have installed MySql Database Server & Standard Clients (4.0) > >and MySql Control Center > >and I'm using Win2K OS... > >-- > >As well...what specifically can I use MySql for? I have a website >that I'm trying to learn a lot of things through to make my resume >more beefy and to make myself more marketable...What do you all >suggest? > >Thanks, >b-jazzy -- 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]
Re: new install - command prompt doesn't work
Try c:\mysql\bin\mysql.exe If that works, then put c:\mysql\bin the system's path. - Original Message - From: "Betta Jazzy Brown" <[EMAIL PROTECTED]> To: "Paul DuBois" <[EMAIL PROTECTED]>; "Betta Jazzy Brown" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, December 13, 2003 8:48 AM Subject: Re: new install - command prompt doesn't work i have done that C:\>mysql but it will say 'mysql' is not recognized as an internal or external command, operable program or batch file there must be something else i'm missing... Paul DuBois <[EMAIL PROTECTED]> wrote: At 18:21 -0800 12/12/03, Betta Jazzy Brown wrote: >I have installed MySql on my PC and I was trying to run the program >by going to the command prompt typing: > >C:\>net start mysql > >it says > >The MySql service has started successfully. > >the problem is that the command prompt doesn't read >mysql> > >but still reads >C:\> > >What is the problem here and how can I correct it... There is no problem. The server has started successfully. But you need to *connect* to the server using a client program. Try running mysql from the C prompt, for example: C:\> mysql > >i have installed MySql Database Server & Standard Clients (4.0) > >and MySql Control Center > >and I'm using Win2K OS... > >-- > >As well...what specifically can I use MySql for? I have a website >that I'm trying to learn a lot of things through to make my resume >more beefy and to make myself more marketable...What do you all >suggest? > >Thanks, >b-jazzy -- 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]
Re: new install - command prompt doesn't work
i have done that C:\>mysql but it will say 'mysql' is not recognized as an internal or external command, operable program or batch file there must be something else i'm missing... Paul DuBois <[EMAIL PROTECTED]> wrote: At 18:21 -0800 12/12/03, Betta Jazzy Brown wrote: >I have installed MySql on my PC and I was trying to run the program >by going to the command prompt typing: > >C:\>net start mysql > >it says > >The MySql service has started successfully. > >the problem is that the command prompt doesn't read >mysql> > >but still reads >C:\> > >What is the problem here and how can I correct it... There is no problem. The server has started successfully. But you need to *connect* to the server using a client program. Try running mysql from the C prompt, for example: C:\> mysql > >i have installed MySql Database Server & Standard Clients (4.0) > >and MySql Control Center > >and I'm using Win2K OS... > >-- > >As well...what specifically can I use MySql for? I have a website >that I'm trying to learn a lot of things through to make my resume >more beefy and to make myself more marketable...What do you all >suggest? > >Thanks, >b-jazzy -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/
Re: new install - command prompt doesn't work
At 18:21 -0800 12/12/03, Betta Jazzy Brown wrote: I have installed MySql on my PC and I was trying to run the program by going to the command prompt typing: C:\>net start mysql it says The MySql service has started successfully. the problem is that the command prompt doesn't read mysql> but still reads C:\> What is the problem here and how can I correct it... There is no problem. The server has started successfully. But you need to *connect* to the server using a client program. Try running mysql from the C prompt, for example: C:\> mysql i have installed MySql Database Server & Standard Clients (4.0) and MySql Control Center and I'm using Win2K OS... -- As well...what specifically can I use MySql for? I have a website that I'm trying to learn a lot of things through to make my resume more beefy and to make myself more marketable...What do you all suggest? Thanks, b-jazzy -- 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]
new install - command prompt doesn't work
I have installed MySql on my PC and I was trying to run the program by going to the command prompt typing: C:\>net start mysql it says The MySql service has started successfully. the problem is that the command prompt doesn't read mysql> but still reads C:\> What is the problem here and how can I correct it... i have installed MySql Database Server & Standard Clients (4.0) and MySql Control Center and I'm using Win2K OS... -- As well...what specifically can I use MySql for? I have a website that I'm trying to learn a lot of things through to make my resume more beefy and to make myself more marketable...What do you all suggest? Thanks, b-jazzy