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

phpmyadmin Fatal error: Uncaught Error: Class 'SqlParser\Lexer' not found

I'm a new XAMPP and phpmyadmin user and I don't know many things about networks etc but I am trying to install XAMPP to use phpmyadmin and learn to use it. The issue is that it was working fine at ...
0
votes
0answers
13 views

Installing Apache, MySQL, PHP and phpMyAdmin on El Capitan (Password Problems)

I am at my wit's end! I am fairly new to using a mac, and I've never set something like this up before, but I'm fairly sure I'm not an idiot. Every time I've tried to install this, I'd get all the way ...
-2
votes
0answers
14 views

VPS CPU HIGH LOAD

I got new vps with 256 MB RAM, 1 CPU core. I have few test php/mysql backend scripts, which is run by cronjob. But while running,i found that cpu usage are getting high to 10, and memory fulled. ...
0
votes
0answers
13 views

How to parse .tag file?

Our company has a deal with another company where we exchange data. I created a JSON file for them containing our data. They sent me back a .tag file containing theirs. I requested a common ...
0
votes
2answers
70 views

Cant Locate MySql History File [on hold]

I need to find a sql users password, I cant reset it. All i know is that there is a mySql History file containing this information. On ubuntu 12.04
0
votes
0answers
14 views

Remove data that created by Mysql into outfile?

I've created some files with into outfile command. Now I want to remove it. Is it possible? Thanks. UPD: I want to remove those outfiles so nobody will know they existed.
0
votes
1answer
23 views

How do I convert sql to excel syntax?

I have two sheets in an excel file, "sheet1" and "sheet2". The first sheet has a table called Oranges, it shows where the oranges were produced and where they were exported to: On the second sheet ...
0
votes
1answer
23 views

Backup MySQL, using Screen and Crontab

I'm trying to backup my database's table every day, using mysqldump, screen and crontab. If I run only mysqldump, it dumps correctly, but if I do it trough screen, the output file is blank. Editing ...
0
votes
1answer
27 views

Fully resetting MySQL

I've just spun up a CentOS 6 server. I installed mysql on it yum install mysql-server And after I started the MySQL service it spat out on STDOUT a bunch of stuff about the necessity of changing ...
0
votes
0answers
13 views

Debian Mysql and MariaDB installing

I'm researching over the internet about how to have 2 instances of databases like Mysql and Mariadb, actually there's one resource on MariaDB URL but it is for Centos. I need one step by step focus ...
0
votes
1answer
27 views

where is the my.cnf file for mysql server located on windows?

I'm running MySQL Server 5.6 on Windows 7 and would like to enable slow query logging. Unfortunately, it is not immediately obvious to me where the my.cnf file is. I see C:\Program Files\MySQL\MySQL ...
0
votes
0answers
21 views

MySQL for excel: import with many digits

I use MySQL for Excel to import data from MySQL to Excel In the MySQL I have this entry values 0.22 0.26 When I import the values to a Excel sheet, I get values 0,219999998807907 ...
-1
votes
1answer
24 views

MySQL and MariaDB instances on the same server

Is there any way to install correctly MariaDB and update MySQL 5.5 to any superior version,without altering my production database? I'm told MariaDB could be installed on the same server but I need ...
0
votes
0answers
5 views

Run PostgreSQL in Vagrant box with external shell provisioning [migrated]

I have been wanting to actually get a Vagrant box up and running on my PC for quite some time but I have failed to understand a lot of things but then I came across this guide: ...
0
votes
1answer
19 views

Cannot use mysql after removing root user from mysqld

I accidently removed root user from mysqld: DROP USER 'root'@'localhost'; Query OK, 0 rows affected (0.00 sec) Now I am unable to do anything (as expected), but I would like to understand the ...
0
votes
1answer
47 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
7 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
12 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
78 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
34 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
11 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
74 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
93 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: ...
0
votes
0answers
34 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
19 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
49 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 ...
2
votes
1answer
78 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
24 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
26 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) ...
3
votes
1answer
39 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 ...
0
votes
1answer
139 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
175 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
49 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
16 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
30 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
14 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
32 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
21 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
35 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
43 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
97 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
8 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
19 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
56 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
40 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
49 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
24 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
3 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
40 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
28 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 ...