remote connection to mysql
Added by fonzo de laia over 11 years ago
hi,
I would like to know how I can remotely access mysql goautodial, I have version 2.1 and I am comfortable and I would not change, the only problem is access to mysql remotely. I created a super user from phpmyadmin I disabled the firewall, I tried to find a negative result "bind-address" under /etc/my.cnf , I have also been updated with "yum update" but I can not connect with any management program database.
thanks in advance
Replies (4)
RE: remote connection to mysql
-
Added by Demian Biscocho over 11 years ago
If you're using Linux, check the "mysql" command line help. Accessing remote mysql servers are usually done like this:
mysq -u$USER -p$PASSWORD -h$HOST
$USER = mysql user
$PASSWORD = mysql user password
$HOST = mysql server
RE: remote connection to mysql
-
Added by fonzo de laia over 11 years ago
I use mysql query browser from a remote location on the same LAN and I can not connect, for example, put the address of the server the username and password created with phpmyadmin and does not give me anything, comes a screen with writing table and pinga quietly. On other servers I put the asterisk in bindaddres in my.cnf and everything went well, but in this there is no my.cnf bind address is only this (
[mysqld]
datadir = / var / lib / mysql
socket = / var / lib / mysql / mysql.sock
old_passwords = 1
skip-name-resolve
skip-host-cache
max_connections = 200
big-tables
[mysql.server]
user = mysql
basedir = / var / lib
[mysqld_safe]
log-error = / var / log / mysqld.log
pid-file = / var / run / mysqld / mysqld.pid)
and I can not change anything
RE: remote connection to mysql
-
Added by Demian Biscocho over 11 years ago
Try disabling the built-in firewall (iptables) or open port 3306 in your GOautodial server.
RE: remote connection to mysql
-
Added by fonzo de laia over 11 years ago
thank you very much
solved