Questions tagged [mysql-connection]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
2answers
32 views

Removing commands from a specific user

I have a problem, I need to give an access to someone, but the only way to connect to the database is via SSH, so if I have understood everything correctly, I need to create him a linux account (on a ...
0
votes
0answers
11 views

How to connect to pgadmin (deployed in cloud) using psycopg2

Can anyone please help me on how to connect to pgadmin which is deployed in cloud from cloud functions? I tried to connect using psycopg2 as below (a connection file in our cloud function): import ...
0
votes
0answers
209 views

ERROR 2002 (HY000): Can't connect to MySQL server on 'xx.xxx.xxx.xxx' (115)

I wanted to connect to memsql but when I try i wasn't able to connect , I get error as: mysql -u root -h 127.0.0.1 -P 3306 --prompt="memsql> " ERROR 2002 (HY000): Can't connect to MySQL server on '...
0
votes
0answers
175 views

MariaDB: ERROR 2006 (HY000): MySQL server has gone away

When i try to execute a query i got error: MariaDB [suitecrm]> select * from waiter_log; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... An error ...
1
vote
1answer
273 views

mysql database won't allow tcp connections on localhost at the default port

Trying to connect to a database with a c++ program. I am using the mysqlcppconnector with the connection strings tcp://localhost:3306 and tcp://127.0.0.1:3306. The program works on my local machine, ...
1
vote
0answers
97 views

SSH Tunnel/Reverse Tunnel Question

I am attempting to daisy chain tunnels/ports to access mysql on a secured server. Without opening up iptables, I would like to, from my local machine: mysql -uadmin_user -p -hlocalhost:8002 and ...
1
vote
1answer
235 views

MySQL Java connector still using old java version?

Installing mysql-connector-java-8.0.15-1.el6.noarch.rpm (available here ) shows libgcj package as a dependency. Installing libgcj creates below file: /usr/bin/gij $/usr/bin/gij -version java version ...
0
votes
1answer
74 views

How to connect PHP 5.6 to SQL db after compilation

I installed PHP 5.6 from source on Debian server 9 server. The OpenSSL version in Debian 9 is too new for PHP 5.6, so I had to compile an older version in /opt/openssl to use it with PHP 5.6. ( ...
0
votes
3answers
68 views

Login into Mysql without startx

I have had install Damn small Linux(DSL) 10 in Virtual Box with MySQL 5. I created already a database with a Table and Data in it. I can access it over the terminal with the following line: mysql -u ...
-3
votes
2answers
108 views

Connect to external host with/as local ip [closed]

I want to connect to a Mysql database remotely. The database accept connections from only local ip like 192.168.0.%. I am wondering if there is a way to connect to the database host by setting my ip ...
1
vote
0answers
194 views

setup mysql with django

I am trying to setup mysql server with my django application but I am having trouble installing it correctly. I used brew install mysql to install mysql server Then I used pip install mysqlclient ...
0
votes
1answer
25 views

Making my Linux (Ubuntu) to ask me what is the SQL password so I won't store it in the .sh file?

I have a a script file which makes an immediate backup of my server's document root and of my databases and copy it to my terminal system, from which I SSH tunneled to my server environment: ( cd /...
2
votes
0answers
524 views

How do I setup a connection to a database over a SSH-Tunnel with kerberos in a gui?

I need to connect to a Mysql database on a server that is only accessible over ssh with a Kerberos ticket. In a console this is easy, I only do: kinit (then enter password) ssh username@server (...
8
votes
2answers
7k views

SSH tunnel via MySQL Workbench

my new production server is only visible via ssh double tunnel. I can reach targetHost over Ubuntu's 14.04 console simply executing command ssh targetHost and than executing mysql cli on remote ...
2
votes
1answer
2k views

reconfigure mysql question

what happens if I use this command? sudo dpkg-reconfigure mysql-server and more important : what happens to my databases? Are they droped? note: when I upgraded my ubuntu 16.04 in last night , ...
3
votes
2answers
6k views

Is the difference between mono-runtime and mono-complete related to whether MySQL inserts successfully take place on Ubuntu 16.04?

What is the difference between 1. sudo apt-get install mono-runtime and 2. sudo apt-get purge --remove mono-complete followed by sudo apt-get install mono-complete on an Ubuntu linux 16.04 instance? ...
11
votes
1answer
30k views

MySQL Workbench warning when connecting to MariaDB

When using MySQL Workbench 6.3 on Kubuntu 15.10 and MariaDB Server version: 10.0.22-MariaDB-0ubuntu0.15.10.1 (Ubuntu), I get the following warning. Is this expected? Incompatible/nonstandard ...
0
votes
1answer
78 views

mysql monitoring tool

Is there any monitoring tool for mysql which will send a notification mail to mentioned email ID ? It must monitor below parameters. 1. mysql more than 500 concurrent connections. 2. mysql deadlocks. ...
0
votes
1answer
1k views

php server can't connect to the remote mysql server

We have two servers. server 1 and server 2 they are running with Directadmin / CentOS6 my plan: server 1 is running php and html, images...etc. server 2 is running mysql and phpmyadmin They are ...
0
votes
1answer
695 views

Mysql: remote and local access

I have a gentoo where is installed a mysql server. I need a remote access to this server, so I have modified the option bind address in the file /etc/mysql/my.cnf bringing it from bindaddress: 127....
0
votes
1answer
117 views

php connect to mysql

I am using Trisquel 7.0 LTS and installed php5 and php5-mysql. All php scripts working properly.(I used to write my-learning scripts in /var/www/html/xyz.php and all is working by http://localhost/xyz....
6
votes
2answers
793 views

MySQL has over 95,000 connections but processlist is empty?

I have a server that is running mysql and it's using a lot of memory. I run: mysql > show status like '%onn%'; +--------------------------+-------+ | Variable_name | Value | +----------...
-1
votes
1answer
646 views

MYSQL : Connecting to mysql from : 127.0.0.1 + telling ip tables to allow only 127.0.0.1 for mysql port : Logic vs Common Sense

If i make 1 billion or 1 trillion queries to MYSQL database from 127.0.0.1 via port 3306. vs If i make same amount of queries to MYSQL database also from 127.0.0.1 via port 3306. but with a ...
0
votes
1answer
2k views

mysql jdbc connection issues in RHEL 6

I have setup the mysql database in one of the RHEL 6 servers. I would like to connect to this server's database from any other machine using a java program. How should I do it?