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

Please install the mysql2 adapter: `gem install activerecord-mysql2-adapter` (cannot load such file — mysql2) (LoadError)

I am trying to install Redmine on Ubuntu and currently having an error if open Redmine page: Please install the mysql2 adapter: gem install activerecord-mysql2-adapter (cannot load such file -- ...
0
votes
0answers
9 views

sum of multiple products with show rows concerned using array [on hold]

I have a table that has 3 products description (Product_1, Product_2, Product_3) and Each product of some reference AND quantity with location of every row Iwant show all rows for product_1, ...
0
votes
2answers
36 views

Can't start MySQL to reset root password

I've installed mysql-server on a Linux box and forgot (oops) the root password. Having looked around the internet, the general method is so: Stop MySQL (sudo service mysql stop) Start MySQL in ...
0
votes
0answers
19 views

MySQL Performance -Windows 7 Professional vs Microsoft Server 2012 or higher [on hold]

What benefits will I get hosting MySQL on MS Server 2012 or higher vs Windows 7 Professional? My database is mainly used for bulk reads and writes or hooking up to a Tableau Server Software. My ...
-1
votes
1answer
10 views

Owncloud - where in the SQL database is the email stored?

I am searching and searching but still cannot find it. In what table does owncloud store the email addresses?
-7
votes
0answers
31 views

Don't understand Amazon Glacier pricing [closed]

Here's a situation: I build linux servers for medical practices and one of the services I provide is backup of the mySql database which stores patient data. Servers built: Ubuntu server minimal ...
0
votes
1answer
32 views

Installation of MySQL Server and connector/c++ on CentOS

I am using CentOS 5.4. I am trying to install MySQL Server and Connector/c++, but i am unable from rpm package. Errors while installing yum -i -allfiles MySQL-server-5.6.22-1.el6.i686.rpm and ...
0
votes
1answer
52 views

MySQL server: Error 1067 (in services.msc) and Error 10061 (in mysqld console) - what troubleshooting may be attempted?

I'm trying to install MySQL Community edition on a Windows 8.1 machine. To sum up the problem: whith the .msi installer I get MySQL registered as a service, but unable to start (error 1067); with a ...
0
votes
0answers
9 views

Database is randomly refusing connection [closed]

I have the newest xampp installed on localhost. I'm using MySQL database in my php app, the problem is that the connection is refused multiple times, and then it connects (like 1 successful to 5 ...
1
vote
1answer
21 views

Add new Server to Visual Studio application via SSH

I have a RHEL Linux instance with MySQL running. I have the connectors and I'm trying to setup a new connection to the database in Visual Studio 2012. Problem is, it's on a corporate remote server and ...
0
votes
0answers
42 views

Installing MySQL with Macports on Yosemite

I am following this tutorial Step 3 (Install MySQL) but it's failing. I am running Mac OS X Yosemite and have freshly installed Macports 2.3.3-10.10. sudo port install mysql51-server failed with "All ...
1
vote
2answers
9 views

Show All Results From One Table Not Listed In The Other (Junction) Table By :id

I have 2 tables I'm interacting with. The first table: acl_permissions (is just a normal table). +-----------------------------------+ | acl_permissions | ...
0
votes
1answer
14 views

phpMyAdmin used by java application

I have a MySQL database running at a site using phpMyAdmin. My problem is that I want to use this database inside a Java application which runs as a regular, non browser, application. The problem is ...
0
votes
0answers
22 views

MySQLdb-python installed but throws import error when run: Library not loaded: libssl.1.0.0.dylib

I'm having issues setting up my python environment on a new computer, specifically with the MySQL-python module. Im using... macbook pro version 10.10.1 the anaconda distribution for python 2.7: ...
0
votes
0answers
41 views

Mysql Service crashes

I am using wampserver 2.0. I restarted it (until restart no issues). After the restart the mysql is crashing frequently. If I start it after a while its automatically stopped. I need to do the ...
0
votes
0answers
8 views

Low TPS using Virtualbox + Ubuntu + Nginx + PHP-FPM + Silex

I am trying to understand why I get such a low TPS rate on my development environment. I am using the following: Mac OS X Mavericks VirtualBox Ubuntu 14.04 Nginx PHP5-FPM Silex I did not tweak ...
1
vote
2answers
25 views

Does binary logging for MySQL slow down performance?

The question is simple. Does turning on binary logs in MySQL slow down performance considerably, i.e. will it write large amount of data to disk thereby causing high I/O, will it hog memory, does it ...
-1
votes
0answers
15 views

What is the 95% of sysbench result in a MySQL 5.6 setup

I used SysBench to benchmark of MySQL 5.6. What does the approx. 95 percentile mean in the result? What is it? Here is my command that i run: sysbench --test=oltp --oltp-table-size=1000000 ...
0
votes
2answers
60 views

I can't install MySQL Server on Windows

I asked this question on Stack Overflow as well, but decided I had to ask it here too. I have been trying for quite some time to install MySQL Server. I have read the documentation countless times, ...
0
votes
1answer
21 views

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) [2002]

For some reason over night mysql has broken. I tried /etc/init.d/mysqld start Starting mysqld: [ OK ] but it doesn't actually appear to start ps aux |grep mysqld root 5114 0.0 0.0 ...
1
vote
1answer
23 views

Connect to MySQL in VirtualBox Ubuntu

I have this code on my PC (Windows), calling a database from an Ubuntu Virtual Machine with host-only network. I'm using VirtualBox for the Ubuntu Machine $ipHost = "xxx.xxx.x.xxx"; $nombreUsuario = ...
1
vote
1answer
19 views

mysqladmin won't accept password

I have a new MBP with Yosemite. I have installed the latest version of MySQL (5.6.21 via the pkg file) and have successfully set up its password and see it through Sequel Pro. However, I cannot login ...
0
votes
1answer
65 views

How to configure phpmyadmin under Ubuntu

I've installed LAMP but when I put in apache.conf this line as is in instruction Include /etc/phpmyadmin/apache.conf and trying to restart apache I get follow error: ~$ sudo /etc/init.d/apache2 ...
0
votes
0answers
17 views

How to properly move mysql dumps between hosts

One would thing that it will be as easy as mysqldump -u root -p -QqeR --add-drop-table --all-databases | bzip2 -v9 - > blabla.sql.bz2 and then import on the other side, but in real world that's ...
0
votes
0answers
24 views

Weird SQL Time and Date exception in Windows

OS: Windows - Environment: MySQL I am facing a weird problem (for me at least), I was running some tests on database activities, the full scenario is like this: I have two Java programs manipulating ...
0
votes
2answers
55 views

How to store results of multiple sql queries in shell variables in Bash?

I need to store in array the results retrieved from the database. So far this is basically what I'm trying with no success. Myarray=$(echo "SELECT A, B, C FROM table_a" | mysql database -u $user ...
1
vote
1answer
38 views

Setting Vim key bindings for the MySQL client

I add these following lines to ~/.inputrc and now the Postgres client, psql, uses Vim keybindings. set keymap vi set editing-mode vi However, this does not work for MySQL. I understand that MySQL ...
0
votes
0answers
33 views

Create empty MySQL database via batch file

I have read several answers here but can't see to get the syntax right. The task is to get a batch file that inputs a variable (db) and uses that variable to create an empty MySQL database. My ...
0
votes
1answer
21 views

Installing mysqld on Ubuntu 12 (LTS) non-interactively

I want to install MySQL server on Ubuntu 12.04 LTS non-interactively. For most packages, I just use the -y flag, which is described on the apt-get manpage as: Automatic yes to prompts; assume ...
0
votes
1answer
28 views

How to change MySQL status variables?

How can I change Mysql system status variables? I need to increase value for Ssl_default_timeout. Here is more about status variables: ...
0
votes
0answers
58 views

Mampstack Mysql won't start in Yosemite

So I have a problem with the latest OSX version : I installed Yosemite, and now I can't start the mysql server in mampstack I came across that link and tried to edit the scripts but I don't have edit ...
0
votes
0answers
23 views

SQL file can be returned but contents are damaged

I have a DataTraveler brand flash disk (4GB, file system - NTFS). The entire contents (directories and files) were accidentally deleted. Most of the files that were deleted. I got them back using a ...
0
votes
0answers
33 views

phpMyAdmin + TYPO3 = Error code 200, how to solve?

I'm running a TYPO3 4.5.37 with the phpMyAdmin 4.18.4 plugin installed (both latest versions). TYPO3 itself works perfectly fine and the website, too. But if I click on the phpMyAdmin extension in the ...
2
votes
1answer
65 views

Mysql.server through homebrew on macbook

i am getting the following error when trying to run mysql through home-brew. Arshads-MacBook-Air:~ Arshi$ mysql.server start /usr/local/bin/mysql.server: line 256: my_print_defaults: command not ...
1
vote
2answers
22 views

Showing filenames when grepping from mysqlbinlog

I am trying to find out when some queries have been executed on our DB. For that I started looking in MySql binarylogs, using mysqlbinlog: find -name "binlog.000056*" -exec mysqlbinlog {} \; | grep ...
0
votes
1answer
49 views

Why won't mysqld start after a yum update?

This morning I ran yum update and it completed successfully. We noticed, however, that the database server wasn't running. As root, I ran: service mysqld restart Which gave me the following error: ...
0
votes
1answer
16 views

Vagrant/Puppet/MySQL localhost issue

I have a vagrant file using puppet to configure mysql. Here is the relevant code in default.pp: class { '::mysql::server': override_options => { 'mysqld' => { 'bind_address' => ...
0
votes
0answers
19 views

High CPU Usage for Mysql after adding partitions

On a amazon m3.large instance (vCPU:2, Mem: 7.5), I run a mysql(5.5.29) server. Initially, the state of the server is OK except that the query is too slow. However, after partitioning the table into ...
2
votes
1answer
76 views

How to check variable returned from MySQL in bash?

I need to run a stored procedure using MySQL from bash. The stored procedure returns a variable and I need to check the value of the variable in bash to display it accordingly. If I echo the variable ...
1
vote
0answers
45 views

install glassfish independently, or from netbeans?

I'm running Ubuntu on a desktop and laptop, and use Netbeans as an IDE. On the desktop, $/glassfish-4.1 has everything configured properly. I may have copied a JAR for MySQL over to the libs folder, ...
0
votes
0answers
38 views

MySQL stops unexpectedly on CentOS 6.5 with WHM/Cpanel after migrating server with transfer tool

I recently moved my entire websites from a dedicated CentOS5 server to a CentOS 6.5 on Amazon EC2 with the same cPanel/WHM version. WHM 11.44.1 (build 19) However after angry calls from clients I ...
0
votes
0answers
52 views

How to connect to mysql database on a remote server behind a vpn requiring an ssh tunnel from another remote server using php?

I need to connect to a mysql database with php from a remote server. The mysql database is on another server owned by me. On the mysql server, the only permissions I have is to read and do database ...
1
vote
0answers
27 views

can filling up a disk and then freeing up space cause filesystem problems a month later?

I had an incident happen not too long ago with a server running mysql. Someone had enabled slow query logging on the server but never bothered to implement a log rotation, so the log files slowly ...
0
votes
0answers
90 views

#1130 - Host 'localhost' is not allowed to connect to this MySQL server after acunetix scan

I am using the xampp . As stated in the question i am getting the #1130 - Host 'localhost' is not allowed to connect to this MySQL server after i ran acunetix vulnerability scan on my localhost . I ...
0
votes
2answers
112 views

How can I get MySQL workbench to always show the result grid?

When I execute a SELECT query in the MySQL workbench, the result grid appears. Then, when I execute an UPDATE, the grid disappears. Then when I run a SELECT again to view the changes, it reappears. ...
0
votes
1answer
216 views

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

I have this error when trying to connect to my phpmyadmin. I tried all the solutions but nothing works. I changed password in config.inc and cleared cookies, restarted services of wamp but nothing. ...
1
vote
0answers
50 views

PHP exec() causing memory usage to stay high?

I am quite new to using exec() command in php. I am using it along with this script called phantomJS (http://phantomjs.org/) to run a process which creates a pdf of my website's pages. The problem ...
0
votes
0answers
7 views

mysql 2 databases synchronization

I've got 2 databases, one in local server and one in internet: local) server1 : DB1 { table1(40lines) } Net) server2 : DB2 { table2(30lines) } So how can I get those 10 lines from table1 in ...
1
vote
1answer
22 views

No output / stdout / feedback in mysql prompt on Ubuntu 14.04

I'm running Ubuntu 14.04 and Nginx, and I recently installed mysql-server while following Digital Ocean's LEMP stack setup guide (I intend to run a WordPress site with it). When I try to log into an ...
0
votes
0answers
24 views

Why is it not recommended to use zero in an id column in MySQL?

If you're building out a project from scratch, what are some reasons that one would not recommend using zero (0) in an id column for MySQL? Assuming that the MySQL database/server is in strict mode ...