| cant find bind-address =127.0.0.1 (mysql binding) inside my.cnf [message #83957] |
Mon, 23 May 2011 14:32  |
|
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 #83962 is a reply to message #83960] |
Mon, 23 May 2011 15:20   |
|
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   |
|
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 
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 
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 #83967 is a reply to message #83964] |
Mon, 23 May 2011 15:44   |
|
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 #83973 is a reply to message #83971] |
Mon, 23 May 2011 17:36  |
|
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
ProfiVPS.com Cheap VPS hosting! Buy it from me 
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 
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.
|
|
|