MySQL is an Open Source database now owned by Oracle. The MySQL documentation is expansive and incredibly useful.

learn more… | top users | synonyms

1
vote
1answer
204 views

Initial MySQL 5.7 installation on RHEL Instance Fails to Start

I did a standard MySQL install with Chef on an AMI on AWS. Here's the recipe: mysql_service 'default' do bind_address '0.0.0.0' port '3306' version '5.7' initial_root_password 'hunter2' ...
0
votes
0answers
507 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
2answers
865 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 ...
-1
votes
1answer
180 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?
0
votes
1answer
226 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
1k 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 ...
1
vote
1answer
635 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
3answers
56 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
505 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
131 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
122 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
19 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
155 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
2answers
505 views

I can't install MySQL Server on Windows [closed]

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
64 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
253 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
53 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
904 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
22 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
28 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
2k 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
143 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
175 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
38 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
41 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
115 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 ...
2
votes
1answer
226 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
42 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
258 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
88 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
37 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
332 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
1answer
166 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
192 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
257 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
40 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
566 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
1answer
754 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
969 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
100 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
8 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 ...
2
votes
1answer
60 views

No output / stdout / feedback in mysql prompt on Ubuntu 14.04 [closed]

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
34 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 ...
0
votes
0answers
133 views

borked XAMPP upgrade — any way to rebuild my database if i saved var/mysql folder?

After I upgraded to Mac OS X Yosemite, the mySQL server on my XAMPP install stopped turning on. XAMPP released an upgrade that fixed this. So, I copied and pasted my "htdocs" and "var/mysql" folders ...
0
votes
1answer
495 views

PHP site doesn't work on Linux Mint

I started using a Linux Mint and I'm having a little problem. I have a project, where the main folder contains PHP files, and inside this folder there are other folders with images, JS files and CSS ...
0
votes
0answers
38 views

How not to start MySql server on EasyPhp startup?

I'm using EasyPhp 14.1 on Windows XP. I would like to know how to configure EasyPhp to start Apache webserver, but not MySql server when the app starts?
1
vote
1answer
649 views

MySQL in OS X Terminal.app — how to exit mysql command prompt but continue using the Terminal?

I type mysql and enter the mysql command prompt (denoted ~mysql) (I have ohmyzsh installed also). But I can't seem to do anything within it. No commands work. To exit, I type 'exit', and get [Process ...
1
vote
1answer
504 views

Openoffice / Excel combine multiple worksheets into one

I have not yet found the exact answer to my specific problem, so let's give it a shot : The Layout : 1 SharePoint Farm on which a report was run, returning 6 Excel Files with each containing 250 ...
0
votes
1answer
144 views

Accessing mysql behind firewall with ssh port forwarding

I have an architecture which looks like this: | - DMZ - | ________ | ________ | _______ | CLIENT | | | SERVER | | | MYSQL | |________| | |________| | |_______| ...