GoFuckYourself.com - Adult Webmaster Forum

GoFuckYourself.com - Adult Webmaster Forum (https://gfy.com/index.php)
-   Fucking Around & Business Discussion (https://gfy.com/forumdisplay.php?f=26)
-   -   mysql question: how to grant remote access.. (https://gfy.com/showthread.php?t=586602)

mrthumbs 03-14-2006 10:09 AM

mysql question: how to grant remote access..
 
i tried a
GRANT ALL PRIVILEGES ON *.* TO '%'@'%' IDENTIFIED BY 'passwd';
with a flush

and ive tried it with setting a username and host address..

All access denied when i connect remote..

Is there some config file i have to change?

mrthumbs 03-14-2006 10:12 AM

ports are open because mysql responds with a "access denied"..

Juicy D. Links 03-14-2006 10:14 AM

GRANT ALL PRIVILEGES TO JUICY ON *.* TO '%'@'%' IDENTIFIED BY MEOW 'passwd';
with a flush of the colon. MEOWWWW WOOFF MYSQL

That should work

mrthumbs 03-14-2006 10:15 AM

Quote:

Originally Posted by Juicy D. Links
GRANT ALL PRIVILEGES TO JUICY ON *.* TO '%'@'%' IDENTIFIED BY MEOW 'passwd';
with a flush of the colon. MEOWWWW WOOFF MYSQL

That should work


hahahahaha.. man that shit is build in by default!

Juicy D. Links 03-14-2006 10:16 AM

Quote:

Originally Posted by mrthumbs
hahahahaha.. man that shit is build in by default!

:costumed- :costumed- :costumed- :costumed- :costumed-

ServerGenius 03-14-2006 10:23 AM

GRANT ALL PRIVILEGES ON *.* TO '%'@'%' IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

You don't need to flush privileges if you use grant, flush you only need if you
use insert or update to edit permissions.


All times are GMT -7. The time now is 05:40 AM.

Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
©2000-, AI Media Network Inc123