Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
0answers
124 views

dependency issue while installing phpmyadmin on nginx webserver

I tried to find a solution for this problem for a long time but I cannot find it. Maybe you can help me. I have Ubuntu 14.04 installed on my system and want to use it for web development using nginx. ...
0
votes
0answers
70 views

Ubuntu php5-fpm www.conf pooling

Ubuntu VPS with 4GB RAM running wordpress with nginx, php5-fpm, and percona mysql 5.5 Daily unique visitors 8000 Maximum concurrent connections 90 For the above which is better www.conf (php5-fpm ...
0
votes
1answer
635 views

trouble in installing mysql workbench

i am trying to install mysqlworkbench in my ubuntu using sudo dpkg -i mysql-workbench-community-6.0.9-1ubu1310-amd64.deb.3 but getting following errors (Reading database ... 188276 files and ...
0
votes
0answers
24 views

Problem with i7 notebook running ubuntu - Good hardware

I use ubuntu 14:04 on a notebook for web development. However, about 3 times a day it enters 'bottleneck'. The processing and memory usage go into space. Patiently when I'll see what is happening with ...
0
votes
2answers
254 views

How to install MySQL in Ubuntu Minimal 12.04

How can I install MySQL in Ubuntu Minimal 12.04? When I try to apt-get install mysql-server (as root) even after apt-get update and apt-get upgrade in a fresh install, I receive this: # Setting up ...
0
votes
0answers
139 views

Ubuntu Minimal 12.04 with MySQL installation errors (and minor issues, like the lack of Dialog and ReadLine)

I am trying to start my server with Ubuntu Minimal, because I will not use 90% of the default stack included in Ubuntu Server. But I can't install MySQL, getting erros like these: # Setting up ...
0
votes
0answers
143 views

copy the MySQL Connector/J jar file to the domain-dir/lib directory

Where is the MySQL JDBC connector JAR supposed to go? To do this, copy the MySQL Connector/J jar file to the domain-dir/lib directory. For example, copy mysql-connector-java-5.1.30-bin.jar to ...
0
votes
1answer
205 views

/usr/lib/i386-linux-gnu/libmysqlclient.so.18: no version information available

I wrote a program in C++ (QtCreator) on Ubuntu 14.04 LTS which reads values from Web-API's (curl) and stores them in a MySQL Database (using the MySQL C-API). When I start the program on my Desktiop ...
0
votes
0answers
141 views

Scheduled Cron Back up from EC2 to S3

I have created a script for scheduling sql back ups and store in Amazon S3. Below is the script that I used for taking backups. DATABASES="testdb" testdb_USER=root testdb_PW=root ...
0
votes
2answers
670 views

Installing LAMP - PHP not connecting with MySQL - Why?

Am followoing this amazingly simple LAMP tutorial http://ubuntuserverguide.com/2014/06/how-to-install-lamp-in-ubuntu-server-14-04-lts.html Installing Apache Installing MySQL Installing PHP The ...
0
votes
0answers
175 views

Mysql connection error

I'm newly installed Ubuntu 14.04 on my system. And I individually installed apache2, mysql 5.6.19 and PHP Version 5.5.9-1.whenever I connect to database it's giving error in the console window like ...
0
votes
0answers
55 views

access denied from local host

Ok, I've set up my server and have been having fun designing my website. At the moment I've got several php files that access my MySQL databases. everything is ok client side and the php has no ...
0
votes
0answers
244 views

DBI failed to connect mysql

I encountered DBI connection failure to mysql when I tried to install and configure the orthoMCL programs. I would appreciate very much if you can help diagnose and advise some troubleshooting tricks. ...
0
votes
1answer
190 views

mysqld is suddenly taking too much memory and my laptop is getting hotter

I have been using ubuntu 14.04 for a while but really new to linux command line stuffs. I mainly use it for Java/android/web development purposes. Sometimes I notice my laptop gets more hot than ...
0
votes
1answer
380 views

mysql_config_editor not included in MySQL APT Repository?

I've installed MySQL from MySQL APT Repository. Now I want to run "mysql_config_editor" to encrypt my .mylogin.cnf, but it displays: The program 'mysql_config_editor' is currently not installed. To ...
0
votes
0answers
137 views

MySql crashes happening daily after ubuntu system updates

I have been having this issue for sometime and have no idea why it happens or how to fix it. I'm a Linux novice so that doesn't help. I have a server running on AWS and s used only for hosting ...
0
votes
0answers
122 views

Does VM require Swap? su: fork: Cannot allocate memory

We have Mysql Server in AWS environment in Ubuntu 14.04. Recently our server lost new connectivity like ssh, or scp any connections due to cannot allocate memory. And my existing connectivity to ...
0
votes
1answer
68 views

Not installing softwares after changing the server

I changed the download server from sri lanka server to US server using software and update window. Then I tried to install mysql using this command. sudo apt-get update sudo apt-get install ...
0
votes
1answer
58 views

I am not able to install mysql on ubuntu after unistalling it

I have to install MySQL in Ubuntu for a class. The first time intalling mysql it worked perfectly. However, I accidently ran the sudo mysql_secure_installation command when I wasn't supposed to. I ...
0
votes
1answer
555 views

What version of “mysql-connector-java” to include in pom.xml for ubuntu 14.04

The mysql server version installed is 5.5.38 as verified by sanchit@sanchit-3560:/$ mysql --version mysql Ver 14.14 Distrib 5.5.38, for debian-linux-gnu (x86_64) using readline 6.3 But in the ...
0
votes
0answers
86 views

JUJU - deployed wordpress and mysql - Error establishing a database connection

After a week of deploying wordpress on juju with mysql, the site has gone down with the error: "Error establishing a database connection". Juju status is not working at all and I can't seem to ssh on ...
0
votes
0answers
224 views

Apt-get unmet dependencies

I´m using Ubuntu Server 12.04 and MySQL 5.5. When I try to install libsml2-dev I get the following message : root@myserver:/usr/local/php5516/php-5.5.16# apt-get install libxml2-dev Reading package ...
0
votes
0answers
124 views

PhpMyAdmin wont let me log in without password

I am preparing a Vagrant box to develop websites and I wanted to install phpmyadmin, to log in just as "root", no password needed, since it is just for development, but whenever I try it, I get the ...
0
votes
1answer
309 views

Skipping incompatible error when compiling mysql library using arm-linux-gnueabihf

All problems posted related to mysql library use standard gcc compiler. However, I need to compile a project running on a beaglebone black device. Hence, I am using arm-linux-gnueabihf-gcc instead of ...
0
votes
0answers
23 views

Remote access times out after update

Here is the situation: I have a MacBook which I use for all of my development and an Ubuntu server running a LAMP stack for my website. I've only had Linux anything for a few days so please bear with ...
0
votes
0answers
44 views

UnsupportedClassVersionError with OpenJDK 1.6 and Mysql

Using Ubuntu 13.10 on virtual server hosted by OVH (France), Server version: Apache/2.4.6 (Ubuntu), OpenJDK Runtime Environment (IcedTea6 1.13.3) OpenJDK 64-Bit Server VM (build 23.25-b01, mixed ...
0
votes
0answers
177 views

Installing sql*plus on Ubuntu 14.04

I tried installing sql*plus on Ubuntu 14.04 by following 1, 2 and 3. But after downloading Instant Client I still facing following error; sqlplus: command not found I am new to Ubuntu, guide me to ...
0
votes
1answer
43 views

Licensing terms query

This is quite non technical question, but please help me with direction. One of our customer who is enterprise (and quite nontechnical folks), is planning to buy a solution from us. This solution ...
0
votes
1answer
121 views

install phpmyadmin error

I want to install phpmyadmin on Ubuntu 14.04 LTS and type the following commands, but I get the following error message on either one of the following command. Anything I can check the configuration ...
0
votes
0answers
34 views

Bind mounting for Site Storage Ubuntu and Plesk

I have Ubuntu 14.04 server installed and Plesk CP My system drive is too small to be 9f much use other than running the OS and software. So what I was thinking is I have another huge drive that id ...
0
votes
0answers
36 views

Temporarily unable to connect to database

I've got a fully patched Ubuntu 12.04 Server VM that I'm using to host a few low traffic sites. My site is PHP (WordPress) and uses mysqli to connect to a MySql database - pretty standard stuff :) ...
0
votes
1answer
259 views

MySQL Workbench 6.17 error Ubuntu 12.04 x64

Im trying to run MySQL Workbench Migration to transfer a table from MS SQL to MySQL. Using the latest version of workbench (or in fact any of the latest ones), the migration fails instantly and gives ...
0
votes
1answer
124 views

Why is ubuntu server dovecot 2 coming up with Unknown setting: driver

So like I said in the quest dovecot 2 keeps coming up with "Unknown setting: driver". I've been following a guide and setup my auth-sql.conf.ext file however when I try and start up dovecot 2 I get ...
0
votes
0answers
96 views

Try 'apt-get -f install' with no packages [duplicate]

I am using Ubuntu 14.04 lts OS. So when I go to installed mysql server using below command sudo apt-get install mysql-server I have some error message. This is the error message: Reading package ...
0
votes
1answer
319 views

Unable to execute expect script via cron even with the permissions set to 777

I created an expect script that won't seem to run when called by cron. I included the full path in cron when calling it as follows. * * * * * /usr/local/sbin/checkForRemoteTasks ...
0
votes
1answer
363 views

Cron job from mysql and send an email with results

I have a ubuntu box hosted and need to setup a cron job for executing a stored procedure and sending the results via email to one address once a week. How can I do this? I am using Mailgun
0
votes
1answer
2k views

Mysql 5.5 server not working

I had Ubuntu 14.04 installed on my system. I recently updated ubuntu and now my mysql does not start and workbench says that mysql server has been stopped. And when i try to start it gives me the ...
0
votes
1answer
44 views

How to install mysql and other software to ubuntu12.04?

I've just installed Ubuntu 12.04 to my laptop. This is the first time I'm using this OS. Their is no software to watch videos and flash player to watch in web. I'm not being able to install also. I ...
0
votes
0answers
223 views

Percona Xtradb Server Cluster 5.6 Setup

Thanks for any help you can provide I seem to be stuck on this error for hours. I am trying to setup a percona 5.6 cluster. I have installed on 14.04 these packages and removed any trace of mysql. ...
0
votes
0answers
133 views

Stuck booting after network adapter change

I have been switching around my VirtualBox network adapters recently, and when I got to the office today my Ubuntu 14.04 server VM got stuck at Starting MySQL [OK] (or whatever the phrasing is of that ...
0
votes
0answers
46 views

lampp MYSQL linux permissions

I decided to go safe. I am no linux expert either. I edited my.cnf and gave the mysql username (instead of nobody) I set it to 'nugget'. I then added a user named nugget and added it to the group ...
0
votes
0answers
212 views

Locked out of the MySQL database

I'm using Ubuntu 14.04 as my host for my apache-mysql-php server setup. At first, I tried installing XAMPP (from apachefriends.org) and deployed my Moodle and Wordpress sites. However, after a reboot ...
0
votes
1answer
340 views

How to compile/install bind9 with DLZ (MySQL) support?

I am wondering how to compile or install a version of bind9 that supports DLZ (specifically, MySQL) on Ubuntu 14.04. According to my internet research, bind9 doesn't support it by default. Does anyone ...
0
votes
1answer
48 views

unsure of owncloud mysql password and database

I've recently attempted to make my pc an owncloud server. I attempted to logon on the same machine I am hosting it on. However, I first need to enter a mysql password, database name, etc., and I don't ...
0
votes
1answer
135 views

How to connect from MySQL to Web Application [duplicate]

I have been trying to setup a local instance for a web application. I am new to MySQL and I can't understand how to actually connect this database to the actual web application sitting in the ...
0
votes
1answer
83 views

Apache status suddenly stops

I have a problem with my apache, I am running Ubuntu server 12.04 on a VPS. I have a basic LAMP stack, my problem is this, every few days apache will just stop and I will just notice this if I checked ...
0
votes
1answer
1k views

Could Not Connect: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I am new to Ubuntu and using Ubuntu Server 14.40 LTS. I am trying to connect my mysql database to show database data on a php file but I am not able to connect it. I am getting error Could Not ...
0
votes
2answers
467 views

debian.cnf file location in Ubuntu 14.04

Where can I find the "debian.cnf" file in Ubuntu 14.04? It was under "/etc/mysql/debian.cnf" in Ubuntu 12.04. Is there some location changes or name changes ? What I want is to reset MySQL root ...
0
votes
1answer
270 views

How to install mysql, mysql workbench on Ubuntu 14.04

I am having problems trying to install mysql workbench. Says there is no mysqlclient installed, but I already have. and when you run mysql server also gives error. I am using mysql 5:16:17. How do I ...
0
votes
1answer
64 views

Query mysql return an error Incorrect key file for table

I have a site in joomla I hosts locally on an Ubuntu server. When a query is executed by mysql, I get the following error: Incorrect key file for table '/tmp/#sql_6ef4_1.MYI'; Here is my ...