Questions tagged [mysql]
MySQL is an Open Source database now owned by Oracle. The MySQL documentation is expansive and incredibly useful.
0
votes
0answers
20 views
How to correctly configure MySQL service in Windows 7 [on hold]
I have installed MySQL server as a test bench on my machine, but the service is being a pain.
The only way I could get it to run is to use my own login credentials. The problem is that when ...
0
votes
0answers
12 views
incron not executing the mysql command
I have configured FTP on my Server and I want a functionality where when a csv file is uploaded in a particular folder then that csv should be imported into mysql tables.
For that I have installed ...
0
votes
1answer
27 views
Ubunut 18.04 failed to boot. [FAILED] Failed to start MySQL Community Server
I am facing serious issue. My hard disk was extremely full that 0 bytes available. I tried to empty the trash bin but it hanged. I restarted the system. But it failed. It gives this messages:
[FAILED]...
0
votes
0answers
15 views
In what case I need to set up a MySQL partitioning on Zabbix db?
CentOS Linux release 7.5.1804 (Core)
Linux localhost.localdomain 4.19.0-1.el7.elrepo.x86_64
PHP 5.4.16 (cli)
PHP 5.4.16 (fpm-fcgi)
nginx/1.14.1
10.3.11-MariaDB
Zabbix 4.0.2
Hi. I use latest Zabbix ...
0
votes
0answers
22 views
MySQL Server 8.0. my.ini file editing. To prevent MySQL Server from connecting to Internet
I want to install MySQL Server 8.0 on my desktop computer. The operating system is Windows 10 Home. I want to prevent MySQL Server from connecting to the Internet. I assume that MySQL Server is ...
0
votes
0answers
18 views
WHERE in INSERT MySQl & PHP [migrated]
In MySql is possible to make UPDATE using WHERE in for multiple users like:
$users = ['user1', 'user2', 'user3'];
$amount = 25;
$users = implode(", ",array_keys($users));
"UPDATE balances SET ...
0
votes
0answers
54 views
Where did MySQL Server go on Mac Mojave OS
I have a new Macbook Pro, with macOS Mojave (iOS 10.14.1).
I downloaded the MySQL Community Server for the Mac, latest version (0.0.13). I opened up the installation package, clicked on it to install....
0
votes
0answers
15 views
XAMPP | Mac OS - Access phpmyadmin & Apache from local server
I'm unable to access to the XAMPP server from any other device in my local network except the host.
I have XAMPP started and my phpmyadmin is configured like this in the httpd-xampp.conf:
<...
1
vote
2answers
95 views
What's my MySQL root password
I just installed mysql-server with the following command
$ sudo apt install mysql-server mysql-client mysql-common
Then when I call the command mysql_secure_installation MySQL asks to enter the root ...
0
votes
0answers
41 views
Accidentally executed 'sudo chown -R www-data:www-data /' Ubuntu
Was trying to change the ownership of a folder but executed this command
root@xyz.com:~# chown -R www-data:www-data /
The entire directory structure under '/' got changed.
Upon ...
0
votes
1answer
16 views
How can I disable Win10 ISS so I can Install XAMPP?
I'm an EE and not very familiar with the workings of websites and in particular with the Windows IIS server. Up until Windows 10 arrived I've never had any trouble installing development tools using ...
0
votes
1answer
24 views
E-Mail Server Ubuntu SQL Error
I've been trying to set up a server but it doesn't work. I got this error:
23:59:43 mail dovecot: auth-worker(14604): Error: sql(test@mydomain.eu, ip): Password query failed; You have an error in ...
0
votes
3answers
78 views
database copy shell script including password with special characters
I am trying to create a shell script for a mysqldump (and mysql) operation where the password is stored directly in the script. The password contains special characters which need to be handled ...
0
votes
2answers
68 views
Mysql error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)'
I had a space issue in my server, so I added more space and now MySQL won't start.
trying to start mysql:
root@vps:~# /etc/init.d/mysql start
[....] Starting mysql (via systemctl): mysql.service
Job ...
0
votes
0answers
29 views
Excel data validation
I need to validate data in Excel before loading into a MySQL table. (The validating data also available in MySQL tables.)
For example, a value for country is “India”. Before it inserting into MySQL ...
0
votes
0answers
25 views
Asterisk sip.conf in MySQL database
I'm able to include a phone inside a database for realtime usage. So, this code (from /etc/asterisk/sip.conf):
[phone]
type=friend
username=phone
secret=12345
host=dynamic
disallow=all
allow=g729
...
0
votes
0answers
21 views
Cannot contact DB using MAMP
Im working on a custom web application. I have a local development environment using MAMP. Im trying to contact my DB and it fails every time so i tried running a custom DB test script which also ...
0
votes
0answers
18 views
(can't connect to mysql server on ''localhost:3306' (-5 no address assoicated with hostname)
I am using pie 3 b+ and installed mysql. I have no problem getting sql from the command line and creating databases and getting data back from it.
I am new to python, mysql and lunix in general. I ...
0
votes
3answers
212 views
Can't install mysql server on Windows 10
I'm trying to install a mysql server on my win 10 machine. I've downloaded the installer from here, but when I open it, it finds an installed version of mysql server on my computer (which I thought I ...
0
votes
0answers
64 views
Fastest way to search inside a text file?
I'd love to get some advice from people here. I'm trying to make a locally searchable simple/flat database that will just consist of long URLs from my site, and URLs I've shortened with bit.ly. The ...
0
votes
2answers
32 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 ...
0
votes
0answers
241 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
70 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
8 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
42 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
48 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
81 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
154 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
45 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
30 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
19 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
13 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
199 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
208 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
34 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
177 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
106 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
227 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
38 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
15 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
230 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
24 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
43 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
161 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
157 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
16 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
17 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
92 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
505 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 ...
