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

Find most common capitalizations of MySQL column value

Suppose I have two MySQL tables representing items of some kind, and the text labels that are applied to those items. It's a many-to-many mapping of items to labels, represented with foreign key ...
3
votes
1answer
36 views

Initialize MySQL database as non-root and run SQL server for testing

I want to do some MySQL-specific testing and need to run a fresh MySQL database as non-root user. I am using Debian Linux and expect one could start the mysql_install_db and other commands as normal ...
0
votes
0answers
69 views

MySQL Install DB Error 13 / 1005

I am trying to programmatically install multiple mysql databases on a Ubuntu distribution server via a bash script, and I keep hitting the ERROR: 1005 Can't create table 'db' (errno: 13) each time I ...
0
votes
1answer
202 views

XAMPP and MySQL workbench [duplicate]

Ok so I have this message error in XAMPP: 20:25:37 [mysql] Error: MySQL shutdown unexpectedly. 20:25:37 [mysql] This may be due to a blocked port, missing dependencies, 20:25:37 [mysql] ...
0
votes
0answers
67 views

XAMPP and MySQL

Ok so I have this message error in XAMPP: 20:25:37 [mysql] Error: MySQL shutdown unexpectedly. 20:25:37 [mysql] This may be due to a blocked port, missing dependencies, 20:25:37 [mysql] ...
0
votes
1answer
75 views

restoring a mysql db via powershell

Say I have the following command: "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysql" -u user --password=pass dbname < backup.sql It works fine in cmd but in PowerShell I get the following: At ...
0
votes
1answer
44 views

MySql - access denied, despite GRANT ALL

What am I doing wrong here? GRANT ALL PRIVILEGES ON *.* TO 'demoUser'@'localhost' REQUIRE NONE WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ...
0
votes
0answers
14 views

How do I address the java process warning and MySql conflict while deploying Hortonworks?

I have two nodes in AWS. I got a java process warning while registering and confirming hosts. Could this warning message, issued for the name node, be ignored please? Process Issues (1) The ...
0
votes
1answer
179 views

Connect database in another computer

I cannot connect the database in another PC. I already disabled the firewall and followed the instruction in another forum. Should I install software or third party software to connect the database ...
0
votes
0answers
51 views

How can I restore a MySql database dump direct from S3?

I have a gzipped database backup stored on S3 and would like to restore it to MySql without having to first download it due to disk space constraints. I tried the two commands below but got gzip: ...
0
votes
0answers
45 views

Failed to change password to MySql (Uniform Server)

I'm trying to change the root password of the MySql and is not working, i try using the UI in normal & safe mode, the last one seems to work to change the port in Apache last time that was a ...
-1
votes
1answer
72 views

How to Find a Backdoor in a Hacked WordPress Site with Debian [closed]

I think there was a backdoor created by the hacker which allowed them to bypass normal authentication. Wordpress 4.4.2 in apache2 with MySQL I install chkrootkit, rkhunter but finding nothing! I ...
0
votes
0answers
7 views

MySQL Connection staleness

I have a Java client talking to MySQL server, When we do master/slave flipping, connections are no longer valid and JDBC stays waiting for socketRead() forever, is there a way to make server configure ...
0
votes
1answer
21 views

Vagrant box not talking to mysql on Mac through 127.0.0.1

I'm running a vagrant box to host local sites. Importantly, the mysql server is running on the Mac, not the VM. When I've set the site configuration files to use localhost the site loads properly, but ...
0
votes
0answers
155 views

“waiting for the query to be executed”

I use Excel files which pull data from MySQL via MySQL's Download Connector/ODBC (MySQL's official Excel plugin). Whenever it connects to the remote MySQL server (on Google Apps), Excel gets stuck for ...
0
votes
0answers
16 views

How do I open in Excel data exported from MySQL workbench?

When clicking to Export Data, the default format is CSV, but when the data element is text that contains a double quote and/or newline, such characters are treated by common readers (e.g. Excel) as an ...
0
votes
1answer
18 views

Setting up mysql in path on OSX so it's included everytime I open terminal

I have installed mysql on my OSX 10.11 and I want to run it from the terminal, so I need to add it to my path. I have created a .bash_profile file in my home directory with the contents export PATH="/...
1
vote
0answers
320 views

Secure wifi connection with FreeRADIUS, MySQL, EAP-PEAP, TLS

I'm trying to setup a wireless network as shown in the picture and I'm struggling how to secure it. Picture of Wifi Network: My basic question is: How I can securely store passwords into MySQL ...
-1
votes
1answer
31 views

drop database via bash with dash in database-name

I have a variable in a script with the list of folder names with dash in their names DBDIR="some directory" dbdash=`ls -l $DBDIR | egrep '^d' | grep '.-.' | awk '{print $9}'` And I want to drop ...
0
votes
0answers
271 views

E: Sub-process /usr/bin/dpkg returned an error code (1) when trying to install mysql

I'm getting the following error message while trying to install mysql on ubuntu. I've tried apt-get clean, purge, -f & uninstall but i'm heading back to the same spot. Any help would be greatly ...
1
vote
2answers
47 views

Why am I getting this MySQL database creation error?

I have a redhat linux in AWS EC2. I created a few dbs yesterday for an application. Today, I am getting an error in creating a new database. mysql -u root -p pw: xxx CREATE testdb; I get an ...
0
votes
0answers
67 views

How to find bottleneck in mysqlcluster and apache/php server?

I have setup a mysql cluster 7.3.x with 2 Datanodes,2 SQL nodes and 1 Management Node in a LXD/LXC centos 6.7 containers and a separate Apache 2.2.x/PHP-5.5 web server. The website currently serves a ...
1
vote
1answer
34 views

CPU utilization - not getting load balanced

On Ubuntu 12.04 mysqld is using 100% of the CPU and I am wondering why it is not being load-balanced among the 4 cores. Is there way to do it manually? Or should I optimize MySQL?
0
votes
1answer
18 views

MS SQL equivalent of MyISAM?

I'm trying to port an old project from Linux onto current Windows (mostly as a learning exercise). The database side is all MySQL and every table uses TYPE=MyISAM, which I've done a little reading on ...
0
votes
0answers
126 views

Host “my ip” is not allowed to connect to this MySQL server

I have hosted my MySQL database on https://www.000webhost.com/ . I tried connecting the same using C# code , but getting error like Host "my ip" is not allowed to connect to this MySQL server . Please ...
0
votes
0answers
611 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
247 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 ...
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
78 views

Can't Locate MySQL History File [closed]

I need to find a SQL users password, I can't reset it. All I know is that there is a MySQL History file containing this information on Ubuntu 12.04
0
votes
0answers
60 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
36 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
37 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
59 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
15 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
70 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
22 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,...
-1
votes
1answer
68 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
1answer
21 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
164 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
10 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
306 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
122 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
28 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
587 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
110 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
95 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
353 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 ...