MySQL is an Open Source database now owned by Oracle. The MySQL documentation is expansive and incredibly useful.

learn more… | top users | synonyms

3
votes
1answer
46 views

Excel ODBC - General 'How does it work?'

Thinking of moving a couple of linked spreadsheets into a database model instead. However, I have a lot of non-technical uses who can just barely use Excel but having them use something like MS Access ...
0
votes
2answers
93 views

phpMyAdmin cannot login - keeps asking for credentials

I have phpmyadmin on my Arch linux box, it is running, so is apache with php and mysql. When I go to http://localhost/phpmyadmin/, it shows the usual login prompt. However, no matter what I enter, ...
-1
votes
1answer
134 views

getting error in mysql— #1064 error while creating trigger

I need to create a trigger for a table called try.. which will execute after something is entered into the table..(I am using phpmyadmin mysql) But i am getting #1064 error while creating it.. My ...
0
votes
1answer
58 views

Can't login to local phpmyadmin

Hy, I've just installed MySQL and PHPMyadmin on my OS X Maverics, following this link: http://www.coolestguidesontheplanet.com/downtown/get-apache-mysql-php-and-phpmyadmin-working-osx-109-mavericks ...
0
votes
0answers
21 views

Find the reason why mysql root password is reset at ever system boot

Every time when I restart the server, booting the system I have to the following error: database error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I can ...
0
votes
1answer
549 views

Unknown SQL server host error in phpMyAdmin after switching php versions in WAMP

I've installed Wamp Server 2.2, which includes php 5.3.13, Apache 2.2.22 and MySQL 5.5.24. Then I installed php 5.2.4 using the WampServer2-PHP524.exe extension found here on SourceForge. When I ...
0
votes
1answer
159 views

Database tables exist but MYSQL says they don't

When I log into MySQL and SHOW TABLES, I see a list of the tables. But, when I run a query against any of them, I get the message: ERROR 1146 (42S02): Table 'dbname.tablename' doesn't exist If I ...
0
votes
2answers
129 views

Moving /tmp to a different mounted drive

I've mapped my MySQL datadir to a different (and bigger) disk with 900GB [root@web ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/xvda1 40G 24G 14G 64% / tmpfs ...
-2
votes
1answer
28 views

WAMP after MySQL

I had previously installed Developer default using MYSQl notifier. I have recently installed WAMP. Do I need to remove all connectors, documentation etc of the MySQL components, or only MySQL server, ...
0
votes
1answer
30 views

One database on Linux and Windows

I want to use MySQL database on my Ubuntu installation as of Windows 7, It should be dynamically, I mean when I change data in database on Ubuntu it should save also on Windows too. I've already ...
1
vote
0answers
25 views

Apache and MySql datbase memory consumption issue with Django

I'm writing a relatively simple web-application as a learning project to learn Django, Apache, Mysql etc. in practice. It consists of a web flash/html5 client which makes two API-calls to Django ...
-2
votes
1answer
53 views

Secure way to manage mysql through web browser

I would like to offer clients access to their own mySQL database. Is there a secure way of doing this? Is there any way to secure phpmyadmin without using a htaccess password or restricting it to ...
0
votes
0answers
97 views

Phpmyadmin hide_db hides all databases

I want to hide the information_schema database from users as it has caused confusion. I have the following in config.inc.php: $cfg['Servers'][$i]['extension'] = 'mysqli'; /* Optional: User for ...
0
votes
0answers
47 views

Two rpms with the same prefix name on one repository

I am using CentOS, I have a local repository and I want to add mysql server and mysql cluster rpms on it so I added all required rpm and all dependencies. At client that added my repo list all rpm ...
0
votes
0answers
23 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
150 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
118 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
55 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
107 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
25 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
93 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
73 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
523 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
68 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
191 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
1k 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
169 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
29 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
135 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
62 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
135 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
115 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
308 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
295 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
170 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
91 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
145 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
2answers
167 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
90 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
866 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
48 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
13 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
72 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
81 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
82 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
240 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
317 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
5k 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
54 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
87 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 ...