Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

3
votes
0answers
83 views

upgrade process stuck for too long while Preparing to unpack …/mysql-server-5.7_5.7.12-0ubuntu1.1_amd64.deb

I tried to do upgrade and its been unpacking for too long (20 minutes) is it normal?, not responding to ctrl+C too.What to do next? shubhendu@shubhendu-HP-Pavilion-g6-Notebook-PC:/opt$ sudo apt-get ...
3
votes
0answers
33 views

I need a correct help for MariaDB SSL support

I have to make my MariaDB authentication a bit safer than default. I tried to set up SSL support for this, but found only an old howto here: How to enable MySQL SSL on Ubuntu I followed it, however ...
3
votes
0answers
113 views

My Akonadi server keeps crashing on startup. How do I fix this?

I am trying to make KPIM work on my kubuntu (Wiley) machine. When I try to start akonadi (the db server) it tells me it is not registered with dbus and fails to start -- heres the output of the ...
3
votes
0answers
2k views

MySQL Workbench do not render Columns Tab at ER

I have a fresh install of Ubuntu 14.10, after installing all I need, I started MySQL Workbench (v.6.1.7 build 1788) and in it's ER modeling its not showing anything in Columns Tab when editing a table,...
3
votes
0answers
583 views

Using gnome-keyring with svn via ssh and mysql-workbench

Problem: mysql-workbench fails to connect to the keyring to connect to mysql. I'm trying to get my svn command (which uses an svn+ssh uri) to prompt me to enter my password for my local rsa secrets. ...
3
votes
0answers
434 views

Another apparmor / mysql wont install

I am trying to config another instance of mysql on my present but i can't mysql_install_db --user=mysql --datadir=/var/lib/mysql2 Installing MySQL system tables... ERROR: 1005 Can't create table '...
2
votes
0answers
62 views

Error after attempting to update php lampp and reinstall lampp

I tear my hair, it's been almost one day I try to reinstall lampp but it doesn't work. It's been almost one day I try to reinstall lampp on my ubuntu 14.04 LTS in vain. I installed first lamp with ...
2
votes
0answers
110 views

Access denied in localhost phpmyadmin

I have xampp installed on my local machine which was working fine. Suddenly, im getting this error. I am sure it was working fine, but now i have important database in my localhost(i dont have backup)...
2
votes
0answers
76 views

How can i run two servers in xubuntu 14.04: Mysql server 5.5 & Activemq 5.11

I am developing a web application in netbeans 8.0.2. I have already installed mysql server 5.5 and it was running correctly until i executed the './activemq start' command. The following two error ...
2
votes
0answers
384 views

Error 500 on localhost/phpmyadmin

I recently installed apache2 and phpmyadmin on localhost, and everytime I try to connect to localhost/phpmyadmin I get prompted with an "Enter your username/password". I enter root as the username and ...
2
votes
0answers
1k views

MySQL Workbench on MySQL 5.6.19

I tried to install MySQL Workbench 6.1.7 on Ubuntu 14.04 after installing Mysql 5.6 library, but get the following: error: Package dependencies cannot be resolved This error could be caused by ...
2
votes
0answers
3k views

Mysql fails to start after upgrade

I had mysql working fine, and then I upgraded from 5.1 to 5.5. Now I think it was still working after the upgrade, but I'm doubting myself now that I can't get it started again. I have looked at the ...
2
votes
0answers
397 views

“package mysql-server is not installed” even when it is installed

I am trying to install a deb package running the command dpkg -i code/mydeb.deb it gives an error saying dpkg: dependency problems prevent configuration of openmrs: openmrs depends on mysql-...
2
votes
0answers
448 views

Ubuntu virtual memory overcommit apparently hitting MySql performance

I have several installations using Ubuntu Server 10.04 and 12.04 LTS running on Dedicated and VPS with various hosting companies. I am hitting a problem where, especially on migrating to a new server ...
2
votes
0answers
838 views

How I can connect the syslog-ng with a mysql database?

Hi guys I want to use a syslog-ng server for logging data from the firewall and I get Data from the Firewall in the file /var/firewall.log but now I want that the logs go to a database. For this I ...
2
votes
0answers
3k views

MySQL Workbench will not open on my Ubuntu 12.04

I have install mysql-workbench version 5.2.38+dfsg-3 via Ubuntu Software Center on my Ubuntu 12.04 laptop for some week ago, This work fine until now! Now when I press in the mysql-workbench icon ...
1
vote
0answers
37 views

mysql-server-5.7 configure fails

mysql-server-5.7 doesn't want to configure. root@me-device:~# dpkg --configure mysql-server-5.7 Настраивается пакет mysql-server-5.7 (5.7.13-0ubuntu0.16.04.2) … Renaming removed key_buffer and myisam-...
1
vote
0answers
50 views

Installation of mysql-server on Ubuntu 16.04 LTS fails

I spent a day to install mysql for LAMP server on a fresh install of UBUNTU 16.04 LTS. I try all stackexchange says related of this issue. here the same problem each time : $ sudo apt install ...
1
vote
0answers
16 views

How to restore mysql databases after upgrading to mariadb

While installing mariadb-server, it moved all of my existing databases to /var/lib/mysql-5.7 and created a new /var/lib/mysql folder. How do I restore these databases from the backup folder?
1
vote
0answers
67 views

'mysqld' using a lot of ram in Ubuntu 16.04, is it normal?

I am working on my Django project and recently installed mysql-server on my ubuntu 16.04. It is using a lot of ram approx 800 MB to 1GB, is it normal? Picture attached :
1
vote
0answers
79 views

dpkg: error processing package mysql-server (--configure)

I am getting the following error when I remove, autoremove, install, upgrade etc.. via terminal and also software updater. The sudo apt-get autoremove result is given below. The error says dpkg error ...
1
vote
0answers
29 views

Does ubuntu's installation of mysql-server-5.7 now require apparmor?

Ubuntu 16.04: When I use apt to install mysql, it shows: The following additional packages will be installed: apparmor mysql-server-5.7 Suggested packages: apparmor-profiles apparmor-profiles-...
1
vote
0answers
20 views

MySQL works fine with GUI, but won't start without it. Ubuntu-mate

This one is making me nuts. I have a Raspberry PI 2B with a Ubuntu-mate 16.04 installation. I use it to run PLexmediaserver and Owncloud, the last one over Apache, MySQL and PHP 7.0. Ubuntu-mate for ...
1
vote
0answers
222 views

Apache2 and Mysql gone wrong after upgrade to 16.04

After I installed Ubuntu 16.04 I was not able anymore to access to my Mysql server from h-ttp://localhost/phpmyadmin. I tryed to uninstall and install mysql but unsuccessfully. I discovered that the ...
1
vote
0answers
160 views

Ubuntu 16.04 Cannot install MySQL

After installing Ubuntu 16.04 and in the process of setting up a lampp stack. I tried to install MySQL as usual using the code below: sudo apt-get install mysql-server However I get the below ...
1
vote
0answers
204 views

Error on sudo apt-get upgrade and MySQL start job failed

I'm trying to start mysql on linux but i'm getting the job failed error. I'm trying to upgrade it just to check if it will fix the issue.. I get the following output when I do sudo apt-get upgrade: ...
1
vote
0answers
164 views

Mysql-Server installation stuck on root password

I trying to install mysql-server into a Docker container so in my Dockerfile I've added apt-get install mysql-server , install runs until it demand to provide the root user's password and then just ...
1
vote
0answers
370 views

Mysql database browsers not working after upgrade

I needed version 5.7 of mysql server for a project. I upgraded from version 5.5 to 5.7 using this tutorial. The upgrade was successful and I am able to use the updated version via command line. ...
1
vote
0answers
151 views

MySQL Server 5.6 fails to install on Ubuntu Wily

I have Ubuntu 15.10 (wily) and am trying to update MySQL to the latest version. When I run aptitude safe-upgrade, it fails like so: Errors were encountered while processing: mysql-server-5.6 mysql-...
1
vote
0answers
185 views

Start Ampps, with root permissions, once desktop loads

Been hacking my way through getting Ampps to work on Ubuntu. Ampps will be used to use host a local Web app for my families business, and I need Ampps to start when Ubuntu starts, always. I figure I ...
1
vote
0answers
129 views

MySQL gradually taking up more and more memory

Just to start with, I have read the following threads and they do not help: Optimising MySQL settings - mysqld running out of memory MySQL Server keep shutting down http://stackoverflow.com/questions/...
1
vote
0answers
92 views

I can not save data to MySQL when is tomcat running

I have tomcat 7 and mysql 5.5.46. On my tomcat is running simple application which reads data from mysql. I have another java program that stores data in to mysql. When running tomcat and java ...
1
vote
0answers
2k views

Plesk not starting after server reboot because of MySQL socket

I've a problem with my plesk (12.5.30) installation on a fresh Ubuntu14.04 LTS server. I used plesk autoinstaller file downloaded from plesk official website, to install plesk. It seems that the ...
1
vote
0answers
222 views

Installing mysql 5.6 fails on VM + vagrant

Error start: Job failed to start invoke-rc.d: initscript mysql, action "start" failed. dpkg: error processing package mysql-server-5.6 (--configure): subprocess installed post-installation script ...
1
vote
0answers
448 views

Can't install mySLQ server on ubuntu

I can't access mySQL server since yerterday, it gave me this: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) After spending several hours ...
1
vote
0answers
584 views

Ubuntu Trusty 14.04 Mysql 5.6 install not working

I read a lot about the issues here with mysql server and client 5.6 on ubuntu 14.04 and tried all the things but I cannot get it to work. Following steps I already took sudo apt-get update sudo apt-...
1
vote
0answers
372 views

Mysql 5.6 not installing/removing/running on 15.10

I have tried to purge mysql and then reinstall it (sudo apt-get purge mysql-server mysql-client mysql-common mysql-server-5.6 ), but it does not work. It looks like a dependency issue. Here is the ...
1
vote
0answers
127 views

Ubuntu xampp, mysql wont start at all

After changing whatever I saw and I found, unfortunately no success. When I installed xampp it ran successfully and both apache and mysql started. But surprisingly after restart below errors begin ...
1
vote
0answers
163 views

Can't open shared library

I am trying to add a function i wrote in C into MySql, in the function I am using 'gmp' library, it compiles correctly and I copy the '.so' file to '/usr/lib/mysql/plugin/' and then log in to mysql ...
1
vote
0answers
111 views

Convert SQL Server Stored Procedure into MY SQL Stored Procedure

Any tools are available to Convert SQL Server Stored Procedure into MY SQL Stored Procedure. We tried with some license tool but only tables are created properly, but Stored Procedure are created ...
1
vote
0answers
630 views

mysqld_safe Can't log to error log and syslog at the same time

I forgot my MySQL password, and following these steps to reset it... https://www.digitalocean.com/community/tutorials/how-to-import-and-export-databases-and-reset-a-root-password-in-mysql#how-to-reset-...
1
vote
0answers
146 views

Can't find job mysql on crouton precise

I'm using Ubuntu precise as chroot in my chromebook machine. I'm trying to install mysql through apt-get install mysql-server. The thing is, when I try to start it, it can't find the job: (precise)...
1
vote
0answers
78 views

ProFTPD - set a group manager to access all users files in the group tree

I am currently developing a client application with pyqt and ftplib to help backup/restore file to/from a ProFTPD server. The company is divided into many agencies and every agency is a ftp group with ...
1
vote
0answers
371 views

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' in Ubuntu 12.04.5 LTS

I encountered with the error Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' in Ubuntu 12.04.5 LTS. So,I uninstalled mysql 5.5 from Ubuntu 12.04.5 LTS.But when i tried ...
1
vote
0answers
27 views

Upgrading to 15.04 stalls when trying to install MySQL 5.6

I've just tried to upgrade my ubuntu OS (desktop) and it's just stopped when installing MySQL. It said that i had to update the password (did this twice in the install) but the second time it said "...
1
vote
0answers
270 views

Have localhost with dual boot (Windows/Ubuntu) share htdocs & mysql databases with XAMPP

I just got a new machine with dual boot Ubuntu+Windows 8.1 and set up a localhost using XAMPP in a way that allows me to edit and preview the files on both OSes (so htdocs and mysql databases have to ...
1
vote
0answers
373 views

Difference between using mysql in xampp and using mysql seperately

I have used xampp on windows to do some php programming(basic) and now i'm trying to do some python/perl database connectivity programs(again basic) with mysql. The thing is when i used xampp, it ...
1
vote
0answers
2k views

I Get 'Import error : No module named MYSQLdb' in python 2.7. I've tried everything from the other similar thread

The error: import MySQLdb ImportError: No module named MySQLdb. Particulars: OS is Ubuntu 14.04 python 2.7.10 and is the default MySQL 5.5.43 What I've tired: sudo apt-get install ...
1
vote
0answers
85 views

Unable to get MySQL Utilities (mysqlrpladmin) to work properly under Ubuntu 14.04

I currently have replication running between 1 master and 2 slave servers. When I attempt to run mysqlrpladmin using the "--discover-slaves-login" option and "health" command, it only returns the ...
1
vote
0answers
330 views

phpmyadmin: unable to connect to 127.0.0.1

I recently installed LAMPP on Ubuntu 14.04. When I start/restart Apache on terminal it shows [OK] but phpmyadmin says "Can't establish a connection to 127.0.0.1". I have tried solutions provided in ...