Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

3
votes
0answers
22 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
94 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 ...
3
votes
0answers
578 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
423 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
38 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
95 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 ...
2
votes
0answers
41 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
360 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
425 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
828 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
15 views

Script of getting mysql user grant details

I am trying to get mysql user grant details and echo it to out file hari=mysql -sN -e "show grants for mysqladm"; echo $hari GRANT ALL PRIVILEGES ON prod_server_list.txt stage_server_list.txt ...
1
vote
0answers
123 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
85 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
120 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
73 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
125 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 ...
1
vote
0answers
96 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
111 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 ...
1
vote
0answers
75 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
178 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
252 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
285 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 ...
1
vote
0answers
332 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
108 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
143 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
82 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
550 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... ...
1
vote
0answers
130 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: ...
1
vote
0answers
69 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
345 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
233 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
293 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
239 views

phpmyadmin could not connect to mySQL database

I had installed phpmyadmin through the apt-get and it was running fine until I installed XAMPP. Now, it keeps giving me "Acess Denied" I removed phpmyadmin through apt-get remove phpmyadmin ...
1
vote
0answers
77 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
285 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 ...
1
vote
0answers
204 views

Can`t reinstall mysql on kubuntu

Every time I try to install MySQL I get Setup package mysql-client-5.5 (5.5.41-0ubuntu0.14.04.1) … Setup package mysql-server-5.5 (5.5.41-0ubuntu0.14.04.1) … 150415 15:35:15 [ERROR] Can't find ...
1
vote
0answers
548 views

On connecting to MySQL via SSL getting ERROR 2026 (HY000): SSL connection error: protocol version mismatch

I am working with MySQL and generated the certificates to use with MySQL to enable SSL. Here are SSL configs: mysql> show variables like '%ssl%'; +---------------+----------------------------+ | ...
1
vote
0answers
384 views

ISPCONFIG Ubuntu 14.04 phpmyadmin 404 Not Found

After following this tutorial https://www.howtoforge.com/perfect-server-ubuntu-14.04-apache2-php-mysql-pureftpd-bind-dovecot-ispconfig-3-p4, and successfully completed when i try to acces phpmyadmin ...
1
vote
0answers
48 views

Something wrong with my terminal

I am trying to run this command apt-get install mysql-server and it sets up the packages but when it reaches a point where a password input is needed, this is the screen i am getting I can't even ...
1
vote
0answers
345 views

Why are MariaDB versions different with same configurations?

So, last night I install a fresh copy of ubuntu 14.04 and followed some instructions for installing MariaDB as follows: > sudo apt-get install software-properties-common > sudo apt-key adv ...
1
vote
0answers
539 views

Problem connecting to database via SSH with MySQL Workbench

I am having trouble connecting to an external database via SSH with Workbench. The error that I get says: Could not acquire management access for administration UnboundLocalError: local variable ...
1
vote
0answers
375 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. ...
1
vote
0answers
470 views

Server slow after Nginx errors and restarting PHP

I have a server with Intel Xeon 2xE5520 2.27GHz, 48 GB Ram, 2x146 GB 15K HDD (Raid) OS Ubuntu 14.04.01, Nginx 1.6.2, PHP 5.5.9, MySQL. Webmin. My website is video portal. Traffic is approximately ...