0
votes
1answer
27 views

mysql client won't run on my Ubuntu instance

Running a LAMP server on Ubuntu 12.04. Trying to run mysql from the command line like so: root@server:~# mysql -u 'wp-user' -p and I'm getting mysql: ambiguous option '--v' (vertical, version) ...
2
votes
2answers
67 views

Apache2 and MySQL fail to restart after Server restart or apt-get update

Does anyone know of any reason why Apache2 and MySQL do not run after either a server reboot or apt-get update? I am currently running Ubuntu 12.04 LTS server There are the corresponding files in ...
0
votes
2answers
55 views

Monit issues with mysql Ubuntu server 12.04

I've installed Monit on Ubuntu server 12.04 but Im having issues getting mysql monitoring to work at all. Here is what I have done so far. #/etc/default/monit startup=1 #/etc/mysql/my.cnf pid-file ...
1
vote
1answer
83 views

ERROR 1044 (42000): Access denied for 'root' With All Privileges when root user is missing in plesk installation

My provider has supplied a Ubuntu 12.04 LTS LAMP installation with a bunch of software preinstalled. The system is supposed to be mantained using Parallels Plesk (which I unfortunately didn't know ...
0
votes
1answer
154 views

MySQL Workbench: 'Disk Space in Data Dir' limited to 20G [closed]

I have an OVH private server (Ubuntu 12.04, 8 GB RAM, i3-2130, 2x500 GB HDD) and I'm dealing with MySQL administration. I have installed MySQL Community server 5.6.16 correctly and it works fine(it ...
2
votes
1answer
221 views

mysql wont start after update (seems an apparmor issue)

I just updated mysql-server to 5.5.35-0ubuntu0.12.04.1 and MySQL does not restart anymore. dmesg shows following errors: [ 832.490460] type=1400 audit(1392612759.575:31): apparmor="STATUS" ...
-2
votes
1answer
478 views

Removing Unnecessary Services & Packages in a MySQL Ubuntu 12.04 Server [duplicate]

As part of hardening a standalone/dedicated MySQL 5.6 server running on Ubuntu 12.04 LTS, unnecessary services and packages will have to be removed. For a server that is serving only as a MySQL ...
0
votes
0answers
57 views

MYSQL became unresponsive after some time (In my case 30 mins) on high load (400 concurrent thread per hour)

I am doing load testing on my application using MySQL server for the same. Here I am putting load of 400 users per hour for doing something on application. I have done some MySQL tuning at my.conf ...
0
votes
1answer
63 views

MySQLd all queries 'Lost Connection'

I am running mysql 5.5 on ubuntu 12.04 I have many databases : the main one has ~15k innodb tables with a ~2GB size and the other one is a db for simple machine forum ~50MB. 2 days ago, all my ...
1
vote
2answers
98 views

mysql fails every day at the same time and when many requests occurs

I am 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. The first: Every day ...
0
votes
1answer
89 views

Website is slow without https

As you can see, http://coinad.com/ is slow, and https://coinad.com/ is fast. I've upgraded the server, reviewed the code, optimized the tables and anything seems to work. This is driving me mentally ...
0
votes
1answer
219 views

Ubuntu 12.04 Server - MySQL keeps crashing - Possible InnoDB problems

I have been searching for a solution but nothing seems to work. I have a single Drupal 6 website up on this server. Server:Ubuntu 12.04 Apache/2.2.22 (Ubuntu) 5.3.10-1ubuntu3.8 MySQL 5.5.32 Drupal ...
0
votes
2answers
443 views

Extremely high mysqld CPU usage with no active queries

I have a VPS running Ubuntu 12.04 LTS with LEMP stack, followed the guide from Linode Library (since I'm using a Linode) to setup, and everything worked fine until now. I don't know what's wrong, but ...
1
vote
1answer
125 views

Ubuntu 12.04: Unable to add or delete a user named 'mysql'

I am trying to install MySql on Ubuntu 12.04 but the installation is failing with the error: "Can't change to run as user 'mysql'. Check if the user 'mysql' exits." So I go ahead type in the command ...
1
vote
1answer
208 views

MySQL Crashing and failing to restart

MySQL seems to be crashing, normally later in the day but I can't see why! It says out of memory but there is loads of free ram and no swap space being used. I'm using Azure. Here is the log: Oct 3 ...
0
votes
2answers
98 views

Will re-installing phpmyadmin will have any effect on my Databases?

I am quiete new and somehow I crashed my phpmyadmin website, it can't be displayed without errors after changing the port of it once. So does it has any effect on my databases when I reinstall my ...
0
votes
0answers
124 views

mysql-server-5.5 (5.5.32-0ubuntu0.12.04.1) … start: Job failed to start

Seems this issue is common but I cannot solve it. How do I reinstall mysql-server. Every time I try, I receive this crash message. Setting up mysql-server-5.5 (5.5.32-0ubuntu0.12.04.1) ... start: ...
0
votes
0answers
12 views

configure hibernate.cfg.xml for MySQL on Ubuntu 12.04

I tried to rebuild project settings from SQL Server to Apache 2 with MySQL. I newly at JDBC and can't figure out all aspects. I installed according this tutorial MySQL/JDBC Driver Setting Up ...
0
votes
2answers
190 views

MySQL without password prompt?

I have a MySQL server with the MySQL root password is an empty string. If I try to connect to MySQL without a password, I am denied. Like this: # mysql ERROR 1045 (28000): Access denied for user ...
0
votes
0answers
157 views

problems while installing python-mysql package

I've got an Ubuntu 12.04 x64 Server edition VM that I'm running python2.7 on and trying to install the MySQLdb package via the command (I've already got easy_install installed and working): $ sudo ...
0
votes
1answer
46 views

Recover lost POST data on LAMP site

I've had a screwup on my LAMP based site where a certain string value that's posted to the site from a form, was not being stored in the db. The db column for it was an enum but it needed to be a ...
0
votes
0answers
97 views

Is there a way to diagnose an apt-get installation?

The mysql daemon has been failing to start and after an apt-get purge and trying to reinstall the installation fails. Is there some way to diagnose the failure of the installation? The ...
1
vote
1answer
630 views

apt-get purge mariadb leaving traces which stop mysql install

I'm trying to bug test a database issue with a website I'm working on. I would like to see if switching between mariadb and MySQL fixes the issue (however unlikely that is). I thought this would be a ...
4
votes
2answers
62 views

What is the effect of adding a user on a MySQL slave?

This is on a Ubuntu 12.04 server running MySQL 5.5 which is slaved to an OS X server running MySQL 5.1 Logrotate has been sending error: error running shared postrotate script for ...
0
votes
2answers
357 views

Ubuntu, mysql server connection

Hello everybody please ignore my noobness, My problem start from connecting to mysql on ubuntu 12.04 ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
-1
votes
1answer
50 views

Server A cant connect to Severs B's mysql database [closed]

I have two servers both running mysql on Ubuntu 12.04. I have an application on Server A which has to connect to Server B's database. I have opened the my.conf file on server B and make the ...
0
votes
0answers
171 views

MySQL won't start, reinstall fails on Ubuntu 12.04

My problem started yesterday night when I tried to change the my.cnf config on my ubuntu 12.04 x64 System. I simply tried to changed the bind-address parameter from 127.0.0.1 to 0.0.0.0. A simple ...
-2
votes
1answer
165 views

MySQL memory leak?

I've just installed a brand new server image, and have been finding that MySQL has been consuming a lot of memory despite the fact that nobody's been querying it. I checked free -m to see if it was a ...
0
votes
1answer
873 views

Install Navicat for MySQL on Linux Ubuntu 12.04

How do I install Navicat on Ubuntu Desktop 12.04? I have just configured a new Ubuntu 12.04. Because I'm not so familiar with the command line, I prefer to use Ubuntu Desktop so that I can have a ...
0
votes
1answer
94 views

Ubuntu 12.04 VPS doesn't boot with mysql in nsswitch.conf

1and1 VPS ("dynamic cloud server") does not boot any more as soon as mysql lookup is enabled in nsswitch.conf - any suggestions appreciated. Minimal setup to reproduce the problem: install Ubuntu ...
0
votes
0answers
71 views

Cant connect to mysql server

I'm trying to configure a freshly installed mysql server to listen on port 3306. I've removed skip_networking, I have changed bind-address=172.20.33.1 (which is my server ip) and it completely ...
0
votes
2answers
596 views

Best way to recover mysql from a “chmod -R 777 /” with databases intact

Question: What is the best way to recover mysql (or worst case: migrate away) from a "chmod -R 777 /" with databases intact? System: Ubuntu 12.04 LTS MySQL 5.5.24 64 bit Amazon EC2 cloud server. ...
0
votes
0answers
37 views

shutdown temporary specific database

I have a wordpress installation on my VPS and it uses too much RAM. Is there a way to temporary shutdown this wp, so it wont make use of the database it is connected to and earn that additional ram ...
0
votes
1answer
518 views

Getting mysqld_multi to work with upstart

I used this guide to get started and this wiki page as a reference for the upstart script. My problem is that when I do a service mysql start I get six processes instead of two, as if upstart ran ...
9
votes
3answers
18k views

What is the ibdata1 file in my /var/lib/mysql directory?

Logging in to my Webmin control panel, I noticed that virtually all of my disk space is full. I searched for the ten largest files/ directories on my system and found that a file called ibdata1 is ...
2
votes
2answers
6k views

Error 2013: Lost connection to MySQL server during query when executing CHECK TABLE FOR UPGRADE

I just upgraded Ubuntu from 11.10 to 12.04. My rails app now returns the (passenger) error "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) (Mysql2::Error)". I ...
1
vote
1answer
417 views

Wordpress : Shift from local MySQL to Amazon RDS Mysql?

i have a 32 bit Bitnami ubuntu wordpress stack ami for amazon and hence a working wordpress installation. My questions are 1)How can i shift over to amazon RDS mysql from local MySQL. And if more ...
1
vote
1answer
168 views

MySQL Password Authentication with Proxy Users and Group Mapping

I'm actually using MariaDB here, but I'm working under the pretext that MariaDB is a "drop in replacement" for MySQL. I won't be surprised if this winds up being a cross platform difference/issue, but ...
1
vote
1answer
124 views

MySQL crashes once every ~24h

I've a bit of a problem with MySQL crashing once every ~24h. This is the error log. 121205 9:42:49 [Note] Plugin 'FEDERATED' is disabled. 121205 9:42:49 InnoDB: The InnoDB memory heap is disabled ...
1
vote
0answers
492 views

MySQL crashes when connecting from localhost with tcp (UNIX sockets work)

I have Ubuntu 12.04 running MySQL server 5.5.24. I can connect with mysql --user root -p. status shows me : ... Connection: Localhost via UNIX socket ... When I try to connect with mysql --host ...
0
votes
0answers
290 views

Can’t start MySQL on Ubuntu 12.04 after restored from innobackupex

I can’t start MySQL on Ubuntu 12.04 after restored backup from innobackupex. Before I tried to restore the db from backup I moved the datadir and got the same problem. With help from google I fixed ...
0
votes
1answer
255 views

Ubuntu 12.04 php5-fpm stopped recognizing MySQL

So this morning I used aptitude to install a few security updates. Seemed innocent enough until stuff stopped working. Somewhere along the way, a few packages got dropped, I guess. Now PHP ...
0
votes
1answer
73 views

Is case relevant in SQL commands?

MySQL 5.5 on Ubuntu 12.04.1 I know that the databases, users, tables, etc. are case-sensitive (at least on Linux). But what about the commands themselves? For example, compare: SELECT * FROM ...
1
vote
1answer
132 views

High mysql server load, sar output

I have a MySQL Server that should be performing better than it seems to be. We're running ubuntu on a Amazon Cluster Compute (cc1.4xlarge) Linux ip-10-0-1-60 3.2.0-25-virtual #40-Ubuntu SMP Wed May ...
0
votes
2answers
1k views

Trying to install Mysql on Ubuntu Server 12.04

I am currenty trying to install MySql on my Ubuntu 12.04 server. But I got problems, When i run sudo apt-get install mysql-server it runs, ask me for a Yes but then. It returns Temporart failure ...
0
votes
1answer
2k views

How to disable LOCAL INFILE in MySql 5.5 Ubuntu 12.04

Cannot disable LOCAL INFILE ( for security reasons ) in mysql Ver 14.14 Distrib 5.5.25a, for debian-linux-gnu (i686) using readline 6.2 on ubuntu 12.04; Here is my /etc/mysql/my.cnf [client] port ...
1
vote
2answers
3k views

Can't install mysql on ubuntu 12.04, Can't find messagefile '/usr/share/mysql/errmsg.sys'

Trying to install mysql, using apt-get but it fails # apt-get install mysql-server Reading package lists... Done Building dependency tree Reading state information... Done The following extra ...
2
votes
1answer
293 views

Partitioning and configuring a RAID array for a dedicated MySQL server

I'll be running ubuntu server on a 3 disks server (450 GB each) and 16 GBs of RAM. My target at the moment isn't configuting MySQL itself, but what could be the best RAID configuration for my case ...
2
votes
1answer
812 views

php-mysqlnd or php-mysql (ubuntu)

Long story short: just installed Ubuntu 12.04, nginx, php-fpm and mysql. Now I need the MySQL driver for PHP, but which should I choose? php-mysqlnd or php-mysql?