Server :: Mysql Remote Access Failed?
Dec 28, 2010
I'm using slackware 13.1 and I have a problem to accept remote access to mysql server.The steps I have followed to do that thing are:vi /etc/my.cnfline skip-networking is commented
bind-address my_ipaddressI opened the port 3306 of my firewallAlthough I can connect locally, i.e. mysql -u a_user -h localhost -pI can't do it remotely i.e. mysql -u same_user -h my_ipaddress -pI have also turned off my firewall, but nothing.telent 3306 my_ipaddress results in: telnet: connect to address my_ipaddress: Connection refusedMy my.cnf file is:
Code:
[client]
port= 3306
[code]....
View 14 Replies
ADVERTISEMENT
Aug 9, 2010
I have a question in regards to enabling root remote access to the server.I am trying to use the mysql workbenchit kicks back an error saying "Access denied for user 'root'@'10.x.x.x' (using password: YES)" But I am able to login locally on the server.How do I enable root to long on remotely from any workstation?
View 3 Replies
View Related
Aug 25, 2010
Scenario:A - Local Unix machineB - socks proxy server port 1080C - remote mysql server port 3306I want to connect to the remote mysql server(C) from local unix machine(A) using sock proxy(B).
View 1 Replies
View Related
Jan 7, 2009
I have yum installed mysql 5 on Centos5 and I can successfully run queries through shell.However, I want to now allow external access to mysql via some mysql tools (Mysql Administrator/Mysql Query Browser) which is on some windows machines on the same network.Mysql is running on port 3006.When i try connecting through mysql Admin i get the following:Could not connect to the specified instance.MySQL Error Number 2003Can't connect to MySQL server on 'ipaddress' (10065)If you want to check the network connection, please click the Ping button.Googling this I get the impression its something port related, but I have tried what I have found and still no go.When I ping the server I get:
Start Pinging:
Reply from ipaddress: Time=0ms TTL=64
Reply from ipaddress: Time=0ms TTL=64
[code]....
View 5 Replies
View Related
May 4, 2009
I have just installed CentOS 5. I have set mysql database to access from remote machines. But now the problem is it is not connecting from the local machine now.
View 5 Replies
View Related
Jan 29, 2011
Enable remote access to MySQL database server I used the link above to enable remote access to mysql for a specific user. But when I try to telnet 3306 or user mysqladmin to connect, both just hang there. Using mysql 5.0 on opensuse 11.1
View 1 Replies
View Related
May 31, 2011
I have a server machine that is running SUSE Linux Enterprise Server 11. I set up a mysql server there. Now I want to access this mysql server from my laptop. I used the following command,
> mysql -h 12.246.5.70 -u davidehs -p
I found if the firewall on the server machine is running, I can not connect the mysql server from my laptop. If I stop the firewall first, and the do the connection, I can access the mysql. how to keep the firewall running and allow the remote mysql incoming requests?
View 4 Replies
View Related
Jan 28, 2011
I have a server machine that is running SUSE Linux Enterprise Server 11. I set up a mysql server there. Now I want to access this mysql server from my laptop. I used the following command,
> mysql -h 12.246.5.70 -u davidehs -p
I found if the firewall on the server machine is running, I can not connect the mysql server from my laptop. If I stop the firewall first, and the do the connection, I can access the mysql. Do you guys have any idea how to keep the firewall running and allow the remote mysql incoming requests?
View 11 Replies
View Related
Jan 14, 2011
i was trying to allow remote access to mysql by following mysql was running perfectly until i got here :
Code:
/sbin/iptables -A INPUT -i eth0 -s 192.168.1.0/24 -p tcp --destination-port 3306 -j ACCEPT
i changed my.cnf bind-address line to : "bind-address = 127.0.0.1" and nothing
[code]....
View 4 Replies
View Related
May 13, 2011
I have install mysql on my fedora12. My different mysql server is located in us. I want to check health status and hits per seconds everything. Is it possible with mysql-administrator command.
now a these days i am connect through ssh and excuting below command
#mytop mysql -u root -p <passwd>
In my mysql db i have added the userip & passwd (allowed the privileages for that ip)
If i use mysql-administrator i am getting below error
MySQL Error Nr. 2003
Can't connect to MySQL server on '66.98.152.64' (111)
View 6 Replies
View Related
Apr 15, 2011
I can not access my MySQL database from any remote host on my home network, I keep getting "Access denied for user 'dbuser'@'192.168.1.10' (using password: YES)"
From what I've read this seems to be a permission problem, I tried
'dbuser'@localhost';
'dbuser'@'%';
'dbuser'@'192.168.1.10';
and between each change of permission, I've flushed privileges.
View 1 Replies
View Related
Jun 13, 2009
I setup mysql v5 on centos, follow all the instruction i was able to google for to enable remote access, I am able to log in to -h localhost and -h (external IP address) from same server, I am able to telnet to 3306 using localhost and external ip address, BUT when I try to connect from deferent server i get host unreachable error H3000 (113) and telnet also is not able to connect via port 3306 I covered all the bases but stii no luck. same setup works for slackware no problem and there is no issue with client.
View 1 Replies
View Related
Jan 21, 2010
I just finish tring to get my mail server running but I get an error in my mail.log
Jan 21 16:33:08 server imapd-ssl: Connection, ip=[::ffff:67.223.78.XX]
Jan 21 16:33:08 server authdaemond: failed to connect to mysql server (server=127.0.0.1, userid=postfixadmin): Access denied for user 'postfixadmin'@'localhost' (using password: YES)
Jan 21 16:33:08 server imapd-ssl: LOGIN FAILED, user=jason@[mydomain].com, ip=[::ffff:67.223.78.76]
Jan 21 16:33:08 server imapd-ssl: authentication error: Input/output error
I have the right password in all the mysql config files and tried to reset the password in the sql database with no luck. I granted perms to all and its still giving me the error.
View 1 Replies
View Related
Feb 3, 2011
We have 2 servers, 1 is the webserver and the other is the Mysql server.
When transfering a 2GB file from the webserver to the Mysql server.
The webserver's connection to the mysql DB server dies completely.
Need to restart the MYSQL process in order for it to come back online.
During this connection downtime, when using phpmyadmin on the mysql server shows no problem running queries etc.
View 2 Replies
View Related
May 14, 2010
I would like to connect to a separate mysql server, yet I can't find any documentation on how to do this.How would one achieve this? I am running qmail on centos4.
View 3 Replies
View Related
Jun 8, 2010
what is the correct command on a mysql command line to alllow mysql to alllow remote connection on a server
View 1 Replies
View Related
Nov 19, 2010
I tried to install php from source file on centos server and i got the error as # ./configure --with-apxs2=/usr/local/packages/apache/bin/apxs --with-mysql --prefix=/usr/local/packages/apache/php --enable-force-cgi-redirect --disable-cgi --with-zlib --with-gettext --with-gdbm
checking for specified location of the MySQL UNIX socket... no checking for MySQL UNIX socket location... /var/lib/mysql/mysql.sock checking for mysql_close in -lmysqlclient... no checking for mysql_error in -lmysqlclient... no configure: error: mysql configure failed. Please check config.log for more information.
View 6 Replies
View Related
Jun 7, 2010
I am fresh out the box to linux I am using mysql for the 1st time also, my question is what is the correct command to run on a mysql command line to connect to remote server.
View 5 Replies
View Related
Jul 27, 2010
I wish to connect to MySQL using an ODBC connection and I'm using isql to test. On the server connection using isql to local host is sweet however the problem is the client.Okay my set up looks like thisOn the server /etc/odbc.ini is[MySQL-scopus2008]Description = MySQL citation databaseDriver = MySQLServer = localhostDatabase = scopus2008Por
View 4 Replies
View Related
Mar 22, 2010
I'd love a hint or two on the following problem. I've set up iptables rules to forward all connections to port 3306 to a non-standard mysql port on a remote server. This works, except that I need to deal with the loopback interface in a special way and I'm stuck.
Code:
iptables -t nat -A PREROUTING -p tcp --dport 3306 -j DNAT --to 128.XXX.XXX.XXX:3197
iptables -A FORWARD -p tcp -d 128.XXX.XXX.XXX --dport 3197 -j ACCEPT
iptables -t nat -A POSTROUTING -j MASQUERADE
Since locally-generated packets will never hit the PREROUTING rule, you'll need to setup a near identical rule using OUTPUT to make it work. Here is what I've tried:
[Code]...
View 4 Replies
View Related
Jul 28, 2011
Mysql can't start after I uploaded my.cnf file in /etc directory before that everything was okay but after I uploaded my.cnf and then restarted the mysql it can't boot
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
I tried to delete my.cnf and try again but the same error ...
View 5 Replies
View Related
Jun 14, 2011
I want to connect to my Linux debian server, via Remote desktop connection, but when I give IP of my server and click connect, it fail, it says can't connect to the remote computer and below 3 reason.
View 3 Replies
View Related
Feb 26, 2010
I enabled remote desktop on my Fedora core machine.
SELinux is disabled, as is iptables.
I used UltraVNC to connect and it worked.
However, after I came back overnight, I tried to connect and it failed.
I received a "Failed to connect to server"
Found that the machine had rebooted.
How do I get it the Remote Desktop function to start as a service? I am new to Linux.
View 3 Replies
View Related
Aug 30, 2009
how i have a machine installed Red Hat Enterprise Linux Server release 5.1 with 2 modem (usb & com port) still i want to configure RAS server so some pple able to connect my server and send me some files.
View 4 Replies
View Related
Mar 10, 2010
I have some confusion about mysqladmin and mysql.I am using mysql version Quote:
[root@localhost freepbx-2.7.0]# mysql --version
mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (i686) using readline 5.1
My MySQL is running
Quote:
[root@localhost freepbx-2.7.0]# /etc/init.d/mysqld status
mysqld (pid 11440) is running...
[Code]...
View 4 Replies
View Related
Oct 25, 2010
Im using CentOs on a remote server. I've recently installed phpmyadmin but cant access from [URL] I checked the files and found only 3 folders in /var/lib/phpmyadmin -config / save / upload - all of them empty. Whenever I try intstall phpmyadmin again it just says its already installed and up to day.
View 2 Replies
View Related
Jul 15, 2010
When you access mysql within the same Apache server (same ip address) via php, do you need to GRANT user ip in order to login to mysql?
Where are the log files for php, mysql etc?
View 4 Replies
View Related
Nov 27, 2010
I have a computer set up running an apache httpd server with the basic LAMP functionality. I logged into the server today and noticed numerous attempts by a remote IP to access various files on my server.
Code:
[Fri Nov 26 07:37:56 2010] [error] [client 72.167.161.46] File does not exist: /var/www/html/phpMyAdmin-2.8.1-rc1
[Fri Nov 26 07:37:56 2010] [error] [client 72.167.161.46] File does not exist: /var/www/html/phpMyAdmin-2.8.1
[Fri Nov 26 07:37:57 2010] [error] [client 72.167.161.46] File does not exist: /var/www/html/phpMyAdmin-2.8.2
[Fri Nov 26 07:37:57 2010] [error] [client 72.167.161.46] File does not exist: /var/www/html/sqlmanager
[Code]...
There are many many more lines similar to this but its obvious that a remote host was attempting to run my phpmyadmin page and gain access. My question is that since I'm a novice at running httpd what sort of things should I be looking out for in regards to security and configuration to prevent any attacks or is this common and should just be ignored? I do run phpMyAdmin on the server and have configured MySQL to not have blank passwords or user accounts. The database had no new changes to it so I doubt they actually accessed it.
View 6 Replies
View Related
Jul 15, 2010
Is there a safe way for me to configure my server for access from any internet connection as well as from my home/office LAN? I'd like to be able to access file shares, webmin, the router console behind my Gateway for maintenance purposes. Access to Server Desktop itself would be a bonus.
View 12 Replies
View Related
Mar 23, 2011
I've been using ubuntu for quite a few years, and know the basics of databases. However, how to get them to talk to each other... Not so much.
I need to be able to connect to a MySQL database using Microsoft Access 20074. The database is going to be running on my server, which runs ubuntu server 10.10.
So far, I have installed MySQL server and libmyodbc. I took the deetails for the odbc.ini file from the ODBC ubuntu community page, so this is the current setup (database name is business):
Code:
[ODBC Data Sources]
odbcname = MyODBC 3.51 Driver DSN
[business]
[Code].....
When I try to connect using Access, I get "Server does not exist or access denied."
View 3 Replies
View Related