Project

General

Profile

remote connection to mysql

Added by fonzo de laia over 10 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 10 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 10 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 10 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 10 years ago

thank you very much

solved

    (1-4/4)
    Go to top