Questions tagged [mysql]
MySQL is an Open Source database now owned by Oracle. The MySQL documentation is expansive and incredibly useful.
1,849
questions
2
votes
2answers
152 views
request mysql with curl
I have a mysql running. I can access it with
mysql -h 127.0.0.1 -u root -P 8009 -p
(password requested)
Now I want to make requests with curl :
curl 127.0.0.1:8009 ????
I need to pass the password ...
0
votes
1answer
490 views
Remove Mysql from homebrew Mac
When executing brew search mysql brew finds something but when I try to uninstall it it say it can't find it.
macbookaaa:sbin aaaa$ brew search mysql
==> Formulae
automysqlbackup ...
0
votes
0answers
15 views
Install mysql-server 8 after mariadb-server 10 debian 10 buster on the same host
I've found some text to install mariadb-server alongside mysql-server 8, mariadb after mysql-server.
I've not found any way to do the inverse.
With mariadb-server installed on debian 4.19.0-16-amd64 #...
0
votes
1answer
32 views
selecting from SQL with LEFT JOIN and multiple conditions
I am trying to fetch posts with multiple filters, my database is as below,
"Meta" Table
id
meta_key
meta_value
object_name
object_id
2
location
new city
post
2
1
post_type
section
post
2
...
0
votes
0answers
4 views
multiple requests to node express mysql synchronization issue [migrated]
Using expressJS I have an endpoint which is connected to a mysql DB where I am making a query and getting a set of data and assigning the first returned result to a user by updating a field to the ...
0
votes
1answer
33 views
Can't connect remotely to MySQL database over network
I'm trying to connect to a MySQL database that's set up on a Linux Mint installation however I can't connect to it through MySQL Workbench:
Failed to Connect to MySQL at
10.0.0.5:3306 with user root
...
0
votes
0answers
17 views
MySQL Wordbench an old version
Every time I go through the process of installing MySQL Wordbench on Mac it shows and old '5.7.32' when it should show '8.0.12'. I also use MAMP PRO. Can someone please help me...
MySQL Wordbench
0
votes
1answer
15 views
MySQL 1273 Workbench
I have initially started to run https://www.youtube.com/watch?v=7S_tz1z_5bA&t and installed it all. When using MySQL Work Bench I initially run it, I get thunder icon when it runs but then I get ...
0
votes
0answers
20 views
MariaDB service fails to start with InnoDB Space id error
I've been running MariaDB on a Raspberry Pi 4 as the database server for my Webtrees and Owncloud sites. Recently, I noticed that the server wasn't looking right, and after a reboot, I can see that ...
0
votes
0answers
13 views
Server down while downloading file through Filezilla
I tried to connect with File Zilla for donwloading files, it was successfully connect with server at the first time, after I try to download file to my computer, server just down and disconnect with ...
0
votes
1answer
44 views
Restart Mysql in RHEL 7
I am trying to restart Mysql in RHEL7
Here are the packages installed:
]$ yum list installed | grep mysql
rh-mysql57-lz4.x86_64 r131-7.el7 @rhel-server-rhscl-7-rpms
rh-mysql57-...
1
vote
0answers
8 views
What is causing my home LAMP server to wait about 57 seconds before serving up a web page?
I should preface this all by saying that I'm certainly not a sysadmin, or even a web designer. I've searched for an answer but most answers I've seen have to do with WAMP and DNS. Not my particular ...
0
votes
0answers
15 views
XAMPP Control Panel starting MySQL shows Windows Firewall pop-up
I just installed XAMPP a few weeks ago, and the first time I start up MySQL, I get a Windows Firewall prompt:
XAMPP Control Panel
Windows Defender Firewall
I can't tell what MySQL is trying to do here....
0
votes
1answer
24 views
MySQL beginner: How to set an user's host if there is no static public ip?
I want to connect to a database called 'data' of my web server from my local raspberrypi. To accomplish this, I have already set up a user named raspberrypi (using the web server's phpmyadmin UI), ...
0
votes
1answer
22 views
ip address to connect to remote database
I understand that there's local ipv4 address that we can get from ipconfig in commandline and the public ip address that we get from google. If I am trying to establish connection to a remote database,...
0
votes
1answer
26 views
Port forwarding killing the springboard server?
I am trying port-forwarding from Local machine ->EC2 ->RDS
What I am doing is like this on local machine
$ssh -f -N -L 3308:my_rds.amazonaws.com:3306 -i ~/.ssh/id_rsa.cina02 ubuntu@my_ec2....
1
vote
0answers
50 views
MySQL Workbench unable to backup connections
I tried to take backup from connections through tools from top menu, however I received this error which I have no idea how to get rid of it. Do you know how to solve it?
1:
0
votes
0answers
138 views
Cannot reinstall Mysql because sub-process /usr/bin/dpkg returned an error code
I'm trying to remove MySQL from absolutely everywhere in my computer, to be able to reinstall it and use it again. If I launch MySQL, I got this:
mysql
ERROR 2002 (HY000): Can't connect to local ...
1
vote
1answer
35 views
Cannot log in to the MySQL server _After data dir changed _cent os 7
I am having centos 7 and recently i changed my data directory of mysql from /var/lib/mysql to /test/sql after the migration i am able to login from mysql server through terminal but not able to login ...
0
votes
1answer
19 views
mysql report multiple values on same line
I have a bunch of temperature sensors in my house. I poll the sensors every minute and store the data in a mysql database that looks like this:
+------------+--------------+------+-----+---------+----...
-1
votes
1answer
140 views
Problems with MySQL on Linux and 100% CPU load
I'm on Ubuntu 20.04.
Why meanwhile I am deleting this package, the system is starting the relative service?
I need MySQL on this server. How correctly I should execute its installation procedure?
root@...
0
votes
0answers
38 views
MySql Installer - Select Products Empty when installing on server
I have Windows Server 2016 Datacenter.
I need to install MySqL 8.0.23 and the options are all greyed out, even when I attempt the non web installer ?? Ive tried 8.0.22 and 8.0.23 and 5.6.51 and none ...
0
votes
1answer
13 views
Use OR with condition in AutoHotkey script
I created the following AHK script to answer my own question here:
NumpadEnter::
Process, Exist, httpd.exe
If ErrorLevel = 0
{
Run, C:\XAMPP\apache_start.bat,,Hide
Run, C:\XAMPP\...
0
votes
1answer
74 views
Restart XAMPP without using the Control Panel
I use XAMPP to run several local development environments. For the last few years I've been using an AutoHotKey script that lets me launch the XAMPP Control Panel with a keypress. While this is ...
0
votes
1answer
26 views
Number of processes on server
I am bit worried about the number of processes on my server. I see plenty apache and mysql processes after a reboot. I am worried they will start eating up too much resources and bring the server ...
1
vote
1answer
190 views
MySQL 8.0.23 Community Server Installation skips Configuration Part on windows 10
When i try to install MySQL 8.0.23 Community Server, it just skips the whole Product configuration part. Its going instantly to installation successfull. After that i cant do anything because theres ...
0
votes
0answers
5 views
How to Docker Flask App Connection to My Local DB
Guys i have a project about flask and opencv like mix project and i'm trying to connect my-flask project in docker to my local database (not docker db) but i didn't how can i connect ??
I mean i have ...
0
votes
3answers
61 views
2 Raspberry PI connecting to same MYSQL database on the same network
I am working on a project which requires 2 Raspberry Pis to share some data.
I have figured that it would be most convenient for me to use MySQL database since I had a bit of experience on that. I ...
0
votes
1answer
51 views
Mysql login without password in terminal
I have an Ubuntu 20 server with Mysql installation. I am sure the root user have a password set. But if I run command mysql -u root it does not require password and run mysql with all privileges. How ...
0
votes
0answers
83 views
Unable to log in to phpMyAdmin 5.1 using cookie authentication
Running phpMyAdmin v. 5.0.2 and it works fine.
Downloaded 5.1.0-rc1, unzipped it to public_html and added server by phpMyAdmin/setup.
Also tried to manually edit the configuration.
When I try to log ...
0
votes
0answers
27 views
Can not connect a MySQL on a windows[ERROR 1045 (28000):]
I installed a xampp and tried to use MySQL on a different port base on this article ..
after running MySQL on a xampp and I started the command line and went to the \xampp\mysql\bin directory and put ...
0
votes
2answers
104 views
How do I add a column to a Table in a row with data from another column?
I have a query that aggregates MySQL.Database output.
What I would like to do is update the Table in Data to contain the value of Schema for each row in the Table.
I think it would be something to do ...
0
votes
0answers
12 views
Is it possible to create a time series table from a MySQL data?
I was wondering, given a MySQL table that has no "datetime" information but has something simple like key [VARCHAR] and value [NUMBER(19,2)].
I want to periodically query the table to track ...
1
vote
1answer
52 views
mysql connection from bash shell with special characters in password errors out
#!/bin/bash
set -x
MYSQLTEMPPWD=`grep 'temporary password' /var/log/mysqld.log | awk 'NF{ print
$NF }'`;
MYSQLPWD=`echo "'$MYSQLTEMPPWD'"`;
echo $MYSQLPWD;
CONNINFO="mysql --host=...
1
vote
1answer
145 views
How can I solve this error on my Pentaho BI Server: “pentaho PentahoSystem.ERROR_0014”
I get this error when I set MySQL as repository:
PentahoSystem.ERROR_0014: Error while trying to execute startup sequence for org.pentaho.platform.engine.services.connection.datasource.dbcp....
0
votes
0answers
244 views
Start mySQL docker container with existing InnoDB Database failing on startup
I'm testing the workflow to start a mySQL Docker Container with an existing InnoDB directory. This was pretty much rsync'ed from a remote server.
I tried MariaDB with the following result:
db_mariaDB |...
0
votes
0answers
30 views
MySQL not getting installed
MySQL is not getting installed on my laptop. It is getting stuck on the same page i.e on the MySQL installer .It only shows connector .When I installed it first time it installed successfully but due ...
0
votes
0answers
83 views
Mysql 8 for mac OS high Sierra 10.13.6 error : Access denied for user 'root'@'localhost'
After installing Mysql server I have problem accessing mysql> prompt due to restrictions on root user
Here are the steps
Mysql installation for mac OS
view img installation
Enter password
view ...
0
votes
2answers
2k views
mysql doesn't ask for root password when installing
situation
I did install MySQL by using a MySQL installer and I did fill out the content as following MySQL did ..but not asked a password ..
try
Anyway I tried to start mysql set-up in the command ...
0
votes
0answers
9 views
Access denied to root from console and can't use mysqld_safe
I have been using MySQL for over a month in this computer and today it decided to not let me connect from anywhere anymore
I have seen some proposed solutions about using mysqld_safe but I can't do ...
0
votes
0answers
22 views
MySQL 5.7.32/Ubuntu 18.04.5 won't allow me to create a user
I'm logged in to MySQL as root and I'm typing the command as:
mysql> CREATE USER 'c7d7m1q7s'@'localhost' IDENTIFIED BY 'sG&0sQ#@Roge7CLV';
ERROR 1064 (42000): You have an error in your SQL ...
0
votes
1answer
21 views
Redirect output of mysqlsh interactive environment
I'm trying to redirect the output of statements made inside the mysqlsh interactive environment.
I'm running mysqlsh inside the terminal on OSX and didn't find a proper parameter to achieve the ...
0
votes
1answer
24 views
Recover Ubuntu file owners after improper use of chown
I made the mistake of changing the owner with the command
sudo chown -R userG: userG /
Now MySQL and other things not working, I try to repair but the ** sudo ** command does not work
Give this error
...
1
vote
0answers
11 views
Upgraded mysql server from 5.7 to 8.0 and lost local schema connections
I had a few local schemas I seem to have lost / disconnected from when I uninstalled mysql server 5.7 and installed mysql server 8.0. Is there a way to get the schemas back or reconnect them or am I ...
0
votes
0answers
17 views
How can I get my data back when I did system restore (mysql)?
I copied Xampp folder and then do system restore in windows 10 but I lost my data in database (mysql), when I restored Xampp folder I copied before restore my data is not restored.
What can I do in ...
0
votes
0answers
17 views
Mac, Installed a program that uses postgres, little snitch randomly notifies me, annoying, how can I stop this?
Anyone know how to acces/shut up postgres activity, shows as trustd, postgres, no option to set rule unlike other items, I rarely use the program, but I will later, I don't seem to be able to do it ...
0
votes
0answers
20 views
MySQL stopping Ubuntu from booting
I'm new to MySQL but I've had it working without any problems for the last month or so, until I had to reset my Ubuntu virtual machine. Now, whenever I try to boot it up, it stops, giving me the error;...
0
votes
0answers
2k views
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) mysql 8.0
I tried every single thing to make this error go away, when i start mysqld --skip-grant-tables and i do mysql -u root mysql then it shows ERROR 2002 (HY000): Can't connect to local MySQL server ...
0
votes
0answers
23 views
apt-get does not recognize correct installation of openssl
I'm trying to instal mysql using the command:
sudo apt-get install -y mssql-server
I get an error,
mssql-server: Depends openssl (>= 1.0.1g) but 1.0.1f-1ubuntu2.27 is to be installed
I installed ...
0
votes
0answers
28 views
PyMySQL Remote Connection Error
I'm quite new with the database scene so please bear with me if this is too simple, but I couldn't find solutions anywhere. I made a Python script that successfully connected to a local MySQL database ...
