Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

3
votes
0answers
49 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
1k 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
565 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
403 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
53 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
36 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
291 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
2k 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
380 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
792 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
2k 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
74 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
29 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
399 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
88 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
52 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
77 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
64 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
40 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
364 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
98 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
48 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
302 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
25 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
161 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
202 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
991 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
661 views

SonarQube installation

I have followed all the steps listed here: http://mamikon.net/blog/installing-sonarqube-ubuntu/ However, in my /opt/sonar/conf/sonar.properties , these 2 lines are missing: ...
1
vote
0answers
67 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
174 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
170 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
391 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
332 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
294 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
506 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
311 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
392 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 ...
1
vote
0answers
434 views

XAMPP (LAMPP) on Ubuntu Touch

Can I install and run XAMPP (LAMPP) on Ubuntu Touch on a Nexus 10 in order to host a local website (that needs PHP and MySQL)?
1
vote
0answers
172 views

Apache and MySQL bringing server to a crawl several times a day

I am having difficulty troubleshooting a bottleneck problem with my Ubuntu 12.04 server. I run a very small intranet website off of the server. There are web requests (SOAP, HTML, REST, etc) at a ...
1
vote
0answers
2k views

Apache Timeout (Problem loading page) on localhost

I am running a php script locally in my Firefox web browser. After exactly 300 seconds I get an error page. "Problem loading page. The connection has timed out. The server at localhost is taking too ...
1
vote
0answers
373 views

Copying Folder while Preserving Permissions/Ownership Error: operation not permitted

I am trying to copy a folder while preserving ownership. When I use the command: sudo cp -R -p /var/lib/mysql /newpath the files copy but the ownership changes (my username becomes the owner on the ...
1
vote
0answers
121 views

Error Changing MYSQL Data Directory

I was trying to change the mysql data directory following these instructions. When I try to restart the database with step 8: sudo /etc/init.d/mysql restart Gets the following errror: Rather than ...
1
vote
0answers
386 views

Ubuntu 12.04 problems with mysql

I use Ubuntu Server 12.04 for my Django project. On my local PC there is no errors and etc. Sometimes on server I have error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
1
vote
0answers
500 views

Subdirectories Show 404 Not Found on 13.10 web server

I recently set up a web server on Ubuntu 13.10 and when I enter the external IP it works fine showing the index file of var/www/ but whenever I try to add a folder, say one called test, and I go to ...
1
vote
0answers
3k views

MySQL not starting because “mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)”

I am setting up a new LAMP server with Ubuntu Server 13.10 and MySQL 5.5 and was in the middle of migrating mysql databases to new server when I realized mysql server is not running. All was fine last ...
1
vote
0answers
458 views

What does this mysql error mean?

I'm on Xubuntu 13.10 64 bit. I know the password of my mysql database, but still can't login as root. I try to change the password sudo mysqld_safe --skip-grant-tables & I get [1] 8863 mypc ~: ...
1
vote
0answers
326 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 ...
1
vote
0answers
701 views

Update and Upgrade updated mysql and now “Job failed to start”

I ran apt-get update and apt-get upgrade earlier today and I had a conflict with the my.cnf file I saw default=n so I pressed "n" and went on my merry way. I now can't start mysql via service mysql ...