Raspberry Pi Stack Exchange
Raspberry Pi Stack Exchange

Questions tagged [mysql]

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

Is part of the LAMP software stack ("Linux, Apache, MySQL, Perl/PHP/Python") is MySQL a popular choice of database for use in web applications/servers.

99 questions
20
votes
1 answer

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.
CPRitter
  • 1,061
  • 10
  • 15
7
votes
1 answer

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 in @Sapher answer, but didn't work. Ign…
Galo Ciber
  • 71
  • 1
  • 4
7
votes
1 answer

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
Demetrius McCallister
  • 71
  • 1
  • 1
  • 2
6
votes
2 answers

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 update. I guess I'll need to compile MySQL myself. What…
mkoryak
  • 243
  • 2
  • 8
5
votes
1 answer

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@raspberrypi:~ $ mysql -u root ERROR 1698 (28000):…
Chad G
  • 1,063
  • 1
  • 7
  • 14
5
votes
2 answers

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 during installation (which I believe it should) and it…
Soma Zambelly
  • 153
  • 1
  • 1
  • 5
5
votes
2 answers

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.deb sudo apt-get update When I type in sudo apt-get…
cheezburger
  • 53
  • 1
  • 4
4
votes
4 answers

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 import MySQLdb ImportError: No module named…
เพชอน เพชอน
  • 41
  • 1
  • 1
  • 4
4
votes
1 answer

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 for the most part. I run into an error when trying…
NotCras
  • 43
  • 1
  • 5
3
votes
1 answer

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.raspberrypi.org/raspbian/ stretch main contrib non-free…
Jan
  • 175
  • 2
  • 9
3
votes
1 answer

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 for debian arm.
Steve Lloyd
  • 177
  • 2
  • 8
3
votes
4 answers

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 installed. This may mean that you have requested an…
Sam Driver
  • 31
  • 1
  • 2
3
votes
2 answers

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 solve this problem?
Tancredi
  • 35
  • 2
3
votes
0 answers

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 superfast at laptop but when i tried to connect from…
aeropi
  • 49
  • 1
  • 3
3
votes
2 answers

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. When setting the password I used a 32-character…
ClearCarbon
  • 141
  • 1
  • 5
1
2 3 4 5 6 7