top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

SSH tunnels and non root accounts get "the server service or the configuration file could not be found"

0 votes
463 views

Server running Centos and MySQL and Client is a windows xp machine.
I have setup a SSH tunnel with putty and run mysql administrator. It works fine with the root account.

With a non-root account I get
the server service or the configuration file could not be found. I can log on but I can't see the databases that I should be allowed to see.

Running a mysql -h 127.0.0.1 -u myuser -p mypassword from linux works fine

I have created a .my.cnf file in the home folder with 600 permissions in the linux box and filled it with:

[client]
 pass='mypass'
 user=myuser

Server configuration file is under /etc/my.cnf. What am I doing wrong?

posted May 29, 2013 by anonymous

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

2 Answers

0 votes

Your windows-based client never sees the files on the linux server. All the tunnel provides is the ability to treat port 3306 of your linux box as-if it was a port local to your windows system. It does not, can not make file access transparent across those systems.

answer May 29, 2013 by anonymous
0 votes

If you are tunneling port 3306 to your local machine, you need to have mysql listen on the local port.

what ever port is being used on your local computer to operate the tunnel to port 3306 remotely is the port you will use for mysql locally.

answer May 29, 2013 by anonymous
Similar Questions
+3 votes

Why I get this message " You have new mail in /var/spool/mail/root " in CentOs?

My queries are the following -
1. Why this is generated ?
2. How to disable this ?
3. Is this system generated ?
4. Is this message gain any importance ?

0 votes

How to produce this error
Step 1: Open up a PowerShell or CMD session as Administrator.
Step 2: Type the following command:

DISM /Online /Enable-Feature /All /FeatureName:Microsoft-Hyper-V

While enable the Hyper-V role using DISM I am getting these following error

Deployment Image Servicing and Management tool
Version: 10.0.10240.16384

Image Version: 10.0.10240.16384


Error: 0x800f080c

Feature name Microsoft-Hyper-V is unknown.
A Windows feature name was not recognized.
Use the /Get-Features option to find the name of the feature in the image and try the command again.

The DISM log file can be found at C:\Windows\Logs\DISM\dism.log

Image from Windows 10

DISM restore

+1 vote

For a Wordpress website I have installed mysql-server-5.1.69-1.el6_4.x86_64 and run /usr/bin/mysql_secure_installation on a CentOS 6.4 machine with mucho RAM (32 GB) and I wonder, what would be the best place for the mysqld parameters descibed at http://dev.mysql.com/doc/refman/5.1/en/server-parameters.html

mysqld_safe --key_buffer_size=64M --table_open_cache=256  --sort_buffer_size=4M --read_buffer_size=1M &

Should I just edit the file /etc/init.d/mysqld or is there a better place in CentOS for that (under sysconfig?)

...