Re: How to connect from local Windows 95 computer to remote shared Linux host server? - rene - com.mysql.lists.win32

4 messages in com.mysql.lists.win32Re: How to connect from local Windows...

From	Sent On	Attachments
Markus Rathmayr - onScreen	12 Dec 2001 11:59
Korendir	12 Dec 2001 14:09
rene	12 Dec 2001 14:21
Erik Augustijns	12 Dec 2001 20:11

Subject:	Re: How to connect from local Windows 95 computer to remote shared Linux host server?
From:	rene (teg...@dubaron.com)
Date:	12/12/2001 02:21:24 PM
List:	com.mysql.lists.win32

grant select, update[, ...] on mybase.* to 'user'@'%' identified by 'users pass';

btw, it's all in the manual...

hope this helps

Is there any way to set it so that you can allow any host but still require the password? I am working on a Visual Basic project that has sevreal components that need to use the same database and I would like to use MySQL as that database.

That's because normally you are not allowed to connect from anywhere else than the Webserver. There are providers that allow anyhost connections but only in combination with a unqiue IP-address.

There is no change in the user name but the MySQL-Server takes your Hostname assigned from telnet.be and connections from that host - and any other apart from the one allowed access.

-----Ursprüngliche Nachricht----- Von: Erik Augustijns [mailto:erik...@pandora.be] Gesendet: Donnerstag, 13. Dezember 2001 05:12 An: win...@lists.mysql.com Betreff: How to connect from local Windows 95 computer to remote shared Linux host server?

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?

To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail win3...@lists.mysql.com instead.