Unix and Linux Stack Exchange
Unix and Linux Stack Exchange

Questions tagged [mysql-connection]

29 questions
15
votes
1 answer

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 server version or connection protocol detected…
MountainX
  • 17,168
  • 59
  • 155
  • 264
8
votes
2 answers

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 machine but I'd like to get to MySQL db over gui…
Michal_Szulc
  • 256
  • 1
  • 3
  • 13
6
votes
2 answers

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 | +--------------------------+-------+ | Aborted_connects …
Cody
  • 245
  • 1
  • 9
3
votes
1 answer

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 , changed some settings that I modified , then I can't…
user3047270
  • 31
  • 1
  • 2
3
votes
2 answers

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? I was told earlier today that the difference…
Frank
  • 651
  • 3
  • 10
  • 25
2
votes
0 answers

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 (without entering password) sudo su - (without entering…
Fels
  • 121
  • 2
1
vote
0 answers

MariaDB connector (remote)

I'm new to databases and have some very basic how-to/where-to questions: I have successfully setup a MariaDB + phpmyadmin on my raspberrypi zero (running the latest diet-pi), including a database with a couple of columns, which works like a…
user2305193
  • 141
  • 5
1
vote
2 answers

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 Debian 10 machine), the user created doesn't have…
Christophe S
  • 25
  • 3
1
vote
1 answer

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, but when I try to run it on my remote ubuntu…
Taylor
  • 123
  • 6
1
vote
0 answers

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 have it jump ssh tunnel connections through to the…
Joseph Michael
  • 11
  • 1
1
vote
1 answer

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 "1.5.0" gij (GNU libgcj) version 4.4.7 20120313…
penguin
  • 109
  • 1
  • 1
  • 8
1
vote
0 answers

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 which gives this error: Command "python setup.py…
Ninja Turtle
  • 11
  • 1
1
vote
2 answers

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. 3. connection between mysql and application.…
Nitesh B.
  • 563
  • 2
  • 7
  • 20
0
votes
2 answers

Program starts from rc.local but doesn't do anything

I have a program which uses msqllib. It scans some hardware that I build and then updates a mysql database. This program has been running for a number of years but I have never been able to autostart it when the system reboots. Now I have an issue…
Nigel W Johnson
  • 3
  • 1
0
votes
0 answers

wordpress can not find database, while mysql_client can

I am trying to prepare a WordPress site, on my public web server, running apache2. The database host, I am trying to use, for the WordPress installation, is another server. While I can successfully connect the db_host from my web server, through…
manmatha.roy
  • 197
  • 1
  • 4
  • 9
1
2