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
1answer
69 views

delete a MySQL database with a strange name

I started to maintain a MySQL database and I have no idea who and why this database was created: "#mysql50#backup-2012-03-01". I want to get rid of this one, but the following commands did not work: ...
0
votes
2answers
81 views

Backup mysql from files

I have problems running MySQL (I'm in rescue disk and can't run anything) and I would like to backup up the databases from the system files because I'm planning on formatting the system. How can I do ...
0
votes
0answers
95 views

MySQL not starting Error 1067, error with InnoDb recovery

The Log file states this.. could you please help 2014-01-22 16:24:51 5484 [Note] Plugin 'FEDERATED' is disabled. 2014-01-22 16:24:51 5484 [Warning] option 'innodb-autoextend-increment': unsigned ...
1
vote
1answer
31 views

Tool for converting tables into 2nd, 3rd and 4th normal forms? [closed]

I'm looking for a tool that will convert a table, in CSV format, into 2nd and 3rd normal forms. I've found many tutorials and examples on the process, but no tools. I'm running Windows 7 on PC.
0
votes
0answers
59 views

Mysql tables corrupt when plugging off power on mac os server

I have apache and mysql running on mac os server (mavericks). I use some automation php scripts to sent queries to mysql db and also some other scripts that can be run on demand. Everything worked ...
0
votes
0answers
22 views

Master - Slave - Master — MySQL

I need to make master - slave replication with MySQL. But I have one question... is it possible to convert the master in slave and the slave in master when the master dies and the slave is promoted to ...
0
votes
1answer
38 views

Debian: Login to mysql doesn't work

So I rented this server with Debian 7, and wanted to install a webserver, and followed the following tutorial: http://www.howtoforge.com/ubuntu_debian_lamp_server And I'm now stuck at the PHPMyAdmin ...
1
vote
1answer
85 views

MySql server only working with localhost

I installed mysql server on my machine and I could connect using MySqlWorkbench as localhost (port:3306). But when I change the localhost to my machine name it is not working. I need to access the ...
0
votes
1answer
82 views

MySQL Workbench 6.0 ce will not start on Windows 8 Pro

Just install windows 8 Pro Install xampp for mysql and php while install mysql workbench 6.0 Install went fine but the application does not start Try to install the version of mysql workbench ...
1
vote
1answer
50 views

How to install MySQL on OS X Mountain Lion? [duplicate]

I tried downloading the MySQL community server from the MySQL website, however, when I try to open the installer, I get a popup saying "You may only run executables from the Mac App Store". What kind ...
0
votes
1answer
46 views

Allowing any MAC admin user to run MySQL server on startup

I recently installed MAMP on our server in order to launch a Wordpress site. Though everything is working fine I am not the computer's main user, something which results in long downtime when it has ...
0
votes
1answer
53 views

How to run this command in CMD Windows

I' am not an expert in CMD. I want to reset my MySQL Database password. I saw articles online which only says to run the following command C:\\Program Files\MySQL\MySQL Server 5.6\bin\mysqld-nt ...
0
votes
0answers
19 views

how to install geoserver and mediawiki on the same machine?

on a w2k8 r2 machine, geoserver is installed --- mysql is used for geoserver. it works fine. now, mediawiki has to be installed. bitnami installer will be used. could this one affect the prior ...
0
votes
0answers
33 views

Liferay Production Issues

I've sought out an answer for this for weeks now and am completely stuck. WHO CAN HELP ME HERE? I've got Liferay 6.2 installed on a Dev server in production mode on top of Web Logic 12c. The ...
0
votes
0answers
292 views

SUPER,REPLICATION CLIENT prev to external MySQL user

I'm trying to create an MySQL slave, but I'm not able to grant SUPER,REPLICATION CLIENT to the external powerdns user. I'm using phpMyAdmin and granted ALL PRIVILEGES to the powerdns user, but it ...
0
votes
0answers
82 views

Upgrading MySQL on RedHat 6.5 and installing MySQLdb

I have a fresh (clean slate) VM with RHEL 6.5 installed. I've been trying to upgrade MySQL 5.1 that comes with it by following one of the resources that I found online. But, when I try to install ...
-1
votes
1answer
76 views

use basic auth over an https connection for phpmyadmin

I'm having issues with my server that was recently investigated by a website scanning tool. The result as follow. Impact: User credentials are sent as cleartext and are vulnerable to packet ...
0
votes
0answers
26 views

Connect sequel pro to db on another networked computer

I have a local network computer that is set up to run php etc and can be accessed using host names such as mysite.dev etc all works well. At the moment the php server / computer uses workbench to ...
0
votes
0answers
86 views

MySQL database on external encrypted hard drive

I want to move MySQL database installed on my "Windows 7 Enterprise" PC to an external hard drive which is PGP 2.0 encrypted. Could you please suggest how to do this?
0
votes
1answer
71 views

Multiple requests shut down MySQL

I have some problems with my MySQL database. I configured a server with the database and other services (apache, php) and put run multiple applications. There are two problems: Every day at the ...
2
votes
2answers
138 views

Why would a MySQL function be getting randomly dropped?

I have the following function that is used in several databases on my server. CREATE FUNCTION `fn_strings_intersect`(arg_str1 VARCHAR(255), arg_str2 VARCHAR(255)) RETURNS varchar(255) CHARSET latin1 ...
0
votes
0answers
134 views

Attempting to recover MySQL (MariaDB) Server InnoDB Tables after server crash

So sometime early in the morning the database server which powers all our sites crashed during a system update and lost its partition tables, after my friend did something we managed to get the system ...
0
votes
0answers
75 views

Synology mysql indexing

I'm trying to set up a mysql server for my xbmc library. I was able to successfully set this up. Unfortunately my library is large and it slows xbmc down compared to local library. I was advised to ...
2
votes
4answers
458 views

MySQL - “Root Element is Missing”

Something has happened to the MySQL server installation on my computer. Normally, the MySQL notifier program, which is supposed to start automatically and run in the system tray has stopped starting ...
0
votes
1answer
44 views

How do I monitor resource usage of crond php scripts?

I am using a VPS which is running 5 php scripts on a minute by minute basis using cron. Each script, itself, loops to execute a mysql query then sleeps for between 5 and 15 seconds. They all ...
0
votes
1answer
66 views

Useradd command vs MySQL CREATE USER

Do users and passwords created by useradd command in linux also register them with same creditionals in MySQL database?
0
votes
0answers
75 views

Need convert my Vanilla 2 forum to phpbb3. I found some great progress, but don't know how to finish them

Alright, so I'm wanting to convert my Vanilla 2 forum to phpbb3. Ive searched all over the internet and found countless requests for such a thing, but almost zero help. Theres supposedly a way to ...
0
votes
1answer
304 views

installing apache, php5 on windows 7 64 bit [production]

The easiest way to install apache, php, mysql and phpmyadmin on windows is to download and install XAMP. The problem is that it is meant for development purposes and is not recommended for production ...
0
votes
0answers
163 views

MySQLInstallerConsole correct command line arguments?

I have tried: MySQLInstallerConsole.exe --action=install --product=mysql-5.5-win32 --configure=mysql-5.5-win32:passwd=apassword --type=server And I get the following error: Error: Found 3 ...
1
vote
1answer
234 views

mysqldump not on wamp server

I am trying to use mysqldump on my wamp server mysql console however, it doesn't seem to have mysqldump included. I found the mysqldump.exe file in this location: ...
1
vote
0answers
770 views

Postfix: SMTP, use port 587 rather than 465

I have set up a mail server on AWS EC2 using the instructions from Flurdy: http://flurdy.com/docs/postfix/ it has mostly gone well. My issue is that I would prefer to use SMTP port 587 with TLS ...
0
votes
0answers
37 views

phpMyAdmin only shows two databases

Having a weird problem where mysql is showing multiple databases when I go SHOW DATABASES; I get 5 results. When I go to phpMyAdmin I only get two: information_schema and test. If you could ...
1
vote
2answers
228 views

How to connect local apps (i.e. rubymine, prosequel) to remote server using AWS private key?

Programs that allow remote connections (usually in ssh) typically request a user name/pwd to connect to a remote server: see the below examples from sequelpro and rubymine, respectively: Sequel pro: ...
1
vote
1answer
1k views

MySQL server 5.5 on CentOS 6.5 error: “mysqld: unrecognized service”

I am using CentOS 6.5. I installed MySQL Server 5.5 from a .rpm package (downloaded from the official MySQL site) using the default .rpm installer. I also installed MySQL Client package the same way. ...
2
votes
3answers
271 views

MySQL Workbench equivalent for OS X

Is there any equivalent of MySQL Workbench for OS X? The current version is very slow and hangs up even with 8GB RAM.
0
votes
0answers
31 views

Bugzilla mail template not supported in outlook

I have installed bugzilla 4.2 version in linux centos 6.4. Everything working fine except mail format. It is not supporting in outlook. whenever we raising the bug from bugzilla mail delivered in ...
2
votes
1answer
69 views

How can I enforce atomic inserts?

I'm working on an application backed by a MySQL instance, and I've encountered strange behavior involving what seems to be "phantom" inserts. Given a table with an auto-incrementing integer key, I ...
0
votes
1answer
95 views

How to install Mysql on oracle Virtual box which has Opensuse OS

We have an open suse image on Virtual Box, which doesn't have mysql libraries. Can we install mysql libraries onto that image ? If so how ?? Please Help..
0
votes
1answer
445 views

Writing typical MySQL query in excel

I'm trying to run a MySQL query in excel. I've set up ODBC in excel and the connection to database is solid. Is there a way to input my usual query (e.g. select * from table where date= 20131212) to ...
0
votes
1answer
2k views

Starting MySQL database server mysqld[fail]

Today I install MySQL on my Ubuntu 13.10, and it worked very well. But after I restart the computer, when I restart MySQL, it failed, and the log from /var/log/mysql is: 31216 22:40:25 mysqld_safe ...
1
vote
1answer
166 views

Centos 6 - Can't get out of safe mode

So I was going into safe mode from following a tut to fix the error Access denied for user 'root'@'localhost' (using password: NO) And I had issued the following command: mysqld_safe ...
0
votes
0answers
46 views

Trying to migrate a mysql server to AWS

Please advise on how to migrate my local mysql server to the cloud. Currently I have a Fedora linux box and a NAS attached to it via ethernet. I believe the best way to go about it is : Take a ...
0
votes
0answers
30 views

Moved database from Production to development - get 403 error

I exported a Wordpress mysql database from my production server to my development server because I had done some updates on production and wanted them on dev. Now I get a 403 error and no matter what ...
0
votes
0answers
47 views

Connect to MySQL from Integration Services 2012 (SISS)

I am trying to read the schema of a MySQL table on Microsoft SQL Server 2012 Integration Services (SISS), I can successfully "test the connection", get the list of tables, however it seems I can't ...
0
votes
0answers
76 views

mysql store procedure text fili

In MySQL using sqlworkbench, how can I create a procedure for a table to get the input value (only the first 100 rows) from the text file and store it in the database? For example: in the text the ...
0
votes
0answers
43 views

Apache doesn't start in Ubuntu

I'm trying to get my apache2 to work under Ubuntu. I've installed all packages from MySQL to PHP and Apache. When I program on PHP, the PHP scripts aren't recognized and aren't interpreted. I ...
0
votes
1answer
260 views

Can't access server from public wifi

I have a MySQL server (XAMPP) running on my computer and I can't access it from the university wifi. It's working from my home, from my friend's home and on my cellphone (3G), but it just won't work ...
0
votes
3answers
7k views

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

So at first I was getting this error when trying to create databases for use in phpmyadmin. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I ...
1
vote
2answers
133 views

Installing from rpm gives weird dependency error

I'm trying to install mysql from rpm file and this is what is get. libaio.so.1 is needed by MySQL-server-5.6.14-1.el6.i686 libaio.so.1(LIBAIO_0.1) is needed by MySQL-server-5.6.14-1.el6.i686 ...
0
votes
0answers
1k views

MySQL Daemon Failed to Start - centos 6

So not sure why I am getting such error. When I type: mysql I get: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I know that there should ...