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

Questions tagged [mysql]

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

0
votes
1answer
9 views

What is the correct format of a postfix sasl password database map file?

It is possible to request postfix to fetch sasl login information for its relay server from a database. I then have this relay server fetch the very same login information. How do we format this ...
-2
votes
0answers
8 views

Rebuildall.php attempt gave message in PuTTY: It is impossible to determine the wiki ID [duplicate]

Sorry for posting the same thing twice. I just wanted someone to answer my question right away. Anyways, I have been working in PuTTY to fix the problems I have with my second wiki (as a part of a ...
0
votes
0answers
56 views

Rebuildall.php failed gracefully in PuTTY [closed]

I have been working in PuTTY to fix the problems I have with my second wiki (as a part of a larger wiki family) and fixing the separate database. However, there is one problem. When I tried to run ...
0
votes
0answers
15 views

LDAP or Postgres, MySQL to store user identities [closed]

I am confused between using LDAP and Postgres or MySQL as Identity Store for the IdM and Access Management system. I have following requirements The DB should be scalable to store apprx. 100 million ...
0
votes
0answers
25 views

Is there any way to install MySQL in Windows through a third party application such as Inno Setup?

I need MySQL to be installed with my PHP-Desktop application in Windows machines. I don't like to import my database into SQLite,instead I want it to be MySQL. I have used Inno Setup for compilation. ...
0
votes
0answers
52 views

can not uninstall MySQL Connector Net 8.0.12 in anyway

I installed MySQL (on windows 10) but in some reasons i wanted to uninstall it. So first of all i deleted all its files (for example in appdata or programdata) then i uninstall all mysql* from ...
0
votes
0answers
23 views

How to fix blurry MySQL Workbench 6.3 on Windows 10.1709?

I'm running MySQL Workbench 6.3 on Windows 10.1709. The application looks blurry, as if the pixels had been run through a Photoshop Soft-Focus Filter. I cannot upgrade to MySQL Workbench 8.0 because ...
0
votes
1answer
6 views

MySQL Workbench necessary to have server running to create a database?

I installed mySQL workbench and the SQL server. I have successfully got the server running and am wondering if it is necessary to run it while I am creating a database, or if I can work in Workbench ...
0
votes
0answers
35 views

remote mysql backup script on Linux server froze entire network

I have a Linux script that ssh into a remote offsite machine, takes a mysqldump and writes the dump file back to the local directory on the Linux server. The backup is over 500MB. The local Linux ...
0
votes
0answers
28 views

Rsync on Windows issue

I want to get SQL database file from a remote machine using rsync. I've already installed DeltaCopy on my Win7 PC, but all I have is the one URL: rsync://export@10.123.101.225/folder/dmp_db.sql.gz ...
0
votes
2answers
30 views

loop(repeat) script block until successful db(mysql) password

I have the following function function executeMySql() { while IFS= read -p "$prompt" -r -s -n 1 char do if [[ $char == $'\0' ]]; then break fi if [[ $char == $'\177' ]...
0
votes
1answer
78 views

Why so many line feeds in a mysql file?

cat -A dfs.MYI M-~M-~^G^A^@^@^AT^@M-0^@d^@M-D^@^A^@^@^A^@^X^A^@^@^@^@^@M-^?^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@M-^?M-^?M-^?M-^?M-^?M-^?M-^?M-^?^@^@^@^@^@^@^D^@^@^@^@^@^@^@^@^@^@^@^@^@^@...
1
vote
0answers
31 views

SSH port forwarding on MacOS X

I know there are quite a few tutorials about this, but I can not get it to work on my machine. So I have a MySQL database running on: Server: dbhost.net Name: mydbuser PW: mydbuserpwd Port: 3306 ...
0
votes
1answer
34 views

Run a mySQL Query With a Parameter from Excel - Multiple Rows

I was able to adapt this link for my project, but I am looking for a way to duplicate for multiple rows. Here is my query: SELECT data_0.InvoiceNumber, data_0.CustomerNumber, data_0....
1
vote
1answer
28 views

“find” command has been looking for mysqli.so for 9.729 hours

I have been searching on this site and many others, but I have a process which has been running for 9,729 hours at 100% CPU at all times. According to htop, this is the command is being run by "root" ...
1
vote
0answers
13 views

MySQL Insert Trigger: Checking for duplicate entries before executing

I've got a trigger running "copying" entries from my Home Assistant (home automation software) database to another table in another DB. Home Assistant stores entries in a table called "states". If ...
1
vote
1answer
10 views

AppArmor mod_php + MySQL

Is there any way to get AppArmor to work with Apache2 + mod_php + MySQL? I've already tried sudo aa-complain apache2 and sudo aa-logprof, but still I get a database connection error.
1
vote
2answers
55 views

MySQL error in loading CSV file data into table

I am trying to load the contents of a CSV file into a table using the following MySQL commands on Windows: LOAD DATA LOCAL INFILE 'C:/Users/TD_DI_026.csv' INTO TABLE digitalTags FIELDS TERMINATED BY '...
0
votes
1answer
74 views

How to connect to MySQL running on XAMPP through WSL terminal

MySQL is running on XAMPP and working fine. I am trying to connect to it through the Windows Subsystem for Linux running a Flask app using flask-msqldb. But when I run the Flask app and try to make a ...
0
votes
0answers
30 views

Unable to access mysql over LAN when there is no internet

I have a MySQL server running locally inside my building, lets say it is on machine 192.168.0.116. Normally, everything works fine. But, my town, and by extension my building, loses internet from time ...
0
votes
1answer
83 views

MySQL “Error loading password's vault file”

Something has gone very wrong and I'm getting nowhere on fixing this. My machine booted, threw this error. Showing the details comes up with "Key not valid for use in specified state". The only ...
0
votes
1answer
93 views

Cannot Install MySQL on Ubuntu 17.10

Trying to install MySQL on Ubuntu 17.10 after removing a previous installation of MariaDB. In order to purge everything I ran the following: sudo apt-get remove --purge *mysql* sudo rm -rf /etc/...
2
votes
2answers
137 views

How does one forward a TCP connection (specifically MyQSL client-->server) through a multiple hop SSH tunnel?

I want to open a connection to a remote MySQL database. This database is in a private subnet on a different network, so I cannot directly open a connection to it. Remote SSH access is also ...
0
votes
1answer
31 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
28 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
1answer
14 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
96 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
23 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
42 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
66 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 ...
0
votes
1answer
104 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
15 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
12 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
63 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
1answer
320 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
26 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
36 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
108 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
101 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
30 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 ...
0
votes
1answer
230 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
1answer
45 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
668 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
99 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
62 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
47 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 ...
4
votes
1answer
2k 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....
7
votes
3answers
3k 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
258 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
37 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 ...