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

MySQL server Connection Error

I have virtual server hosted and this is my configuration of VPS.. ubuntu 14.04 with tomcat 8 and java 8 and i installed mysql 5.5.40 I created a new user in it with CREATE USER 'ram'@'localhost' ...
1
vote
1answer
4k views

Installing MySQL 5.1 on 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
1answer
20 views

Excel 2013 MySQL Database Connection - SQL Server does not exist or access denied

I recently set up the most basic possible version of MySQL 5.6 and created a test schema in which a test table was placed. The connection is just named "Local instance MySQL" with host "localhost", ...
1
vote
2answers
3k views

Clear screen for MYSQL command line client

Please help me.I am unable to clear screen of mysql command line client like i know in case of java it is 'cls'.thanks in advance.
1
vote
1answer
19 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
19 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 -- ...
-1
votes
2answers
70 views

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

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
0answers
15 views

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

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
46 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 ...
4
votes
2answers
4k views

Can't start mysql (xampp) after installing on external drive

I decided to move my XAMPP installation to external drive. It's USB3 3TB Seagate drive. Unfortunately mysql doesn't want to start. All works fine if I install XAMPP to C drive but doesn't work when I ...
0
votes
2answers
2k views

MySQL don't start (ubuntu): [ERROR] /usr/sbin/mysqld: unknown option '--skip-locking'

I can't start MYSQL. I changed a parameter in WEBMIN in the main mysql configuration: SKIP LOCKING OF TABLE FILES?... the original value was "NO", and I changed to "YES" This is the LOG file: ...
0
votes
0answers
20 views

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

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?
1
vote
2answers
265 views

MySQL database restore

I've written a script which backups my MySQL database and produces a GZIP file with the mysql dump of my database. I wondered if it's possible to decompress the GZIP file and restore the database in ...
0
votes
3answers
13k views

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

So at first I was getting this error when trying to create databases for use in phpmyadmin. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I ...
0
votes
1answer
42 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 ...
1
vote
2answers
10 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
68 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
23 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
64 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 ...
0
votes
1answer
19 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 ...
3
votes
1answer
1k views

Postfix: SMTP, use port 587 rather than 465

I have set up a mail server on AWS EC2 using the instructions from Flurdy: http://flurdy.com/docs/postfix/ it has mostly gone well. My issue is that I would prefer to use SMTP port 587 with TLS ...
0
votes
1answer
4k views

Curl Returns “Connection Refused” when trying to access 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
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 ...
0
votes
1answer
23 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
5k views

WAMP - Reset Root password on mysql

I'm getting this error: access denied for user 'root'@'localhost' using paswword (NO). Its a fresh install of wampserver 2.2 32 bit. Is there a way I can reset the mysql root password? I have tried ...
0
votes
0answers
29 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
1answer
3k views

phpMyAdmin removes the primary key for MySQL table

My problem is this: I create a table in WAMP Server's phpMyAdmin, I always make the first column as name: id type: int index: primary auto_increment: true then I add other columns , mostly harmless ...
0
votes
1answer
20 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
44 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
votes
0answers
16 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 ...
1
vote
1answer
2k views

MySQL ERROR 2002 (HY000) on CentOS 5

I have problem with starting up mysql. When I type service mysql start All I got is ERROR 2002 (HY000): Can't connect to local MySQL server through socket /var/lib/mysql/mysql.sock' (2)** ...
1
vote
2answers
575 views

Database is full; what should be the strategy?

What if my database is full and I don't have any spare hard disk or memory space. What should my strategy to free up the space?
1
vote
1answer
75 views

database statistics and reporting with or without parsing of built in logs

I prefer a generic statistical utility / plugin / application, but don't limit myself as specific might do well too. I want to see a way by which I can see query statistics for ALL queries. e.g ...
2
votes
4answers
193 views

What is the best way to convert a MySQL database to an access database?

I need to convert databases both directions and I also need to grab subsets of data on occasion. Is there an easy way to do this?
3
votes
2answers
6k views

MySQL form builder like MS Access

Are there any good tools out there (don't have to be be free) that provide functionality analogous to MS Access but for non-MS databases like MySQL? I'm looking for more than just a query builder ...
0
votes
0answers
43 views

Barnyard - Database Warning

I installed snort and barnyard. When I start snort and barnyard services, barnyard could read snort.log file but it doesn't write to mysql database. So I run tail -100 /var/log/messages and I ...
0
votes
1answer
321 views

How do I create & restore a mysql database dump with Chef?

Environment Ubuntu 12.04 Precise64 Enterprise Chef opscode-cookbooks/mysql opscode-cookbooks/database Wordpress 3.9 Objective I am trying to replicate/clone my production Wordpress server. I'd ...
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
votes
1answer
92 views

Missing MySQL Database after Windows Upgrade

First of all, please bear with me as I am quite new to HeidiSQL, MySQL, and the concept of relational databases as a whole. I recently started using HeidiSQL in order to create tables for import into ...
5
votes
2answers
4k 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 ...
12
votes
4answers
15k views

how do I see which user I am logged in as in MySQL?

I have multiple text console session open and log in as different users into different consoles. I forget after while which consoles belong to which user, it would be nice to not have to quit and log ...
0
votes
0answers
61 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 ...
0
votes
0answers
38 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 ...
1
vote
1answer
24 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 = ...
4
votes
3answers
10k views

Mysql Fail to start

I'm running a Ubuntu 12.04 LTS Virtual Machine. Last week, the VM stopped unexpectedly now mysql will not start on the VM. These two events may be related, they may not be. When I try to connect: ...
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 ...
1
vote
1answer
371 views

The server quit without updating PID file

I am trying to install MySQL on my Mac w/ Mavericks OS. Whenever I try sudo /usr/local/mysql/support-files/mysql.server start it shows an error The server quit without updating PID file ...
0
votes
1answer
81 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 ...