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

watch mysql output w/ tabular columns

how come when I run a mysql query and dump the results to stdout I get a pretty printed table ie: > mysql -e "describe <table>" <database> ...
1
vote
1answer
534 views

View existing indexes using phpMyAdmin

Using phpMyAdmin, is it possible to view existing indexes on a table? If so,how? One of my tables should have an unique index with two keys, and I want to confirm it exists.
0
votes
0answers
170 views

How should MySQL Workbench's Compare Schema report be interpreted?

I have a database schema model in MySQL Workbench and a live database. The Workbench model is the most current of the two, and should be used to update the live database. To compare the differences, ...
0
votes
1answer
71 views

let mysql use full resources

We have a Windows server 2008 R2. It has 24GB RAM and 2.926 Mhz, 8 Core(s), 8 Logical Process. We have a large MySQL database and it's taking a lot of time to execute some queries. But while running ...
0
votes
1answer
136 views

Identifier 2, identifier_type 2 not found in identifier list

I am using asterisk 11.9.0 and created a dialplan.My problem is that everytiime i perform an sql operation its working fine but the line same => n,mysql(clear ${resultid}) is giving a error ...
0
votes
1answer
29 views

how to delete taggregate_temp_ tables at once?

In MySQL, I have multiple tables named like this: taggregate_temp_1364792160 taggregate_temp_1364795760 taggregate_temp_1364799360 taggregate_temp_1364802960 taggregate_temp_1364806560 ...
0
votes
1answer
148 views

how to insert many similar records in mysql at a time using phpmyadmin?

we know that we can insert multiple records at a time using this query: INSERT INTO `TABLE1` (`First`,`Last`) VALUES ('name1','surname1'), ('name2','surname2'), ('name3','surname3'), ...
0
votes
0answers
81 views

Idiomatic way to read .env variables in Ansible?

I'm provisioning a Vagrant box with Ansible, and using Benno Joy's MySQL role to setup MySQL (including creating a database and users.) The database name and credentials are stored in a .env file in ...
0
votes
0answers
679 views

xampp MySQL app not running (win8)

I am using xampp for few month. But facing and error for 2 days and MySQL app isn't running. I reinstalled xampp and it was working fine, but when I restarted, it stopped working again. Here are error ...
0
votes
0answers
77 views

Linux Has Become Very Slow Dealing With Large Data

Last year I bought a computer, for around $1,800, so it is relatively high-end. When I first got it I was particularly pleased at how quick it dealt with large MySQL queries, imports and exports. But ...
1
vote
0answers
205 views

mySQL doesn't start in XAMPP on Windows 8

I installed XAMPP. Apache is getting active but when I try MySQL, it doesn't start. I will appreciate if someone can help me. Looks like RC=0 but it doesn't do anything. It gives the following ...
0
votes
2answers
2k views

Command-line access to remote MySQL server

I administer a website on a remote, shared host. My web host offers MySQL, and I am able to access this from my Mac OS X computer using a GUI program, Sequel Pro. That works great. But I want to ...
0
votes
2answers
203 views

phpMyAdmin wrong configuration on Debian

I'm running Debian Sid (headless) with phpMyAdmin 4.2.2deb1. When I log in on phpMyAdmin I see the following message: The phpMyAdmin configuration storage is not completely configured, some extended ...
0
votes
1answer
31 views

how to add mysql to path global variables [duplicate]

I have recently installed MySQL and am trying to access it through my command prompt by simply typing in MySQL. I believe I need to add it to my PATH globals. How can I do this?
1
vote
1answer
197 views

Making phpmyadmin accessible over internet

I have XAMPP installed on my Windows XP server. I have port 3306 (mysql) and 80 (apache) on the machine forwarded to 5016 and 5011 on the router respectively. I am able to access the phpmyadmin ...
1
vote
1answer
66 views

Can't connect to MySQL database after moving to local [closed]

I can't connect my website to the mySQL database installed on the same box. I've had a website running on a shared host and decided to move it local. Installed Ubuntu Server - check. Installed LAMP ...
0
votes
1answer
266 views

Launch a daemon after another daemon on Mac OS X

How one would create a dependency between two daemons launched on system start? I would like to launch sonar when the system starts but it requires mysql server to be already up and running. I ...
0
votes
1answer
173 views

Make ODBC connection between Windows 8 on VMware Fusion to MySql instances on OS X host

I am trying to create an ODBC connection (64-bit) from a Windows 8 installed on VMware Fusion, to a mysql instance install on the host OS (OS X Mavericks). Connection not successful. What am I ...
1
vote
0answers
349 views

Mysql socket error 2002 on Linux Mint - Access denied

My apache and xampp servers are running on port 2145 and 16443 respectively. sudo /opt/lampp/lampp restart Restarting XAMPP for Linux 1.8.2-5... XAMPP: Stopping Apache...ok. XAMPP: Stopping ...
0
votes
0answers
388 views

How to fix Microsoft ODBC for Oracle on a Windows Server 2008 R2 RDP

I share a Windows Server 2008 R2 RDP with several colleagues and we all make heavy use of Microsoft ODBC to do our jobs. One of the important databases we have to connect to is an Oracle database ...
0
votes
2answers
205 views

Upgrade Failure in FreePBX Installation

I'm building FreePBX 2.11.0.25 from source over Asterisk asterisk-11.9.0 (also built from source) on a Ubuntu 14.04 64-bit server installed on a VMWare VM. During installation I had an error that ...
-1
votes
2answers
107 views

Which version of MySQL for Ubuntu

I have the 64 bit Ubuntu 14.04 on my machine. I want to install the MySQL server from here. But I am confused which version to download. My best guess is that, since Ubuntu is apparently a Debian ...
0
votes
1answer
189 views

Network connection to server lost, but not to internet

I have a network with four computers, each running Windows 7. All of them are connected to a central switch. My problem is that the internal network connection is lost very often, although internet ...
0
votes
3answers
320 views

where does MySQL 5.6 on Windows 8 get it's configuration?

Everything I've googled says that the configuration file for MySQL on windows (my.ini) should be found in C:\Program Files\MySQL\MySQL Server 5.6. If I look there, there is no "my.ini", but there is ...
0
votes
1answer
104 views

innodb buffer pool size and munin

I was looking at the below graph of one of my db server's memory usage and have the following question. Is the mysql innodb buffer pool included in the apps or the cache memory allocation? Right now ...
1
vote
0answers
1k views

I have a MySQL 5.6.17 server on OSX 10.9.2 that “sometimes starts”, and most of the time don't

I have setup a MySQL 5.6.17 server on my Mac OSX 10.9 to run some demo (I usually do not attempt MySQL and Apache things on a Mac), using Homebrew. Everything went just fine (apart usual stinky parts ...
0
votes
0answers
59 views

mysql 5.6 client talking to 5.0 server?

I have an old MySQL 5.0 server at work (which I can't upgrade). I'm trying to connect via the "mysql" 5.6 client on Windows. mysql -u ccurvey -p -h <host_name> <database_name> Spits ...
0
votes
1answer
14 views

mysql replication adding slaves at later stage

I need to setup mysql replication environment my main question is related to adding slaves later, Is it possible to add more slaves at later stage just use one or to initially. what are the issues or ...
0
votes
0answers
89 views

invalid default value in SQL export

I exported a database with phpmyadmin, and am now attempting to import the database with PMA on a different machine, but I'm getting this weird error. What can I try as a solution? Error SQL query: ...
0
votes
1answer
95 views

Postfix virtual users without database [closed]

I've made several attempts to setup a mail server. Each time, I find a tutorial to follow, and each time I get frustrated with the tutorial for one of the following reasons: The tutorial doesn't ...
0
votes
0answers
95 views

Is this mysql config valid? (my.cnf)

I'm trying to allow remote connections for mySQL according to this tutorial but since I changed the config, I haven't been able to start mysql. I get the error: MySQL Daemon failed to start. Here's ...
1
vote
0answers
263 views

Corrupted MySQL index caused data-loss! How to recover data?

Introduction to my problem is following. A few days ago I wasn't able to start MySQL service in Wamp! Well, I was google-ing a lot to find solution why it doesn't start and some guy suggested to ...
1
vote
1answer
435 views

Reset vTiger 5.4 password

A while ago I installed vTiger on a server for a co-worker. He forgot his password and asked me to reset it. There are some threads out there telling you how to reset the password on older versions of ...
4
votes
1answer
9k views

How to manually install Apache, PHP and MySQL on Windows?

How do I install Apache with PHP support and the MySQL server on Windows without using any ready-to-use packages like WAMPServer or XAMPP ?
0
votes
0answers
64 views

Importing pygments' highlighting to vim

Usually, vim does very good job in highlighting, using the packaged syntax files. Unfortunately, it does bad job with MySQL. At first, I looked everywhere for a better MySQL vim syntax file, with no ...
0
votes
1answer
150 views

Where can I download the MySQL prefpane source code for Mac OS X

I have been poking around for a while and I have been unable to find the source code for the MySQL prefPane for Mac. I found this for PosgreSQL https://github.com/jwang/pgpane which is helpful but ...
1
vote
1answer
2k views

Can phpMyAdmin be used to connect to a remote database?

I recently read this tutorial, which explains how one can easily reconfigure a local installation of phpMyAdmin to connect to a remote database. The functionality seems to be supported, but not ...
0
votes
0answers
60 views

Connecting to remote database via phpMyAdmin - Validation error

I've been trying to connect to a remote MySQL database via local phpMyAdmin, as per explanation by this tutorial. However, I'm not authenticating properly with the database due to the IP address ...
0
votes
2answers
1k views

Configuring PHPMyAdmin to connect to remote database

After Googling the possibility of using PHPMyAdmin to connect to remote databases, I found this article, which confirms that this is supported after a simple config edit. In the article, the author ...
1
vote
2answers
167 views

Why is the MySQL for Excel freezing when data append is attempted?

I am using Microsoft Excel 2013 on Windows 8.1. where I am trying to use the MySQL for Excel plugin to append data in an Excel spreadsheet to a MySQL database table. Each time I try to do this by ...
1
vote
1answer
549 views

Initial administrator log in to horde

I have installed horde webmail on my debian wheezy machine using the jessie packages and this guide: https://wiki.debian.org/Horde I have set up a database skeleton in mysql - just created a horde ...
0
votes
0answers
196 views

Difference between AWS RDS and AWS Opsworks MySql layer?

We are migrating everything over to opsworks and presently we have an RDS server setup for our database. Our plan for deployments is this: Have our production stack (Stack-A) Have our staging stack ...
0
votes
2answers
124 views

mysql, ssh, rsync, git hang with dns name but not IP address on Ubuntu 12.04

Certain network based programs recently (problem did not exist a couple of weeks ago) started hanging for me. Some that I've experienced the problem with are mysql, ssh, rsync, and git. My first ...
2
votes
1answer
1k views

Connecting to mysql from 127.0.0.1 instead of from localhost

I have similar problem as here. The problem is that solution proposed there does not work for me: Just for now I have users: +----------+------------------------------------+ | user | host ...
1
vote
1answer
24 views

single click or command setup for webserver on unix system

One of the product has requirement of on premise webserver. We are using LAMP stack. We have selected website for on premise use due to business constrains. We are to install this on multiple servers ...
0
votes
0answers
83 views

error installing MySQL-python

I'm starting to learn python. When I try to install MySQL-python with yum from yum install MySQL-python.x86_64 I get this error Loaded plugins: katello, product-id, security, subscription-manager ...
0
votes
0answers
132 views

configure: error: invalid MySQL root directory

I've a problem installing sphinx with percona 5.6 on centos 6.4. I'm getting the following error while building from source: ...
3
votes
1answer
1k views

How to display text in UTF8 from mysql /phpmyadmin?

I have a database with multiple tables. The database and table and every row of table is set to utf8_romanian_ci. Every name which I import that contains diacritics will not be displayed correctly. ...
1
vote
1answer
655 views

Rails startup script runs twice

I'm having some difficulties with a new installation of Ruby on Rails. I want to use my application with MySQL. Here's the problem: The server starts without a problem when I use the default ...
0
votes
0answers
116 views

Centos 6 - Lighttpd/ 403 error on PHP files, and issues adding website

So, I do have PHP/MySQL and PHP-FPM installed, but when I try to access PHP files, I get a 403 forbidden error. I have been looking around Google quite a lot, and not finding anything that is solving ...