RE: Newbie MySQL Install Question
Thanks... I figured that out now. All is good and now I have access. I just needed to create a new user with the proper host information. Dan > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bill Adams > Sent: Friday, November 09, 2001 3:59 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: Newbie MySQL Install Question > > > Dan Tappin wrote: > > > Ok that worked... but now my SQL utility program returns a 'Host > > 192.168.0.74 (my local IP) is not allowed to connect to this > MySQL server' > > > > I assume that I need to get into the grant tables. Is this just via > > mysqladmin -u root -p??? > > To get into the grant tables, as it were, you need to get into > the mysql db: > 'mysql -u root -pyour?new.password mysql'. Note that there is NO > space between > the '-p' and the password. > > b. - 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
Re: Newbie MySQL Install Question
Dan Tappin wrote: > Ok that worked... but now my SQL utility program returns a 'Host > 192.168.0.74 (my local IP) is not allowed to connect to this MySQL server' > > I assume that I need to get into the grant tables. Is this just via > mysqladmin -u root -p??? To get into the grant tables, as it were, you need to get into the mysql db: 'mysql -u root -pyour?new.password mysql'. Note that there is NO space between the '-p' and the password. b. > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bill Adams > > Sent: Friday, November 09, 2001 2:26 PM > > To: [EMAIL PROTECTED] > > Cc: [EMAIL PROTECTED] > > Subject: Re: Newbie MySQL Install Question > > > > > > Dan Tappin wrote: > > > > > I tried that but it came back with a 'mysqld is running already' error. > > > > Actually your command is wrong. If you never set the password > > before it should > > be (without the -p): > > mysqladmin -u root password your?new.password > > > > note that 'password' IS the command. > > > > > Side Question: How can I allow a SSH connection from a remote > > machine? My > > > linux box is in a locked server room and I would like to > > administer it from > > > my office via a terminal. I tried via SSH from my MacOS X > > laptop but I get > > > a secure connection refused message. > > > > 1) Make sure you have a recent openssh that fixes the host access bug. > > > > 2) Check another list as I don't actually know off the top of my head. > > Basically you want to install openssh and run > > /etc/rc.d/init.d/sshd start (on > > a RH system). And read the man pages about how to limit access. > > And please > > direct further questions about ssh elsewhere. Thanks. > > > > b. > > -- Bill Adams TriQuint Semiconductor - 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
RE: Newbie MySQL Install Question
Ok that worked... but now my SQL utility program returns a 'Host 192.168.0.74 (my local IP) is not allowed to connect to this MySQL server' I assume that I need to get into the grant tables. Is this just via mysqladmin -u root -p??? Thanks, Dan > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bill Adams > Sent: Friday, November 09, 2001 2:26 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: Newbie MySQL Install Question > > > Dan Tappin wrote: > > > I tried that but it came back with a 'mysqld is running already' error. > > Actually your command is wrong. If you never set the password > before it should > be (without the -p): > mysqladmin -u root password your?new.password > > note that 'password' IS the command. > > > Side Question: How can I allow a SSH connection from a remote > machine? My > > linux box is in a locked server room and I would like to > administer it from > > my office via a terminal. I tried via SSH from my MacOS X > laptop but I get > > a secure connection refused message. > > 1) Make sure you have a recent openssh that fixes the host access bug. > > 2) Check another list as I don't actually know off the top of my head. > Basically you want to install openssh and run > /etc/rc.d/init.d/sshd start (on > a RH system). And read the man pages about how to limit access. > And please > direct further questions about ssh elsewhere. Thanks. > > b. > - 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
Re: Newbie MySQL Install Question
Dan Tappin writes: > I tried that but it came back with a 'mysqld is running already' error. /me silently curses the bad quoting habits that Lookout causes, but knows what the thread was about, and so _please disregard_ this sentence unless you know what I'm talking about. Now where was I? Oh, yes, good, the server is running. I think I know what's wrong. As I recall, you typed "mysqladmin -uroot -p password", but then you will be prompted for the old password, and if there is already a password and you enter it, you'll get an error because of a missing argument. The correct thing to type is this: mysqladmin -uroot password= If you're slightly (or more) paranoid and don't want the password to be shown to the rest of the users for a brief moment (and to be stored in your shell history), you could start the mysql client ("mysql -uroot") and set the password from there, although it'll still be stored in your .mysqlhistory (or whatever it's called). The bottom line: I don't know of any way to be prompted for your new password. There should be some way to avoid having to enter it on the command line. Does anyone on this list know how? > Side Question: How can I allow a SSH connection from a remote machine? You need to install some SSH daemon. I bet there is one or two to choose from on the Redhat CDs. Have a look at what RPMs are named something that starts with ssh or SSH or something like that. //C -- Carl Troein - CĂrdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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
RE: Newbie MySQL Install Question
DOH! :^) Thanks for the tips. Dan > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bill Adams > Sent: Friday, November 09, 2001 2:26 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: Newbie MySQL Install Question > > > Dan Tappin wrote: > > > I tried that but it came back with a 'mysqld is running already' error. > > Actually your command is wrong. If you never set the password > before it should > be (without the -p): > mysqladmin -u root password your?new.password > > note that 'password' IS the command. > > > Side Question: How can I allow a SSH connection from a remote > machine? My > > linux box is in a locked server room and I would like to > administer it from > > my office via a terminal. I tried via SSH from my MacOS X > laptop but I get > > a secure connection refused message. > > 1) Make sure you have a recent openssh that fixes the host access bug. > > 2) Check another list as I don't actually know off the top of my head. > Basically you want to install openssh and run > /etc/rc.d/init.d/sshd start (on > a RH system). And read the man pages about how to limit access. > And please > direct further questions about ssh elsewhere. Thanks. > > b. > - 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
RE: Newbie MySQL Install Question
I'm getting the sazme exact error, can anyone help us?? -Original Message- From: Kelley Reynolds [mailto:[EMAIL PROTECTED]] Sent: Friday, November 09, 2001 4:07 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Newbie MySQL Install Question Make sure that the mysql server has been started. - Original Message - From: "Dan Tappin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 09, 2001 4:07 PM Subject: Newbie MySQL Install Question > I have some experience with MySQL on MacOS X but that was with a > pretty GUI > installer. > > I am now trying to get MySQL installed on Redhat 7.0. I download the client > and server versions and followed the install procedures. > > The problem I am having is with mysqladmin. The docs state that you > need to > set the root password with 'mysqladmin -u root -p password'. I enter > this command, I am then prompted for the new password and then I get a > 'could not > connect to local host' error. > > I think I am missing something here. To make matters worse my Linux > experience is pretty limited as well. > > Thanks, > > Dan > > > - > 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 > > - 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 - 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
Re: Newbie MySQL Install Question
Dan Tappin wrote: > I tried that but it came back with a 'mysqld is running already' error. Actually your command is wrong. If you never set the password before it should be (without the -p): mysqladmin -u root password your?new.password note that 'password' IS the command. > Side Question: How can I allow a SSH connection from a remote machine? My > linux box is in a locked server room and I would like to administer it from > my office via a terminal. I tried via SSH from my MacOS X laptop but I get > a secure connection refused message. 1) Make sure you have a recent openssh that fixes the host access bug. 2) Check another list as I don't actually know off the top of my head. Basically you want to install openssh and run /etc/rc.d/init.d/sshd start (on a RH system). And read the man pages about how to limit access. And please direct further questions about ssh elsewhere. Thanks. b. - 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
RE: Newbie MySQL Install Question
Port 3306 is open on the machine. Dan > -Original Message- > From: Kelley Reynolds [mailto:[EMAIL PROTECTED]] > Sent: Friday, November 09, 2001 2:07 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: Newbie MySQL Install Question > > > Make sure that the mysql server has been started. - 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
RE: Newbie MySQL Install Question
How do I double check? LSOF? I tried that but I can't get the option right? Side Question: How can I allow a SSH connection from a remote machine? My linux box is in a locked server room and I would like to administer it from my office via a terminal. I tried via SSH from my MacOS X laptop but I get a secure connection refused message. Thanks, Dan > -Original Message- > From: Kelley Reynolds [mailto:[EMAIL PROTECTED]] > Sent: Friday, November 09, 2001 2:07 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: Newbie MySQL Install Question > > > Make sure that the mysql server has been started. > > - Original Message - > From: "Dan Tappin" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, November 09, 2001 4:07 PM > Subject: Newbie MySQL Install Question > > > I have some experience with MySQL on MacOS X but that was with a pretty > GUI > > installer. > > > > I am now trying to get MySQL installed on Redhat 7.0. I download the > client > > and server versions and followed the install procedures. > > > > The problem I am having is with mysqladmin. The docs state > that you need > to > > set the root password with 'mysqladmin -u root -p password'. I > enter this > > command, I am then prompted for the new password and then I get a 'could > not > > connect to local host' error. > > > > I think I am missing something here. To make matters worse my Linux > > experience is pretty limited as well. > > > > Thanks, > > > > Dan > > > > > > - > > 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 > > > > > > - > 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 > - 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
RE: Newbie MySQL Install Question
I tried that but it came back with a 'mysqld is running already' error. Side Question: How can I allow a SSH connection from a remote machine? My linux box is in a locked server room and I would like to administer it from my office via a terminal. I tried via SSH from my MacOS X laptop but I get a secure connection refused message. Thanks, Dan > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bill Adams > Sent: Friday, November 09, 2001 2:10 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: Newbie MySQL Install Question > > > Dan Tappin wrote: > > > I have some experience with MySQL on MacOS X but that was with > a pretty GUI > > installer. > > > > I am now trying to get MySQL installed on Redhat 7.0. I > download the client > > and server versions and followed the install procedures. > > > > The problem I am having is with mysqladmin. The docs state > that you need to > > set the root password with 'mysqladmin -u root -p password'. I > enter this > > command, I am then prompted for the new password and then I get > a 'could not > > connect to local host' error. > > > > I think I am missing something here. To make matters worse my Linux > > experience is pretty limited as well. > > You need to start mysql first with either safe_mysqld (3.23.x) or > mysqld_safe (4.0). > > b. > - 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
Re: Newbie MySQL Install Question
Dan Tappin wrote: > I have some experience with MySQL on MacOS X but that was with a pretty GUI > installer. > > I am now trying to get MySQL installed on Redhat 7.0. I download the client > and server versions and followed the install procedures. > > The problem I am having is with mysqladmin. The docs state that you need to > set the root password with 'mysqladmin -u root -p password'. I enter this > command, I am then prompted for the new password and then I get a 'could not > connect to local host' error. > > I think I am missing something here. To make matters worse my Linux > experience is pretty limited as well. You need to start mysql first with either safe_mysqld (3.23.x) or mysqld_safe (4.0). b. - 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
Re: Newbie MySQL Install Question
Make sure that the mysql server has been started. - Original Message - From: "Dan Tappin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 09, 2001 4:07 PM Subject: Newbie MySQL Install Question > I have some experience with MySQL on MacOS X but that was with a pretty GUI > installer. > > I am now trying to get MySQL installed on Redhat 7.0. I download the client > and server versions and followed the install procedures. > > The problem I am having is with mysqladmin. The docs state that you need to > set the root password with 'mysqladmin -u root -p password'. I enter this > command, I am then prompted for the new password and then I get a 'could not > connect to local host' error. > > I think I am missing something here. To make matters worse my Linux > experience is pretty limited as well. > > Thanks, > > Dan > > > - > 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 > > - 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
Newbie MySQL Install Question
I have some experience with MySQL on MacOS X but that was with a pretty GUI installer. I am now trying to get MySQL installed on Redhat 7.0. I download the client and server versions and followed the install procedures. The problem I am having is with mysqladmin. The docs state that you need to set the root password with 'mysqladmin -u root -p password'. I enter this command, I am then prompted for the new password and then I get a 'could not connect to local host' error. I think I am missing something here. To make matters worse my Linux experience is pretty limited as well. Thanks, Dan - 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