The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
0answers
16 views

ArchLinux can't get MySQL Workbench to connect to server

I just installed the mysql-workbench 6.3.8-1 package from the AUR. I started it and before making my connection I clicked on the Test connection button and got the following error: Failed to ...
2
votes
2answers
170 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 ...
0
votes
1answer
111 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 , ...
0
votes
2answers
363 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? ...
4
votes
1answer
6k 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
30 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
444 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
249 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
62 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....
5
votes
2answers
229 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
348 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
925 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?