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
1answer
21 views

validate a mysql regular expression

I have a php5 app which performs mysql searches, and I give the user the possibility to enter a regular expression to use with RLIKE. I want to be sure that the regular expression is valid, in order ...
0
votes
0answers
121 views

how install only json extract_json_value function from common_schema for MySQL?

There are some risks during install common_schema. What if extract_json_value only needed? Can it be installed with it's dependencies without any code which affect MySQL critical tables?
0
votes
0answers
69 views

MySQL Service won't start

I want to learn SQL and when I tried to start it with help of some YouTube videos it always display same error. I tried to find solution on internet, but i haven't found anything yet. Here is the link ...
0
votes
2answers
101 views

Strange error from Easy Tomcat 7 connecting to MySQL database

I'm fairly new to Java servlet and web app development, but this is puzzling. I have built a project in Eclipse (Mars) that consists mostly of static HTML pages with one JSP that contains a form that ...
0
votes
0answers
63 views

Configure SSL on Amazon RDS

I would like to force all users to connect to my Amazon RDS instance via SSL, otherwise the connection should not be established. I believe I have enabled SSL on the RDS instance which can be ...
0
votes
0answers
4 views

Setting up event capturing and sharing mobile App

Assumptions 1 Messages are 10MB max size 2 Assuming 30 % of users are creators for original creative contents 3 Assuming 70% of users are consumers 4 Assuming 80% of the users forward their ...
0
votes
0answers
48 views

What does “losing a second of transactions” mean in MySQL?

Setup: Homeserver with Owncloud using MySQL as database. Problem: I/O on server HDD slows sync down to several days per 70k small files. Solution: ...or at least a workaround that I found is to ...
0
votes
1answer
59 views

ssh port forwarding through a pseudo terminal

Here's a situation: I do all my work on a Mac. There's a certain linux server 'server01' that provides access to another linux server 'server02' via a pseudo terminal So, to ssh into ...
0
votes
1answer
436 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
453 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 ...
0
votes
0answers
78 views

Cant connect to local MySQL “only” when connected to VPN on VM?

Setup: MySQL installed on my Mac using Xammp Virtual Machine installed using VMware Fusion running Windows XP. I am able to connect to the MySQL database (192.168.0.11) through my VM normally. ...
0
votes
0answers
21 views

Installing C4G blis into an online server running on Ubuntu

Hi I have downloaded this application called c4g bliss from http://blis.cc.gatech.edu/download.php However it only works as an executable local application. the way it does this is by running ...
0
votes
0answers
161 views

How to uninstall a manual configuration of PHP 5.2.17 on CentOS 6.7 (Final)

Centos 6.7 (Final) comes with PHP 5.3.3, but the site running on the server needed PHP 5.2.17. Because it is not supported much anymore I manually configured PHP 5.2.17 using this guide: PHP ...
0
votes
0answers
18 views

MySQL Query to Find Distinct Instance of Status

My question is regarding a MySQL query that I am trying to write. I have written some psuedo-code to help illustrate what query I am trying to write: SELECT * FROM persons AS p INNER JOIN ...
0
votes
1answer
81 views

Can't dump to file despite mysqld running as root

TL;DR I don't understand how mysql running as root@localhost would not be allowed to write to /usr/lib/? Writing a file there is a common step in going from SQL injection to root shell. Details ...
0
votes
1answer
206 views

Understanding the use of gearman with memcached as persistent storage

I have configured Gearman on my Centos environment with both client and workers running on the same machine. It runs fine. I am trying to use gearman with memcached persistent storage. I have ...
0
votes
0answers
113 views

Mysql won't start on CentOS 6.7 running Plesk

I have a Plesk server, and yesterday I tried to update it to the newest version. After a couple of tries, I couldn’t reach my Plesk panel anymore. Getting this error: ERROR: ...
1
vote
0answers
42 views

Could not initialize MySQL client library in Justhost

I am trying to configure redmine in justhost. following link was used for configuration. Link: https://my.justhost.com/cgi/help/redmine I am getting error - Could not initialize MySQL client library. ...
-1
votes
2answers
49 views

MySQL crashes on Windows boot

Migrated from Stackoverflow My setup is the following: Windows 8.1 Pro OS Main HDD 500GB split in two partitions (C: and D:), in order to be formatted without losing data Both partitions ...
0
votes
0answers
21 views

Find out if any tables have been updated in your database with new data

MySQL mysqladmin Ver 8.42 Distrib 5.6.25-73.1, for Linux on x86_64 Is there a (i'm sure there is) cmd in ssh (putty) that allows you to search the whole db for any new insertions or updates to ...
0
votes
1answer
73 views

Two MySQLs after updating to El Capitan

I installed MySQL with brew install mysql in Yosemite and working fine. After updating from Yosemite to El Capitan, I uninstalled mysql and installed it again. Now I am not able to connect to MySQL. ...
0
votes
0answers
69 views

Mysql crashed and can't be restarted after trying to access database from phpMyadmin

I was trying to edit an entry in one of my mysql databases on my pc from phpMyadmin but when I clicked on the database MySQL crashed and since than it can't be restarted. (MySQL ver. 5.6.26 x64 on ...
0
votes
1answer
58 views

what will happen when two users submit same form and the php code having more than one queries will be executed on the server?

I want to ask that what will happen when two user will submit the same form and then the php code having more than one queries in more than one for loops and if statements which alter the table data ...
1
vote
0answers
39 views

How to know what application is injecting a script on html

I'm trying to figure out what application is injecting a javascript called http://queryjs.me/services/script.js into my pages on localhost and on my server. It only injects this script when the ...
0
votes
2answers
259 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
69 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
75 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
649 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
2k 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
649 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
598 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
466 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
109 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
108 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
1k 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
74 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
940 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. ...
7
votes
2answers
5k 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 ...
-1
votes
2answers
61 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
103 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
61 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
80 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: ...
0
votes
0answers
16 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
143 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
465 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 ...
6
votes
1answer
2k 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
69 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 ...