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
89 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
23 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
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
0answers
21 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 ...
-3
votes
0answers
15 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 [closed]

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
14
votes
4answers
34k views

How to drop all MySQL tables from the command-line?

Usually I open Terminal.app and connect to a remote MySQL database. Then I use this command to drop a table: mysql> drop table [table name]; But what I need is the command line to drop all ...
-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
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
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
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
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 ...
34
votes
3answers
360k views

mysql how to fix Access denied for user 'root'@'localhost'

Before I screw up something, when login using $ mysql -u root -p, and show databases: +--------------------+ | Database | +--------------------+ | information_schema | | mysql ...
0
votes
1answer
28 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 ...
0
votes
1answer
6k 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 ...
1
vote
1answer
3k views

Can I output results of a MySQL query to a Excel file via Putty?

I'm on a local windows machine. The MySQL DB is on a CentOS machine elsewhere on the same local network. I want to output the results of the query that I'm typing directly into Putty into an Excel (or ...
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
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
0answers
59 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
1answer
52 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 ...
2
votes
1answer
9k views

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

I've installed xampp on my MAC computer in my table I saw a word named user I clicked it and I saw that I was able to change from not having a password by default to using a password. I clicked it and ...
3
votes
2answers
1k 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 ...
3
votes
1answer
4k 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
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
2answers
3k views

csv file to phpmyadmin import error

here is the pattern of my csv file -------------------------------------------------------------- | col1 | col2 | | col4 | | ...
0
votes
2answers
315 views

Event ID 10 - Windows Event Viewer

I receive the following error every bootup which does a few minutes crash. It then also can occur later on which does a complete crash and it will not unfreeze until I restart. Event filter with ...
2
votes
2answers
3k views

Can phpMyAdmin be used to connect to a remote database?

I recently read this tutorial, which explains how one can easily reconfigure a local installation of phpMyAdmin to connect to a remote database. The functionality seems to be supported, but 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
80 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
36 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
80 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
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?
0
votes
1answer
107 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
20 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 ...
3
votes
2answers
10k views

WAMP MySQL service does not start

My question is similar to this. But none of the posted solutions worked. my.ini file is pasted here. 'mysql.log' is pasted here. The problem seems to be caused for no reason. I don't remember ...
0
votes
2answers
25 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 = ...
0
votes
0answers
51 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
80 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 ...
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
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 ...
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
2answers
4k views

What's the difference between .db and .sqlite files?

I had a look into a program's folder in Program Files of the Windows directory and I found that it has a lot of files with .db extension. I opened one with notepad and I saw that the first string in ...
0
votes
1answer
48 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 ...
0
votes
1answer
149 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 ...
2
votes
0answers
829 views

Row is not deleted in PHPMyAdmin

I have a problem deleting a row in PHPMyAdmin. When I click the 'Delete' button to delete the row, at the top it says Showing rows 0 - 0 ( ~1 total , Query took 0.0004 sec) SELECT * FROM ...