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

learn more… | top users | synonyms

1
vote
0answers
936 views

Why can't I access MySQL server with port forward rule in router?

This is my setup (the relevant parts, anyway): I have port forwarding rules in place (in the Linksys) for all the relevant ports and I've restarted that router multiple times, each time hoping that ...
0
votes
1answer
345 views

SLES11 - DBD: Can't load driver file apr_dbd_mysql.so

We're trying to set up a htaccess authentication with user data from a MySQL database. The part of vhost.conf looks like that: DBDriver mysql DBDParams "host=<XXX> dbname=<XXX> ...
2
votes
2answers
1k views

Installing phpmyadmin package ERROR 1045 (28000)

I need to create a new mySQL db for a local site, I thought I'd do that with phpMyAdmin so I installed that package like so: sudo apt-get install phpmyadmin During this process I get a couple of ...
4
votes
1answer
87 views

Autostart PtokaX at boot only after mysqld has started

I've the following script in /etc/init.d/server.sh #!/bin/bash ### BEGIN INIT INFO # Provides: PtokaX server # Short-Description: PtokaX P2P server ### END INIT INFO ...
0
votes
0answers
76 views

Trying to run toad for mysql with wine in mint 16

I'm trying to run toad for mysql with wine in mint 16, however I get this error: me@me-mint ~/Downloads $ ./ToadforMySQL_Freeware_7.0.0.2038.exe fixme:storage:create_storagefile Storage share mode ...
1
vote
1answer
45 views

Dual web servers that load balance and point to the same database

So I am currently running a web server at my house with a Raspberry Pi. Quite successfully might I add. The only problem is that sometimes the SD card becomes corrupt and my site goes down for an hour ...
0
votes
1answer
58 views

Understanding Postfix and Courier IMAP

I'm setting up my own mail server, and I'm very new at this... and I'm getting lost. I need your help in determining some parameters the way I know them already, because the configuration is huge. ...
0
votes
1answer
424 views

Using PHPMyAdmin or MySQL Workbench, how to search across 10 tables and return all records matching a specific criteria?

This seems like it should be so simple but I'm having a hell of a time solving it. I have 10 tables named in the following way: b1_settings b2_settings ... b10_settings I need to search across all ...
0
votes
0answers
145 views

Mysql error 28 no space left on the device

I keep running in to the same problem with mysql with error code 28 which means there is not enough space left on the device. Now the weird part is that there is enough space, here are some tips i ...
0
votes
1answer
109 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
108 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
103 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
33 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
72 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
25 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
47 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
126 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
146 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
57 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
51 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
69 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
24 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
41 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
1answer
467 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
95 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
101 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
28 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
121 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
80 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
142 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
153 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
90 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
755 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
62 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
82 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
117 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
404 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
202 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
373 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
950 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
50 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
286 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
2k 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
392 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
41 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
115 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
120 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
868 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
203 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 ...