Questions tagged [mysql]

MySQL is an Open Source database now owned by Oracle. The MySQL documentation is expansive and incredibly useful.

Filter by
Sorted by
Tagged with
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 ...
Seby_Plays's user avatar
-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:...
Dante's user avatar
  • 1
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://...
Preston Bennett's user avatar
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/...
nowox's user avatar
  • 2,849
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 ...
Fakhar's user avatar
  • 1
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 --...
ManuelJE's user avatar
  • 225
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 ...
squeakuel's user avatar
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 ...
Macros's user avatar
  • 493
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 (...
58k723f1's user avatar
  • 101
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 ...
user3055349's user avatar
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 ...
Vincent's user avatar
  • 111
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 ...
Ken's user avatar
  • 23
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 ...
lostsaint25's user avatar
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 ...
Moggz's user avatar
  • 21
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 ...
aFku's user avatar
  • 3
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 ...
bleistift2's user avatar
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 (...
spraff's user avatar
  • 2,118
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....
acgbox's user avatar
  • 775
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\...
C_Z_'s user avatar
  • 109
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 ...
user1139270's user avatar
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: ...
Luandre Ezra's user avatar
-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; +------------------+-----------+ ...
code-8's user avatar
  • 444
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/...
Vladimir's user avatar
  • 349
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: - ...
lily's user avatar
  • 1,835
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'
Masaba James Moses's user avatar
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 ...
Grumbunks's user avatar
  • 113
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 ...
Michael Sivolobov's user avatar
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, ...
Lyefyre's user avatar
-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 ...
Masaba James Moses's user avatar
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):...
hemlock's user avatar
  • 51
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 ...
Alexey Starinsky's user avatar
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 ...
R. Doolan's user avatar
  • 115
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 ...
Beach Chicken's user avatar
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 ...
kaladan's user avatar
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,...
Alexey Starinsky's user avatar
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 ...
sander shi's user avatar
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 ...
user2997534's user avatar
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 ...
Alex Khonko's user avatar
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 ...
I am iRSV's user avatar
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 ...
Ken's user avatar
  • 23
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='...
Ken's user avatar
  • 23
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 ...
Sanchay Arora's user avatar
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 --...
membersound's user avatar
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 ...
membersound's user avatar
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 ...
Mehdi Maazi's user avatar
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 ...
TheJavaGuy-Ivan Milosavljević's user avatar
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 ...
Deeven's user avatar
  • 109
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 ...
eleaf's user avatar
  • 21
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'.
AA12345's user avatar
  • 11
2 votes
0 answers
111 views

How to give phpmyadmin privileges to create databases?

How do I grant phpymadmin privileges to create databases?
mdtanos's user avatar
  • 21

1
3 4
5
6 7
39