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

Pentest SQLi: how cand you get the number for culumns if order by and union don't work

Pentest SQLi question: how cand you get the number for culumns if order by and union don't work? id=5' or 1=1 --+ works but when I try id=5' order by 1 it doesn't show anything. I also tried id=5' ...
1
vote
0answers
20 views

Can't connect to local MySQL instance when ran as service

I've been running a local MySQL server for development purposes lately and for some reason never got around to running it as a service so I was constantly starting it up using the mysqld.exe every ...
0
votes
1answer
7 views

Autostart multiple apache2 instances on start up

I have an OpenSUSE 13.1 installation, on which I am running multiple instances of apache under a proxy instance of apache. Currently I can start the proxy instance of apache and its MySQL database on ...
-1
votes
0answers
17 views

Undefined class constant 'MYSQL_ATTR_MAX_BUFFER_SIZE'

I have EasyPHP 14.1 configured and running properly on a Windows 7 x64 machine. Trying to open a web-app called Open Device Manager, I get the following error Fatal error: Undefined class constant ...
0
votes
0answers
9 views

Installing mysql - Fedora20 - Where is the installation directory

I am trying to install mysql on to a Fedora 20 box. I am using the below guide which states the following; First, MySQL was replaced by MariaDB since Fedora 19 ...
-2
votes
0answers
13 views

Magento Errors - What is the cause & how to fix? [closed]

I have shifted to a Magento based website from a PHP hard coded website & i have been facing a frequent issue of Magento Database crash or maybe something else i am not sure of. Can someone tell ...
0
votes
0answers
17 views

Multiple webservers on one machine

I am attempting to setup a Dell Poweredge R720 with a variable number of separate instances of apache/mysql. This is because we wish to be able to update some of our systems, without affecting others. ...
0
votes
2answers
31 views

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

I've installed xampp on my MAC computer in my table I saw a word named user I clicked it and I saw that I was able to change from not having a password by default to using a password. I clicked it and ...
0
votes
2answers
19 views

Ubuntu - Secure PHPMyAdmin in Nginx

I followed the instruction on this site for installing PHPMyAdmin. However, this configuration is for an Apache, and I am using Nginx. I can't find any tutorial online on how to restrict the allowed ...
0
votes
0answers
4 views

Redmine reports intermittent Internal Error

I've been using Redmine/Apache for a few months now. Occasionally a page will not load, and instead I will get Internal Error 500. Refreshing generally fixes this. When I look in the log file on the ...
0
votes
0answers
7 views

tango taco next generation objects

I installed Tango on Windows 8, and successfully created the database on a MySQL server. But when I launch the start-db.bat script, I get the message C:\Program Files\tango\bin>start-db.bat ...
0
votes
0answers
8 views

TANGO : TAco Next Generation Objects

I installed Tango on Windows 8, and successfully created the database on a MySQL server. But when I launch the start-db.bat script, I get the message C:\Program Files\tango\bin>start-db.bat ...
0
votes
1answer
23 views

analyzing htop data in ubuntu

i am trying to find bottleneck in my server, specifically in my web application of why things are running super slow. Here is a screenshot of my htop: As far as I can tell mysql here is almost ...
0
votes
0answers
16 views

Am I using this command correctly? Can't understand why I get the error I am getting. Myqsl - Centos 6

So, I am trying to connect to a database through mysql ssh, but whenever I run the command Connect postfix@127.0.0.1 on postfix It returns with: ERROR 2005 (HY000): Unknown MySQL server host 'on' ...
0
votes
1answer
43 views

Difference between connecting to 127.0.0.1 and server ip

I am brand new to php, databases, and linux and had a problem where I could not connect to mysql databse with the php mysql_connection function. When I used the ip address of my VM I kepy getting a ...
0
votes
0answers
7 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
5 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
1answer
19 views

SQL remove everything behind a comma in string [closed]

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
21 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
16 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
9 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
64 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
29 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
17 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
57 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 ...
0
votes
0answers
14 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
73 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
116 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
13 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
26 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
38 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
28 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
13 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
99 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
45 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
35 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
17 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 ...
1
vote
0answers
10 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
46 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
30 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
27 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
15 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
26 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
30 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
57 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
20 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
35 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'), ...