Back To Website Hosting Forum

MySQL Problems...again

  • guitrspaz
  • Graduate
  • Graduate
  • No Avatar
  • Joined: Apr 27, 2003
  • Posts: 106
  • Loc: Baltimore, MD
  • Status: Offline

Post May 8th, 2003, 10:33 am

different server this time. I'm having trouble logging in, and I'm pretty sure it's because of the GRANTs.

When I enter this line:
shell> mysql -h hname -u uname -p dbname

I get this line:
shell> ERROR 1045: Access denied for user: 'uname@hname' (Using password: YES)

I'm wondering if there may be ANOTHER reason... I don't have access to GRANT so I'm hoping it's something I CAN fix on my own :) thanks
  • Anonymous
  • Bot
  • No Avatar
  • Joined: 25 Feb 2008
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post May 8th, 2003, 10:33 am

  • guitrspaz
  • Graduate
  • Graduate
  • No Avatar
  • Joined: Apr 27, 2003
  • Posts: 106
  • Loc: Baltimore, MD
  • Status: Offline

Post May 8th, 2003, 12:38 pm

I left out a very important detail oops...the server in question is unflux's :) neither of us are sure about what the problem is.
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Joined: Dec 20, 2002
  • Posts: 8922
  • Loc: Seattle, WA & Phoenix, AZ
  • Status: Online

Post May 8th, 2003, 1:47 pm

Okay first, after you enter that on your line, does it prompt you for the password? Also what did you put for the hname? Hname should probably be "localhost"

Second you also know you do not have to use the complicated commands from the console. If you want to that is no problem, but if you want the easy way out you should use MySQL Admin which is on Unflux's server. Its a graphical interface which lets you manage everything you need.
Ozzu Hosting - Want your website on a fast server like Ozzu?
  • guitrspaz
  • Graduate
  • Graduate
  • No Avatar
  • Joined: Apr 27, 2003
  • Posts: 106
  • Loc: Baltimore, MD
  • Status: Offline

Post May 8th, 2003, 1:54 pm

i guess i didn't say enough..oops
yes, i entered the password...and i tried localhost as well as the ip. I did use the admin tool to set up the db and it let me in, but when my pages couldn't access the db, i went ahead and tried to log in from the terminal. and it didn't work.
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Joined: Dec 20, 2002
  • Posts: 8922
  • Loc: Seattle, WA & Phoenix, AZ
  • Status: Online

Post May 8th, 2003, 2:01 pm

Try setting the password by going in your control panel and changing it to something you know. I know sometimes the default is different than your normal password, and that could be what is causing the problem.
Ozzu Hosting - Want your website on a fast server like Ozzu?
  • UNFLUX
  • Genius
  • Genius
  • User avatar
  • Joined: Dec 20, 2002
  • Posts: 6382
  • Loc: twitter.com/unflux
  • Status: Offline

Post May 9th, 2003, 9:40 am

i know I've told him that at least twice. :wink:
UNFLUX.FOTO
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Joined: Dec 20, 2002
  • Posts: 8922
  • Loc: Seattle, WA & Phoenix, AZ
  • Status: Online

Post May 9th, 2003, 12:52 pm

So does that mean it didn't resolve anything? or does that mean he didn't listen to you yet haha :)
Ozzu Hosting - Want your website on a fast server like Ozzu?
  • guitrspaz
  • Graduate
  • Graduate
  • No Avatar
  • Joined: Apr 27, 2003
  • Posts: 106
  • Loc: Baltimore, MD
  • Status: Offline

Post May 9th, 2003, 12:55 pm

sorry, it worked...I had done that once, but the second time it did indeed work. :) thanks for the help
  • UNFLUX
  • Genius
  • Genius
  • User avatar
  • Joined: Dec 20, 2002
  • Posts: 6382
  • Loc: twitter.com/unflux
  • Status: Offline

Post May 9th, 2003, 1:01 pm

glad to see you FINALLY listened to me! ;)

actually, I know it doesn't take the password change sometimes. It's
happened to me a number of times, and I never thought to try changing
it again since it should have the first time. And it told me it did!

Oh well, glad you got it working! that's what ozzu is for. :D
UNFLUX.FOTO

Page 1 of 1

Post Information

  • Total Posts in this topic: 9 posts
  • Users browsing this forum: No registered users and 22 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
cron
 

© 2011 Unmelted, LLC. Ozzu® is a registered trademark of Unmelted, LLC.