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

Connecting to mysql via 127.0.0.1 instead of localhost

I have similar problem as here. The problem is that solution proposed there does not work for me: Just for now I have users: +----------+------------------------------------+ | user | host ...
-2
votes
0answers
15 views

Can't open hostname/phpmyadmin

Issue:When I try to browse to my server's hostname/phpmyadmin I get a local ISP error that "This URL was invalid." I can connect to my server's static IP and get the Apache web splash page to verify ...
1
vote
1answer
19 views

single click or command setup for webserver on unix system

One of the product has requirement of on premise webserver. We are using LAMP stack. We have selected website for on premise use due to business constrains. We are to install this on multiple servers ...
0
votes
0answers
8 views

error installing MySQL-python

I'm starting to learn python. When I try to install MySQL-python with yum from yum install MySQL-python.x86_64 I get this error Loaded plugins: katello, product-id, security, subscription-manager ...
0
votes
0answers
16 views

configure: error: invalid MySQL root directory

I've a problem installing sphinx with percona 5.6 on centos 6.4. I'm getting the following error while building from source: ...
0
votes
0answers
3 views

Cannot Merge Multiple layers in MySQL [closed]

With mysql diagram growing so large I will have to place the multiple layers into separate diagrams. Is there a way to merge all of the diagrams and connect the tables in each separate diagram and ...
3
votes
1answer
35 views

How to display text in UTF8 from mysql /phpmyadmin?

I have a database with multiple tables.The datatabase and table and every row of table is set to 'utf8_romanian_ci' . Every name which I import that contain diacritics will not be displayed corectly. ...
1
vote
1answer
23 views

Rails startup script runs twice

I'm having some difficulties with a new installation of Ruby on Rails. I want to use my application with MySQL. Here's the problem: The server starts without a problem when I use the default ...
0
votes
0answers
8 views

Centos 6 - Lighttpd/ 403 error on PHP files, and issues adding website

So, I do have PHP/MySQL and PHP-FPM installed, but when I try to access PHP files, I get a 403 forbidden error. I have been looking around Google quite a lot, and not finding anything that is solving ...
0
votes
0answers
3 views

WEB-INF/web.xml displays mysql credentials?

I found web.xml in /WEB-INF/ on a domain I'm associated with. In said xml file, I see it displays: <database> <jndi-name>jdbc/mysql</jndi-name> <driver> ...
0
votes
0answers
10 views

Trying to move the MySQL data directory on Ubuntu 12.04

OS: Ubuntu 12.04 I am trying to move the mysql data directory and log files to separate mounts to make it easier to swap out drives when needed in the future. ##Moving the MySQL data directory sudo ...
1
vote
2answers
27 views

How to completely shut MySQL server down on Ubuntu server

I had mysql server running. I stopped it, and removed it (apt-get remove mysql-server mysql-client) I then manually removed the directories: /var/lib/mysql /var/run/mysqld I rebooted. But when I ...
0
votes
0answers
2 views

encfs mysql datadir: Errcode: 13

I'm using encfs to encode the /var/lib/mysql data directory, but mysql returns Errcode: 13 at any attemp of create tables or databases. To do so, I moved all files to a temporary dir, created the ...
2
votes
1answer
37 views

Do we need a VPN?

We are looking at setting up a server for our university research group (small group of 5 people). The server is eventually going to be gathering and storing data from a number of our project partners ...
1
vote
0answers
37 views

How to keep mysqld alive with minimal memory?

I have a rackspace server that I have been renting to run my personal projects upon. Since I am cheap, it has 256Mb of RAM and honestly can't handle a lot. Every once in a while, when there is a sharp ...
0
votes
0answers
28 views

Error starting MySQL server through commandline on Mac OS X 10.9

I am installing MySQL manually on my Mac and during that I started MySQL through command line using this command $ /usr/local/mysql/support-files/mysql.server start Starting MySQL . ...
0
votes
0answers
5 views

error-> Could not update ICEautohrity file

error-> Could not update ICEautohrity file in my Cent OS operating system When i was unable to use my mysql database i stopped it and restarted the system. Then i got the error as error:- Could ...
0
votes
0answers
7 views

How to configure Mysql backend for Apache Nutch?

Just finished reading Apache Nutch tutorials, but they only talk about HBase. Any tutorials showing how to configure mysql backend?
0
votes
1answer
33 views

What would cause MySQL to not respond to connections on 127.0.0.1 but work fine using localhost?

having a strange issue on one of my CentOS servers. I've noticed MySQL randomly will not respond if I try to connect via 127.0.0.1 in my PHP script. Basically, 1 out of 20 requests or so will usually ...
0
votes
0answers
18 views

Access MySQL running on VirtualBox Win7 guest from a VirtualBox XP guest

I have a Windows 7 host, and 2 VirtualBox guest machines running on it. One has Windows7 as well and running a MySQL 5.6 server. The other guest has Windows XP. I want to run a software (for testing ...
1
vote
0answers
13 views

High available distributed web service based on LAMP to encounter link failure

Recently I started a project aims at decentralizing a Moodle e-learning web server to encounter link failure. Here's a detailed description: Connection here (rural area in Africa) is fragile (60-70% ...
0
votes
0answers
16 views

Wy is mysqldump producing structure only

OS Version: Ubuntu 12.04.4 LTS MySQL server version: Server version: 5.5.35-0ubuntu0.12.04.2 (Ubuntu) I have been using the following command to produce a data dump: mysqldump -u someuser ...
0
votes
0answers
25 views

How can I use FSContact Form to send email to database as a newsletter signup?

From the FSCF website, it appears to have the capability. As you see here, you can create a newsletter signup like this (basically it is a simple contact form that says "newsletter signup" but it's ...
0
votes
1answer
50 views

MySQL does not work on MacBook Pro after restoring from Time Machine

I just used Time Machine to restore my hard drive. However I am not able to connect to MySQL. I get the following error when I type mysql -u root -p. ERROR 2002 (HY000): Can't connect to local ...
0
votes
1answer
45 views

Add mysql connector support to jaspersoft studio

I want to use a mysql connection in jaspsersoft studio. The mysql connector is not included, and needs to be added, as is described in various places, e.g. here. Unfortunatly, it seems to be common ...
1
vote
0answers
11 views

How to forward data to mysql server using socket module in python

How to forward data to mysql server using socket module in python, i have try to import socket and connect it to mysql server for test, but have no data received from it, my code like this def ...
0
votes
1answer
24 views

Problems with MySQL [Minecraft Server]

I get an error with MySQL. My servers crash every day having something to do about Java. But this one was different. Error: http://pastebin.com/n2xLY50L Edit: I also have two values put in my ...
0
votes
1answer
18 views

Problems with MySQL [Minecraft]

I get an error with MySQL. My servers crash every day having something to do about Java. But this one was different. Error: http://pastebin.com/n2xLY50L Edit: I also have two values put in my ...
-1
votes
2answers
61 views

cPanel MySQL 5.5 Server keeps crashing (lots of errors + warnings)

I have a dedicated server (not a VPS/VM) running x64 Centos 6.5 Final + cPanel. The machine has 16 GB memory. I run a game server on this server (which uses MySQL as the back-end for data store). I ...
0
votes
0answers
15 views

MySQL SQL rules for user [migrated]

Let's say I have a MySQL database, with a table session_data containing: | ID | SESSION_KEY | SECRET_DATA | 100| ABCDEFGHIJK | bankAccountNumber=123123 Normally, users would have to authenticate ...
0
votes
1answer
38 views

remote connection to mysql

have two machine PC#1 with db mysql and appache and PC#2 with a c# form try to connect to this db here is my connection string used in PC#2: SERVER=My_public_ip;PORT=3306;DATABASE = my_test; UID = ...
0
votes
0answers
14 views

store mysql database details in linux

I have a test server and live server which has all the files the same (a cio) except I want to connect to a test copy of my msql database on the test server. How secure would it be to have a ...
1
vote
0answers
36 views

resolving host names from parallels (windows) to Mac (mavericks)

I was given a macbook for work that is running mavericks. We also do windows development. I'm currently running windows 8.1. I set up mysql on the mac side that both the windows 8.1 running on ...
0
votes
2answers
31 views

Linux server update

I know that for security reasons the server services have to be up to date, and since my server was attacked by a virus I think this a good time to upgrade the system. Linux sytem: Distributor ID: ...
1
vote
0answers
26 views

Mysql Master database goes offline for a while and slave database do not update data changes made during downtime [closed]

I have configured master-slave bidirectional replication.Both are syncing database properly.When master goes offline/down(disconnected from slave) and meanwhile I make some changes(create/delete table ...
0
votes
0answers
16 views

Bizarre lag in HTTP connection

Running on a LAMP stack, CentOS 6, Apache 2.2.3, PHP 5.4.25, MySQL 5.5.31 Have a very complex web application. It's been running pretty smoothly for about 5 years, now. Of a sudden we've run into ...
0
votes
1answer
18 views

Can i give foreign key relationships of ODBC tables from ms sql to ms access

I have a question regarding the ODBC relationships between SQL and MS ACCESS as i have migrated several tables from SQL to ms access and i performed some operations but the problem occured in ...
0
votes
4answers
72 views

Internal server error on user_directory

Today I am trying to install httpd and mysql on my fedora 14 PC. That works fine. After this I try to create a public_html folder on the user directory and allow php to access that folder. For that I ...
3
votes
4answers
151 views

bind-address = ::1 # however, netstat shows 0.0.0.0:3306 LISTENING

I'm running MySQL 5.6 on 64-bit Windows 7 with IPv6 and IPv4 enabled. In my.ini: port=3306 bind-address = ::1 I was hoping to use IPv6 and restrict to the loop-back adapter. I used ::1 instead ...
0
votes
0answers
15 views

Save rows effected from mysql delete statement in bash

I am trying to create a bash script that will connect to my database and purge older records, I would like to keep a record of the number of rows are deleted in a file (lets call it rowseffected.log). ...
1
vote
2answers
34 views

Nagios: monitor mysql auto_increment overflow

Recently we had an overflow in an auto_increment column in a mysql table. Now I'd like to monitor our databases with nagios, so that we'll be alerted whenever an auto_increment column comes near to ...
1
vote
0answers
23 views

How to prevent mysql blobs from borking my terminal

When using the linux terminal client for mysql, every column with a blob prints out tons of control characters and the terminal has to be reset. This looks something like the following Map: �PNG ...
0
votes
0answers
14 views

Reading Text file in Where clause in mysql

I want to look up a table upon certain column whose values are present in text file in mysql. like select * from table where user LIKE '%user1%' here all users like user1, user2.. usern are stored in ...
0
votes
1answer
22 views

Why there is always a tilde (~) sign in the result message in mysql

Whenever I refresh or search anything in the table in mysql, the result message always shows result like this. Showing rows 0 - 10 ( ~11 total , Query took 0.0004 sec) When it is showing the exact ...
0
votes
3answers
26 views

Setting up a local webserver using CentOS on VM

im new here, and basically new at setting up a webserver... now im already googling, and searching here in stackexchange on how to setup a webserver, they tend to direct me to a working server.. i ...
0
votes
0answers
22 views

In Mysql Workbench, where is Synchronize Model with Database

As displayed in Mysql Database Synchronization documentation. I cannot find this particular Synchronize Model with Database window / wizard under Database -> I have Mysql Workbench 6.0.9.11421 ...
0
votes
1answer
161 views

MySQL Notifier High Severity Error at startup

When i start MySQL Notifier up and error like this is shown: "High Severity Error" "Object reference not set to an instance of an object." And when i click over "Show Details" I can see the ...
0
votes
1answer
19 views

How to ensure version 5.5.* for mysql with puppet?

How can i ensure that the latest patch version of 5.5 will be installed by the yum installer under CentOS? class { '::mysql::server': package_ensure => '5.5.*' }
1
vote
1answer
33 views

Can't find mysql data in install directory

I was looking for my mysql data on my harddrive, so i went to the install directory (C:\ProgrammData\MySQL\MySQL Server 5.6\data) but there are only a few of the databases displayed I actually use. ...
1
vote
1answer
30 views

MYSQL fails with: InnoDB: Operating system error number 30 in a file operation

My MYSQL server has been stopping recently about once a week. It requires a reboot to get is working again. But once its rebooted, it will work again for another week or two. The error in question is ...