Justtechjobs.com Find a programming school near you






Online Campus Both


php-install | 2003092

Re: [PHP-INSTALL] maybe someone can help From: John Williams (jwilliam <email protected>)
Date: 09/18/03

At 06:47 PM 9/18/2003 -0500, Melissa Bilodeau wrote:
>I know this is a php list but some one may be able to help me out so here
>goes it.
> running php, mysql on a linux(7.1) server I ,am trying to set up mysql
> so i can connect to it remotely from home as well as from at work I keep
> getting the error "host yada yada yada is not allowed to connect to this
> mysql server" I know i have to grant permission and temporarily would
> like to grant permission to all who attempt to login (another remote
> company will be setting up a web app on it in the next couple days) but i
> have tried and failed several times, have read through mysql manual more
> times than i care to admit.
>
>id appreciate any help you all can give,
>Thanks

I would NOT recommend granting permission to all who want to log in.

Just grant access to that web app company to their table from their ip address.

grant all on table.* to user <email protected> identified by "somepassword";
flush privileges;

for you at home you can

grant all on * to user <email protected> identified by "somepassword";
flush privileges;

to access all tables.

also check out
http://www.webyog.com/sqlyog/ I use it at work and love it!

Good luck!
John

--Statement of Confidentiality--
This message (and any attachment) is intended only for the recipient and may contain confidential and/or privileged
material. If you have received this in error, please contact the sender and delete this message immediately. Thank you.