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:
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?
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).
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
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.
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
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?
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?
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)
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
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.
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.
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.
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.
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.
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
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:
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 ...
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.
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.
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...
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.
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.
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.
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):
