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

Method of checking user credentials against a MySQL database?

I was experimenting with user authentication with MySQL and my code that I got from a Tinkernut tutorial is heavily outdated. I tried to update it but I don't know enough about MySQL to do very much. ...
0
votes
0answers
6 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
13 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
0answers
13 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
2 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
1answer
11 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
14 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
8 views

Linked Server Mysql to SQL Server 2008 32-Bit [migrated]

I have an SQL Server 2008 64 Bit and a Mysql-Server, and would like to use a Linked Server. However I need the 32-BIT Mysql ODBC Connector for an extern Application. When I would like to connect to ...
0
votes
0answers
17 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
19 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
23 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
24 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
10 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
69 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
27 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
11 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
69 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
11 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 ...
-1
votes
0answers
15 views

How to handle ini-files for Homebrews

When installing MySQL and PHP with Homebrew, it puts its config files in version specific folders: /usr/local/etc/php/5.5/php.ini /usr/local/Cellar/mysql/5.6.21/my.cnf Thereby it effectively ...
0
votes
2answers
31 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
23 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
0answers
17 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
425 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
0answers
19 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
17 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
22 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
68 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
21 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
71 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
49 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
82 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
69 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
16 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
100 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
137 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
0answers
147 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
20 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
61 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
62 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
65 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
10 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
29 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
119 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
30 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
40 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
21 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
189 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
18 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
26 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
182 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 ...