Server :: MySQL - Remote Access For Root?

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


ADVERTISEMENT

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 View Related

General :: Access Remote Mysql Server Through Socks Proxy Server?

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

General :: Allow Remote Access To MySQL Server On Centos5?

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

CentOS 5 Server :: MySQL Server Setup For Remote Access

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

OpenSUSE :: Enable Remote Access To MySQL Database Server?

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

OpenSUSE Network :: Configure Firewall To Allow Remote Access To The Mysql Server?

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

OpenSUSE Network :: Configure Firewall To Allow Remote Access To The Mysql Server

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

Software :: Cannot Access MySQL Server Other Than User=root?

Apr 13, 2011

I've tried every manual there is for creating new MySQL users ... but without success.
I keep getting

Code:
ERROR 1045 (28000): Access denied for user 'test'@'localhost' (using password: YES) even though I just created it with all privileges ... WITH a password that I DO remember .

Fortunately I still have access via the MySQL root user (so I try not to disturb that user, because I have had computers with THAT account not accessible as well - even WITH resetting the password via skip-grant-tables).

View 5 Replies View Related

Server :: Changed Root User Access For MySQL To Any From Localhost?

Mar 14, 2011

I did something silly and changed my root user access for mysql access to Any from localhost using webmin. I get an access dented when i try to open up the mysql editing page on webmin. Can any of you tell me if there is a way to change it back to hosts=localhost I am using webmin 1.5.30 on Centos 5.5. I am hoping I can change it by command line or if I can access the config files and change it that way?

View 2 Replies View Related

Ubuntu Servers :: Mysql ERROR 1045 \ Trying To Allow Remote Access To Mysql?

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

General :: Access Remote Mysql Db With Mysql-administrator Command?

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

Ubuntu Servers :: Setup The MYSQL Server - Error: 'Access Denied For User 'root'@'localhost' (using Password: NO)'

Mar 26, 2010

I set up a servber on my local machine, & also PHp - Both working fine.I'm trying to load up MYSQL i have installed it, & *can* start/stop the server. however if I do anything else with it, I get this error :-

Quote:

root@gordon-desktop:~# sudo mysqladmin -u root -h localhost password MYPASSWORD
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

Query :-

1) How do I know MYSQL is actually active ? (apart from the message it says that its statrted (or stopped).

2) Is there a way to

a) Find out the usernames that are recorded on the MYSQL server ?
b) set / RESET the 'root' username (I know MYSQL root user is different to PC root user)
c) anything else I can do on the PHP / website code to see if MYSQL is working

(as yet, no tables / databases etc have been set up - as I can't get past this error message - I get the same error when setting up a database.)

Ps I did allow my usermname (when logged in to ubuntu) to edit / create files in the /usr/www/ directory (but it is still OWNED by 'root' - that directory)

View 4 Replies View Related

Ubuntu Servers :: Cannot Access MySQL Database From Any Remote Host

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

CentOS 5 :: Remote Access To Mysql - Unreachable Error H3000 - 113

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

Ubuntu Servers :: Can't Access MySQL With Root?

Dec 11, 2010

I'm running an Ubuntu 9.04 Minimal server and trying to get MySQL to work correctly. But when I try to access MySQL with the root user it doesn't want to.

Code:
mysql -u root -p
Enter password:

[code]....

View 4 Replies View Related

Debian :: MySQL: #1045 - Access Denied For User 'root'?

Jan 31, 2011

I am not sure if this is the correct forum to post this as I have usually been able to find the answers from other peoples threads.The error I receive is below.(changed "at" as can't post links)"#1045 - Access denied for user 'root' at 'localhost' (using password: NO)" Not entirely sure what has happened here. I have had this server running for a long time and today it seems to have spat it's dummy out!I have checked the config.inc.php and the controluser and controlpass are entered correctly so the error saying a password is not being usPHP Code:Thisis needed for cookie based authentication to encrypt password incookie

View 2 Replies View Related

Server :: Remote MySQL Server Connection Dies After Wget Large File

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

Server :: How To Connect Qmail / Vpopmail To Remote Mysql Server?

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

Server :: Mysql Command To Allow A Remote Connection?

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

General :: Connecting To Remote Server Using Mysql Command

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

Server :: MySQL Odbc Connection Remote Client?

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

Ubuntu Networking :: Make 127.0.0.1:3306 Redirect To A Remote Mysql Server?

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

Server :: Mysql-server Root Connects, No Other Account Does?

Jul 17, 2011

I'm running Debian Testing and am confounded by a new problem.mysql -u root -p works great.mysql -u mythtv -p doesn't. This is a first for me.I did the usual as mysql root: mysql> create user 'mythtv'@'127.0.0.1' identified by 'mythtv';Query OK, 0 rows affected (0.01 sec)

mysql> grant all on *.* to 'mythtv'@'127.0.0.1';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;

[code]....

View 2 Replies View Related

Server :: How To Reset Root Password Of MySQL?

Sep 21, 2010

for resetting the root user's password. Actually, I am using www.linuxzoo.net for online practice of Linux and have MySQL installed on it. But I forgot the password I set. There was no password by default set for the root user. So, I just trying setting a password last week. Now I am not getting what I did.

View 13 Replies View Related

General :: Setup Remote Access Server On Red Hat Enterprise Server Release 5.1?

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

General :: Non-Root Portable Install Of MySQL Server?

Mar 3, 2010

Is there a non-root, portable distribution of MySQL for Linux? I need to do some testing on a server that I do not have root access to.

View 2 Replies View Related

Server :: MySQL Root User - Administration And Permissions

Jun 22, 2010

I'm using an older redhat system (2.6.9-22.ELsmp) here which is running an older mysql (server version: 4.1.12). I don't think that's the source of the problems. I believe that have understood things rightly when I say that the mysql root user is unrelated to the linux root user ... in my case I believe the root user to be the unix user mysql. So when I connect to the server (local host from a local terminal) I use:
Code:
-bash-3.00$ mysql -u mysql -p
and enter a blank password

This gets me on, however I seem unable to do anything like create database or alter privilege. I wonder if its related to my finding no database called mysql?
-bash-3.00$ mysql -u mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 11 to server version: 4.1.12

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
mysql> show databases;
+----------+
| Database |
+----------+
| test |
+----------+
1 row in set (0.00 sec)
Although I understand that show databases will not show things I have no priv to see. Does this mean my settings for the users are all screwed? How do I rectify this situation? Some other (perhaps) useful information.

Code:
[root ~]# cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

So my BASEDIR seems to be nothing like is suggested in the documentation at [URL].

View 2 Replies View Related

Fedora Installation :: Change The Root Password Of MYSQL Server

Mar 16, 2009

How can I change the root password of MYSQL server. I have just finished installation, but I mistakenly typed the wrong root password, and now I need to change it from command line, because I cannot even access the UI.

View 8 Replies View Related

Server :: Using CentOs On A Remote Server But Can't Access PhpmyAdmin

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







Copyrights 2005-15 www.BigResource.com, All rights reserved