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
