Questions tagged as 'mysql'

0
answers

Connect mysql with apache spark using python? [closed]

I am starting to use spark for some data response problems that we have since mysql . I have consumed tables that I exported with phpmyadmin to son but I want to connect directly to my localhost to consume the database...
asked by 17.06.2016 / 22:29
1
answer

Access denied error 1011 when obtaining an image with file_get_contents?

I would like to know why I can not access the image and show it, every time I run the script the image is not displayed and when I open it from my host I get the following:    Error 1011 Ray ID: 2c82fb8597081629 • 2016-07-25 22:17:31 UTC   ...
asked by 26.07.2016 / 00:25
1
answer

Error in LOAD DATA LOCAL of MySQL

I'm using LOAD DATA LOCAL INFILE , to fill a table and to try it I use a text like this: kffokwofkwf "hostname" ksakosak "IP" kdosko _ "mac_eth"____ ______ "mac_wifi"_ Which I have in my table 5 fields: (ID AUTOINCREMENT, HOSTNAME,...
asked by 11.06.2016 / 23:55
1
answer

How to prevent mysql from always connecting to localhost?

I'm trying to do a mail service and I'm using dovecot but at the moment of wanting to login as a dovecot user it always throws me the same error posftfix @ localhost does not exist which is true because it is not using my domain. Try to enter...
asked by 23.11.2017 / 20:07
1
answer

JPA / MySQL define Time zone for type TIME?

I have a front-end application in AngularJS and a back-end in Java, using Spring. Technically I have the model of the application made with JPA, my conflicting attribute is the following: @Column(name = "hora_inicio") @Temporal(TemporalType...
asked by 20.05.2016 / 23:51
2
answers

Problem with select without where to a database from php

<?php $mysqli = new mysqli('localhost','root','alumno','radius'); if (mysqli_connect_errno()){ echo "Fallo al conectar a MySQL:"; exit(); } $query="SELECT id,nombre,autor FROM canciones"; $stmt=$mysqli->prepare($query); $stm...
asked by 07.06.2016 / 15:57
0
answers

doctrine: mapping: convert, error password

I am trying to do a mapping on the mac console, for Symfony3, and it is giving me access denied access error all the time, it tells me that no password is used, when really in my main root if it has a password. I pass you screenshot p...
asked by 28.04.2016 / 23:56
0
answers

Problem with captive portal + mysql using varying logued

I am using pass as the main firewall for my project end of cycle and I have a first problem. The captive portal when I create it initially cuts the network to all those who are inside the network, that's fine, but the portal that should be autom...
asked by 17.05.2016 / 16:48
2
answers

SELECT .. JOIN to relate 2 tables

Good evening, I have a problem because I currently have two tables in mysql and at the time of making the query I can not make them show me all their data because I do not know how to relate them. The primary keys are CedulaAlumno and CedulaRepr...
asked by 17.05.2016 / 02:05
2
answers

How to concatenate a value with the ORDER BY? - Nodejs

What would be the correct way to concatenate the value that I have in the constant data in my MySQL query? The way I'm doing does not work. const data = req.body; req.getConnection((err, conn) => { conn.query('SELECT * FROM ordenar_usu...
asked by 02.11.2018 / 19:40