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 ...
