On Monday 22 October 2001 08:41, jim barchuk wrote:
> Hi Martin!
>
> > I have been trying to connect to mySQL for a couple of days now with
> > no result! I try to log in via telnet..to my remote server..I get in
> > the system but when I try to log in to the database, nothing!! I use
> > this:
> >
> > mysql -h localhost -u futureenter -p
> >
> > it then asks for a password, I put it in and the return is: "Access
> > denied for user: 'futureenter@localhost' (Using password: YES)"
> >
> > I also tried it with phpMyAdmin, but still the same thing! I have the
> > right data for it..Do I have to stand in an certain location? If it is
> > a remote server, 'localhost' is still good?
>
> Telnet should work fine. Localhost maybe should work, but not necessarily.
> Depends on how the host has your permissions installed in their server.
> Try -h domain.com, or just leave it out altogether. In fact try leaving
> the -u off, maybe your login name is enough.
>
> Only your host admin knows for sure. Ask if they have a FAQ page with the
> promise that if they do you'll never have to ask them another question
> again. LOL!
How was the security set up?
You will definitely need a GRANT of the form:
GRANT XXX ON YYY.ZZZ TO futureenter@localhost IDENTIFIED BY 'WWW';
XXX = the actual grants such as SELECT, INSERT, DELETE ...
YYY.ZZZ = the database and table on which you have these privileges
this could be *.* for everything
WWW is your password, unencrypted.
Note that the hostname must actually match. If the grant was given such that
the FQDN of your host was used instead of "localhost", you'll need to use
that as Jim noted above.
The chapters in the MySQL manual are fairly good. Please read them carefully.
Best,
Kyle
--
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
MicroTelco Services saves money on every Fax:
- Fax to email (FREE)
- Fax to PSTN based Fax (Up to 95% Savings)
- Fax Broadcasting: Send 100s of faxes to fax machines
and email addresses in the time it takes to send just one!
===========================================================
So send a fax today and let us know what you think!
For more info. visit: www.internetfaxjack.com
===========================================================
---------------------------------------------------------------------
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
