MySQL is an Open Source database now owned by Oracle. The MySQL documentation is expansive and incredibly useful.

learn more… | top users | synonyms

0
votes
0answers
31 views

mariadb server broken after failed package update

So I had a problem the other day when mariadb's server package failed to update correctly and would not longer run. Log started: 2016-07-19 04:00:34 Setting up mariadb-server-10.1 (10.1.16+maria-1~...
0
votes
0answers
30 views

MySQL & PHP, mysqli_num_rows always returns 0 [migrated]

I have a little problem with a basic register script that im writing and i cant seem to be able to fix it. Well, here is the code: <?php //MySQLi connection $con = mysqli_connect("-","-","-","...
1
vote
1answer
16 views

Use a .Properties File to pass values to a Batch File

What we’d like to do is to eliminate the need for embedding the User_ID, User Password, Host Server Name, and Specific Database names into our batch file when automating a backup from our MySQL Server....
0
votes
1answer
8 views

fatal error: 'mysql/mysql.h' not found (but added in path)

I use MAC OS X El capitan 10.11.5 I am trying to understand and execute some code on c++ (it is a lot of files and i am new to c++ a), but when i type "make" to compile everything, it returns the ...
0
votes
1answer
7 views

Remove duplicates in column of MySQL data

I have a MySQL database that was created from data output by another application. On of the columns is for an email address, however the data in this column is all duplicates. For example, the email ...
0
votes
1answer
15 views

Restarting mysqld on CentOS 6.6

I'm trying to restart my mysqld process on CentOS 6.6. I have root access to the server and when I run top, this is the first line: PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND ...
0
votes
0answers
22 views

Installing libmysqlclient18 on Ubuntu 16.04

I'm using Ubuntu 16.04. I'm trying to install mapr-metrics, which keeps failing because it requests libmysqlclient18 or 16, whereas apt-get install libmysqlclient yields libmysqlclient20. Is there ...
0
votes
1answer
29 views

MySQL Port 3306 on VPS not visible from remote

Newbie here, migrating my site from a shared host to a name-based virtual host on a new virtual private server (Linode) running Ubuntu 16.04. Apache is working. I have installed MySQL and created an ...
0
votes
0answers
20 views

How to update MYSQL-version on Raspian

I installed MYSQL 5.5.44 on Raspbian using this command line: sudo apt-get install mysql-server But I'm needing at least MYSQL 5.7.8. The version 5.7.13 might be better, so ... how to get this ...
0
votes
0answers
9 views

mysql does not display string variables only numerical

Just experimenting with mysql and batch file (call me nostalgic :-) ) echo SELECT some_field FROM some_table WHERE some_field like '%needle%' \G > command.sql mysql -s -q -h %svr% --user=%user% --...
-2
votes
2answers
30 views

How to connect multiple websites to one database in same server

What would you do if you have one server and multiple websites in that server and you want to connect all of the websites to one MySQL database in the server? I know it decreases the security but I ...
0
votes
0answers
24 views

Cannot access mysql in local database

I wroted python app which connect to mysql database (192.168.1.19 ubuntu) in my local network and make query. I tested my app on my computer (192.168.1.3 windows 10) and everything works properly. ...
0
votes
0answers
17 views

MySQL Monitoring (5.7) causing very high CPU useage when MySQL is Idle

I am running MySQL 5.7 on a Linux redhat machine, and the CPU usage went high for a period, when the database was idle - no queries running. %CPU PID USER COMMAND 79.5 88237 mysql /opt/mysql/...
0
votes
1answer
22 views

MySQL insert into table - syntax problems

$servername = 'edited'; $username = 'edited'; $password = 'edited'; $dbname = 'edited'; $name = $_POST ['name']; $email = $_POST ['email']; $number = $_POST ['number']; $manufacturer = $_POST ['...
0
votes
0answers
25 views

Failed to stop mysql-server.service: Unit mysql-server.service not loaded

I'm getting a weird error when trying to stop mysql-server with the service command: $ sudo service mysql-server stop Failed to stop mysql-server.service: Unit mysql-server.service not loaded. Is ...
0
votes
0answers
7 views

Bluespice administration issue when adding new groups

I have deployed MediaWiki and the Bluespice addon that comes with it locally. However when I log in with an administration account (sysop) and navigate to Group Manager and try and add a group I see ...
-2
votes
0answers
17 views

In MySQL Workbench 6.3, how do I create a ZERO to MANY relationship?

Yes, I know this question has been asked here: http://stackoverflow.com/questions/25086363/how-to-create-a-zero-or-one-to-many-relationship-in-mysql-workbench However, at least in MySQL Workbench 6....
1
vote
0answers
29 views

Reconnect to a running process

I was trying to import an SQL file to a MySQL replication server using mysql -u -p -h ... < my_dump.sql using a PuTTY client from my laptop. Unfortunately, my network cable got chewed by my cat, so ...
0
votes
0answers
22 views

MySql 5.6 - windows 8.1 can't access or copy ibdata1 file after force restart - cannot restart MYSQL

I'm having a serious problem with my MySQL server and my ibdata1 file. I had for force restart my development machine - as result I cannot restart my MYSQL server. When I restart my MySQL server - ...
0
votes
0answers
28 views

Variable WHERE in one query [migrated]

I'm trying to list a simple query. I have table "users" and columns: "name" and "payment" = (1/0) I want echo all and count how many have payment 0 and how many payment 1. I don't know where put ...
0
votes
0answers
43 views

MySQL 5.7 stuck forever “waiting for table level lock”

I have a webserver with a MySQL database. It holds several databases serving my various projects. Since Upgrading Ubuntu to 16.04 it has given me a lot of trouble in general. This question ...
1
vote
1answer
63 views

MySQL error, can no longer login as root

So I updated my MySQL and PHPMyAdmin yesterday and ever since then I cannot login to MySQL as root or any other username I have. I tried both phpmyadmin and the terminal and still cannot get in. How ...
0
votes
1answer
36 views

MySQL Workbench error for schema in database and table created from Workbench itself

Based on a database with a single simple table, created using MySQL Workbench (Community) version 6.3.7b1199-CE-64b connected to CentOS MySQL 5.1.73, I tried to use MySQL workbench to get information ...
1
vote
1answer
11 views

Build hash of lists, as for “all tags for id” with perl dbi

I searched around the dbi docs and googled around but could not find if there was a (dbi) native way of building up a hash of lists. The closest I can think of is fetchall_hashref but that overwrites ...
0
votes
0answers
100 views

How to disable secure-file-priv MySQL Ubuntu

Guys I have an application that use SELECT OUTFILE to be used as cache for another application, so, it outputs straight to /dev/shm/some/folder. As it runs on a background server, I have no issue ...
0
votes
1answer
82 views

Mysql 5.7 vs 5.5: simple query takes 50 times longer to run

I have a database "algebra" with a table "questions" with 1,033,990 rows. The records have an attribute 'solved' that is INT. I have a simple query select count(*) from questions where solved = 0 ...
0
votes
0answers
11 views

ERROR 1005 (HY000) at line 455: Can't create table 'bugzilla5.components' (errno: 150)

I ran into this problem while i was trying to import a dump file. I used the following command : #mysql -u bugzilla5 -p bugzilla5 < bugzilla.sql ERROR 1005 (HY000) at line 455: Can't create table '...
0
votes
1answer
40 views

mysqld looks for config file and data in wrong place

I have new MySQL portable located in D:\Apps\MySQL\mysql-5.7.13-winx64 and it has my.ini file in D:\Apps\MySQL\mysql-5.7.13-winx64\my.ini The content of ini file is follows: [client] port=...
1
vote
1answer
97 views

Horrendous decrease in MySQL Performance after upgrade to Ubuntu 16.04 MySQL 5.7.12

I have a development server that I recently upgraded from 14.04 to 16.04. I have a database 'algebra', which hosts data for my website algebra.com. It is a Q&A website that has Questions and ...
0
votes
0answers
11 views

MySQL dump saves only one item from tables

I'm trying to backup my MySQL db with mysqldump.exe using C:\xampp\mysql\bin\mysqldump.exe -u root -p2e970e822e1a8834203d06abb60f59ec mydb > mydb.sql I've also done cd C:\xampp\mysql\bin ...
0
votes
0answers
36 views

“require all granted” not working with dbd auth on my apache 2.4.1

I am replacing my old apache 2.2 server with a apache 2.4.1 server. I'm in the process of testing if everything i need is still working with apache 2.4. I have some pages secured with apache auth ...
0
votes
1answer
15 views

Postfix keeps saying wrong MySQL-Syntax

I have the following Postfix config-file to map an email to itself (All credentials are fictional): user = db_mailuser password = mailuser_password hosts = 127.0.0.1 dbname = mailserver query = ...
1
vote
0answers
19 views

MySQL doesn't seem to be executing commands

I am cleaning up a lot of my DB's/Tables, and have been running into an issue. When I execute most commands which change data on a table (i.e, DELETE FROM or UPDATE), the command returns as completed ...
0
votes
0answers
26 views

MySQL doesn't shutdown cleanly sometimes

I have a fresh install of Ubuntu 16.04 LTS Server x64 in a VirtualBox VM with its provided MySQL, without any additional databases currently. Sometimes the shutdown of MySQL itself fails with the logs ...
0
votes
1answer
40 views

Postfix setup with Dovecot, MySQL error when sending mail

So, following problem. I'm trying to setup a Mailserver loosely following this tutorial here: https://workaround.org/ispmail/wheezy/ The problem starts when I try to send my first testmail (inside ...
0
votes
0answers
18 views

checksetup.pl issue while updating bugzilla to 5.0.3

I have a problem with updating to Bugzilla 5.0.3. The problem is when I try to run checksetup.pl and this is the output that I get : Updating old chart storage format... Updating old charting data ...
0
votes
0answers
66 views

Can't connect to local MySQL server through socket - Fedora

I am a new Fedora user and I am installing ROR on my machine. But when I try to enter the following command rake db:create it shows the following errors. Can any one please tell me how can I solve ...
0
votes
1answer
120 views

Openshift portforwarding to remote access MySQL database

So a followup to my other question: http://stackoverflow.com/questions/37056763/cannot-remote-access-mysql-database-of-my-openshift-mysql-cartridge I've tried port-forwarding as suggested here: http:/...
3
votes
2answers
36 views

How to check every directory size using one shell command?

I want to get database sizes for - test, mysql, performance_schema, sakila, information_schema [root@linux data]# ls -ltrh 总用量 32M drwx------ 2 mysql root 4.0K 4月 27 17:44 test drwx------ 2 ...
0
votes
0answers
58 views

I am running Eclipse Mars 4.5 , My CPU usage goes beyond 100% and suddenly all system stops

My system Info:: Model: Dell vostro 1015 RAM: 4 GB (2 GB extended) Processor: CORE 2 Duo Software's installed Eclipse Mars(STS and M2E plugins installed) MySql Crome Quick Heal Antivirus I have ...
0
votes
1answer
31 views

Trouble installing MySQL through Cygwin on Windows 10 “error while loading shared libraries”

I'm running babun(cygwin based) shell on Windows 10, and trying to install MySQL. I've ran: $pact install mysql mysqld Which executed successfully. Now, when running: $mysql_install_db I'm ...
0
votes
0answers
31 views

How to use and IF statement in PHPMyAdmin

I am using the expression below in PHPMYADMIN with the intent to use it later in a PHP/MySQL application. It gives an error relating to the DECLARE statement in line 1. I've looked at example ...
0
votes
1answer
19 views

place the MySQL libraries in the correct location

Run the following command to place the MySQL libraries in the correct location: cp /usr/local/mysql/lib/* /usr/local/lib/ and I get bash-3.2# cp /usr/local/mysql/lib/* /usr/local/lib/ cp: /usr/...
0
votes
0answers
91 views

xampp myphpadmin and mysql server 5.7 not working together

I have MySQL Server 5.7 running on my windows 10 machine and I installed xampp 5.6. To start MySQL for phpMyAdmin I have to stop the MySQL57 service which uses port 3306 if it is already running. If ...
0
votes
0answers
12 views

mySQL ODBC driver is ANSI only

I just downloaded latest mySQL ODBC driver from here. When I tried to install it on my Windows 8.1 laptop the wizard from MSI said that it is an ANSI driver. Is Unicode version of the driver not ...
0
votes
1answer
44 views

mysql, tcp/ip, and passwords

I can't figure out why this is happening. My user has two accounts: ans@localhost for socket connections and ans@% for TCP/IP connections. My host name is valiant. mysql> select host,user,...
4
votes
1answer
47 views

How to combine the output of two querys in MYSQL when they have non-compatible conditions

I'm looking for some assistance in adding together the output of the two following queries. They have two incompatible conditions so I'm struggling to combine them in the one query. Total Revenue ...
0
votes
1answer
40 views

Set a password to a pre-hashed value in mysql

How can I set a mysql user's password using a pre-hashed password? ===== I've got a mysql database version 5.1.73 . According to the mysql documentation, in the newer versions of mysql, creating a ...
0
votes
0answers
67 views

mysql workbench 6.3 hangs on queries on percona mysql 5.6

So I have three computers: Windows 10 with MySQL Workbench 6.0 Windows 7 with MySQL Workbench 6.3 Windows 10 with MySQL Workbench 6.3 I also have three MySQL servers. version=5.5.35-33.0, ...
1
vote
0answers
17 views

How to install MySQL on separate box from IIS 7

I've got two servers running Server 2008 r2. I've set up one sever as the webserver with IIs7.0, asp.net, php, nodejs, etc. And I have put MySQL and MongoDB on the other server. As best I can tell ...