i had a similar problem installing our POS with several terminals for a client in town. edit my.ini after the line that reads [mysqld] to read [mysqld] port=3306 bind_address=*.*.*.* where *.*.*.* is ip address of pc where wamp is installed then refresh wamp and make sure it says its online then enter "*.*.*.*:3306" from whichever terminal you want to connect to the server from im sure same settings apply to lamp hope this helps On Wed, Jul 4, 2012 at 11:04 AM, joe mwirigi <joemwirigi@gmail.com> wrote:
@gisho Which version of mysql is that?
am using 5.1.37-1ubuntu5.5
I reset the my.cnf exactly as it was, also tried without binding to 127.0.0.1 to no avail
rgds *_______________________________________________________________ We must Keep on, *
On Wed, Jul 4, 2012 at 10:55 AM, gisho <gichuhie@gmail.com> wrote:
i can't help but i checked my my.cnf and there's nothing close to your problem. this is my unmodified .cnf
[root@lenana]# cat /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0
[mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid [root@lenana]#
-erastus
On Wed, Jul 4, 2012 at 10:39 AM, joe mwirigi <joemwirigi@gmail.com>wrote:
@kip,
The pings both return normal, my problem is getting mysql to re-learn that localhost== 127.0.0.1. and actually allow connections from localhost as would from the ip. This affects all apps that have localhost as the 'host'
I also have the paths to mysqld.sock well defined
rgds
*_______________________________________________________________ We must Keep on, *
On Wed, Jul 4, 2012 at 10:29 AM, kipropest <kipropbrian@gmail.com>wrote:
What does ping localhost say.
Also try coffee.
On Wed, Jul 4, 2012 at 8:25 AM, joe mwirigi <joemwirigi@gmail.com>wrote:
Hi All, I encountered a unique problem(to me) While i was setting up remote Mysql Access to a server.
(1). Edited my.cnf to bind at the server address instead of 127.0.0.1 (2). Allowed access from my remote ip on the iptables (3) Added host to mysql and granted access to the database (4) Realized something was wrong all 'localhost' configs could no longer access db -shoot! I reverted to the old my.cnf (5)Hell broke and could no longer access server via localhost as host but can access only though 127.0.0.1 as host.
Stuff I have checked and done (1) /etc/hosts had the directive that localhost is 127.0.0.1 (2) Passwords on mysql user are Ok (3) Reset users,host and passwords but still access denied for user@localhost (4) Restarted mysql n times (5) Drunk lots of tea
My question: How do I make it revert to the Old access where localhost meant 127.0.0.1
Could this be the sockets and TCPIP issue is there hope for getting back?
even a google pointer here is welcome since my eyes are now red (cant tell whether its sleep || 'am so screwed color' || part of the bug
help!
Regards again!
*_______________________________________________________________ We must Keep on, *
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke