Questions tagged [mysql-connection]
The mysql-connection tag has no summary.
34 questions
0
votes
0
answers
23
views
mariadb client connection settings
Computer with mariadb server was set up a long time ago and has 3 client-computers on LAN that work great.
I want to add another client.
Installed mariadb-client on latest linux mint 22.2. But,
...
- 37
0
votes
2
answers
1k
views
What is the correct "mysql-client" package to install in Debian 12?
In Debian Desktop 12 if I want to do a remote connection as client to a MySQL Server in other machine in the LAN I need use the mysql command, when it is executed happens the following:
manueljordan@...
- 2,196
1
vote
0
answers
175
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 ...
- 73
0
votes
0
answers
425
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 ...
- 1
1
vote
0
answers
58
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 ...
0
votes
2
answers
309
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 ...
-1
votes
1
answer
583
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-...
- 2,367
0
votes
0
answers
50
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 ...
- 207
0
votes
1
answer
2k
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 ...
-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.
...
- 1
1
vote
0
answers
263
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 ...
- 143
1
vote
2
answers
307
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 ...
- 25
0
votes
0
answers
3k
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 '...
user384052
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 ...
- 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, ...
- 133
1
vote
0
answers
225
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 have ...
1
vote
1
answer
684
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 ...
- 99
0
votes
1
answer
335
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. ( ...
- 1,480
0
votes
3
answers
107
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 ...
- 111
-3
votes
2
answers
217
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 ...
- 139
1
vote
0
answers
228
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 ...
- 11
0
votes
1
answer
47
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 /...
user149572
3
votes
0
answers
742
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 (...
- 131
9
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 ...
- 266
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 , ...
- 31
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?
...
- 711
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 ...
- 19k
1
vote
2
answers
154
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. ...
- 593
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 all ...
- 3
0
votes
1
answer
728
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....
- 1,603
0
votes
1
answer
136
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....
- 25.8k
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 |
+----------...
- 245
-1
votes
1
answer
680
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 ...
user78397
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?
- 40.6k