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

Modify data values in a MySQL database by means of MySQL workbench?

I'm using MySQL workbench 6.0 on Xubuntu 14 I have tried to create a Database but I don't manage to insert values on the fields by means of the workbench. In fact in my template I have inserted some ...
0
votes
0answers
95 views

Connecting to mysql server at 127.0.0.1:3307 with iptables port redirect

I have a ruby application which, for various reasons, connects to a mysql server running at 127.0.0.1:3307. This works perfectly on the server side, but now I want to run this application on my ...
1
vote
3answers
55 views

Can a database be too relational?

I have a question about database design. I'm asking here because I'm an enthusiast/hobbyist and not a "professional" so I don't want to post it on the "Database Administrators" stack exchange ...
0
votes
1answer
68 views

My SQL Workbench crash when I want to save

Sorry for bad grammar, first at all, English is not my native language. :) First, I'd installed MySQL Workbench in my computer Windows 8.1, but when I want to save like a model for example, Windows ...
0
votes
0answers
60 views

phpmyadmin export from two tables where data in one column matches?

I'm running MySql server 5.6.2 with phpmyadmin 4.3.7 on a Windows 2012 server. I have one database - "tsl". Within "tsl" I have a table named "apps" and another table named "flat_apps". The "apps" ...
1
vote
0answers
51 views

Set up sftp mysql authentication with chroot

How do I set up an openssh SFTP server that authenticates against a MySQL table where the users are jailed? Each user will need to have its own jail: /home/sftp/john /home/sftp/jane etc.. However ...
0
votes
1answer
16 views

FTP and WWW services don't acknowledge connections

I have Lubuntu 14.04 LTS with vsftpd and the lamp stack (apache2, etc.) installed. Everything works fine on the LAN. Externally, the services don't acknowledge connection attempts. I can see packets ...
0
votes
0answers
9 views

How to identify the database and took backup from another server?

Please guide me in this situation. I have two domains domain1 and domain2, both domain are registered from the different provider but hosted on the same server (server1). My question is that if I ...
0
votes
2answers
324 views

Apache couldn't be started because port 8888 is in use by some other software

I am having an issue starting up MAMP, when I attemp it, I get this error message: Apache couldn't be started because port 8888 is in use by some other software I have been trying for the last 2 ...
2
votes
1answer
38 views

Why mysqld set user/group of /var/log/mysql with ‘s’ rights?

In Ubuntu, sudo apt-get install mysql-server, the package will: create an account mysql create storage directory /var/lib/mysql with permission drwx------ 4 mysql mysql create log directory ...
0
votes
1answer
57 views

Can't get MySQL server running on Windows 7

I had MySQL up and running several days ago with the help of a friend, but after a reboot I can't get it to startup. My understanding is that I am to run a command prompt as administrator, go the bin ...
0
votes
1answer
45 views

MySQL dump permission error

It seems strange but when doing mysqldump -h host -u backup -p database | gzip > /tmp/test.gz I get Access denied for user 'backup'@'%' (using password: YES) when using LOCK TABLES When ...
0
votes
1answer
56 views

Why do I get this error installing MySQL server?

So I have a empty VPS running Debian 7 32bit. The VPS has just been created so nothing is installed but the base OS. I run apt-get update and then apt-get install mysql-server and i get this error: ...
1
vote
1answer
77 views

MySQL data on ramdisk partition

I'm using Docker with Ubuntu for my CI and development environment. I would like to put the database on a ramdisk partition to speed up the builds, since I have to reload my fixtures a lot, so data ...
0
votes
1answer
27 views

Mysql won't show my databases (MYSQL-WIN7)

I create a database using workbench and don't find this database at ODBC list, I'm able to see only information_schema database. I tried to restart my machine but don't solve the issue. Could you ...
0
votes
0answers
9 views

Suggestions on how to set up my dev server for dev clients (Linux and WIndows)?

I am creating web intranet systems and have always struggled with developing on multiple clients with moving files and databases over back and forth trying to keep everything in sync. I have now set ...
0
votes
1answer
32 views

Centos my.cfg file is incomplete

I recently got a server which has mysql running and I want to access to it remotely. I searched internet and I find out that my.cfg file in /etc/ location has a property that will enable that: ...
0
votes
1answer
451 views

install php-fpm on centos after remoe it

i install php-fpm and php-mysql and nginx then i remove it and update servers kernel. now, when i want to install php-fpm ,.. dont install $>uname -a 2.6.32-504.3.3.el6.x86_64 #1 SMP Wed Dec 17 ...
0
votes
0answers
43 views

how to enable “sql_auto_is_null” (MySQL 5.6)

in MySQL 5.0 it came enabled by default, but now in 5.6, it's not. So, I need to turn the thing on. i've tried modify my.ini (i'm in a windows box) sql_auto_is_null=1 sql_auto_is_null=ON ...
0
votes
2answers
73 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
339 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
37 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
62 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
81 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
126 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
27 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
220 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
33 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
17 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
27 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
43 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
39 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
54 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
60 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
30 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
28 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
92 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
37 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
357 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
159 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
369 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
437 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
85 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
184 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
707 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
450 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
43 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
380 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 ...