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
2answers
90 views

How do I use ssh ProxyCommand to connect to remote MySQL server behind bastion host?

Three machines are involved here. Localhost where I do my development. AKA laptop. Bastion host where you must connect first. AKA jump. MySQL server where I want to connect to. AKA DB. My ssh ...
1
vote
0answers
484 views

How to recover MySQL database on xampp/windows using ib/frm files?

I'm using xampp on Windows 7. Couple of tables of my Wordpress database got corrupted. When I view the database in phpmyadmin, the tables have the message "in use". I tried ...
0
votes
0answers
44 views

MacOSX Terminal with MYSQL command line how to highlight and copy/paste

Is there a default keyboard command when using the Terminal on MacOSX while in MYSQL command line for highlighting and copying/pasting text? I'm looking for a native solution without having to use ...
0
votes
1answer
83 views

Possible to export/import remote DB to WAMP server?

If I needed to gzip a remote database and import it into my WAMP MySQL database I believe the command I should use is - ssh user@server "mysqldump ericdev | gzip" | gunzip | mysql ericcart But how ...
0
votes
1answer
110 views

Missing MySQL extension required to run WordPress on custom Linux server

I need to get WordPress up on running on a custom Red Hat Linux server, but am getting the following error when attempting to visit the WordPress install page: Your PHP installation appears to be ...
0
votes
1answer
223 views

Table name not showing in relation view in phpmyadmin

I have a database named flk_embriodery. It contains two tables. user countries I created user table from phpmyadmin but generated countried table from mysql query. But interestingly countries table ...
0
votes
0answers
30 views

How I can unistall MYSQL5.6.22 installed using source code on Oracle Enterprice Linux 6.6 ?

I have installed MYSQL-5.6.22 using make utility by source code(tar file) and now I can't able am to uninstall it using sudo make clean or sudo make uninstall. So please suggest me the ...
0
votes
1answer
225 views

Compiling MySQL Workbench on Fedora 21 antlr-4.3 jar not found

I'm trying to compile MySQL Workbench This is the result of cmake: -- The C compiler identification is GNU 4.9.2 -- The CXX compiler identification is GNU 4.9.2 -- Check for working C compiler: ...
0
votes
2answers
35 views

Canon Registry Keys Remain after Uninstallation

I have a Canon printer but have found that with it installed I can't correctly install MySQL (there are threads about this problem). So I uninstalled the Canon files, reinstalled MySQL and found that ...
0
votes
0answers
20 views

mysql community 5.6 instal path on Win 7

I'm new to mysql. When I install, I don't see an option for the installation path so it seems to autoselect the path and complete the installation. When it is done when I open the mysql installer, ...
0
votes
3answers
78 views

What is the IP address of my home computer from the perspective of the outside world? [duplicate]

What is the IP address of my home computer from the perspective of the outside world? I need this in order to grant myself permissions to connect to a mysql database on a work server. I'm working on ...
0
votes
0answers
29 views

Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT)?

I have an application that could care less about internationalization. It would be perfectly happy with 7-bit ASCII. Unfortunately MySQL insists on giving me all sorts of UTF8 goodness (I prefer to ...
0
votes
2answers
47 views

MySQL error, Too many connections

When I try to see my website, instead of the forum that I was uploaded on the host, this below screen appears : me, as the one who bought a domain and a free host, what must do to solve it? As you ...
0
votes
2answers
49 views

How can I pass the result set of filenames from an MySQL query to zip in Linux

My problem is pretty straight foward, and I think I'm close but need a boost in the right direction. I have a MySQL table that contains a lot of file names that are used by a website. These files all ...
0
votes
1answer
71 views

Mysql Connector crash on SQL Server 2008

I would like to create a linked Server betwenn my MYSQL Server and a SQL Server 2008. I already installed the MYSQL Connector ODBC drivers 5.1 (previously the 5.3 Version but same problem) on my SQL ...
1
vote
2answers
1k views

MySQL Workbench not present in MySQL Community RPM for Fedora 21

I have given up trying to find a proper workaround or solution to install MySQL Workbench + MariaDB so I decided to install the official stack provided by MySQL so I enabled their YUM repository using ...
0
votes
1answer
73 views

Asterisk Ivr menu mysql build

I would like to implement an IVR menu to see if the call comes in and announces a text waiting 6 numbers. Then the number 6 is controlled by a MySQL database. If "Active" or "Valid" the status will be ...
0
votes
0answers
33 views

Updating MySQL data in an Excel spreadsheet

I have a data table in excel drawing data from a MySQL data connection using a custom query definition. Right now I am trying to change one of the "WHERE" clause parameters, but when i do so the data ...
0
votes
2answers
38 views

Default mysql user is empty string. How do I change it to be “me” (i.e. whoami)

I recently updated my OS from Mavericks to Yosemite, and now when I do mysql foo I get: ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'foo' This used to run mysql with my ...
-1
votes
1answer
104 views

I want to install and configure MySQL Server silently with remote access

How NSIS MySql Silent install and configure to enable remote machine access. **ExecWait "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqlinstanceconfig.exe -i -q ServiceName=MySQL RootPassword=root ...
0
votes
1answer
41 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' ...
0
votes
1answer
476 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
1answer
186 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
450 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
675 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
131 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
198 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
553 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
52 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
456 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
121 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
104 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
16 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
115 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
417 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
63 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
204 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
42 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
754 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
20 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
27 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
1k 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
112 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
154 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
34 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
39 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
110 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
264 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 ...