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 [EMAIL PROTECTED] identified by "somepassword"; flush privileges;
for you at home you can
grant all on * to [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.
