Questions tagged [mysql]
an open source relational database management system using Structured Query Language (SQL).
101 questions
20
votes
1
answer
3k
views
Is there an alternative to MySQL?
I'd like a lightweight database for my lightweight RaspPi. MySQL seems a bit of overkill and involves too much administration. I'll need one with a perl API.
- 1,061
7
votes
1
answer
17k
views
Trying to install MySQL: Package 'mysql-server' has no installation candidate
I'm trying to install MySQL; my command is:
sudo apt-get install mysql-server php-mysql -y
and what I'm getting is an error stating
E: Package 'mysql-server' has no installation candidate
7
votes
1
answer
7k
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 ...
- 71
6
votes
2
answers
9k
views
How do I install MySQL on Occidentalis?
I cannot find any guides on how to install MySQL on a Raspberry Pi running Occidentalis 0.2; Occidentalis is a Raspbian derivative.
I cannot use apt-get to install it even after running apt-get ...
- 243
5
votes
2
answers
20k
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 ...
5
votes
2
answers
8k
views
Raspbian - unable to locate package mysql-server-5.6 after adding repo
I'm trying to install MySQL 5.6 in Raspbian 7 (wheezy).
I've added the repo:
wget http://dev.mysql.com/get/mysql-apt-config_0.3.7-1debian7_all.deb
sudo dpkg -i mysql-apt-config_0.3.7-1debian7_all....
- 53
5
votes
1
answer
16k
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@...
- 1,063
4
votes
4
answers
41k
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 <...
- 41
4
votes
1
answer
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 ...
- 43
3
votes
1
answer
3k
views
I cannot install a very popular component, libmysqlclient-dev. What's wrong?
On an up to date stretch, I want to install libmysqlclient-dev libmysqld-dev, but apt tells me it was not available in my sources.
/etc/opt/sources.list looks like this:
deb http://raspbian....
- 175
3
votes
4
answers
5k
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 ...
- 31
3
votes
1
answer
9k
views
Where can I find mysql-devel?
I installed mysql / apache and php. It is all working fine but now I want to use mysql calls in C programs. Therefore I need mysql-devel. Can't find it.
- 43
3
votes
2
answers
17k
views
PHP-version on Raspberry Pi different in phpinfo()
I have a Raspberry Pi 2 where I want to run my backend for an application on. This needs php 5.6 to run correctly, otherwise it will just not work. I installed PHP 5.6 on this Raspberry Pi, but now I ...
- 133
3
votes
4
answers
5k
views
Can Raspberry Pi Model B be used as JEE applications web server?
I have learnt how to develop web applications with JEE technologies, working in Eclipse IDE, using Apache TomEE server and MySQL database. Until now, I was using local server instance.
I don't have ...
- 133
3
votes
1
answer
6k
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 ...
- 177
3
votes
2
answers
211
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 ...
- 35
3
votes
2
answers
6k
views
Failed MySQL install (Raspbian)
I finally got a Raspberry Pi for Christmas and decided to set it up as a home web server. I have nginx with PHP set up and working. I came to install MySQL and ran sudo apt-get install mysql-server.
...
- 141
3
votes
0
answers
159
views
Local LAMP server slow on mobile devices
I set a local lamp server at my raspberry 2 B. I uploaded a HD media file in it is working well when I browse I can watch video well. My problem is I am connecting to raspi by wireless and it is ...
- 49
2
votes
2
answers
2k
views
Control GPIO from outside home network
I'm not exactly the most knowledgeable on the server-side aspects of how this kind of thing should/would work, but I do tend to pick things up pretty quickly.
I've played around with WebIOPi and a ...
- 161
2
votes
1
answer
7k
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 ...
- 169
2
votes
1
answer
5k
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 ...
- 173
2
votes
1
answer
1k
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 ...
- 173
2
votes
2
answers
348
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 ...
- 141
2
votes
3
answers
3k
views
MySql backup database every night
I have service and MySql database on my Raspberry Pi 2B. Yesterday, my SD card in my phone died.
I started thinking about database backup on my Raspberry Pi.
Anybody have any experience with this? I ...
- 121
2
votes
1
answer
3k
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 ...
- 21
2
votes
1
answer
10k
views
How to connect to MySQL from Python (3)? [closed]
I believe the preferred way to connect to MySQL database from Python is with MySQLdb.
I'm relatively new to Python programming and it also seemed to be advised to write for Python 3, so I've been ...
- 353
2
votes
1
answer
5k
views
Establish connection between Qemu Raspbian machine and Host
Objective: I would like to install several virtual (emulated) Raspberry machines on the laptop, connect them to each other and to the laptop. Afterwards I would like to send tcp packets from virtual ...
- 123
2
votes
1
answer
2k
views
How to merge port 80 and port 8080? [closed]
i would like to seek your opinion on this as I have little idea about the whole structure and not sure where to find more information.
Currently I have this problem of having both Apache2 and ...
- 401
2
votes
3
answers
1k
views
How can I share data between a network of Arduino and Raspberry Pi temperature monitoring stations?
I am planning on doing an internet connected temperature monitor (among other data) at multiple locations. At two of the locations I want to use a Raspberry Pi to display the information. The ...
- 196
2
votes
0
answers
974
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 ...
- 143
2
votes
0
answers
122
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 ...
- 121
2
votes
1
answer
263
views
Problems with server services on Raspberry Pi3 [closed]
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 ...
- 21
2
votes
0
answers
420
views
Segmentation fault caused by libmysqlclient.so or libcofi_rpi.so
Was getting a segmentation fault in a program that has traditionally run fine on most flavors of linux. Running ADB revealed that this seems to be caused by libmysqlclient.so using memcpy incorrectly, ...
- 293
2
votes
0
answers
4k
views
HTML Button onclick function()
I would like to seek help on my Web Control Interface - LED On and OFF button REST API. I just started node.js two weeks ago and manage to created a basic REST API. It manage to display mySQL database ...
- 95
2
votes
2
answers
1k
views
Cannot start mariadb - timeout [closed]
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 ...
- 121
1
vote
2
answers
8k
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 ...
- 11
1
vote
2
answers
389
views
Trouble installing MySQL
I am following this guide, How to set up a web server on the Raspberry Pi. I am using a Pi 400 so I skipped step 1.
Step 2 involved running:
sudo apt install nginx
which was successful. Now if I re-...
- 9
1
vote
1
answer
393
views
Use actual MySQL on Raspbian Stretch instead of MariaDB
I have a web based project which I wrote with NodeJS. I moved the project to my Raspberry Pi which runs on Raspbian Stretch. The project has a lot of lines of code which deal with MySQL connections. ...
- 143
1
vote
3
answers
3k
views
How do I build Qt's mysql-plugin on Raspbian Buster
I try to build the MySQL plugin on a Raspbian Buster with C++ and Qt 5.12.4. Building Qt itself worked fine by following this tutorial: https://www.tal.org/tutorials/building-qt-512-raspberry-pi
...
- 43
1
vote
3
answers
522
views
Wordpress not working after PHP update
I recently upgraded PHP5.X to PHP7.3 on my Pi 3 and also moved to Raspbian Buster from Jessie.
Now I get this message when I try to open the port 80 where I could earlier see my Wordpress site.
Your ...
- 398
1
vote
1
answer
61
views
Linux programming concept approach [closed]
I am working on an IoT project using a Raspberry That connects to a couple of sensors gathers data, saves into a local database then at the end of the day sends all the data to a remote server. ...
user114087
1
vote
1
answer
5k
views
Connect to mySQL from Win 10 IOT
How can I connect to a mySQL Server from a Windows 10 IOT Universal app? The official mysql.Net connector doesn't work for WP projects. The error from nuget is: MySQL.NET 6.6.4 is not compatible with ...
- 153
1
vote
2
answers
8k
views
Database for raspbian accessed with the same raspberry pi
Here's what it want to do. I'm using my raspberry pi kind-of as another computer. I'm not using it as a server. I'm not accessing it remotely.
And I don't care to do either of those as of this ...
- 13
1
vote
1
answer
2k
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 ...
- 325
1
vote
1
answer
7k
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 '...
- 111
1
vote
1
answer
1k
views
Error when trying to install mysql-server
I'm trying to install mysql-server package using sudo apt-get install mysql-server on my Raspberry Pi (Raspbian Jessie), but I encounter the following error :
dpkg: error processing archive /var/...
- 111
1
vote
1
answer
867
views
Syncing backups to cloud storage
I am about to embark on a project which will require a lot of documentation and since I have a spare Pi, I think it would be really useful to use it to store this documentation in a custom MySQL ...
- 253
1
vote
1
answer
1k
views
Wordpress error: "PHP installation appears to be missing the MySQL extension which is required by WordPress."
I tried to created a LAMP web-server with Wordpress following that guide: https://projects.raspberrypi.org/en/projects/lamp-web-server-with-wordpress/6/. But when I used this command to install MySQL: ...
- 121
1
vote
2
answers
13k
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.
...
- 11
1
vote
1
answer
684
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/...
- 11