Re: [Hampshire] Which Perl Modules
On Tuesday 24 February 2009 14:16:22 Tim Henley wrote: > > -Original Message- > > From: sweseme...@ntlworld.com > > Sent: Tue, 24 Feb 2009 14:07:28 + > > To: hampshire@mailman.lug.org.uk > > Subject: Re: [Hampshire] Which Perl Modules > > > >> In reverse order, yes I do have a password on mysql which I did not > >> before > >> > >> OK still failing, this is what I am typing > >> > >> mysql -e -p "GRANT ALL ON msn.* TO t...@localhost IDENTIFIED BY > >> 'timssqlpassword'" > >> > >> Error 1045 (28000) Access denied for user 'tim'@'localhost' (using > >> password: NO) > >> > >> and the error I get is the same as before > >> > >> I have tried changing the localhost to IP address and the name of the PC > >> but still the same. > >> > >> Am I being really dumb here?? > >> > >> Tim > > > > Hiya, > > > > try > > > > mysql -e -u root -p "GRANT ALL ON msn.* TO t...@localhost IDENTIFIED > > BY 'timssqlpassword'" > > > > Cheers. > > Steve > > Hi Steve > > All that done was list all the possible commandline options, same as mysql > --help > > Tim > > > FREE 3D MARINE AQUARIUM SCREENSAVER - Watch dolphins, sharks & orcas on > your desktop! Check it out at http://www.inbox.com/marineaquarium You probably have sorted it by now with Vic's last email but alternatively do the following: mysql -u root -p [enter mysql root user password when prompted] You should now be at a mysql prompt mysql> GRANT ALL ON msn.* TO t...@localhost IDENTIFIED BY 'timssqlpassword'; mysql> flush privileges; mysql>quit Cheers, Steve -- Please post to: Hampshire@mailman.lug.org.uk Web Interface: https://mailman.lug.org.uk/mailman/listinfo/hampshire LUG URL: http://www.hantslug.org.uk --
Re: [Hampshire] Which Perl Modules
> -Original Message- > From: sweseme...@ntlworld.com > Sent: Tue, 24 Feb 2009 14:07:28 + > To: hampshire@mailman.lug.org.uk > Subject: Re: [Hampshire] Which Perl Modules > > >> >> In reverse order, yes I do have a password on mysql which I did not >> before >> >> OK still failing, this is what I am typing >> >> mysql -e -p "GRANT ALL ON msn.* TO t...@localhost IDENTIFIED BY >> 'timssqlpassword'" >> >> Error 1045 (28000) Access denied for user 'tim'@'localhost' (using >> password: NO) >> >> and the error I get is the same as before >> >> I have tried changing the localhost to IP address and the name of the PC >> but still the same. >> >> Am I being really dumb here?? >> >> Tim > Hiya, > > try > > mysql -e -u root -p "GRANT ALL ON msn.* TO t...@localhost IDENTIFIED > BY 'timssqlpassword'" > > Cheers. > Steve > Hi Steve All that done was list all the possible commandline options, same as mysql --help Tim FREE 3D MARINE AQUARIUM SCREENSAVER - Watch dolphins, sharks & orcas on your desktop! Check it out at http://www.inbox.com/marineaquarium -- Please post to: Hampshire@mailman.lug.org.uk Web Interface: https://mailman.lug.org.uk/mailman/listinfo/hampshire LUG URL: http://www.hantslug.org.uk --
Re: [Hampshire] Which Perl Modules
>>> Error 1045 (28000) Access denied for user 'root'@'localhost' (using >>> passowrd: NO) > > OK still failing, this is what I am typing > > mysql -e -p "GRANT ALL ON msn.* TO t...@localhost IDENTIFIED BY > 'timssqlpassword'" OK, there was only really one place that you could put the "-p" that would cause a problem - and you picked it... Don't split the "-e" (execute statement) from the statement you want to execute... > Error 1045 (28000) Access denied for user 'tim'@'localhost' (using > password: NO) Right, you've also changed user - you're now tim, not root. You'll need to add "-u root" to run as the root user. Again, don't split the "-e" from its statement. > Am I being really dumb here?? You might want to open up the man page so you can work out what these commands are doing... Vic. -- Please post to: Hampshire@mailman.lug.org.uk Web Interface: https://mailman.lug.org.uk/mailman/listinfo/hampshire LUG URL: http://www.hantslug.org.uk --
Re: [Hampshire] Which Perl Modules
> > In reverse order, yes I do have a password on mysql which I did not before > > OK still failing, this is what I am typing > > mysql -e -p "GRANT ALL ON msn.* TO t...@localhost IDENTIFIED BY > 'timssqlpassword'" > > Error 1045 (28000) Access denied for user 'tim'@'localhost' (using > password: NO) > > and the error I get is the same as before > > I have tried changing the localhost to IP address and the name of the PC > but still the same. > > Am I being really dumb here?? > > Tim Hiya, try mysql -e -u root -p "GRANT ALL ON msn.* TO t...@localhost IDENTIFIED BY 'timssqlpassword'" Cheers. Steve -- Please post to: Hampshire@mailman.lug.org.uk Web Interface: https://mailman.lug.org.uk/mailman/listinfo/hampshire LUG URL: http://www.hantslug.org.uk --
Re: [Hampshire] Which Perl Modules
> -Original Message- > From: l...@beer.org.uk > Sent: Tue, 24 Feb 2009 13:19:52 - (GMT) > To: hampshire@mailman.lug.org.uk > Subject: Re: [Hampshire] Which Perl Modules > > > Well, the thread title is wrong now - this is a MySQL question... > >> shell> mysql -e "GRANT ALL ON mwforum.* TO mwfo...@localhost IDENTIFIED >> BY >> 'password'" >> >> I have named my database msn so I assume mwforum.* should be msn.* > > Yes. > >> mwfo...@localhost I think should be m...@localhost > > Could be. In this context, "mwforum" and "msn" are MySQL usernames; use > whatever will remind you of their function in three years' time... > >> password is the password for mysql database?? > > It's the password for *that user*. > >> The error I am getting is >> >> Error 1045 (28000) Access denied for user 'root'@'localhost' (using >> passowrd: NO) > > Try adding "-p" to your mysql command. Make sure you know the root MySQL > password. > >> The stupid thing is I have setup the forum on a test machine and did not >> have a problem but doing it again on the server is causing me problems. > > Your test machine probably had no root MySQL password set. Your > production > machine definitely should... > > Vic. > > In reverse order, yes I do have a password on mysql which I did not before OK still failing, this is what I am typing mysql -e -p "GRANT ALL ON msn.* TO t...@localhost IDENTIFIED BY 'timssqlpassword'" Error 1045 (28000) Access denied for user 'tim'@'localhost' (using password: NO) and the error I get is the same as before I have tried changing the localhost to IP address and the name of the PC but still the same. Am I being really dumb here?? Tim FREE 3D MARINE AQUARIUM SCREENSAVER - Watch dolphins, sharks & orcas on your desktop! Check it out at http://www.inbox.com/marineaquarium -- Please post to: Hampshire@mailman.lug.org.uk Web Interface: https://mailman.lug.org.uk/mailman/listinfo/hampshire LUG URL: http://www.hantslug.org.uk --
Re: [Hampshire] Which Perl Modules
Well, the thread title is wrong now - this is a MySQL question... > shell> mysql -e "GRANT ALL ON mwforum.* TO mwfo...@localhost IDENTIFIED BY > 'password'" > > I have named my database msn so I assume mwforum.* should be msn.* Yes. > mwfo...@localhost I think should be m...@localhost Could be. In this context, "mwforum" and "msn" are MySQL usernames; use whatever will remind you of their function in three years' time... > password is the password for mysql database?? It's the password for *that user*. > The error I am getting is > > Error 1045 (28000) Access denied for user 'root'@'localhost' (using > passowrd: NO) Try adding "-p" to your mysql command. Make sure you know the root MySQL password. > The stupid thing is I have setup the forum on a test machine and did not > have a problem but doing it again on the server is causing me problems. Your test machine probably had no root MySQL password set. Your production machine definitely should... Vic. -- Please post to: Hampshire@mailman.lug.org.uk Web Interface: https://mailman.lug.org.uk/mailman/listinfo/hampshire LUG URL: http://www.hantslug.org.uk --
Re: [Hampshire] Which Perl Modules
> -Original Message- > From: xendis...@inbox.com > Sent: Tue, 24 Feb 2009 02:13:44 -0800 > To: hampshire@mailman.lug.org.uk > Subject: Re: [Hampshire] Which Perl Modules > > > >> -Original Message- >> From: hug...@earth.li >> Sent: Tue, 24 Feb 2009 09:58:58 + >> To: hampshire@mailman.lug.org.uk >> Subject: Re: [Hampshire] Which Perl Modules >> >> On Tue, Feb 24, 2009 at 01:46:58AM -0800, Tim Henley wrote: >>> I need to install DataBase interface Perl Modules DBI and DBD::mysql >>> on my Debian Lenny based system but there are several packages with >>> those terms in them and I can't work out which ones are the ones I >>> need. I can download them from Cpan but I would rather pull them from >>> the Debian repo if I can. Could somebody point me in the right >>> direction please >> >> Just install libdbd-mysql-perl which should pull in libdbi-perl (it >> depends on it) and any other bits you need. >> >> In Debian the convention is as follows: >> Foo::Bar -> libfoo-bar-perl >> >> Simon. >> >> -- >> oOoOo "I'm tour guide Barbie! Please keep your hands, arms and oOoOo >> oOoOoaccessories inside the car and no flash photography,oOoOo >> oOoOo thank you."oOoOo >> htag.pl 0.0.24 ::: http://www.earth.li/~huggie/ >> >> -- >> Please post to: Hampshire@mailman.lug.org.uk >> Web Interface: https://mailman.lug.org.uk/mailman/listinfo/hampshire >> LUG URL: http://www.hantslug.org.uk >> -- > > Thanks Simon, just checked and it is already installed. > > Tim > > > GET FREE SMILEYS FOR YOUR IM & EMAIL - Learn more at > http://www.inbox.com/smileys > Works with AIM®, MSN® Messenger, Yahoo!® Messenger, ICQ®, Google Talk™ > and most webmails > > -- > Please post to: Hampshire@mailman.lug.org.uk > Web Interface: https://mailman.lug.org.uk/mailman/listinfo/hampshire > LUG URL: http://www.hantslug.org.uk > -- I have hit a wall, I am trying to install mwforum, I have been following the instructions (http://www.mwforum.org/doc/stable/Install.html) and I am stuck at what I guess is a simple instruction shell> mysql -e "GRANT ALL ON mwforum.* TO mwfo...@localhost IDENTIFIED BY 'password'" The words, mwforum, mwfo...@localhost and password have to be changed a suitable word for my setup, but I am at a loss to workout what I should put in those bits. I am running the command as root I have named my database msn so I assume mwforum.* should be msn.* mwfo...@localhost I think should be m...@localhost password is the password for mysql database?? The error I am getting is Error 1045 (28000) Access denied for user 'root'@'localhost' (using passowrd: NO) The stupid thing is I have setup the forum on a test machine and did not have a problem but doing it again on the server is causing me problems. Could anybody open my eyes for me, there so many trees I can't see the wood Tim -- Please post to: Hampshire@mailman.lug.org.uk Web Interface: https://mailman.lug.org.uk/mailman/listinfo/hampshire LUG URL: http://www.hantslug.org.uk --
Re: [Hampshire] Which Perl Modules
> -Original Message- > From: hug...@earth.li > Sent: Tue, 24 Feb 2009 09:58:58 + > To: hampshire@mailman.lug.org.uk > Subject: Re: [Hampshire] Which Perl Modules > > On Tue, Feb 24, 2009 at 01:46:58AM -0800, Tim Henley wrote: >> I need to install DataBase interface Perl Modules DBI and DBD::mysql >> on my Debian Lenny based system but there are several packages with >> those terms in them and I can't work out which ones are the ones I >> need. I can download them from Cpan but I would rather pull them from >> the Debian repo if I can. Could somebody point me in the right >> direction please > > Just install libdbd-mysql-perl which should pull in libdbi-perl (it > depends on it) and any other bits you need. > > In Debian the convention is as follows: > Foo::Bar -> libfoo-bar-perl > > Simon. > > -- > oOoOo "I'm tour guide Barbie! Please keep your hands, arms and oOoOo > oOoOoaccessories inside the car and no flash photography,oOoOo > oOoOo thank you."oOoOo > htag.pl 0.0.24 ::: http://www.earth.li/~huggie/ > > -- > Please post to: Hampshire@mailman.lug.org.uk > Web Interface: https://mailman.lug.org.uk/mailman/listinfo/hampshire > LUG URL: http://www.hantslug.org.uk > -- Thanks Simon, just checked and it is already installed. Tim GET FREE SMILEYS FOR YOUR IM & EMAIL - Learn more at http://www.inbox.com/smileys Works with AIM®, MSN® Messenger, Yahoo!® Messenger, ICQ®, Google Talk™ and most webmails -- Please post to: Hampshire@mailman.lug.org.uk Web Interface: https://mailman.lug.org.uk/mailman/listinfo/hampshire LUG URL: http://www.hantslug.org.uk --
Re: [Hampshire] Which Perl Modules
On Tue, Feb 24, 2009 at 01:46:58AM -0800, Tim Henley wrote: > I need to install DataBase interface Perl Modules DBI and DBD::mysql > on my Debian Lenny based system but there are several packages with > those terms in them and I can't work out which ones are the ones I > need. I can download them from Cpan but I would rather pull them from > the Debian repo if I can. Could somebody point me in the right > direction please Just install libdbd-mysql-perl which should pull in libdbi-perl (it depends on it) and any other bits you need. In Debian the convention is as follows: Foo::Bar -> libfoo-bar-perl Simon. -- oOoOo "I'm tour guide Barbie! Please keep your hands, arms and oOoOo oOoOoaccessories inside the car and no flash photography,oOoOo oOoOo thank you."oOoOo htag.pl 0.0.24 ::: http://www.earth.li/~huggie/ -- Please post to: Hampshire@mailman.lug.org.uk Web Interface: https://mailman.lug.org.uk/mailman/listinfo/hampshire LUG URL: http://www.hantslug.org.uk --
