Skip to main content

Questions tagged [mysql-connection]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
0 answers
36 views

mysqld thread count exceeds max_connections

As the question title suggests: I have set max_connections = 2 in my my.cnf file, but when I activate my mysql daemon, the thread count sits at 37. I am searching online but cannot find indication my ...
user10709800's user avatar
0 votes
0 answers
150 views

How to Fix "MySQL error message was : DBI connect failed : Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) ?"

I upgraded my VPS with the provider Contabo, and since then, I have been experiencing issues. Unfortunately, they have not been responsive or provided any support. when i do command : service mysql ...
MD.Favaz's user avatar
1 vote
0 answers
33 views

"Access Denied user root error code 1045 (28000)" after changing root passwords

I'm encountering an "Access Denied user root error code 1045 (28000)" error with user root. I'm facing this problem after changing passwords. It was working fine before, and I'm confused ...
Mushtaq Ahmad's user avatar
0 votes
2 answers
181 views

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 ...
Nigel W Johnson's user avatar
-1 votes
1 answer
477 views

error in installing mysql and connecting to it in wsl2 (Ubunto 22.04)

I am trying to install MySQL on Ubuntu 22.04 (WSL2) and these are the steps that I did: 1- Installing mysql server: root@mans-pc:~# sudo apt-get update Get:1 http://security.ubuntu.com/ubuntu jammy-...
user654019's user avatar
  • 2,337
0 votes
0 answers
33 views

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 ...
manmatha.roy's user avatar
0 votes
1 answer
1k views

How do you completely exit mysqld_safe or kill it?

I opened mysqld_safe for some reason in Linux but now I can't completely exit or kill it! Closing the terminal didn't help. Then I tried with kill -9 <process id(s)> and I killed 2 processes but ...
Fahim Montasir's user avatar
-2 votes
1 answer
2k views

After installing Xampp correctly it's not open into browser in Kali Linux

Firstly I text the command on my terminal like sudo /opt/lampp/lampp start sudo /opt/lampp/lampp start [sudo] password for tayef: Starting XAMPP for Linux 7.2.34-0... XAMPP: Starting Apache...ok. ...
makt's user avatar
  • 1
1 vote
0 answers
215 views

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 ...
user2305193's user avatar
1 vote
2 answers
219 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 ...
Christophe S's user avatar
0 votes
0 answers
2k 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 '...
user avatar
0 votes
0 answers
2k 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 ...
harp1814's user avatar
  • 113
1 vote
1 answer
1k 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, ...
Taylor's user avatar
  • 123
1 vote
0 answers
211 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 ...
Joseph Michael's user avatar
1 vote
1 answer
616 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 ...
penguin's user avatar
  • 109
0 votes
1 answer
277 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. ( ...
dubis's user avatar
  • 1,460
0 votes
3 answers
98 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 ...
Doan's user avatar
  • 111
-3 votes
2 answers
175 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 ...
user3502626's user avatar
1 vote
0 answers
214 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 ...
Ninja Turtle's user avatar
0 votes
1 answer
35 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 /...
user avatar
2 votes
0 answers
699 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 (...
Fels's user avatar
  • 121
8 votes
2 answers
10k 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 ...
Michal_Szulc's user avatar
3 votes
1 answer
3k 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 , ...
user3047270's user avatar
3 votes
2 answers
8k 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? ...
Frank's user avatar
  • 681
15 votes
1 answer
44k 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 ...
MountainX's user avatar
  • 18.1k
1 vote
2 answers
125 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. ...
Nitesh B.'s user avatar
  • 573
0 votes
1 answer
2k 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 ...
Sky's user avatar
  • 3
0 votes
1 answer
720 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....
Bau Miao's user avatar
  • 1,533
0 votes
1 answer
127 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....
Pandya's user avatar
  • 24.9k
6 votes
2 answers
1k 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 | +----------...
Cody's user avatar
  • 245
-1 votes
1 answer
660 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 ...
user avatar
0 votes
1 answer
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?
Ramesh's user avatar
  • 39.6k