Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [mysql]

an open source relational database management system using Structured Query Language (SQL).

1
vote
1answer
377 views

Installing Mysql 8 on a Raspberry Pi 3 B+

Has anyone had success installing Mysql 8 on a RPI? Mysql 8 has json_table function and I would love to use that to insert records in bulk. I have looked around but cannot find a mysql 8 installer ...
0
votes
0answers
16 views

SQL Server 2014 Mgt Studio and Pi3B+

Can I access a large SQL DB on a usb drive plugged into a powered hub attached to a Pi3B+ and write answers to the usb drive using the Pi3B+ running SQL Server Management Studio 2014? The follow on ...
0
votes
1answer
96 views

mysqldump command not found when Backing up MYSQL Database

So I'm trying to turn my Raspberry pi into an automated MYSQL backup server but I'm struggling to find a working shell script to archive what I'm looking for. Until I came across this Git Repo but ...
0
votes
0answers
21 views

using “LOAD DATA” in mysql on raspberry pi

I'm having problems with the LOAD DATA statement for mysql. I have the "MariaDB". I'm trying: LOAD DATA LOCAL INFILE 'tutorials.txt' INTO TABLE tutorials_tbl; It's only inserting blanks instead ...
-2
votes
1answer
218 views

How to upload data from raspberry pi to MySQL, geting errors [closed]

Basically I am trying to upload the data collected from my raspberry pi to MySQL, I have a table called DHT_data with columns 'datetime' using data type timestamp, 'temp' using data type numeric, 'hum'...
0
votes
1answer
357 views

Sending Rpi local data to an online Server (MySQL

I'm using a raspberry Pi zero w with temperature sensor, i don't have a continuous connection that's why i'm saving the temperature data on a local MySQL database using the following command <?...
0
votes
1answer
82 views

How do I use Raspberry Pi to create a web application for my sensors? [closed]

I recently bought many sensor to use with my pi, using the GPIO. All the scripts to retrieve data are ready, but now, I would like to store it in a database, and then thanks to an API, use it to ...
2
votes
1answer
1k views

Connection to MySQL database does not work

I have two Raspbery PI 3 which I have installed (almost) identical. The configuration of /etc/mysql/mariadb.conf.d/50-server.cnf is identical for both Raspberrys. Problem: I can only connect to the ...
-1
votes
2answers
2k views

insert sensor data in mysql to python [duplicate]

Hello I want to insert sensor data in mysql to python. My sensor is connected to arduino and it sends sensor data to raspberry pi via bluetooth. Raspberry pi receives sensor data to python code. This ...
0
votes
1answer
246 views

MySQL vs SQLite on OSMC (Kodi) install

A python app has been successfully configured with the MySQL connector to write records to a small table to demonstrate a concept (very low volume of writes). I will need to write to a database and ...
0
votes
1answer
4k views

MySQL initial installation

I know there are many, many threads on this, but hear me out before marking it as a duplicate. On an Raspberry Pi running stretch installed mysql sudo apt-get install mysql-server No errors pi@...
0
votes
0answers
107 views

MySQL server unable to start

I am trying to host my personal website on my raspberry pi 3 model B. I have Nginx running great. Now i am trying to run a database for login and other things. I have downloaded mysql and php. I am ...
2
votes
2answers
9k views

How to connect MySQLdb in Python 3?

I want to connect MySQLdb with Raspberry Pi. But when running my program, I get this error: $ sudo python3 readMQ2sql.py Traceback (most recent call last): File "readMQ2sql.py", line 17, in <...
2
votes
1answer
2k views

Install MariaDB 10.2 on Raspbian Stretch

How (if at all) can I install MariaDB 10.2 on Raspbian Stretch? I'm using the November 2017 version of Stretch Lite. I found some instructions on how to install on Debian 9 (which I realise isn't the ...
-1
votes
1answer
680 views

How I can use a barcode scanner and PHP/MySQL to run a database? [closed]

I am currently trying the following with the help of a Raspberry Pi: Barcode scanner scans barcode (connected to the Raspberry Pi via USB Port) (via Python?) A hidden form is filled in The user only ...
1
vote
0answers
286 views

MySQL suddenly broken after restart

I restarted my raspberry pi and now then I got this error on my website: SQLSTATE[HY000] [2002] No such file or directory I look at sudo service mysql status and I can see this. Jan 09 17:34:45 ...
2
votes
1answer
809 views

PHP5, MySQL & MySQLAdmin issues on latest raspbian stretch release

A day or two ago I downloaded the latest release of raspbian stretch. I am currently busy installing all the components I require for a web server and mysql server. In the latest release, PHP5 has ...
1
vote
0answers
60 views

Installing mysql in Rasbian installs mariadb [duplicate]

I'm trying to install mysql server on my Raspberry pi 3 Model B. I've updated the packages and I've upgraded the packages using: sudo apt-get update && sudo apt-get upgrade When I install ...
1
vote
2answers
4k views

Can`t install mysql-server on my Raspberry Pi running Stretch

My Raspberry Pi 3b running Raspbian Stretch with desktop, Release 2017-09-07. I want to install the "LAMP" on my Raspberry Pi. I successfully install apache2 and PHP, and went on to install the ...
4
votes
2answers
11k views

Raspbian Stretch with MariaDB

For the last 6 hours I have been trying to install MariaDB on my Raspberry Pi Zero. I am using the latest Raspbian Stretch. The problem is that the configuration menu for MariaDB doesn't show up ...
0
votes
1answer
203 views

Can't upload data from Raspbian to PHPMyAdmin server

I am trying to upload data from Raspbian to my web server which is PHPMyAdmin MySQL type. I am trying to do this using Python 3, as follows: import pymysql as ps con = ps.connect(host='ip address ...
2
votes
1answer
2k views

Win 10 IoT + apache + php + mysql + ssl?

I'm looking for an easy way to get on Win10 webserver based on apache (or familiar), php, mysql, and ssl (all 3 must have). Everything I found on google has no info how to do it... only how to change ...
1
vote
0answers
193 views

Trying to install mysql-server and it throws a mariadb error

While trying to install mysql-server, I get this error: root@raspberrypi:~# sudo apt-get -f install Reading package lists... Done Building dependency tree Reading state information... Done ...
2
votes
0answers
681 views

Cannot start mariadb - timeout

A bit of background information. I have rasbian installed on my raspberry pi 3 and i'm trying to set up mysql however it seems there is a password already set. I tried purging mariadb and mysql but I ...
1
vote
0answers
186 views

Cannot start the Google Cloud SQL Proxy on RPi 3

I am trying to install Google Cloud SQL Proxy to my RPi 3, but it does not work after install the LINUX-64BIT proxy and the below command on this page Connecting mysql Client Using the Cloud SQL Proxy ...
3
votes
1answer
3k views

unmet dependencies for php5-mysql

I'm trying to get owncloud running on a Raspberry Pi 3 to run as a local file server. I'm following some tutorials that are running me through setting up mysql for owncloud, and MySQL installed fine ...
3
votes
4answers
4k views

Unable to install mysql

I am trying to install mysql on my pi. I've installed mysql server successfully, but get the following error when I try to run $ sudo apt-get install php5-mysql Some packages could not be ...
0
votes
0answers
284 views

How much of a load can an RPi apache server handle?

I'm setting up a website/web app using PHP and MySQL and have been looking at using RPi's as home servers for the project. A few things got me interested - the simplicity of installing Apache, the ...
0
votes
0answers
139 views

Mysql or program error?

The code below is the whole, functional code that am using for: reading barcode comparing to barcode in DB if not older then one day, open gate delete used barcode else-keep gate closed The code is ...
0
votes
1answer
59 views

How to install pam_mysql on Raspbian

I'm trying to install the vsftpd web interface, but it requires pam_mysql and I'm pretty sure I don't have this installed. Does anyone know how to install this on the Pi? I'm using the latest version ...
0
votes
1answer
420 views

Read barcode via USB scanner then send it to database

I need to read some barcodes from 10 different working stations, unfortunately I can't put a PC on every station because the space is really small. Given the little space I have I would like to use ...
0
votes
1answer
1k views

No distributions found at all for mysql-connector-python

I tried to install mysql connector for python on Raspberrypi 3 but It didn't work, I got an error message saying : No distributions found at all for mysql-connector python. I usued the command: sudo ...
1
vote
0answers
68 views

Installing mysql installed other software and changed icon set

Raspberry Pi 3 running NOOBS with Raspbian Pixel installed. So i'm trying to setup a webserver on my Raspberry Pi 3 and did that. Then i added MySQL. Running sudo aptitude install mysql-server php5-...
0
votes
2answers
3k views

Install Python Module pyodbc on PI?

I am trying to connect to a MS SQL database and get some values over a Raspberry Pi. I have my Python script and it works well on windows, but i dont know how to install the 'pyodbc' module on the PI. ...
1
vote
1answer
191 views

Cannot install pg on Raspberry Pi

I have been trying to install pg to run my web application (Ruby on Rails). I use a pg database. With bundle install, it fails. The output is: current directory: /home/pi/.rvm/gems/ruby-2.3.3/gems/...
0
votes
1answer
386 views

Listen for certain keyboard input and insert to SQL Server DB

I have a USB NFC reader (acts as an emulated keyboard that types out the 10 digit ID number on the card when scanned). I want an app to listen for this input and when it sees 10 digits, I want it to ...
0
votes
1answer
2k views

MySQL apt-get install not installing

When trying to install MySQL with the Bash command line using apt-get install it does not work. root@raspberrypi:~# apt-get install mysql Reading package lists... Done Building dependency tree ...
1
vote
0answers
307 views

Unable to start mysql after moving it to USB memory stick

To have more room for databases, I copied /var/lib/mysql to /media/usb/mysql To copy them, I had to change their owner and group, so they are now showing /var/lib/mysql shows 755 mysql:mysql /...
0
votes
1answer
115 views

Run a python script when start up and SSH not log in

I am new to programming and doing a simple academic project with Raspberry Pi, I have a script which will monitor the changes of database and output the change with 2 different color LED. I want it ...
2
votes
0answers
100 views

Configuration for NASA ISLE deployment

NASA has released an open-source version of it's lab inventory system known as ISLE: https://github.com/nasa/isle I went through the local setup using Vagrant but I was wondering if it would be ...
0
votes
2answers
640 views

dpkg error when trying to install mysql-server

I'm running a lighttpd web server on my Pi and I'm trying to add php and mysql support. I'm currently trying to install mysql-server with the command 'sudo apt-get install mysql-server' which ...
0
votes
0answers
1k views

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I use rasbian version Wheezy and Raspberry Pi B. I installed mysql-server-5.6. The repository of Wheezy don't contain mysql-server-5.6, so I installed a deb file from http://archive.raspbian.org/...
0
votes
1answer
731 views

SQL Statements from multiple RPi to Web server

I am building a few RPi with temperature sensors and they are all connected to the same lan by ethernet. Raspberry Pi 1 has address 172.10.16.1 Raspberry Pi 2 has address 172.10.16.2 Raspberry Pi 3 ...
0
votes
1answer
87 views

Error synchronising database while installing reviewBoard

Hi I am getting the following error: Press Enter to continue [!] There was an error synchronizing the database. Make sure the database is created and has the appropriate permissions, and then ...
2
votes
1answer
228 views

Problems with server services on Raspberry Pi3

I have a Raspberry Pi 3 with Raspbian installed on it. However, I've tried also tried Ubuntu Mate, and I had the same problem. After a while my LAMP server, SSH server and FTP server become ...
1
vote
1answer
3k views

Cannot create new database in MySQL - logging in as 'root'@'localhost' [closed]

For some reason when I login into MySQL - mysql -uroot -p***** I get this error when running this procedure - mysql> create database new_database; ERROR 1044 (42000): Access denied for user '...
0
votes
1answer
12k views

How to install python-mysql on Raspberry Pi?

I am trying to install python-mysqldb on Raspberry Pi 2. The sequence of commands I am using is as follows, sudo apt-get install python-dev libmysqlclient-dev build-essential python-dev Above runs ...
3
votes
2answers
182 views

Problem about installing mysql in my raspberry Pi 2

Today when I tried to install mysql in my raspberry pi 2, problems happen as shown below: I use the command apt-get install mysql-server python-mysqldb to install mysql. Does any one know how to ...
1
vote
1answer
906 views

MySQL 5.7 on Raspberry Pi

Because this did not work for me: MySQL 5.7 in Raspberry Pi 2 I installed MySQL from source, and now I have MySQL 5.7.11 installed under /usr/local/mysql. I've never used systemd, so I don't know ...
7
votes
1answer
6k views

MySQL 5.7 in Raspberry Pi 2

I want to install Mysql 5.7 on Raspberry Pi 2 with Raspbian Jessie. When I execute the command apt-get install mysql-server, it installs version 5.5. What do I need to do? Update I did every step ...