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

Error while trying to create an album in MySQL in Trovebox

When trying to create a new album in TroveBox I just get an simple error message in the ui notifying me that it failed. No information is in logs from Apache and MySQL. The current user can write in ...
0
votes
0answers
4 views

MySQL is installed but it is not detected as being installed

I think one of my friends had installed mySQL on the RHEL 6.2 OS I'm working on, but when I tried running it or uninstalling, it says the rpm is not installed, and when I try installing the rpm, it ...
-1
votes
0answers
18 views

where to create database for a website [on hold]

I have started designing a website from scratch in notepad. I want to create database containing the login information, etc. for my website, but I don't know where! I know how to create and connect to ...
-1
votes
1answer
16 views

SQL remove everything behind a comma in string [on hold]

I have a mysql table storing some data. One column stores strings containing a comma. I want to get rid of everything (including the comma) in this string and save it, but I don't get it to work. I ...
1
vote
1answer
16 views

Will re-installing MySQL remove or delete existing databases?

If I reinstall MySQL, without removing the actual MySQL installation, would it rewrite all files without deleting my databases? My problem is my mysqld is broken, due to the fact that I accidentally ...
0
votes
1answer
13 views

How to get access to MAMP mysqldata base when 1045 access denied error is posed?

Been stuck for a few days now. I've been SCOURING google for solutions and have tried many things. Basically I was editing my users in phpMyadmin and I think I erased the user 'root' which is my ...
0
votes
0answers
7 views

InnoDB O_DIRECT on NTFS external drive

I have a MySQL database with a table that has about 170 mil rows. I have it partitioned into 32 partitions with hash(id div 10000000). I created and imported the rows and then moved the data to an ...
0
votes
2answers
31 views

Trovebox (OpenPhoto) setup hangs/fails at final step 3

I've been following the install instructions found here about how to install and configure Trovebox on a Ubuntu server running Apache: Ubuntu 14.04 LTS Apache: 2.4.7 MySQL: 5.5.37 PHP: 5.5.9 ...
0
votes
1answer
21 views

mysql backup verification

Im not a dabase admin or advanced database user or advanced linux user.. but I would like to know how to verify mysql dumps because I am backing up my own sites manually. Normally when backing up lot ...
0
votes
0answers
16 views

Mysql resolving 127.0.0.1 to hostname [duplicate]

I'm trying to connect to mysql using the command mysql -h 127.0.0.1 It comes up with the error ERROR 1045 (28000): Access denied for user 'root'@'mydomain.com' (using password: NO) Why is ...
0
votes
5answers
47 views

Mysql resolving 127.0.0.1 to hostname

I'm trying to connect to mysql using the command mysql -h 127.0.0.1 It comes up with the error ERROR 1045 (28000): Access denied for user 'root'@'mydomain.com' (using password: NO) Why is ...
-5
votes
1answer
26 views

I was wondering if anyone could help me out [closed]

I was wondering if someone would know where to direct me if I wanted to make a little bit of extra cash and get small jobs while at home during the Summer - For instance help building up a Website, ...
0
votes
0answers
11 views

Mysql Failed to started after mysql dump restore process

i tried to restore a db backup to a newly created database, suddenly its starts showing error. Can't connect to local MySQL server through socket /var/run/mysqld/mysqld.sock so i checked ...
0
votes
0answers
62 views

Is there anything here to stop access to 3306?

I am trying to work out why a script on my online server cannot access MySQL to get playlist data and display it. I have checked all I can and it is not the script, as many others are using it with ...
0
votes
1answer
61 views

Mysql server won't start after Mavericks upgrade

I am unable to start MySQL server after upgrading from OSX 10.8.5 to 10.9.3 prompt: sudo ./support-files/mysql.server restart ERROR! MySQL server PID file could not be found! ...
0
votes
0answers
12 views

Having trouble with MySQL and 3306

I have XP Pro, Netcomm NB304N Modem and ADSL out to web. Web page is on our shared server website. MySQL is installed, 3306 is shown as open and accessible by Port Forwarder yet I cannot get a script ...
3
votes
1answer
23 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
32 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
25 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
32 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
12 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
61 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
37 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
26 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
14 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
25 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 ...
0
votes
0answers
12 views

Inconsistent slow DB connect times [on hold]

I have an app that shows significantly increased load times every 5 minutes. We use New Relic and I've been able to identify that every slow request is due to our DB connect functions. I've looked ...
1
vote
0answers
8 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
42 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
22 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
24 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
16 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> ...
0
votes
1answer
14 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
17 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
22 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
53 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
17 views

how to delete taggregate_temp_ tables at once?

In my SQL I have multi tables like: taggregate_temp_1364792160 taggregate_temp_1364795760 taggregate_temp_1364799360 taggregate_temp_1364802960 taggregate_temp_1364806560 taggregate_temp_1364810160 ...
0
votes
1answer
28 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
22 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
72 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
44 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
61 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
73 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
75 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
9 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
39 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
41 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
46 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
55 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 ...
0
votes
0answers
87 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 ...