Questions tagged [mysql]
MySQL is an Open Source database now owned by Oracle. The MySQL documentation is expansive and incredibly useful.
1,943
questions
-2
votes
0answers
12 views
When i use function to call form then its give me warning [closed]
When i use to try insert data without function then its working fine
<?php
include('connect.php');
{
if(isset($_POST['send'])){
$name=$_POST['userid'];
$email=$_POST['email'];
...
0
votes
0answers
20 views
MySQL Installer not launching
I installed MySQL Installer 8.0.20.0. After installing it I run the installer but nothing appears. I launched it as administrator and an error dialog box appears saying
Windows cannot find 'C:\...
0
votes
0answers
6 views
OWASP Bricks Installation: Error!Access denied for user 'root'@'localhost'
I've just downloaded OWASP bricks
https://sourceforge.net/projects/owaspbricks/
Then copied it's directory to Metasploitable /var/www
I was able to access the main page
http://10.10.10.10/bricks/
...
1
vote
1answer
30 views
Mysql memory usage and processes
I found out that mysql (on Centos7) is taking up more and more memory, and from htop I see a single process with many threads, and my memory being ~550M/3G:
18895 mysql 20 0 1157M 173M ...
0
votes
1answer
70 views
can only connect to mysql database with root never with other user
I am running LAMP on ubuntu 19 server running on Virtual Box.
I create additional users with these commands.
mysql>
CREATE USER 'kat'@'localhost' IDENTIFIED BY 'katpw';
GRANT ALL ...
1
vote
1answer
18 views
How do you track down high PHP-FPM usage on a dedicated WHM server?
This is on a unmanaged dedicated webserver used to run
Opencart 2.3.0.2
PHP 7.1
Server specs:
Xenon 2.13Ghz 8 Core 32GB RAM
CentOS 7.8
WHM v86.0.18
The traffic looks like I am being ...
0
votes
0answers
32 views
When trying to install MySQL client, I got this error
ERROR: Command errored out with exit status 1:
command: 'c:\users\xbox\appdata\local\programs\python\python38-32\python.exe' -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'C:\\Users\\...
0
votes
1answer
38 views
MySQL was killed by watchdog/snapd ubuntu ec2, watchdog is not installed but listing in ps
On one of my servers mysql was killed because of too much memory usage. Before it crashed the memory usage was around 95%. My confusion is what killed the process because I have seen in past whenever ...
0
votes
0answers
25 views
What is the best way to store and use big JSON data?
I have downloaded a bibliographic corpus that consists of 10,000 zipped JSON files with the total size of ~200GB (zipped, ~800GB unzip)
I have no experience in dealing with this amount of data, and I ...
0
votes
1answer
26 views
Apparmor DENIED ACCESS to soft links
I am using Ubuntu 20.04 (Focal Fossa) but this issues has been happening since I am using an old Ubuntu (19.04 & 19.10). So I have 2 hard disk drives - one is an SSD (small size), the other a SATA ...
0
votes
0answers
30 views
MySQL server crashes after installing wordpress
I have an Ubuntu 20.04 Server
I made a fresh install of Ubuntu 20.04
Installed webmin
Installed Apache/2.4.41
installed and enabled php 7.4
Installed /usr/sbin/mysqld Ver 8.0.19-0ubuntu5 for Linux ...
0
votes
0answers
8 views
phpmyadmin error 1045 installation with maria db
I am stuck with the following error when trying to install phpmyadmin on my ubuntu 16.04
this is weird because when i do mysql -u root -p
i can login just fine.. any idea on what to do ?
0
votes
0answers
9 views
mysql 5.7 unknown variable 'keyring_operations=ON'
Ubuntu 16.04, mysql 5.7. I'm trying to start mysql but it always fails because:
[ERROR] unknown variable 'keyring_operations=ON'
I have no idea how to turn it off as keyring_operations=OFF doesn't ...
0
votes
1answer
66 views
mysqldump makes 0bytes files
I have a mysqldump line in crontab but it doesn't work, it just makes 0 bytes files:
0 0 * * * mysqldump -u 'USERNAME' -p'PASSWORD' database| gzip -c > /mysqldumb/backupfile.`date +\%a`.sql.gz &...
0
votes
1answer
122 views
LAMP on Raspberry Pi to host a web server
First question ever on the site.
Forgive me in advance for my very limited knowledge on the subject, I am fairly new on hosting web servers, databases, and just Raspberry Pis in general. I want to ...
0
votes
0answers
25 views
Can’t remember password for MySQL on macOS
Please help me in step by step setting up MySQL with the help of terminal, I guess I don’t remember the password or I messed up with things. I get the following message and I don’t remember the ...
0
votes
0answers
19 views
How to sync the date time of mysql to its host machine/docker linux system?
I made a mysql images and start it as a docker container, then I log inside the container, and use faketime to change the date, it works coz command date show as expected. Then I log into mysql in the ...
1
vote
0answers
18 views
Can't connect to MySQL server. Keeps changing the host IP to a local IP
I've encountered an odd problem and I'm unsure what is causing it as it has been completely fine prior to today.
I'm trying to connect to a MySQL Server but it is changing the IP address to another ...
0
votes
0answers
112 views
MySQL / phpMyAdmin can't login? mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES)
I've recently reinstalled my KVM server because I couldn't install MySQL-server correctly.
Now I've chosen to install MySQL-server by factory-installation.
And the following problem occurred, I have ...
-1
votes
1answer
40 views
Problems With XAMPP (1 of 2 services running)
When I try to start Apache, it gives me this error:
11:30:58 PM [Apache] Error: Apache shutdown unexpectedly.
11:30:58 PM [Apache] This may be due to a blocked port, missing dependencies,
11:...
0
votes
0answers
31 views
Cyberpanel how do I change the import size for phpmyadmin?
The default database import size is only 2mb, so thats gotta go. I followed this guide from Cyberpanel to the T but myphpadmin still reflects the default size so I still cant import.
https://...
1
vote
1answer
245 views
Connect to MySQL from WSL2?
I have installed MySQL server on Windows and I would like to connect to it from WSL2. Unfortunately it seems that WSL cannot reach the MySQL server:
$ /mnt/c/Program\ Files/MySQL/MySQL\ Server\ 5.7/...
0
votes
1answer
28 views
How to install torrent client on linux in shared servers
I am using "namecheap.com" stellar hosting with Linux OS, installed on shared servers.
It has also Apache, MySQL and PHP preinstalled. I am trying to install uTorrent using terminal with the help of a ...
0
votes
1answer
30 views
mysqlimport gives error when run as cron job but not interactively (Ubuntu 14.02)
I have a bash script which downloads and then imports a CSV file into a local MySQL. The database is MySQL 5.6 on Ubuntu 14.04, I'm loading data with the following statement (bash):
mysqlimport --...
0
votes
0answers
7 views
trouble with publishing new post in wordpress (redirect incorrect)
I have a news wordpress website with 1 GB DB. Sometimes when I want to publish a new post, After "publish" it will redirect to 404 (or 301 with a plugin). After checking all post, I see original post ...
0
votes
1answer
45 views
Is there a way to run MySQL queries from Windows Powershell or Command Prompt?
I currently use Microsoft SQL Server Management Studio to run queries on my databases, but it's a bit clunky and I prefer to do everything through a CLI if possible. Is there a way to do this on ...
0
votes
0answers
8 views
How to setup a Laravel 5.7 and MY SQL database Environment on Windows 10 OS
I have a 32-bit OS x64 based processor Dell that uses Windows 10 OS. I am finding it increasingly difficult to find any useful how-to instructions. Laravel was written off of Mac OS system but there ...
0
votes
0answers
130 views
HDD SAS vs SSD SATA vs NVME for MySQL database server
I am configuring a high end server to run Linux with MariaDB / MySQL. Performance is critical and as such I'll be maxing out RAM as far as possible. Given this, my benchmarking suggests that the ...
0
votes
1answer
10 views
mysql 8.0 replication io_thread cannot keep up
We have created a new MySQL 8.0 cluster.
Our servers are running ubuntu 18.04.
We are running percona-server-server 8.0.18-9-1.bionic amd64.
However, we have issues that the slave cannot keep up (...
0
votes
1answer
82 views
Installed MySQL, but it is not showing in the installer (Windows10)
I tried installing MySQL from the official installer (https://dev.mysql.com/downloads/file/?id=492815).
I ran the installer, but I think the installer stopped someplace midway. Now, I am not able to ...
1
vote
0answers
76 views
Root MySQL Access denied even after resetting root password
I know there are a ton of threads on similar issues where people can't connect using root and need to reset their password to regain access, but in my case resetting the password is not a problem. I ...
0
votes
1answer
46 views
What can I do to prevent MySQL using up all RAM and SWAP in Debian 10?
I am using MySQL 8.0.18 in a group replication (multi-master) infrastructure. There are currently 4 master servers connected to each other and everything seems to be working fine but over the course ...
0
votes
0answers
18 views
MailMerge Word with MySQL database
I try to mailmerde a word document with Word 2016. I want to connect to a MySQL database. I have a connection using odcb32 and I use it frequently for other db applications. It also works from Excel.
...
0
votes
0answers
116 views
how to install mysql with components by command line
I try to install mysql in cmd by command line but doesn't work:
start /w msiexec /i mysql-installer-community-5.7.28.msi /qn
It is not completely installed. I must start and choose the components
...
0
votes
1answer
25 views
Wordpress error connecting to database but it's correct
I've been struggling to find the problem but I just seem to be going around in circles and most of the tutorials just tell me to check the mysql credentials but I'm sure that they're right.
I have an ...
1
vote
1answer
47 views
Excel and Google Sheets calculate different .csv column totals to MySQL and LibreOffice
I have a .csv file with 9273 rows.
I have one column of whole numbers and one column of decimal numbers with values like 0.0001752.
I totalled these columns using Excel's sum function and got totals ...
0
votes
1answer
89 views
How should I set up volumes for multi-task database service in docker swarm?
I am new to Docker and I want to do mini-project with Docker Swarm. I built docker image with my Django app. In dockerfile I added project files, migrated all models, and then ran server. Now it is ...
0
votes
0answers
31 views
What Permissions Does MySQL Need for its Log Files?
I’m trying to enable MySQL’s general log (at runtime, in case that matters) and set a path for the log file. These are the queries I issue after a connection to the server has been established:
SET ...
0
votes
0answers
15 views
Plesk 17: Calculate mailbox usage per domain
I am trying to export the list of emails that their quota is over 80% percent. I am quite new on Plesk scripts and this is where I am right now:
mysql -uadmin -p`cat /etc/psa/.psa.shadow ` psa -NBe"
...
0
votes
1answer
23 views
MySQL apparently running but not listening on TCP, jdbc can't connect
I am running MySQL on Ubuntu. mysql cli, as does http://localhost/phpmyadmin, but I cannot connect using java.sql.DriverManager.getConnection:
java.net.SocketException: Network is unreachable (...
0
votes
1answer
117 views
Trouble with the silent installation command wamp 3.2.x and mysql v5.7.x
I used to silently install wamp with the following command:
start /w wampserver3.1.9_x64.exe /VERYSILENT /SUPPRESSMSGBOXES /NORESTART /NOCANCEL /DIR="%HOMEDRIVE%\wamp64" /LANG="en"
Now with wamp v3....
0
votes
0answers
166 views
'The installer has insufficient privileges to access this directory' Windows 10
I am trying to install the MySQL connector for python but I get the error
The installer has insufficient privileges to access this directory
C:\Program Files\WindowsApps\...
0
votes
1answer
115 views
MySQL Server flashes on and off on mac. How to fix?
I just downloaded the macOS 10.15 (x86, 64-bit), DMG Archive version of MySQL following https://youtu.be/TpOMn5_YIyw?t=305.
But the server just flashes green for a second and then back to red when I ...
0
votes
0answers
7 views
unable to login in mysql through root after install mysql in opensuse
I have installed mysql-communty server on opensuse 15.1. After install mysql i restarted the mysql service and enable the service to active after reboot.
After when i try to login through root it ...
0
votes
0answers
478 views
Mysql server 8.0 initializing database failed
I'm trying to install MySQL 8.0.19 on my windows 10. I have an issue when trying to initializing database. It is failed with a message "may take a long time". Below is the log of configuration:
...
0
votes
0answers
37 views
Can't start MySQL Server on MacOSX, just downloaded
I just downloaded the MySQL Community Server 8.0.19 and can't get the server to start.
I try to start it from the terminal with the following:
sudo /Library/StartupItems/MySQLCOM/MySQLCOM start
but ...
0
votes
0answers
17 views
How to setup a slave replication of mysql database for development?
I've set up a slave replication of MySQL database. And for development requirements, I want to write sth into the slave database, but it would cause the broken of replication.
Since the database is ...
-1
votes
1answer
92 views
How do I safely remotely connect to my database via SSH?
I have these users in MySQL database
mysql> select User,Host from mysql.user;
+------------------+-----------+ ...
1
vote
1answer
37 views
Ubuntu 18.04 debconf shows prompt
I am trying to install MySQL 8.0 on Ubuntu 18.04 automatically using bash script.
I was setup all variables which debconf prompt asking, but prompt is appear anyway.
What's wrong in my script?
#!/bin/...
0
votes
0answers
20 views
How to grand remote connecting access to mariadb?
I am trying to remote connect to a MariaDB via a ssh tunnel but get timeouts.
Connecting via telnet from the remote machine works.
root is there:
SELECT User, Host FROM mysql.user;
| root | ...
