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

learn more… | top users | synonyms

1
vote
1answer
30 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
0answers
30 views

unable to install package snort-mysql

I'm trying to make IDS using this guideline "https://raspberriguy.wordpress.com/2014/02/" on a Raspberry Pi 3 running 2016-03-18-raspbian-jessie-lite When trying to do: sudo apt-get install snort-...
0
votes
1answer
29 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 ...
0
votes
0answers
36 views

Connecting a mysql RPI database to Dundas by Enabling SQL Server Authentication Through Microsoft SQL Server Management Studio SSMS

Setup: Raspberry Pi 2 Model B V1.1 Raspbian Jessie Version March 2016 Hi I am new in the RPI world, I managed to setup 2 DHT22 temperature sensors connected to GPIOs 22 and 23, 2 analog temperature ...
2
votes
2answers
75 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 ...
0
votes
0answers
38 views

Create .deb after compiling MariaDB 10.1.13 in Raspbian Jessie

Finally, I managed to compiled and install MariaDB 10.1.13 in Raspbian Jessie, folowing this steps http://kyuhyuk.kr/392, with several changes.Now the next step is create a .deb for share with the ...
1
vote
0answers
46 views

RPi PHP to run Python script help [closed]

I've been developing a temperature logger that takes readings from an Arduino and sends them to my LAMP server I've set up on my RPi and I store them in a MySQL database. I've got the basics set up ...
1
vote
1answer
126 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 ...
6
votes
1answer
2k 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 ...
2
votes
0answers
53 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 ...
3
votes
2answers
290 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 ...
1
vote
1answer
292 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/...
0
votes
1answer
18 views

Where can I find a linux tar file for MySQLd to go with MySQL 5.5 and Python 2.7?

I have MySQL 5.5 and Python 2.7 installed on RPi. I just need to connect Python to MySQL. I keep reading about MySQLd and MySQL Connector. I think I'd prefer to go with mysqld from what I'm reading, ...
0
votes
2answers
54 views

Did MySQL server cleanly install?

okay so I'm fairly new to the raspberry pi. I went and tried to install a MySQL server. sudo apt-get install mysql-server python-mysqldb the first time I tried it failed. So then I went and ...
1
vote
1answer
951 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 ...
3
votes
2answers
2k 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....
0
votes
1answer
72 views

PL/SQL in Raspberry Pi

Is there any way, by which I can execute PL/SQL commands in Raspberry Pi? I know that MySQL, and SQLite doesn't support PL/SQL, so are there any other means by which I can execute PL/SQL commands in ...
2
votes
0answers
94 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, ...
1
vote
1answer
2k 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 ...
1
vote
2answers
1k 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 ...
0
votes
0answers
41 views

mySQL keeps crashing on every clean shutdown

I have got a problem shutting down my B+ kernel 4.x Pi. There is about 50% chance that mySQL Inno tables will be corrupted on next start up. Any ideas ?
0
votes
1answer
561 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.
1
vote
2answers
13k views

Raspberry PI 2: Installing mysql-server

I'm trying to install MySQL on a raspberry PI 2. First I tried the obvious and just ran: (sudo apt-get install mysql-server). That ultimately fails, looking like this: -----NOTE----- The picture ...
0
votes
1answer
194 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 ...
0
votes
1answer
222 views

Webserver wth phpMyAdmin running. How Do I Connect to the database I created? [closed]

I have my raspberry pi running a webserver publicly with a domain name. I also successfully installed phpMyadmin and created a database with the tables I need and also a server following a few ...
-2
votes
1answer
2k views

Phpmyadmin mysqli extension error

Oh this way to make code on this site... I followed tutorial on this site to install phpmyadmin: http://www.raspipress.com/2012/09/tutorial-install-phpmyadmin-on-your-raspberry-pi/ Here it's what I ...
1
vote
0answers
1k views

Installing MySQL server in latest (NOOBS) Raspbian

Here I was, following this tutorial (http://www.penguintutor.com/linux/raspberrypi-webserver), because I wanted to host a pretty simple PHP site on my Raspberry Pi. But once again, as it usually ...
1
vote
1answer
2k 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 ...
2
votes
0answers
1k 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 ...
0
votes
1answer
147 views

Need advise for Web Control REST LED Switch

I would like to seek for advise and help on REST API - Web Control Interface LED Switch. I been searching over the net and seems kinda lost, so I hope you guys could help me out with it as soon as ...
1
vote
0answers
334 views

Error git clone git@github.com/felixge/node-mysql

I would like to seek help on npm install felixge/node-mysql. I been trying to install mysql into Raspberry PI so that I can do node.js with mySQL for my REST API but this problems been there for 2 ...
0
votes
2answers
162 views

Error on displaying mySQL records in my REST API

I would like to seek help on my REST API. I have finished constructed my basic REST API for my Raspberry PI and able to work now, thanks to you guys. Now I would like to display mySQL database records ...
1
vote
2answers
710 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 ...
2
votes
1answer
779 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 ...
2
votes
4answers
1k 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 ...
0
votes
1answer
715 views

MySQL not starting after powering the Raspberry Pi off

I have a raspberry pi with MySQL installed. I turn off my raspberry Pi by unplugging the power (no system shutdown). At some points the MySQL get infected, and after that it will never turn on again....
0
votes
1answer
436 views

MySQL service stopping

I've had a couple of web apps running on my Raspberry Pi (lighttpd, PHP, MySQL) and have notice recently that the MySQL service dies or stops about once a week. I've checked the MySQL logs under /var/...
0
votes
1answer
2k views

SQLITE/PHP on Raspberry Pi

Wondering if this would be easy/possible. I know MySQL is commonly used but I want to make a sort of web server that can access the Raspberry Pi or more important an External Drive attached to it. ...
-1
votes
1answer
580 views

cloud raspberry pi

Basically, on the cloud, I want to execute a query and then take/emit result of the evaluation. To simplicity, I want use raspberry Pi as cloud server which stores database tables and can execute ...
1
vote
1answer
783 views

Installing PhpMyAdmin in conjunction with Nginx

I've got MySQL and Nginx installed on my raspberry pi, but I can't seem to find a guide that explains how I would install phpmyadmin with nginx on my raspberry pi, and be able to access it through ...
2
votes
3answers
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 ...
1
vote
2answers
3k 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. ...
17
votes
1answer
2k 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.
5
votes
2answers
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 ...