Questions tagged [mysql]

MySQL is an Open Source database now owned by Oracle. The MySQL documentation is expansive and incredibly useful.

Filter by
Sorted by
Tagged with
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,...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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....
user avatar
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": "...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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; +---------------+-----------+----------------------...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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. ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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. ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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:...
user avatar
  • 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 ...
user avatar
  • 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://...
user avatar
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....
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 236
0 votes
0 answers
36 views

Unable to Login to PHPmyadmin

I can't find the login boxes. Why is that?
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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,...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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: ...
user avatar
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 ...
user avatar
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" -...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 1

1
2 3 4 5
38