LxCenter HyperVM & Kloxo Support

Forum



Members   Search      Help    Register    Login    Home
Home » LxCenter » GNU/Linux Help » cant find bind-address =127.0.0.1 (mysql binding) inside my.cnf(looking for "bind-address" inside my.cnf but not there. What file is it included in? )
cant find bind-address =127.0.0.1 (mysql binding) inside my.cnf [message #83957] Mon, 23 May 2011 14:32 Go to next message
xauen10 is currently offline xauen10  
Messages: 20
Registered: May 2011
Location: UAE
Member
Hello,

Need to modify bind-address=127.0.0.1 and change to bind-address={my.remote.ip} to access base "kloxo" db from remote host.
I already googled and they tell the same thing:
Looked inside my.cnf but when i opened the file its not there coz i need access to my kloxo db's from remote host by removing the localhost mysql binding.
Could someone tell me what specific file "bind-address" is located?
Can someone please help me?
Re: cant find bind-address =127.0.0.1 (mysql binding) inside my.cnf [message #83960 is a reply to message #83957] Mon, 23 May 2011 14:56 Go to previous messageGo to next message
mustafaramadhan is currently offline mustafaramadhan  Indonesia
Messages: 5731
Registered: December 2010
Location: Yogyakarta
Super Grandmaster
Forum Moderator

Try add "bind-address = yourremoveip" under [mysqld] section.

http://download.lxcenter.org/kdev.png
..:: MRatWork ::..
Server/Web-integrator - perfect not always more useful

--- Need KVM/OpenVZ VPS? - click here (Kloxo-MR READY!) ---

For bug/feature/security - Member rank status

http://download.lxcenter.org/hdev.png
Re: cant find bind-address =127.0.0.1 (mysql binding) inside my.cnf [message #83962 is a reply to message #83960] Mon, 23 May 2011 15:20 Go to previous messageGo to next message
xauen10 is currently offline xauen10  
Messages: 20
Registered: May 2011
Location: UAE
Member
no thats not it sir...
added bind-address=0.0.0.0 but remote client is not connecting


pam_mysql auth.log:
GNU nano 2.2.2 File: /var/log/auth.log
{omiited non important logs}
May 23 21:41:19 mark4 saslauthd[1867]: pam_mysql - MySQL error (Host '{my.remote.ip}') is not allowed to connect to this server

Any other suggestions sir?

my.cnf file:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
port=3306
bind-address=0.0.0.0
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

# To allow mysqld to connect to a MySQL Cluster management daemon, uncomment
# these lines and adjust the connectstring as needed.
#ndbcluster
#ndb-connectstring="nodeid=4;host=localhost:1186"

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[ndbd]
# If you are running a MySQL Cluster storage daemon (ndbd) on this machine,
# adjust its connection to the management daemon here.
# Note: ndbd init script requires this to include nodeid!
connect-string="nodeid=2;host=localhost:1186"

[ndb_mgm]
# connection string for MySQL Cluster management tool
connect-string="host=localhost:1186"

[Updated on: Mon, 23 May 2011 15:29]

Report message to a moderator

Re: cant find bind-address =127.0.0.1 (mysql binding) inside my.cnf [message #83963 is a reply to message #83962] Mon, 23 May 2011 15:23 Go to previous messageGo to next message
semir is currently offline semir  Hungary
Messages: 985
Registered: January 2011
Location: Hungary
Senior Master
Forum Administrator
LxCenter Evangelist
how did you create the user?
Users have 'username'.'domain' kind of permissions. If your user was created using 'whoever'.'localhost' then your remote server wont be able to connect using that username. Try adding a new user 'newuser'.* .

Google, first match, step 5#:
http://www.cyberciti.biz/tips/how-do-i-enable-remote-access- to-mysql-database-server.html


ProfiVPS.com Cheap VPS hosting! Buy it from me Smile
ProfiVPS.hu Megbízható, Olcsó VPS bérlés, Virtuális szerver bérlés

If I helped you, please consider putting my link on your site/blog! Thank you in advance Smile

Do not forget: HyperVM and Kloxo are open source projects. As such, they need your contribution: if you were helped, add your 50 cents, and try to help others with their problems later.

[Updated on: Mon, 23 May 2011 15:24]

Report message to a moderator

Re: cant find bind-address =127.0.0.1 (mysql binding) inside my.cnf [message #83964 is a reply to message #83963] Mon, 23 May 2011 15:38 Go to previous messageGo to next message
xauen10 is currently offline xauen10  
Messages: 20
Registered: May 2011
Location: UAE
Member
GRANT ALL PRIVILEGES ON kloxo.* TO '{user}'@'%' IDENTIFIED BY '{passwor}'

i did the above statemnet on phpmyadmin and check if its in the priveledge overview.
Its there and the rules are ok. So did i do flush priveledges then restart mysql server

but still auth_failed.
Re: cant find bind-address =127.0.0.1 (mysql binding) inside my.cnf [message #83966 is a reply to message #83964] Mon, 23 May 2011 15:44 Go to previous messageGo to next message
semir is currently offline semir  Hungary
Messages: 985
Registered: January 2011
Location: Hungary
Senior Master
Forum Administrator
LxCenter Evangelist
'{user}'@'%' ? it wont set the user to be '*' if I'm not wrong. It only means that the users that are to be changed could be added from any domain.

Add a new user like you see in that tutorial and come back after that.


ProfiVPS.com Cheap VPS hosting! Buy it from me Smile
ProfiVPS.hu Megbízható, Olcsó VPS bérlés, Virtuális szerver bérlés

If I helped you, please consider putting my link on your site/blog! Thank you in advance Smile

Do not forget: HyperVM and Kloxo are open source projects. As such, they need your contribution: if you were helped, add your 50 cents, and try to help others with their problems later.

[Updated on: Mon, 23 May 2011 15:44]

Report message to a moderator

Re: cant find bind-address =127.0.0.1 (mysql binding) inside my.cnf [message #83967 is a reply to message #83964] Mon, 23 May 2011 15:44 Go to previous messageGo to next message
xauen10 is currently offline xauen10  
Messages: 20
Registered: May 2011
Location: UAE
Member
did telnet also but connection is closed by server

root@mark4:~# mysql -u markcodes -h {mysql.server.IP} -p
-bash: mysql: command not found
root@mark4:~# telnet {mysql.server.IP} 3306
Trying {mysql.server.IP}...
Connected to }mysql.server.IP}.
Escape character is '^]'.
4
5.0.9\)UPqg3f,☻)6tf${c_3~CqConnection closed by foreign host.
root@mark4:~#
Re: cant find bind-address =127.0.0.1 (mysql binding) inside my.cnf [message #83968 is a reply to message #83967] Mon, 23 May 2011 15:45 Go to previous messageGo to next message
semir is currently offline semir  Hungary
Messages: 985
Registered: January 2011
Location: Hungary
Senior Master
Forum Administrator
LxCenter Evangelist
Of course it closed, telnet is not amysql client... It only shows your port is open.
mysql -u markcodes -h {mysql.server.IP} -p
-bash: mysql: command not found

wtf??


ProfiVPS.com Cheap VPS hosting! Buy it from me Smile
ProfiVPS.hu Megbízható, Olcsó VPS bérlés, Virtuális szerver bérlés

If I helped you, please consider putting my link on your site/blog! Thank you in advance Smile

Do not forget: HyperVM and Kloxo are open source projects. As such, they need your contribution: if you were helped, add your 50 cents, and try to help others with their problems later.
Re: cant find bind-address =127.0.0.1 (mysql binding) inside my.cnf [message #83969 is a reply to message #83968] Mon, 23 May 2011 15:54 Go to previous messageGo to next message
xauen10 is currently offline xauen10  
Messages: 20
Registered: May 2011
Location: UAE
Member
So you mean port 3306 port mysql server is open. ok solved for this

Ok i did the following tutorial that you gave me: still auth_failed for pam_mysql
Re: cant find bind-address =127.0.0.1 (mysql binding) inside my.cnf [message #83970 is a reply to message #83968] Mon, 23 May 2011 15:58 Go to previous messageGo to next message
Walter  Brazil
Messages: 866
Registered: February 2009
Location: Florianopolis / BR
Senior Master
Forum Moderator
LxCenter Project Manager

xauen10

Again, this is nothing to do with Kloxo and to make it worse you are posting in HyperVM forums. Please use the correct forums and make sure you do an internet search before posting.
Re: cant find bind-address =127.0.0.1 (mysql binding) inside my.cnf [message #83971 is a reply to message #83970] Mon, 23 May 2011 16:03 Go to previous messageGo to next message
xauen10 is currently offline xauen10  
Messages: 20
Registered: May 2011
Location: UAE
Member
ok my fault for posting in the wrong forum.
To tell you, if ive found the solution in the internet, would ask here?
Thats why i come here coz i know your reliable. Just don't tell me to search coz i already did.
Re: cant find bind-address =127.0.0.1 (mysql binding) inside my.cnf [message #83973 is a reply to message #83971] Mon, 23 May 2011 17:36 Go to previous message
semir is currently offline semir  Hungary
Messages: 985
Registered: January 2011
Location: Hungary
Senior Master
Forum Administrator
LxCenter Evangelist
Look, I've set up not once remote connecting using the link I posted to you.
If it does not work, then it is surely an error you make/made.

Check hostnames in the mysql.user tables.

PS: of course you can post here for help. But ONLY if you do what you are advised to do, or asked to do Wink


ProfiVPS.com Cheap VPS hosting! Buy it from me Smile
ProfiVPS.hu Megbízható, Olcsó VPS bérlés, Virtuális szerver bérlés

If I helped you, please consider putting my link on your site/blog! Thank you in advance Smile

Do not forget: HyperVM and Kloxo are open source projects. As such, they need your contribution: if you were helped, add your 50 cents, and try to help others with their problems later.
Previous Topic:auth_failed on openvpn when connecting to remote "kloxo" db
Next Topic:how enable xml reader & writer
Goto Forum:
  


Current Time: Thu Jun 20 01:12:43 EDT 2013

Total time taken to generate the page: 0.01239 seconds
.:: Contact :: Home :: Privacy ::.

Click here to lend your support to: LxCenter and make a donation at www.pledgie.com !

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software