I have been using MySQL for awhile, and for the first time someone from
outside our portable /16 needs access to some tables. We have given them
the server IP address, the dB name, the port 3306, the root username, and
the password, but they still can't get access. Of course, no firewalls or
Hi There,
Though it's in the manual, you may want to do something like this:
GRANT ALL ON database.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password'
Of course, you'll want to replace:
- ALL with access privelages that are much safer (assuming you don't
completely trust the remote user).
-
Mary,
I guess, depending on your perspective, that is the case. MySQL
identifies users by their user name and their originating host. For
example: [EMAIL PROTECTED] is different than [EMAIL PROTECTED]. Its
likely you have 2-entries in your mysql.user table for root: localhost
and
Hi all,
I have similar problems as Kris posted on 12/17/2002. I didn't find any
solution, so I write this e-mail.
If I connect to mysql in console with:
mysql -u username -p
then everything works fine. MySQL is 3.23.53-max-nt running on WinXP and
on the same machine I am trying to connect to
Hmmm, what about GRANTs on user 'username@machine_name'?
On Thu February 13 2003 18:44, Branko Kaucic wrote:
Hi all,
I have similar problems as Kris posted on 12/17/2002. I didn't find any
solution, so I write this e-mail.
If I connect to mysql in console with:
mysql -u username -p
then
At 18:44 +0100 2/13/03, Branko Kaucic wrote:
Hi all,
I have similar problems as Kris posted on 12/17/2002. I didn't find any
solution, so I write this e-mail.
If I connect to mysql in console with:
mysql -u username -p
then everything works fine. MySQL is 3.23.53-max-nt running on WinXP and
on
Thanks to all. Now it works!
Branko
On Thu, 13 Feb 2003, Martin Hudec wrote:
Hmmm, what about GRANTs on user 'username@machine_name'?
On Thu February 13 2003 18:44, Branko Kaucic wrote:
Hi all,
I have similar problems as Kris posted on 12/17/2002. I didn't find any
solution, so I
