Questions tagged [mysql]
MySQL is an Open Source database now owned by Oracle. The MySQL documentation is expansive and incredibly useful.
1,938
questions
0
votes
0
answers
3k
views
MySQL / phpMyAdmin can't login? mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES)
I've recently reinstalled my KVM server because I couldn't install MySQL-server correctly.
Now I've chosen to install MySQL-server by factory-installation.
And the following problem occurred, I have ...
-1
votes
1
answer
508
views
Problems With XAMPP (1 of 2 services running)
When I try to start Apache, it gives me this error:
11:30:58 PM [Apache] Error: Apache shutdown unexpectedly.
11:30:58 PM [Apache] This may be due to a blocked port, missing dependencies,
11:...
0
votes
1
answer
1k
views
Cyberpanel how do I change the import size for phpmyadmin?
The default database import size is only 2mb, so thats gotta go. I followed this guide from Cyberpanel to the T but myphpadmin still reflects the default size so I still cant import.
https://...
7
votes
3
answers
27k
views
Connect to MySQL from WSL2?
I have installed MySQL server on Windows and I would like to connect to it from WSL2. Unfortunately it seems that WSL cannot reach the MySQL server:
$ /mnt/c/Program\ Files/MySQL/MySQL\ Server\ 5.7/...
0
votes
1
answer
87
views
How to install torrent client on linux in shared servers
I am using "namecheap.com" stellar hosting with Linux OS, installed on shared servers.
It has also Apache, MySQL and PHP preinstalled. I am trying to install uTorrent using terminal with the help of a ...
0
votes
1
answer
264
views
mysqlimport gives error when run as cron job but not interactively (Ubuntu 14.02)
I have a bash script which downloads and then imports a CSV file into a local MySQL. The database is MySQL 5.6 on Ubuntu 14.04, I'm loading data with the following statement (bash):
mysqlimport --...
0
votes
1
answer
391
views
Is there a way to run MySQL queries from Windows Powershell or Command Prompt?
I currently use Microsoft SQL Server Management Studio to run queries on my databases, but it's a bit clunky and I prefer to do everything through a CLI if possible. Is there a way to do this on ...
0
votes
0
answers
1k
views
HDD SAS vs SSD SATA vs NVME for MySQL database server
I am configuring a high end server to run Linux with MariaDB / MySQL. Performance is critical and as such I'll be maxing out RAM as far as possible. Given this, my benchmarking suggests that the ...
0
votes
1
answer
181
views
mysql 8.0 replication io_thread cannot keep up
We have created a new MySQL 8.0 cluster.
Our servers are running ubuntu 18.04.
We are running percona-server-server 8.0.18-9-1.bionic amd64.
However, we have issues that the slave cannot keep up (...
0
votes
1
answer
4k
views
Installed MySQL, but it is not showing in the installer (Windows10)
I tried installing MySQL from the official installer (https://dev.mysql.com/downloads/file/?id=492815).
I ran the installer, but I think the installer stopped someplace midway. Now, I am not able to ...
1
vote
0
answers
963
views
Root MySQL Access denied even after resetting root password
I know there are a ton of threads on similar issues where people can't connect using root and need to reset their password to regain access, but in my case resetting the password is not a problem. I ...
0
votes
1
answer
2k
views
What can I do to prevent MySQL using up all RAM and SWAP in Debian 10?
I am using MySQL 8.0.18 in a group replication (multi-master) infrastructure. There are currently 4 master servers connected to each other and everything seems to be working fine but over the course ...
0
votes
1
answer
46
views
Wordpress error connecting to database but it's correct
I've been struggling to find the problem but I just seem to be going around in circles and most of the tutorials just tell me to check the mysql credentials but I'm sure that they're right.
I have an ...
1
vote
1
answer
466
views
Excel and Google Sheets calculate different .csv column totals to MySQL and LibreOffice
I have a .csv file with 9273 rows.
I have one column of whole numbers and one column of decimal numbers with values like 0.0001752.
I totalled these columns using Excel's sum function and got totals ...
0
votes
1
answer
1k
views
How should I set up volumes for multi-task database service in docker swarm?
I am new to Docker and I want to do mini-project with Docker Swarm. I built docker image with my Django app. In dockerfile I added project files, migrated all models, and then ran server. Now it is ...
1
vote
0
answers
668
views
What Permissions Does MySQL Need for its Log Files?
I’m trying to enable MySQL’s general log (at runtime, in case that matters) and set a path for the log file. These are the queries I issue after a connection to the server has been established:
SET ...
0
votes
1
answer
2k
views
MySQL apparently running but not listening on TCP, jdbc can't connect
I am running MySQL on Ubuntu. mysql cli, as does http://localhost/phpmyadmin, but I cannot connect using java.sql.DriverManager.getConnection:
java.net.SocketException: Network is unreachable (...
0
votes
1
answer
555
views
Trouble with the silent installation command wamp 3.2.x and mysql v5.7.x
I used to silently install wamp with the following command:
start /w wampserver3.1.9_x64.exe /VERYSILENT /SUPPRESSMSGBOXES /NORESTART /NOCANCEL /DIR="%HOMEDRIVE%\wamp64" /LANG="en"
Now with wamp v3....
0
votes
1
answer
3k
views
'The installer has insufficient privileges to access this directory' Windows 10
I am trying to install the MySQL connector for python but I get the error
The installer has insufficient privileges to access this directory
C:\Program Files\WindowsApps\...
0
votes
0
answers
5k
views
MySQL Server flashes on and off on mac. How to fix?
I just downloaded the macOS 10.15 (x86, 64-bit), DMG Archive version of MySQL following https://youtu.be/TpOMn5_YIyw?t=305.
But the server just flashes green for a second and then back to red when I ...
0
votes
0
answers
5k
views
Mysql server 8.0 initializing database failed
I'm trying to install MySQL 8.0.19 on my windows 10. I have an issue when trying to initializing database. It is failed with a message "may take a long time". Below is the log of configuration:
...
-1
votes
1
answer
536
views
How do I safely remotely connect to my database via SSH?
I have these users in MySQL database
mysql> select User,Host from mysql.user;
+------------------+-----------+ ...
1
vote
1
answer
255
views
Ubuntu 18.04 debconf shows prompt
I am trying to install MySQL 8.0 on Ubuntu 18.04 automatically using bash script.
I was setup all variables which debconf prompt asking, but prompt is appear anyway.
What's wrong in my script?
#!/bin/...
1
vote
1
answer
560
views
Can user privilege of docker container impact permission of host machine on mounted volume in docker-compose.yml?
I have docker-compose.yml as below,
version: '2'
services:
mysql:
image: centos/mysql-56-centos7:latest
restart: always
container_name: mysql
environment:
- ...
0
votes
0
answers
249
views
How to connect Crystal Reports 9 to MySQL database in Windows 10
I'm trying to connect MySQL database to Crystal Reports 9 in Windows 10, but I get this error.
Query Engine Error: 'Cannot find DSN in connection string'
0
votes
1
answer
170
views
PhpMyAdmin: Results go by too fast and queries execute multiple times
PhpMyAdmin version: 3.4.9
Problems: two:
When I execute a query, the results are shown on a new page for a split second and then I am returned to my query, so I can't actually see the results of my ...
0
votes
0
answers
2k
views
Error "Invalid utf8 character string" while upgrading MySQL
I have some InnoDB databases on my local MacBook Pro. And after upgrading MySQL through brew upgrade MySQL daemon can't start now.
I already fixed problems with new case insensitive mode by renaming ...
0
votes
0
answers
99
views
I broke logging in MariaDB; How to repair?
I messed up. In order to save disk space, I removed mysql-000xx.bin files with Ubuntu's rm command - rather than using the mysql purge command, as I later found out.
But the damage is done now, ...
-2
votes
1
answer
54
views
Avoid Displaying Success or Failure message twice while inserting Array items in database using php [closed]
I insert values that have been checked in a PHP table, but what happens is when I select more than one item, I receive more than one success or failure message.
This is my code for inserting in the ...
0
votes
1
answer
748
views
Use unix_socket in mysql with host other than localhost
In order to replicate some script behavior on a test box I need to auth mysql with root via unix socket.
It works fine with sudo mysql, but when I do sudo mysql -h testhost I get:
ERROR 1698 (28000):...
1
vote
1
answer
3k
views
A NOT-NULL column of type TIMESTAMP without a default value in MySQL
If I create a table
CREATE TABLE t1 (
id BIGINT UNSIGNED NOT NULL,
createDate TIMESTAMP(3) NOT NULL,
updateDate TIMESTAMP(3) NULL DEFAULT NULL,
closeDate TIMESTAMP(3) NULL DEFAULT ...
1
vote
1
answer
101
views
How to monitor/log sql time from kubernetes
I have some containers running in kubernetes in the cloud, these are querying on prem db servers, I'm interested in seeing how the latencies from the dbs are affecting the app. How would I go about ...
3
votes
1
answer
14k
views
Install mysql-server 5.7 instead of mysql-server 8.0 on an ubuntu 19.10 machine
I have some trouble installing mysql-server 5.7 on ubuntu 19.10 (eoan) machine. Unfortunately I'm bound to mysql-server version 5.6/5.7 so just installing mysql-server 8.0 is no option.
According to ...
0
votes
1
answer
72
views
MySQL Cluster binlog replication order
We are facing an issue with our MySQL replication stack: We actually have a MySQL ndb cluster (7.6.11) acting as a master and an innoDB(5.7) as a slave. Everything seemed to be working right until we ...
0
votes
0
answers
282
views
'Out of memory: Killed process 1190 (mysqld)' on Ubuntu 16.04
I periodically get the following messages on my Ubuntu 16.04 server with 1GB RAM:
[4768052.693699] Out of memory: Killed process 1190 (mysqld) total-vm:2037464kBB
The command
ps -eo pmem,pcpu,rss,...
0
votes
1
answer
23
views
I wanted to set up my own webserver. Error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
I wanted to set up my own web server, but As I follow directions from this website https://www.linux.com/tutorials/easy-lamp-server-installation/ I couldn't download MySQL and have tried many ...
1
vote
0
answers
460
views
Access denied for user in DMS instance
I am trying to set up a data replication task with AWS DMS (MySQL to MySQL).
The endpoint configurations have been successfully tested but the task is not terminated because it gives the following ...
1
vote
0
answers
77
views
Slow MySQL queries, how to optimize?
I worked on some project with more than 30M columns. Some requests take too much time on my local machine (SSD, i5-8300, 16GB memory) and I think it is because I set up my PHP/MySQL incorrectly.
My ...
1
vote
1
answer
297
views
EasyPHP (DevServer 14.1 VC11) unexpected end of mysql
I installed EasyPHP because i need it for school, however when I start it i get an error called "unexpected end of mysql" and i can't start MySQL.
I tried to change some option in the file my.ini but ...
2
votes
1
answer
485
views
Deciding which version of MySQL (5.7 or 8) I should use for Group Replication?
I'm looking for a production ready mysql with group replication, and wondering if there was a difference between v5.7 and v8.0 Group Replication implementation?
Keeping Group Replication and system ...
0
votes
0
answers
116
views
From which mysql variable does mysql know the IP of the master node in a group replication environment?
When I "start group_replication" command how does mysql know which IP to use to connect to the master node?
I ask because when running
CHANGE MASTER TO MASTER_USER='repl',
MASTER_PASSWORD='...
1
vote
0
answers
387
views
sql-server in Kali Linux for Python
When I am trying to install MySQL-server in my Kali, I am again getting an error.
Then, I tried to install something else like apt-get install MariaDB-server. It was installed, but afterward when I ...
0
votes
0
answers
276
views
How to change chown from mysql console? [duplicate]
I have a file /tmp/test.csv created by the mysql process (SELECT * INTO OUTFILE), thus having mysql:mysql ownership.
Problem: I'd like to rewrite the chmod from within the mysql console:
mysql --...
0
votes
3
answers
1k
views
How to delete a file owned by different user using a bash script?
I have a bash script that should remove a file from /tmp. Problem: the file is created my user mysql during SELECT INTO OUTFILE export. Thus the script-running user does not own the file.
Still, how ...
0
votes
0
answers
4k
views
How to notify a client about change in MySQL database without making a request
I have a client (an esp8266 module) that constantly (every 2 seconds) connects to a server, executing a query from a php script and gets any possible changes in MySQL database.
I implemented a http ...
1
vote
0
answers
369
views
How to change MySQL Workbench editor highlighted text background color?
Is there a way to change background color of highlighted text in query editor of MySQL Workbench? It seems it's somehow set to very unreadable default, as shown in the picture:
In comparison, this is ...
0
votes
0
answers
207
views
How to debug node js applications
I have a nodeJS app It queries the Database(mysql) and makes certain API calls. On a load test two things happen:
It just stops responding for some users
The variables for some users are overwritten ...
2
votes
1
answer
4k
views
Phpmyadmin error 500 - can't load anything
I was trying to do a right join of two tables, but it seems like it was too much information or the syntax was wrong and then the page froze so I closed out of it. But when I tried to reload ...
1
vote
0
answers
252
views
Setting NULL as default results in 1067 error Invalid default value for 'created'
Trying to set the default value of a column to NULL results in 1067 error: Invalid default value for 'created'.
2
votes
0
answers
111
views
How to give phpmyadmin privileges to create databases?
How do I grant phpymadmin privileges to create databases?