Questions tagged [mysql]
MySQL is an Open Source database now owned by Oracle. The MySQL documentation is expansive and incredibly useful.
1,883
questions
0
votes
0
answers
9
views
MySQL tuning-primer script and Docker container
I have MySQL docker container and I want to optimize MySQL server there. I use tuning-primer. However, I could not figure out how to make that script connect to the container via socket In other words,...
- 268
0
votes
0
answers
10
views
mysqldump on windows with mysql 8 community
I have MySQL 8.0.26 installed but when I type mysqldump in PowerShell I get a The term 'mysqldump' is not recognized error.
When I open up the installer everything is installed.
Back in the day ...
- 5,890
0
votes
1
answer
18
views
Joining MySQL table
in my database there are 2 tables : posts, room
Posts tables include ID and Title columns and includes many rooms and hotels titles and IDs.
In the room table there are 3 columns : room_id, hotel_id ...
- 1
0
votes
1
answer
52
views
Why can't I install Mysql on Ubuntu 20.04?
I tried everything purge and install many times.
sudo dpkg --configure -a
output
Setting up mysql-server-8.0 (8.0.28-0ubuntu0.20.04.3) ...
Failed to stop mysql.service: Unit mysql.service not loaded....
- 129
0
votes
0
answers
14
views
Could not backup all of docker container, i.e. data & configurations
I have MySQL Docker containers running well on a host with the following docker inspect mysql output:
[
{
"Id": "...
- 268
0
votes
0
answers
10
views
Trying to install MariaDB installs Mysql instead on Fedora 33
I have a PC running Fedora 33 with MySQL installed. I need to install MariaDB as well but since it is a fork from MySQL, when i execute:
sudo dnf install MariaDB-server
It shows me that MySQL is ...
- 101
1
vote
0
answers
17
views
Homebrew gives transfer closed with ... bytes remaining to read while I can manually download it. How do I do?
I'm trying to install MySQL-5.7 with homebrew on my Mac.
Firstly, I tried
brew install mysql@5.7
and I got
==> Downloading https://cdn.mysql.com/Downloads/MySQL-5.7/mysql-boost-5.7.37.tar
...
- 243
0
votes
0
answers
15
views
MySQL not allowing access via php mysqli?
I have just finished setting my VPS up, running on Debian 11 and equipped with the latest MySQL configured to be as safe as it gets via the installer and PHP v8.1.4 + mysqli. Upon trying to access my ...
1
vote
1
answer
31
views
Why is MariaDB using localhost when using TCP?
I installed MariaDB via Nix and I am having trouble connecting via TCP.
I have users such as:
MariaDB [(none)]> SELECT User, Host FROM mysql.user;
+---------------+-----------+----------------------...
- 121
0
votes
0
answers
15
views
Failed to connect to MySQL: (2002) No such file or directoryError: // MariaDB issue?
--Apologies in advance. Not a coder, but have gotten this far with the assistance of v helpful people on forums such as this--
I've had a VM instance running on GCP with no issues for a couple of ...
0
votes
0
answers
184
views
SSL connection error to mysql
Since a couple days I cannot connect to several mysql instances when using SSL. I am quite sure it's a problem on my machine, since colleagues and production servers don't have this issue. In both my ...
- 101
0
votes
0
answers
29
views
How start and stop MySQL and apache web server via PowerShell?
I have installed MySQL 8 and Apache 2.4 web server individually and I would like to have a PowerShell function to turn them off and on as if I was using Xampp.
The problem is if do Start-Service ...
- 4,768
0
votes
0
answers
14
views
mariadb find overlapping date ranges
I have a mariadb table of approximately 12M rows. Fields within each row contain a timestamp for the start time and end time for a process. The timestamps are actually seconds since the Linux epoch. ...
- 401
0
votes
0
answers
15
views
Rsyslog Mysql Connection
I'm using central log collector for rsyslog and My customer want to see there log in mysql. I'm doing config like that but this line is adding all log in mysql. We want to keep all log in file but we ...
- 15
0
votes
0
answers
17
views
Is total MySQL memory usage scaled by innodb_buffer_pool_instances?
I seem to remember reading somewhere that:
Total InnoDB pool usage = innodb_buffer_pool_size * innodb_buffer_pool_instances
but I can't find the original reference.
Is this true?
or true for certain ...
- 317
0
votes
1
answer
31
views
Installed php74-php-mysqlnd but module is not available
I am setting up a clean CentOS 8 server and installed PHP using the Remi repositories. In there, it also has a php74-php-mysqlnd package that should be installing the correct .so files, but I do not ...
- 1,302
0
votes
1
answer
49
views
Connecting to Raspberry database with TCP/IP over SSH
I am trying to connect to my raspberry MYSQL server with MySQL workbench over SSH but get the error:
"Could not connect the SSH Tunnel WARNING: Server public key has changed"
I´m not sure ...
- 15
0
votes
0
answers
24
views
MAMP access MySQL from Command Line
I have MAMP installed on my Mac and I am trying to mysqldump a database. I am in the right folder "/applications/MAMP/library/bin" -- But when I use that command or any mysql command in ...
0
votes
1
answer
39
views
How to create a console that act as a server?
I am a computer science student working on my capstone project. My team is building a vehicle renting system. In this system, user can book and rent a car they like on a specific date range. We are ...
- 1
0
votes
1
answer
23
views
Can't start MySQL due to an error in a View
Good day,
I tried to upgrade mysql today (Ubuntu updates), but it failed. I checked /var/log/mysql/error.log and it says
Error in parsing View 'database'.'view_name' during upgrade. You have an error ...
- 101
1
vote
2
answers
304
views
Install MySQL on Debian 11
I wanted to install MySQL with sudo apt mysql-server but it is obsolete, so use sudo apt default-mysql-server, I installed by default MariaDB.
I didn’t try another package installer, I’m new to Linux. ...
- 11
0
votes
0
answers
14
views
Local database to replace spreadsheets; copy-paste towards database from spreadsheet
I'm doing some scientific research for which I characterize many samples. Currently, I've been using spreadsheets (Libreoffice) to store my stuff, but as I get more and more data it becomes ...
- 101
1
vote
0
answers
42
views
MySQL refuses to start on my Debian 10 server after a botched control panel installation attempt
Context
After two failed control panel installation (tinycp and cloudpanel) attempts and a restart the MySQL service (Community version 8.0.27) is not starting.
When trying to restart the service, it ...
- 11
0
votes
0
answers
20
views
Golang mysql query
I am new to go and I would like to know the function of the below query
db.Query("SELECT id, first_name FROM students LIMIT ?,20", rand.Intn(100000))
It would be great if someone can ...
- 11
0
votes
1
answer
46
views
Lost Wordpress site on Raspberry Pi4
Recently my router died and we have installed a spanking new fibre system with a new Google Wi-Fi mesh. Unfortunately the website on my RP no longer loads. I have assigned a new static IP to the Pi on ...
- 1
0
votes
0
answers
42
views
trying to install mysql server inside my Dockerfile
My Dockerfile is actually a PHP image.
FROM php:8.1
I want to also run a mysql server within it. I tried apt install default-mysql-server but gives out:
2022-01-01 23:37:35 0 [Note] InnoDB: Buffer ...
- 1
0
votes
0
answers
255
views
phpmyadmin installation return ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
I already have a mysql database in local (installed, configured and containing things for a service).
When I try to install phpmyadmin, I get the following error : ERROR 1045 (28000): Access denied ...
0
votes
1
answer
197
views
mysql process won't die on mac
I have a problem in the setup of mysql using homebrew and so I decided to uninstall and start with a clean slate. Following the answer here I try to kill the process by
Getting the process id through:...
- 101
5
votes
1
answer
267
views
Access crashes when opening linked table via MySQL ODBC driver
We installed the 32 bit ODBC driver (8.0.27) for MySQL on a Windows 10 machine
Made a successfull connection via SSL to a MySQL 8 server
Initially tables most table can be opened, but Access crashes ...
- 1,327
0
votes
0
answers
20
views
Gitbucket self-Hosting on Nginx MYSQL configuration doesn't work
I'm configuring my own self hosted (on Nginx) gitbucket repository and my MYSQL configuration does not work as expected here under GITBUCKET_HOME/database.conf :
db {
url = "jdbc:mysql://...
- 103
0
votes
0
answers
38
views
Deleted /etc/mysql, What to do?
Here is the problem: I managed to delete /etc/mysql directory and I tried to recover my mistake but I made it worse.
When running "apt remove mysql-*" I get this:
failed to stop mysql....
- 1
0
votes
1
answer
35
views
Create table in mysql table via JSP [closed]
I am creating a code in which a mysql table will be create which table's name will be provided by the user. The user will type individual data and the code will concatenate all the data and will ...
- 84
0
votes
0
answers
12
views
MySQL Replication: AWS RDS as primary and external self-hosted MySQL as slave
I have seen documentations on how to make AWS RDS a slave for MySQL primary (e.g., https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.External.Repl.html), but I am ...
- 236
0
votes
0
answers
36
views
0
votes
0
answers
32
views
Automatically start SLAVE (mysql) Master Master
I performed the configuration of a database replication (slave), performed it as MASTER MASTER, however, every time I restart as machines, I need to manually start the slave
I use the command:
START ...
0
votes
0
answers
30
views
Can't connect to MySQL from PHP script running on the PHP builtin server (localhost)
I am trying to connect to the MySQL service provided by XAMPP (screenshot) through a PHP script that runs on the builtin PHP server (I started the server through php -S localhost:4242 in the folder ...
0
votes
0
answers
64
views
Temp folder unusable
I had mysql-server installed, wordpress was working fine then I tried to install cyberpanel which failed installing mariadb
So I manually tried to install mariadb to know why it failed, it failed ...
- 101
0
votes
0
answers
27
views
MariaDB: How do I load a copy of a table into RAM for frequent reading?
Colleagues, tell me how to keep a copy of the table in RAM?
I have a database server on MariaDB. One of its databases contains a small table - about five fields and several dozen records. The records ...
- 1
0
votes
0
answers
66
views
I get MySQL shutdown unexpectedly every week, I have to fix this issue for good
When I open XAMPP Control Panel v3.3.0 and click the start MySQL button and it gives me an error.
Error Log.
Error: MySQL shutdown unexpectedly.
This may be due to a blocked port, missing dependencies,...
- 101
0
votes
0
answers
26
views
XAMPP on Mac vs Windows
I’ve seen some videos on XAMPP and it seems Windows install has more functionality.
e.g. the control panel on Windows seems to have a lot more functions.
Can someone please explain if there is any ...
- 1
0
votes
0
answers
56
views
How to establish persistent connection with autossh
I am new to this so sorry in advance if my writing is a little confusing.
I am trying to connect to a remote MySQL database from my AWS terminal. What I do is I start 2 AWS terminal windows. In the ...
- 101
0
votes
0
answers
156
views
Ubuntu Server 16.04 crashes periodically
I have MySQL Community Server 8.0.25 installed on a VM with Ubuntu Server 16.04.7 LTS.
This VM has been running for almost 3 years without any issue until a few months ago when it started crashing ...
- 101
0
votes
1
answer
36
views
Access denied for my user in Community mySQL version 8
I am using Ubuntu 21.04 which changed the mySQL from 5.x to 8.0.
I am in favor of using the latest software so don't want to return to 5.x.
What worked in 5.x no longer works in 8.0.
There is no ...
- 147
0
votes
0
answers
157
views
How do I convert a linux iso into docker image/container
I am trying to convert a linux distro(RasPBX) into a docker container. So, far I was able to deploy the container, its runs without the desired outcome. Here is the docker file and dockerignore file:
...
1
vote
1
answer
127
views
Can't connect to MySQL database over local network
I have two macbooks at my home connected via Wi-Fi to my router. One of them has a MySQL server installed. I want to access a MySQL DB from the second mac. I found the internal IP address of the first ...
- 11
0
votes
1
answer
147
views
My local MySQL server starts via CMD, but won't start as a Windows service?
When I start MySQLd via the command line, it starts perfectly fine and I'm able to run queries on the database:
C:\Users\Nicholas>"C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe" -...
- 101
0
votes
0
answers
30
views
Break MAMP Pro host/db association
I have started developing using Valet and must use port 80 for that. This collides with MAMP Pro's Apache on port 80, so when I need Valet running I change the port for MAMP's apache to port 81. I ...
- 105
0
votes
1
answer
342
views
MySQL Server configuration, is it enough for my needs?
I've never dealt with MySQL before, so I am very new at this.
I am connecting my MS Access front-end to MySQL server. The server configuration is 2 CPU Cores, 2GB RAM and 60GB SSD. The server has ...
- 11
0
votes
0
answers
42
views
MySQL service status shows stopped after started
I installed MySQL in WSL2 running Ubuntu 20.04 following this tutorial
I start the service using sudo service mysql start and received this message.
* Starting MySQL database server mysqld ...
- 1
0
votes
0
answers
43
views
plink cli (ubuntu): open ssh connection and execute local php script
iam trying to:
connect to a mariadb server via ssh server
execute a local php script, which downloads a mysql select query into a csv file to my local machine
i managed to open the ssh session to ...
- 1