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
2answers
320 views

How to kill mysql with moving pid

I have multiple mysql instances running on OSX 10.10. /usr/local/mysql/bin/mysqld stop spits out a bunch of warnings and errors, I'm not sure if they're worth sharing. Here's the first error 16164 [...
2
votes
1answer
74 views

Set up MySQL slave to slave replication

I have two machines with MySQL servers instances A and B. I want to add another MySQL server C which should replicate from B rather than from A. I may stop B but not A. These are the steps I tried: ...
-1
votes
1answer
83 views

Accidently executed wrong command in Linux that delete all files

I made huge mistake today. Actually i have to delete a specific directory files but by mistakenly i have executed the below command, rm -rf /* I think, It started to delete all file from the root (...
0
votes
1answer
934 views

MySQL Workbench unable to restore workspace

Whenever I restart MySQL Workbench I get the following error: That error doesn't make any sense to me. I'm able to open E:\Users\user_name\AppData\Roaming\MySQL in Explorer, so if I'm able to open ...
-1
votes
1answer
3k views

Why is “mysqld.pid” and “mysqld.sock” missing from my system even though the values are set in “my.cnf?”

I was working on an answer to this question—on one of my Ubuntu 12.04.5 development servers—and realized that the MySQL install was not creating mysqld.pid and mysqld.sock files despite their paths ...
2
votes
2answers
813 views

How to automatically restart MySQL and MongoDB when being unresponsive?

I’m running a simple development server (Ubuntu) on which MySQL and MongoDB sometimes crash. I always restart them with sudo service mysql restart. Although I know I need to investigate why they ...
2
votes
2answers
814 views

Issues sending Latin accented characters (ã,õ,á,é,í,…) to a database table in PHP/MySQL

I am having problems making mydatabase table show Latin caracters. (ã,õ,á,é,í,…). I am using WAMP server with Apache 2.4.9 and MySQL 5.6.17. I have a simple form that I created in HTML and I have a ...
0
votes
2answers
593 views

Cannot find file “/etc/my.cnf” in MySQL 5.6 (mysql-5.6.26-win32)

I have read this article but I can not find /etc/my.cnf file/folder. I have mysql-5.6.26-win32. Which version of MySQL I have to download for editing this file?
0
votes
2answers
125 views

Inserting empty string as NULL to MySQL on Mac

I run into a strange problem. I tried to run the following statementon Mac: INSERT INTO table (field) VALUES ('') where field is numeric that accepts NULL value. I have a MySQL 5.5.40 installed on ...
0
votes
0answers
120 views

Cannot start old XAMPP after reinstall Windows

I have XAMPP located at D:\XAMPP. After reinstall Windows, I can't start that XAMPP anymore, in the XAMPP control panel, I quit Skype, changed its port to not use 443/80 port too, but it's not work. ...
1
vote
1answer
2k views

MySQL Workbench has stopped working the first time i want to run it

When i was installing MySQL Workbench i got this error : updating start menu link failed but i complete the installation till the end And after installing the program, i try to launch the ...
0
votes
0answers
105 views

Connect to MySQL server on Host via Host Only Network from Virtual Box guest

I have a Windows 8.1 host with a Centos 6.5 virtual box guest. I run a MySQL server on the host (actually on both, but the one I'm interested in here is on the host) and want to connect from the ...
0
votes
0answers
1k views

MySQL server will not start after upgrading to Windows 10

I had a MySQL server on my machine, and then I got the helpful free Windows 10 upgrade. I updated to Windows 10 and then I tried to start the server again after a reboot and I cannot get it to work. ...
8
votes
2answers
6k views

MySQL binds to port 3307 not port 3306

I am running OS X Yosemite 10.10.5 on a late-2014 Mac Mini. It's my development server. I've just installed MySQL on this machine: 'mysql --version' reports the version is 'mysql Ver 14.14 Distrib 5....
-1
votes
2answers
65 views

how to use the &command in SQL insert into statement?

what is the syntax of the insert into statement wherein SQL prompts for input? like for example, if I have attributes "name" and "age" in a student table and I write an insert query , SQL will prompt "...
2
votes
1answer
118 views

Can I use Window's Robocopy to safely backup MySQL tables?

I've got a MySQL database on a server running Windows 7, and I want to create a quick (but safe!) copy without shutting anything down. I issue FLUSH TABLES WITH READ LOCK, run Robocopy, then issue ...
0
votes
0answers
74 views

Share permissions with MySQL in data directory - OSX Yosemite

I would like to have full access (read/write) on everything in the MySQL data directory (/usr/local/mysql/data). Then an application running as "me" could create/edit/delete every data. I tried to ...
2
votes
2answers
2k views

Issues resetting the MySQL password on an Amazon EC2 'Amazon Linux' instance

Been fighting with resetting the root password for MySQL on an Amazon Linux hosted on EC2. Version: mysql Ver 14.14 Distrib 5.5.42, for Linux (x86_64) using readline 5.1 When installing, I ...
0
votes
0answers
18 views

How can I export my mysql database in webmatrix3

I created a database in webmatrix3 using mysql. Now I would like to generate .sql dump file to create the same database on another machine but I could not find any option to do that. How can I ...
0
votes
0answers
86 views

How can I export MySQL large database from remote server using only phpMyAdmin access? [closed]

My client give me phpMyAdmin access to do database related task. I am stuck to export the database because database size is very large. Client give me credential like followings: {ip-address}/...
0
votes
0answers
17 views

MySQL Installer Asks for Password But Does Not Seem to Set It

I'm using the MySQL Installer on Windows 8.1. I go through the installation steps for MySQL Server, including setting my password. However, when I go back to reconfigure my server through the ...
0
votes
0answers
164 views

Find missing sequence numbers in table mysql

I have a list like this 1 3 9 10 I want it to be like this 1 2 3 4 5 6 7 8 9 10 all the missing numbers will display I try the following query select l.IDBANK + 1 as start from _bank as l ...
0
votes
1answer
620 views

MySQL 5.6 on Windows fails on Security Settings

I'm installing MySQL 5.6 on Windows 8. I'm doing a completely generic install--I accept all defaults. Yet I get this error: Beginning configuration step: Applying security settings Attempting to ...
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 ...
1
vote
1answer
31 views

One server serves over multiple IPs

I am a software developer who happened to buy a dedicated server and 3 additional IPs to host 3 websites. Let's say the main IP is 1.1.1.1 and 1.1.1.2 to 1.1.1.4 for 3 websites. What I have managed ...
0
votes
0answers
84 views

How to track system uptime using a database

I know there are third-party companies that already do this, some even free. However, I want to monitor my own - for the sake of knowledge and experience in doing so. My goal is to setup a central ...
0
votes
0answers
180 views

VS2013 Developer Command Prompt PATH differs from cmd.exe PATH

On Windows 10, I installed MySQL server 5.6 with the VS 2013 integration option. Now when I open the VS2013 Developer Command Prompt, I get: 'MySQL' is not recognized as an internal or external ...
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
2answers
69 views

MySQL sum of column by distinct hostname and by latest date

I have a table that looks like this: DATE | HOSTNAME | MY_VALUE 2015-08-10 | host01 | 1 2015-08-10 | host02 | 3 2015-08-10 | host03 | 4 2015-08-11 | host01 | 7 2015-08-12 | host02 ...
0
votes
0answers
40 views

mysqld stops right after starting because of corrupted tables (disk full + hardware reboot) - how to fix it?

On one of my servers, the SSD was full and I wasn't aware of it. The high-traffic website became working really slow, then started displaying errors, because even the database couldn't save new rows. ...
0
votes
2answers
115 views

How to monitor mysql percentage disk utilization?

I am new to mysql world and not sure if there is a way to calculate mysql TableSpace/DiskSpace utilization in percentage. I am aware mysql does not provide upper limit or free space like Oracle DB, ...
0
votes
0answers
69 views

EC2 WP No errors in mysqld.log yet Error w/database connection?

System information: Linux - latest from AWS | Apache - 2.4.12 | MySQL - 5.5.42 | PHP - 5.4.42 memory_limit: php 128M | wp 64M Running new m3.medium instance and having the database connection issue ...
0
votes
0answers
169 views

OSX Homebrew MySQL Installation Gone Bad

I'm having issues with getting mysql installed properly under homebrew. I want homebrew to manage it, and I had it installed manually using the .dmg installer beforehand. I've backed up my data into ...
0
votes
0answers
45 views

MYSQL LongBLOB ,Search need to avoid image data

I am using Mysql longblob for store the content (image and text ) problem is , while I am searching a text through my appliction , if any word similar to the search string in longblob (image ...
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 ...
0
votes
0answers
22 views

How do I modify the definition of a view in Sequel Pro?

I just switched to Sequel Pro (OSX) from HeidiSQL (Windows), and can't seem to find an easy way to modify the base query of a view. Is there something I'm missing? Or do I have to drop the view and ...
0
votes
1answer
325 views

Upgrading XAMPP, mysql tables “lost”

To upgrade from my older XAMPP to a newer one, I renamed the folder C:\XAMPP to C:\XAMPP_OLD and installed the newer version with xampp-win32-5.6.8-0-VC11-installer.exe into C:\XAMPP. Then I ran ...
-1
votes
1answer
50 views

Trouble setting up the class path for MySQL and running MySQL via terminal

Question: what is the easiest way to run the MySQL app from the terminal What I have tried: Using some stackOverFlow suggestions I have used the following commands echo $PATH, produces /usr/local/...
2
votes
1answer
136 views

CentOS - Trying to backup/restore a MySQL database?

My CentOS 6 server got a server issue, so customer support took a backup of my server and reinstalled it. The backup is in a folder called /home/42406. I'm trying to find my MySQL database called '...
0
votes
1answer
112 views

Best way to implement a GUI under Debian Linux [closed]

I'm currently using Bacula backup software under Debian Linux, all is good except the fact that it doesn't come up with a GUI. I had a look at all existing GUI out there, but none of them is what I ...
0
votes
0answers
86 views

PhpMyAdmin unaccessible from Internet

I have read about and tried other configurations of the web-based PHPMyAdmin and they don't seem to work. My environment is a CentOS 6.6 with Mysql server installed and configured before PHPMyAdmin ...
0
votes
1answer
1k views

Merging two *.db files with same tables into one *.db file

I would like to combine two mysql database files (*.db) into a single database. Both databases have the same tables. Is there an easy way to do this?
0
votes
1answer
85 views

Excel Formula - Match

Can someone recommend a way to write a formula that will achieve the following. I can achieve these things individually but stringing together seems to be difficult. I have a list of orders with ...
2
votes
0answers
158 views

Logon and Logoff scripts not running

I have set SQL queries to run on logon and logoff using group policy editor. But sometimes scripts do not run. logon.bat @echo off echo INSERT INTO UPTIME(INTIME) VALUES(NOW()); > abc.sql mysql --...
1
vote
1answer
1k views

Invalid field count in CSV input on line XX in phpmyadmin?

I have a 16MB CSV file with 50,000 lines that I want to import into my database. I go to the PHPMyAdmin-Interface, choose IMPORT and set the correct options. The import fails with the error Invalid ...
0
votes
0answers
779 views

Arch (Linux): Failed to start verifying integrity of password and group files

I have just started installing arch and installed numerous programs, one of which is mysql. Upon starting linux, I recognized this error [FAILED] Failed to start verifying integrity of password and ...
1
vote
0answers
29 views

Find web server architecture [closed]

I am programming mostly small webs with php and mysql with 10 000 visitors per day. Now I have a web with 50 000 visitors per day and this number still increases. Visitors will load from 50 to 80 ...
0
votes
1answer
13 views

Error when trying to SET field in MySQL

I am trying to set the field block, in the table h8cyw_users, to 1 where the email field in both tables are the same. I am using the following script: UPDATE UPDATE table1 SET block='1' WHERE email ...
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
59 views

How to change readline scroll behaviour on OS X?

I'm SSHing in Mac OS X Terminal to two ubuntu servers, then I connect to various readline-enabled shells, like MySQL or Mongo clients. Recently, it seems that somehow the scroll behaviour changed. ...