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

learn more… | top users | synonyms

2
votes
3answers
7k views

mysql (mariadb) ERROR 1698 (28000): Access denied for user 'root'@'localhost'

I'm working on Xubuntu 15.04. I already installed the MariaDB-Server on various systems and was always asked for a root password during installation. This time, however, I don't remember being asked ...
0
votes
0answers
37 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
1answer
23 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
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("-","-","-","...
13
votes
3answers
7k views

Can't reset MySQL (MariaDB) root password

Today, I wanted to create a database in PMA. It said: "Cannot log in to the MySQL server". I tried via a terminal, same problem, and it is because my password is wrong. And I can't understand why. I ...
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....
-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....
0
votes
1answer
9 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
2answers
3k views

MySQL ODBC driver 5.1 and Windows 7

I successfully installed the MySQL ODBC 5.1 driver for Windows: But unfortunaly it doesn't appear in the ODBC Data Source Administrator of Windows (yes, I even did a log off + log on): Why?
2
votes
2answers
1k views

MySQL - Can't turn off skip-networking

I'm trying to configure a freshly installed mysql server to listen on port 3306. I've removed skip_networking, I have bind-address=127.0.0.1 and it completely ignores the config... When I try SHOW ...
0
votes
1answer
17 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
2answers
244 views

User cannot login to MySQL from localhost with Host set to %

I installed XAMPP 5.5.24 onto another machine (OS X 10.6.8) recently. I created the DB for my application and a user for connect to it. However, I was facing the following problem: The user was not ...
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
0answers
29 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 ...
7
votes
3answers
3k views

MySQL instance lost when upgrading to Windows 10

I had a running instance of MySQL 5.6 in my Windows 8.1. After upgrading to Windows 10, such instance is gone, including the Windows service for it. Server data files are however intact. What would ...
0
votes
1answer
31 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
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 ...
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
0answers
26 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
1answer
594 views

How to log postfix messages to a database?

mysql -u root -p postfix < /usr/share/doc/packages/postfix-mysql/postfix-mysql.sql +-----------+--------------+------+-----+---------------------+-------+ | Field | Type | Null | Key |...
0
votes
1answer
3k views

How to resolve Apache Service path conflict - running both Apache and portable XAMPP on Windows 7

I've got Apache 2.4.7 (Win32) running on Windows 7 and a visiting portable XAMPP on an external drive. After resolving the port issues I'm "only" down with having the "Apache/MySQL Service detected ...
0
votes
1answer
7k views

Curl returns “Connection Refused” when trying to access XAMPP via localhost

I am running XAMPP (Apache, MySQL and PHP) on my Windows Vista computer. I have curl installed on my machine. When I try to curl my localhost in the command prompt, I get the following: curl -v -i ...
20
votes
1answer
74k views

How to manually install Apache, PHP and MySQL on Windows?

How do I install Apache with PHP support and the MySQL server on Windows without using any ready-to-use packages like WAMPServer or XAMPP ?
3
votes
1answer
5k views

MySQL Notifier High Severity Error at startup

When I start MySQL Notifier up, an error like this is shown: "High Severity Error" "Object reference not set to an instance of an object." And when I click over "Show Details" I can see the ...
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
2answers
477 views

#126 - Incorrect key file for table '.\mysql\db.MYI'; try to repair it

I posted my question on serverfault but they hold my question by advising to post it in SuperUser I installed Xampp and can see localhost page as well as both apache and mySQL is starting fine but ...
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
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 ...
1
vote
1answer
64 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 ...
1
vote
1answer
100 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
44 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 ...
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 ...
4
votes
1answer
5k views

Installing MySQL 5.1 on Mac OS X 10.7 (Lion)

I am trying to install MySQL 5.1. I am on Lion, and when I remove all files associated with MySQL on my machine it still tells me that I have a newer version installed when I try to install it from ...
0
votes
1answer
84 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
104 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
13k views

Specified port 3306 is already in use when installing MySQL 5.6

How can I solve the problem when I try to install MySQL 5.6 and it tells me that the specified port 3306 is already in use. I uninstall my previous MySQL which is version 5.1 already and I do not have ...
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
41 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=...
12
votes
2answers
53k views

MySQL InnoDB lost tables but files exist

I have a MySQL InnoDB which has all the database table files, but MySQL doesn't see them, and isn't loading them. The problem happened because I deleted these three files: ibdata1, ib_logfile0 and ...
0
votes
2answers
11k views

Where are logs of MySQL ? Fedora

Hello I just installed MySQL on my Fedora from Source, with cmake,make,make install etc. It's working, but where can I find logs of the server? I have looked into /var/log, but there is nothing with ...
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 ...
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
37 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 ...