Questions tagged [mysql]
MySQL is an Open Source database now owned by Oracle. The MySQL documentation is expansive and incredibly useful.
1,946
questions
2
votes
2
answers
143
views
Permissions error in directories used by Docker and application I am developing
I have run a docker container mysql from my own application development on C#, and configured data persistence to this path:
C:\ProgramData\Persistence\data\mysql
When i start everything goes well ...
- 1
0
votes
1
answer
181
views
Waiting for a MySQL or MariaDB server to become ready to perform updates
Is there an universal command/query to issue at the mysql client program to wait for the server to become ready for processing queries and updates, independent of whether the server is MySQL or ...
- 586
1
vote
2
answers
4k
views
SSH Connection is established on port 22, but service is not working
I am having this recurrent issue on one of my MySQL Cluster Servers, actually always happens in any random MySQL server of this cluster, on many countries where we have this same configuration.
I ...
CommunityBot
- 1
1
vote
1
answer
7k
views
Failed to start MySQL Community Server After Updating to Ubuntu 22.04.2
I have updated my Ubuntu server on DigitalOcean to version 22.04.2. Now I can't log in to the phpMyAdmin ( also my Flask website can't connect to the MYSQL ). When trying to login to the phpMyAdmin ...
CommunityBot
- 1
2
votes
1
answer
12k
views
SUPER,REPLICATION CLIENT prev to external MySQL user
I'm trying to create an MySQL slave, but I'm not able to grant SUPER,REPLICATION CLIENT to the external powerdns user.
I'm using phpMyAdmin and granted ALL PRIVILEGES to the powerdns user, but it ...
CommunityBot
- 1
4
votes
3
answers
10k
views
How to tune MySQL for restoration from MySQL dump?
My little 5GB database which takes 5 minutes to dump via mysqldump, takes 9 hours to restore. Luckily I found this out during a test-run, not an actual emergency situation.
What are the best ...
- 56.1k
0
votes
1
answer
773
views
How can I reset my MySQL root password in MySQL 8.0.36 on Red Hat 8 if ‘mysqld_safe’ is gone?
For years I have been using mysqld_safe (like this) with --skip-grant-tables so I can safely reset my MySQL root password:
sudo mysqld_safe --skip-grant-tables &
But recently, while attempting ...
- 56.1k
0
votes
2
answers
5k
views
MySQL Shell SyntaxError: Unexpected Identifier
I'm trying to follow this guide: https://dev.mysql.com/doc/world-setup/en/world-setup-installation.html
Connect to the MySQL server using the mysql command-line client with the following command:
...
CommunityBot
- 1
0
votes
2
answers
7k
views
Services don't have MySQL Server. How to run it?
I need to run MySQL Server on a new for me laptop. There's Windows 7. And MySQL have been installed on it. In order to verify this, I opened the Programs and Features window and saw it there:
But ...
CommunityBot
- 1
0
votes
0
answers
9k
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 ...
- 1
4
votes
1
answer
4k
views
Hive Installation - Error Executing SQL Query "select "DB_ID" from "DBS""
I'm trying to install Apache Hive (3.1.1) on a Hadoop (3.2.0) multi-node cluster with 1 namenode and 3 data nodes.
I have followed the getting started tutorial step-by-step on the apache website but ...
CommunityBot
- 1
2
votes
1
answer
7k
views
How do I determine what's making the web server so slow (Apache)
I'm running Apache 2.4 (64bit) on a Windows server. It also uses MySQL 5.7 on the same server.
It has been very, very slow recently to come up, but when I look at the access logs, there are very few ...
CommunityBot
- 1
0
votes
0
answers
45
views
MariaDB - database folder changed?
I have MariaDB installed via Homebrew on MacOS.
I have local databases in /usr/local/var/mysql but a day or two ago, my local MariaDB now points to /opt/homebrew/var/mysql and does not find any of my ...
- 101
0
votes
1
answer
3k
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\...
CommunityBot
- 1
1
vote
3
answers
3k
views
Error: Characters found after SQL Statement
I am currently trying to insert a new row of information into a table, and am using the sql view inside of MS Access. When I run this code:
SELECT *
FROM VersionReleases;
INSERT INTO
...
