Hi,
It seems dat a lot of people have this problem and I have seen a lot of
discussions about it. But I'm still struggling after 30 hours of trials and
nothing works..
From my service provider I received a login, password and a data base name:
user: foodnews.be
host: foodnews.be
password: xxx
data base: information
I can start MySQL (in DOS) and create a data base on my machine. But I also
want to connect to my shared host. If I type: mysql -h foodnews.be -u
foodnews.be -p; and then enter the password I don't get a connection. I
always get the message that access is denied for user
food...@DSE04027.kabel.telnet.be (error 1045). Why is the user changed
from food...@foodnews.be changed to food...@DSE04027.kabel.telnet.be
? Apparently it's creating a new user. There's a mix-up with username of
the data base and that of my local computer. I know you should grant
permissions etc. but then you first have to be able to connect to the remote
data base server.
Can someone please help?How can I connect to my data base on my remote
shared host server?