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