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
172 views

Error: MySQL shutdown unexpectedly in xammp

Can anyone tell me why this is not working. I am using XAMPP and get this error message while trying to install SDK of Android Studio that may be causing the problem. Can anyone tell me why it is ...
0
votes
0answers
11 views

Magento backups with MySQL

I'm launching an online store using Magento. I plan to launch two Apache server instances using Apache and two mysql server instances. From what I've read, MySQL master-master replication does not ...
0
votes
0answers
16 views

MySql for Excel add in (select statement in column)

everyone, I am using MySql for Excel add in to append the data from excel to MySql. I would like to know is it possible to use select statement to select data from another table in MySql and append ...
0
votes
1answer
366 views

Mysql.sock missing - “Can't connect to local MySQL server through socket”

Operating System - OSX 10.11.2 MAMP version - 3.5 I'm following along with this guide, setting up wordpress with Xammp on PC and MAMP on Mac, where I'm in step "Mac - 4" is asked to input: "In ...
0
votes
1answer
135 views

How do I determine what's making the web server so slow (Apache)

I'm running Apache 2.4 (64bit) on a Windows server. It also uses MySQL 5.7 on the same server. It has been very, very slow recently to come up, but when I look at the access logs, there are very few ...
0
votes
0answers
35 views

Setup MySQL replication with VMware client and host

I have a laptop running Windows 8.1 64bit. What i plan to do is to install mysql server. and then i would install Windows 7 32 bit on a VMWare on the same laptop and will also have mysql server plus ...
3
votes
2answers
705 views

Access denied for user 'root'@'localhost' (using password: YES)

I am following the Moodle 3.0 dev installation. In the database setting process there is an error: Error: Database connection failed It is possible that the database is overloaded or otherwise ...
0
votes
1answer
2k views

How to uninstall MariaDB 5.5 completely (including configurations) from CentOS 7

I tried command yum remove mariadb mariadb-server It removed the client but failed to remove the server. error reading information on service mysql: No such file or directory error: %preun(...
0
votes
0answers
115 views

Brew update MySQL-Client fails lib_boost

I have a problem updating and i think the same appears during installation of the MySQL-Client. I have installed the MySQL-Client over Homebrew. It was working until the last version was released. Now ...
0
votes
0answers
22 views

Backup website running on Ubuntu / JBoss / MySQL

I have access to a server that our hosting partner is going to decommission. Website wont be used for a few months - and we want to ensure we have all the software required to setup the website again ...
0
votes
0answers
106 views

upgrading to MySQL 5.7 from 5.6

I downloaded MySQL Installer 5.7.10, thinking it'd update the version of MySQL I have from 5.6.27 to 5.7.10 and... it doesn't seem to be able to. I could manually backup my databases, uninstall 5.6....
1
vote
2answers
444 views

Sql Statements in MySQL, the use of the dot operator

The following is the sql statement that I found, and I am still learning SQL thus this might be a silly question for you. SELECT d.name, count(e.emp_id) num_employees FROM department d INNER JOIN ...
0
votes
2answers
30 views

SQL - How to Stop MYSQL from command line

I just noticed when I made an error statement, sometimes, it didn't stop or showed the error. Instead, the line kept going like this one mysql > UPDATE person ->SET birth_data = ...
1
vote
1answer
39 views

Download the output of a command line program using PuTTy/WinSCP [duplicate]

I have ssh-access to a linux server. My account is running out of free space and I am forced to remove some data from the server. I would love to download my mysql database (and delete if afterwards) ...
2
votes
1answer
112 views

Connection failed, Access denied connecting to MySQL via ODBC on Windows

I know nothing about MySQL or Linux and am tasked with migrating a MySQL DB to MS SQL. I found a tool for that but it requires an ODBC connection so I downloaded the MySQL Connector/ODBC and installed ...
-1
votes
1answer
635 views

How to setup a website server on local lan on Windows 8 - Apache.PHP.MySQL

Trying to setup a website server at home. Been trying this for weeks, but to no avail. If someone can help I will indeed be grateful, and I will wire over some beers if necessary. So, I have ...
0
votes
0answers
469 views

“Could not create unix socket lock file” with MySQL 5.7.10 on OS X 10.11.2

I've been trying to install MySQL 5.7 on OS X El Capitan using Homebrew, however when it came to getting the server up and running, I cannot seem to get a lock file created. When I run mysqld_safe, ...
1
vote
1answer
98 views

How to setup APACHE, MYSQL SERVER, PHP on Windows 8.1?

Trying to setup a website server at home. Been trying this for weeks, but to no avail. If someone can help I will indeed be grateful, and I will wire over some beers if necessary. So, I have ...
0
votes
0answers
23 views

LAMP server with remote MySQL on CentOS 6.4

I am pretty new to linux and LAMP setup. I want to setup a LAMP environment with AP on one linux server and M on a different linux server. I have a hard time finding a relevant document with such a ...
0
votes
0answers
81 views

PHP connect to mongodb

I have installed MongoDB on Server A on internet. I installed PHP/Mysql with Mongo PHP Driver on Server B on internet. When I want to run my code in local it works successfully but as soon as I ...
0
votes
0answers
24 views

combing result set of column1 containing same value but column 2 containing different value in mysql?

i want similar solution of problem defined at link How to combine values from multiple rows into a single row in Excel? but using mysql.
0
votes
0answers
34 views

How to install two Mysql in linux and how to tell which one to use?

I want to install mysql in linux but in my home directory.There is already Mysql installed when I am typing which mysql i am getting /usr/bin/mysql So how to change the installation ...
0
votes
0answers
32 views

Failed to Connect to MySQL with specific user

I have installed Workbench 6.3 on a Windows Server2012R2 and MySQL5.7 Server. I can access to the database with user "root", but not with user "client". "client" user has the following configuration: ...
0
votes
2answers
40 views

How to develop with php and MySQL on a mac

I have recently started using a Mac, moving over from Windows. On Windows I use XAMPP for php and MySQL. What should I use on a mac? I know Macs have built in php and the apache server but I am not ...
2
votes
0answers
110 views

MySQL password restrictions?

I installed MySQL 5.5 on a fresh VM running Ubuntu 14 LTS through apt-get. During installation, I set a root user password generated by a password manager. After installation, I could not access any ...
0
votes
0answers
199 views

Synchronizing local DB to web-based DB mysql/php

Here's the situation: I'm writing an app for people to use laptops to perform interviews/questionnaires in rural areas without internet access. If a laptop is online, we use the remote hosted ...
0
votes
0answers
10 views

Hide “doubled” Table Editor in MySQL Worckbench?

I am trying to hide the section below the first column editor. But i can't find any option. I tried to google, but no results for me :( MySQL Worckbench Table Editor I hope it's possible :)
0
votes
1answer
22 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
154 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
87 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
111 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
79 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
50 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
65 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
601 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
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 ...
0
votes
0answers
104 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
24 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
179 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
109 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 below....
0
votes
1answer
250 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
121 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
50 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
59 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 BitLocker-...
0
votes
0answers
22 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
75 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
86 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
61 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 ...