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

“require all granted” not working with dbd auth on my apache 2.4.1

I am replacing my old apache 2.2 server with a apache 2.4.1 server. I'm in the process of testing if everything i need is still working with apache 2.4. I have some pages secured with apache auth ...
0
votes
1answer
10 views

Postfix keeps saying wrong MySQL-Syntax

I have the following Postfix config-file to map an email to itself (All credentials are fictional): user = db_mailuser password = mailuser_password hosts = 127.0.0.1 dbname = mailserver query = ...
-3
votes
0answers
20 views

Connection of database in MySQL [on hold]

I am new to MySQL. I have installed MySQL Workbench 6.3 CE and created a database and one table, and I'm trying to get data from window form application. Following is code for connectivity: String ...
1
vote
0answers
16 views

MySQL doesn't seem to be executing commands

I am cleaning up a lot of my DB's/Tables, and have been running into an issue. When I execute most commands which change data on a table (i.e, DELETE FROM or UPDATE), the command returns as completed ...
-1
votes
0answers
13 views

Connecting to MySQL using SQL Workbench/J with SSH tunnel

Using MySQL Workbench I can connect via TCP/IP over SSH to a MySQL server instance: ...
0
votes
0answers
12 views

MySQL doesn't shutdown cleanly sometimes

I have a fresh install of Ubuntu 16.04 LTS Server x64 in a VirtualBox VM with its provided MySQL, without any additional databases currently. Sometimes the shutdown of MySQL itself fails with the logs ...
0
votes
0answers
16 views

Service MySQL was not found on computer 'localhost' [duplicate]

I recently upgraded MySQL on my system and since then, whenever I startup my computer, I get a dialog box saying - Service MySQL was not found on computer 'localhost' When I click OK, I get ...
0
votes
1answer
23 views

Postfix setup with Dovecot, MySQL error when sending mail

So, following problem. I'm trying to setup a Mailserver loosely following this tutorial here: https://workaround.org/ispmail/wheezy/ The problem starts when I try to send my first testmail (inside ...
0
votes
0answers
11 views

checksetup.pl issue while updating bugzilla to 5.0.3

I have a problem with updating to Bugzilla 5.0.3. The problem is when I try to run checksetup.pl and this is the output that I get : Updating old chart storage format... Updating old charting data ...
0
votes
0answers
36 views

Can't connect to local MySQL server through socket - Fedora

I am a new Fedora user and I am installing ROR on my machine. But when I try to enter the following command rake db:create it shows the following errors. Can any one please tell me how can I solve ...
0
votes
1answer
48 views

Openshift portforwarding to remote access MySQL database

So a followup to my other question: http://stackoverflow.com/questions/37056763/cannot-remote-access-mysql-database-of-my-openshift-mysql-cartridge I've tried port-forwarding as suggested here: ...
-1
votes
0answers
12 views

Script for gathering data from one remote server and insert result into another one [on hold]

I looking for example/solution how to take data from one db and insert into another db. (both db are on a different server). Scenario: Connect to the remote DB and execute query SELECT Result of ...
3
votes
2answers
33 views

How to check every directory size using one shell command?

I want to get database sizes for - test, mysql, performance_schema, sakila, information_schema [root@linux data]# ls -ltrh 总用量 32M drwx------ 2 mysql root 4.0K 4月 27 17:44 test drwx------ 2 ...
0
votes
0answers
32 views

I am running Eclipse Mars 4.5 , My CPU usage goes beyond 100% and suddenly all system stops

My system Info:: Model: Dell vostro 1015 RAM: 4 GB (2 GB extended) Processor: CORE 2 Duo Software's installed Eclipse Mars(STS and M2E plugins installed) MySql Crome Quick Heal Antivirus I have ...
0
votes
1answer
15 views

Trouble installing MySQL through Cygwin on Windows 10 “error while loading shared libraries”

I'm running babun(cygwin based) shell on Windows 10, and trying to install MySQL. I've ran: $pact install mysql mysqld Which executed successfully. Now, when running: $mysql_install_db I'm ...
0
votes
0answers
8 views

How to use and IF statement in PHPMyAdmin

I am using the expression below in PHPMYADMIN with the intent to use it later in a PHP/MySQL application. It gives an error relating to the DECLARE statement in line 1. I've looked at example ...
0
votes
1answer
18 views

place the MySQL libraries in the correct location

Run the following command to place the MySQL libraries in the correct location: cp /usr/local/mysql/lib/* /usr/local/lib/ and I get bash-3.2# cp /usr/local/mysql/lib/* /usr/local/lib/ cp: ...
0
votes
0answers
58 views

xampp myphpadmin and mysql server 5.7 not working together

I have MySQL Server 5.7 running on my windows 10 machine and I installed xampp 5.6. To start MySQL for phpMyAdmin I have to stop the MySQL57 service which uses port 3306 if it is already running. If ...
0
votes
0answers
9 views

mySQL ODBC driver is ANSI only

I just downloaded latest mySQL ODBC driver from here. When I tried to install it on my Windows 8.1 laptop the wizard from MSI said that it is an ANSI driver. Is Unicode version of the driver not ...
0
votes
1answer
19 views

mysql, tcp/ip, and passwords

I can't figure out why this is happening. My user has two accounts: ans@localhost for socket connections and ans@% for TCP/IP connections. My host name is valiant. mysql> select ...
4
votes
1answer
44 views

How to combine the output of two querys in MYSQL when they have non-compatible conditions

I'm looking for some assistance in adding together the output of the two following queries. They have two incompatible conditions so I'm struggling to combine them in the one query. Total Revenue ...
0
votes
1answer
24 views

Set a password to a pre-hashed value in mysql

How can I set a mysql user's password using a pre-hashed password? ===== I've got a mysql database version 5.1.73 . According to the mysql documentation, in the newer versions of mysql, creating a ...
0
votes
0answers
43 views

mysql workbench 6.3 hangs on queries on percona mysql 5.6

So I have three computers: Windows 10 with MySQL Workbench 6.0 Windows 7 with MySQL Workbench 6.3 Windows 10 with MySQL Workbench 6.3 I also have three MySQL servers. version=5.5.35-33.0, ...
1
vote
0answers
15 views

How to install MySQL on separate box from IIS 7

I've got two servers running Server 2008 r2. I've set up one sever as the webserver with IIs7.0, asp.net, php, nodejs, etc. And I have put MySQL and MongoDB on the other server. As best I can tell ...
0
votes
1answer
23 views

Postfix ignoring virtual alias in MySQL database, returns error “Unknown user”

I set up a Postfix email server over a year ago following this guide: https://www.howtoforge.com/virtual-users-and-domains-with-postfix-courier-mysql-and-squirrelmail-debian-wheezy. The server has ...
0
votes
0answers
21 views

How to reset root pass when the db multi-master sync replication cluster is setup in MySQL Galera Cluster

I have installed MariaDB Galera Cluster in ubuntu 14.04. Multi-master sync replication cluster is setup but we have misplaced the root password. Would really appreciate if somebody could help ...
0
votes
2answers
28 views

Excel 2016 list of options for connection to DB has suddenly reduced, (MySQL, PostgreSQL)

I work with open source dbs such as MySQL or PostgreSQL as a back-end data storage with my excel 2016. I had the full list of connections to all different kinds of dbs but they are suddenly reduced ...
0
votes
1answer
88 views

Ubuntu can't install php5-mysql

Now, before someone marks this as a duplicate, I've been looking around on the internet for the last two days and have been unable to find a resolve for my issue. All I'm trying to do is simply get ...
0
votes
1answer
13 views

This is the task manager screenshot for my server. Will increasing RAM make a difference?

The server runs XAMPP (Apache and MySQL mainly). Lately the concurrent user count has increased, and the server crawls and sputters during peak load. It only has 4GB RAM though. So, my question is ...
-1
votes
1answer
20 views

How to work in team on one VMware image?

For one project, four of us got project to work on VMware virtual image, OS is CentOS. We have to do our project in MySQL workbench, R language, and some other programs. What is the best way work ...
0
votes
1answer
14 views

dovecot isn't reading dovecot-sql.conf.ext correctly

I added the following connection string to dovecot-sql.conf.ext: connect = host=localhost dbname=<dbname> user=<dbuser> password="<password>" The following error appears in ...
0
votes
2answers
336 views

How to have MySQL entitle the machine's root user?

I'm trying to run mysqlcheck. Its failing with: $ sudo su - # mysqlcheck --auto-repair --all-databases mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when ...
0
votes
1answer
62 views

MySQL won't start

I recently tried to run a basic MySQL command. Then I got the following response: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) I then ...
0
votes
1answer
167 views

MySQL package does not want to install

I am trying to install the packages mysql-server and mysql-client on Debian Jessie but I get the following output Reading package lists... Done Building dependency tree Reading state ...
2
votes
1answer
25 views

How to display key to a file using OpenSSL?

I'm a newbie at encryption so I could do with some help: I'm trying to follow a tutorial on the MariaDB website to create an aes-256-cbc key to encrypt my data at rest. The line which it tells me to ...
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
31 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
66 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
134 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
59 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
52 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
37 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
118 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
41 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
39 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
63 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
5 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
18 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
89 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 ...