Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [mysql-connection]

The tag has no usage guidance.

1
vote
1answer
71 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
54 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
49 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
78 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
183 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
23 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 /...
1
vote
0answers
410 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 (...
7
votes
2answers
6k 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
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
4k 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? ...
10
votes
1answer
25k 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
67 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
661 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
107 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
648 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
620 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?