Stack Exchange Network

Stack Exchange network consists of 174 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
Join us in building a kind, collaborative learning community via our updated Code of Conduct.

Questions tagged [mysql]

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

0
votes
0answers
13 views

Best method to transfer/clone large MySQL databases to another server

I am running a web application within a shared hosting environment which uses a MYSQL database which is about 3GB large. For testing purposes I have setup a XAMPP environment on my local macOS ...
0
votes
1answer
14 views

MySQL installer seems to be stalled?

I downloaded MySQL installer. I chose the Developer Default Setup Type. Now it's downloading the various components of MySQL. There is an issue here: the downloading seems to be stalled. As you can ...
0
votes
0answers
6 views

Grouping by status then priority and extracting the earliest start time and latest end time if they exist in different rows

In MySQL, how can I group by status, then priority, and take the start time and latest end time if they exist in different rows? This is how my data looks right now: This is what I'd like the data ...
1
vote
1answer
25 views

MySQL install issue on Windows 10 PC

I'm installing MySQL community server edition on my Windows 10 PC. I'm using the MSI installation for Windows. The configuration doesn't start the server and ends with the following error: Waiting 3 ...
0
votes
0answers
22 views

How to recover mysql working prompt after accidentally typing an invalid slash command?

I made the mistake of trying to use postgres' \d to describe a table in mysql. But in mysql \. runs a script by name "source (\.) Execute an SQL script file. Takes a file name as an argument.". ...
0
votes
1answer
40 views

MySQL service not starting due to new SSD

Yesterday I changed out my old SSD (with OS) to a new one, and I want to use the old SSD for a MySQL database. I have successfully cloned the disk, and my OS is working. I cleared the old data from ...
0
votes
1answer
32 views

Where is mysql.sock?

I'm trying to configure "Bacula" on my Ubuntu server which was programed with a PostgreSQL preference. They allow a socket to be used for MySQL but it is missing from my install. I have tried a few ...
-1
votes
0answers
10 views

Can software licensed under the GPLv2 be included in GPLv3 software? [migrated]

I'm writing a database library in Java which is licensed under the GPLv3, and I want to include the MySQL JDBC driver in it, which is licensed under the GPLv2. Are there any restrictions stopping me ...
0
votes
1answer
33 views

MySQL is ignoring pid file setting in my.cnf on Ubuntu 18.04

Another user asked a similar question on a different site. It was recommended he ask here, but I can't find anything on here related to the question. https://stackoverflow.com/questions/48431107/pid-...
0
votes
0answers
14 views

How to see next page in phpMyAdmin?

In phpMyAdmin, is there some way to see more than the first page of results in a big table? I see the option to display up to 500 rows. But I can't see a next page button anywhere.
1
vote
0answers
10 views

Why is phpMyAdmin showing wrong table names?

I noticed that in phpMyAdmin, if I look at information_schema.tables, all the TABLE_NAME fields show the wrong name. For example, what should be bins is showing as sql.php?table=bins&db=...
0
votes
0answers
40 views

Nginx server is stopping for no apparent reason

I've set up an Nginx server for my site. Unfortunately, Nginx stops after some days (it's not a fixed period, sometimes after 5 days, sometimes after 1 month) and my site goes down. I need to restart ...
0
votes
0answers
73 views

mysql version 8.0.11 and Symfony 4 error “MySQL server has gone away”

I' m using Symfony 4 and Mysql version is 8.0.11 and using a user instead of a root login and when i try to use the command php bin/console make:migration i get this error: In AbstractMySQLDriver.php ...
2
votes
1answer
24 views

Copy MySQL data files to another instance to bypass password

Is it possible to copy the MySQL data files for a specific table/database to another instance of MySQL to bypass user/password permissions? For example on 1st instance there is a database that only ...
-1
votes
1answer
21 views

Remote MySQL service unreachable due to port 3306 being blocked locally

Here is the network setup: The computers (Windows PC, RPi,...) making the MySQL connection are located in a network that has blocked port 3306 in there firewall (among others). We do not have access ...
0
votes
2answers
92 views

Locking an IP to a computer

I have a network with 4 computers. Three are connected by cables to the WIFI Router, one connects by wifi I have a static IP from my provider The problem I have is that every time the router is ...
0
votes
1answer
36 views

Cant open phpMyAdmin [closed]

Error Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly. Also ensure that cookies are enabled in your ...
0
votes
1answer
27 views

Opening a mysql db without a server running

I am tasked with debugging a program in a language I am not familiar with that runs. Since the bug only appears on live, I have to be extremely careful. That much for background. That server I am ...
-1
votes
0answers
21 views

MariaDB server failure

I'm inexperienced in setting up and using a mariadb and cant run mariadb server on my centoes 7 VPS. What am i doing wrong ? mariadb.service - MariaDB database server Loaded: loaded (/usr/lib/...
0
votes
1answer
108 views

Why does MySQL leap from version 5.7 to 8.0?

I recently upgraded MySQL 5.7 to 8.0 via homebrew, as it warned me about not being the latest version. I was surprised to see MySQL was version 8.0 as from what I recall the latest version was 5.7. ...
0
votes
0answers
15 views

How exactly does the InnoDB engine in MySQL update its main data storage files?

It's come to my attention in the course of testing Linux's Back In Time backup utility that I can't understand how MariaDB actually saves data. After adding a bogus record to a table and leaving it ...
0
votes
0answers
310 views

Configuration error when installing MySQL (database initialization failed)

I installed wanted MySQL programs while installing MySQL 8.0.1 Enterprise Edition. When I try to apply my configuration settings I keep getting an error that the database initialization has failed. (...
0
votes
0answers
98 views

database server on SSD consumer

The case: MySql 4.1 32 bit on SSD and W10 64 bit. The case: MySql 4.1 32 bit on SSD and W10 64 bit. In some cases the writing on disk fails, we talk about normal update of a few bytes, many times even ...
0
votes
1answer
61 views

MySQL for excel has failing requirements while installation

During custom installation of MySQL, the installer tells me that : MYSQl for excel has failing requirements. Microsoft Excel 2007 or higher is not installed. I already have office products installed ...
0
votes
0answers
44 views

How to wait until services are ready

I have been setting up a Jenkins pipeline using docker images. Now I need to run various services like MySQL, Redis, Memcache, Beanstalkd and Elasticsearch. To wait the job until MySQL is ready, I am ...
2
votes
1answer
919 views

brew install mysql@5.7 can't connect to local MySQL server through socket

I needed MySQL 5.7 installed on Mac OS High Sierra so I ran brew install mysql@5.7. When I do brew services list I see mysql@5.7 started admin /Users/admin/Library/LaunchAgents/homebrew.mxcl.mysql@5....
4
votes
3answers
2k views

Cannot start mysql: InnoDB: Upgrade after a crash is not supported

I am trying to run MySQL from a Homebrew installation, but it keeps failing when trying mysql.server start. My /usr/local/var/mysql/<name>.local.err reads as so, and keeps sending this error ...
0
votes
0answers
104 views

How to install two versions of MySQL on MacOS (High Sierra)?

I need two separate development environments in MacOS 10.13 to accommodate clients running different versions of MySQL on their servers (5.5 and 5.7.22). I've installed MySQL 5.7.22 from a package, ...
0
votes
0answers
36 views

qmail and mysql-How to restore bounces from a specific day

I have a qmail server with a mysql database. Recently, AOL has been rejecting mail on an IP says 'AOL will not accept delivery of this message' The emails bounce, and my system unsubs them. The data ...
0
votes
0answers
232 views

Can't connect MySql to 127.0.0.1, only to localhost

I have a portable version of a MySQL database that I'm trying to connect to. On a computer running on Windows 10, I can connect to it using 127.0.0.1 at port 3310. If I copy that instance to any ...
0
votes
0answers
36 views

SQL queries backing up massively 'Waiting for table level lock' at random time every day

We've started having some strange issues with our website database. On Saturday our website started to respond incredibly slowly at around 9.20am. The issue was eventually fixed when we duplicated ...
1
vote
3answers
119 views

how do I stop mysql running on my server? Standard solutions not working

I have done a remote log-in into my Ubuntu 14.04 server as a root user. When I try: sudo stop mysql I get: stop: unknown instance: When I try: sudo service mysql stop I get: stop: unknown ...
3
votes
1answer
210 views

How to restore mysql database using files on data folder?

I cannot run my mysql since yesterday, and I cannot access it, so I decided to reinstall it. I've backed up the data folder, which I presume contains all I need to restore the database after I ...
0
votes
0answers
129 views

Edit mysql my.ini in cmd windows 10

I would like to open the ini file in cmd to edit it... with the TYPE command it is possible to display the contents of a text file but, is it possible to modify it? (For example, open the file so that ...
0
votes
0answers
58 views

Digital ocean LAMP stack one click install gives me Connection failed: Access denied for user 'root'@'localhost'

I installed LAMP stack using one click installs, upload my project files to www/html directory and when trying to access the website, I get "Connection failed: Access denied for user 'root'@'...
-1
votes
1answer
22 views

Place a String separated by commas into the Excel rows

I have a String like this separated by the commas: id, payment_request_id, user_id, market_id, exchange_id, type_id, nominal, ask_price, original_rate, min_execution, from_date, to_date, state, ...
0
votes
0answers
36 views

How do I get Atom.io to properly color SQL when inside a PHP string?

Am I missing some package to correct this? At times, it works correctly ... Sometimes it does not work correctly ..
0
votes
0answers
26 views

Knowage: issues when passing midnight

I've a knowage (6.1.1) installation on an ubuntu machine (18.4.1). It runs on mysql 5.7. Every morning, as I try to log-in the browser gives out this error: An error has occurred. Retry later. ...
1
vote
1answer
14 views

Mysql 5.7 installation, Repository not getting listed

I am tring to get MYSQL5.7 installed on Linux Server release 6.7 (Santiago). Per instructions I firstly add the repository. This works fine but when I do yum repolist all it doesn't show mysql there. ...
0
votes
1answer
153 views

Remove MySQL for Visual Studio 2.0.5 without VS installation

Today I tried to clean up my PC and this includes uninstalling unnecessary stuff. One of the programs is MySQL for Visual Studio 2.0.5. I already uninstalled my Visual Studio installation which was ...
1
vote
1answer
115 views

MariaDB on Linux Mint: trouble setting root password

I don't know whether this is the right Stack Exchange Q+A for this... I just installed MariaDB in Linux Mint Cinnamon (18.1). mysql --version gives: mysql Ver 15.1 Distrib 10.0.34-MariaDB, for ...
0
votes
1answer
1k views

mysqld: Can not perform keyring migration

Trying to install a mysql8.0 on (not yet supported) debian 10 (aka "Buster") system that formerly held mysql5.5. Installation ends with: mysqld: Can not perform keyring migration : Invalid --keyring-...
2
votes
1answer
22 views

MySQL - Troubles connecting from anything other than localhost

Background So I have a web server on a raspberry pi which works perfectly fine. The web server uses MySQL in the background and web pages can do queries without an issue. Recently I want to make ...
0
votes
0answers
312 views

MySQL update and install fails if Visual C++ 2017 is installed

I wanted to update MySQL 5.7 and all installed connectors/tools on my home PC and I wanted to install MySQL 8 on my work PC but both failed because MySQL requires VC++ 2015 to be installed but if you ...
0
votes
0answers
20 views

How can I insert multiple split string in single insert query

create the following table Declare @APS nvarchar(1000)='1,1,1.5,1.791' ,@cluster nvarchar(1000)='0150,0150,001,0382' ,@style nvarchar(1000)='696707-018,696707-018,696707-018,696707-018' CREATE TABLE ...
0
votes
1answer
56 views

How to size resources (CPUs, RAM, etc) for AWS MySQL database?

In a production environment, 20K scans (records) will uploaded to the AWS database in a day: assume no more than 10K in an hour. A record consists of 6 fields and approximately 50 bytes of data. 1)...
0
votes
0answers
19 views

syncing data between serval columns from two tables in myphpadmin

I'm a web designer and I really stuck on this issue. I trying to sync data between several columns from two tables within the same mysql database. Scenario: I would like to have client register using ...
0
votes
0answers
1k views

Why do I need to use “localhost” to connect to Docker MySQL DB on Windows?

I'm currently in the process of learning Docker (using it on Windows and Linux) and there is one thing I cannot understand and I think it is better explained with a example. I run a MySQL container ...
1
vote
1answer
69 views

.csv file from Excel vs .csv file from Libre Office

I created a simple .csv file with Excel which looks like this: I also created the same .csv file by using Libre Office. Both .csv files are looking absolutely the same at TextEdit: id, questions 1,...
0
votes
0answers
156 views

Error when importing .xslx/.csv file to MySQL database

I have a simple .xlsx file which I filled in manually and which looks like this: When I open this file in TextEdit nothing shows up and (therefore) this file cannot be imported to the MySQLServer at ...