Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

3
votes
0answers
47 views

MySQL (InnoDB) shutsdown same time every day

Ok so recently pushed a large update to my project onto my Ubuntu 14 server. Up until now it's been stable however since the push at exactly 00:36 GMT each day mysql is killed!! Not ideal as we need ...
3
votes
0answers
122 views

I can't deploy mysql to LXC:0 with juju

I used "juju deploy --to lxc:0 mysql" to deploy mysql. But ,the container start failed.--"error: container failed to start" so,I used dmesg to look error message: [1318582.474759] init: ...
3
votes
0answers
458 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. ...
2
votes
0answers
420 views

MySQL Workbench GUI problems in Ubuntu 14.10

I've recently performed a clean install of Ubuntu 14.10. I got Apache, PHP and MySQL from Ubuntu's repositories, then installed MySQL Workbench (6.1.7) from the Ubuntu Software Center. It almost works ...
2
votes
0answers
369 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 ...
2
votes
0answers
289 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
153 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
573 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
278 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
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
28 views

Unable to reinstall MySQL

What I did before this error: I was trying to install mysql for registration in OpenMRS database and it was succesfully, but i forgot my password. And removed mysql packages, i was getting some errors ...
1
vote
0answers
9 views

Install second mysql

I have a VM that has mysql 5.5.40 installed in it. And now i want to install mysql 5.6 without updating or replacing existing version. Means i want to use these two side by side. I have tried to ...
1
vote
0answers
82 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
87 views

Why my apache service does not work correctly?

I am just a newbie using Ubuntu 12.04 LTS. In the beginning, I just want to install mcrypt, I followed this solution: cd /etc/php5/mods-available ln -sf ../conf.d/mcrypt.ini . php5enmod mcrypt ...
1
vote
0answers
93 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
122 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
1k 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
84 views

Postfix and Ownclound mysql authentication

i'm using ubuntu 12.04 with roundcube/postfix and owncloud installed, and using mysql as login authentication. i would like to know if it's possible to make single login for these apps (without LDAP) ...
1
vote
0answers
177 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
73 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
235 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
237 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
1k 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
227 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
71 views

How to install mysql version 5.0.18 in ubuntu 12.04?

I have done the following: sudo apt-get purge mysql-server mysql-common sudo apt-get update && sudo apt-get upgrade sudo apt-get autoremove sudo apt-get autoclean This uninstalled MySQL ...
1
vote
0answers
192 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
186 views

MySQL script does not stop, reboots mysql

I have installed ubuntu 13.10 desktop x64 on my laptop. After the installation I installed MySQL Server sudo apt-get install mysql-server mysql-client Installation wass successful but I noticed the ...
1
vote
0answers
225 views

Why are there multiple Root users in Database?

I'm trying to setup ownCloud in a test lab. At the setup screen (initial login over from the web), I'm having a heck of a time connecting to the MySQL database. I can't log in as either ...
1
vote
0answers
144 views

Can't purge mysql-server installation

Since I've got no privileged user in my current MySQL-installation on 12.04 LTS I want to re-install the mysql-server completely by using: sudo apt-get purge mysql-server After a very short while I ...
1
vote
0answers
292 views

installing Percona XtraDB Cluster on Ubuntu 13.04

So, a bit of explanation of the big picture: I am trying to get multiple PXC instances running on a single machine, replicating via Galera to each other. I am running Ubuntu Server 13.04 amd64 in a ...
1
vote
0answers
690 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 ...
1
vote
0answers
311 views

Problem after installing phpmyadmin

I installed apache, mysql, and php on my Ubuntu 12.04 server but after logging in all I see is a white screen displaying a forward slash. Is there something else I need to configure or enable? / ...
1
vote
0answers
258 views

How to set up a DNS server on ubuntu server?

This DNS server will use to access a web server/ mysql server. Scenario: DNS Server of 192.168.0.0/24 network - 192.168.0.2 domain name(dn): my.site.com redirect to 192.168.2.1 (webserver/mysqlserver) ...
1
vote
0answers
64 views

Mount Drive at Start-up but MySQL can't see it

I'm trying to automount my drive using the following command in startup applications: /usr/bin/udisks --mount /dev/sdd1 However, MySQL fails to start when I mount the disk. On the contrary, if I ...
1
vote
0answers
147 views

Can not install phpmyadmin and mysql

after an interrupted upgrade of ubuntu 10.04 server LTS to ubuntu 12.04 server LTS somethings weren't installed correctly. Anyways I installed apache, ftp, phpmyadmin etc. At some point I deleted some ...
1
vote
0answers
66 views

Error: Mysql database doesn't support transactions

I have a InnoDB has a default database which supports transactions. But, when I run transactions script for Mysql sql-benchmarking I get below error: Show engines: ...
1
vote
0answers
105 views

How do I edit the commands that start a service in Ubuntu 12?

So I am trying out GBrowse, as we will use this later on. But then, I'm getting this ------------------------------------------------------------------------------------------------ 256000 features ...
1
vote
0answers
743 views

How to reinstall mysql without damaging data?

http://stuffthatspins.com/2011/01/08/ubuntu-10-x-completely-remove-and-clean-mysql-installation/ shows how to reinstall everything. I want to do something like this without reinstalling data. ...
0
votes
0answers
4 views

MySQL messed up apt-get?

I tried to install MySQL for my localhost and I managed to break my dependencies, and I can NOT install anything I have tried: Purging MySQL commons, client, server, ect. Removing MySQL commons, ...
0
votes
0answers
11 views

unoconv cannot connect or start listener without sudo

I'm working on a website for school on the school server. My website uses unoconv. It was working up until today for some reason. Basically what is happening is that if i run this command in the ...
0
votes
0answers
44 views

How to update MySQL Server, MySQL Client and phpMyAdmin to the latest stable versions on my local machine running on 64-bit Ubuntu 12.04 LTS?

I'm using 64-bit Ubuntu 12.04 LTS on my machine. I've already installed LAMP server on my machine. I'm using following Apache HTTP Server version. I got following information after I type following ...
0
votes
0answers
13 views

PHPMYADMIN /phpmyadmin was not found on this server

PHPMYADMIN is installed in my computer and I removed and reinstalled it just now Yet I am unable to access the phpmyadmin Your suggestions are kindly appreciated. Thank you in advance
0
votes
0answers
28 views

Cannot install (configure) mysql on Ubuntu 14 server using apt-get

When installing mysql-server-5.5 on Ubuntu 14, I get the latest mysql-server with: sudo apt-get install mysql-server Which asks to install mysql-*-5.5 packages. I am then prompted to give a ...
0
votes
0answers
15 views

Cannot create a new connection in MySql Workbench

Cannot create a new connection using workbench using ubuntu The message is "Failed to Connect to MySQL at 127.0.0.1:3306 with user root" Can somebody please help me.
0
votes
0answers
9 views

problems while creating procedure in sql

whenever i create procedure in sql it always gives me the result as "procedure created with compilation errors" I am using oracle 10g.I don't know what should I do overcome this.
0
votes
0answers
44 views

Ubuntu 14.04 Error when compile PHP 5.6.3

I did everything right with the installation of all dependencies for Apache2 and PHP i think. First I installed a clean Ubuntu 14.04 with all actual updates. Then I installed with "apt-get build-dep ...
0
votes
0answers
15 views

Backup database with mysqldump

Hello i use mysqldump with crontab for save my database each hour but after one day i have 24 files What is solution for auto delete if more 5 files ? And what is chmod for folder backup for security ...
0
votes
0answers
13 views

Load Balance Nginx, SSL, MySQL

So I need to load balance Nginx servers, can someone give me a good tutorial or explanation. With SSL is there such thing as load balancing SSL? I've heard of it. And clustering MySQL, how can I do ...
0
votes
0answers
10 views

MySql error in Edubuntu 12.04

As this the first time I m here to ask, as unable to run mysql on edubuntu 12.04 with following error. Kindly help in tracing the error.... thanks gnps@gnps-ibm:~$ mysql -u root -p Enter password: ...
0
votes
0answers
83 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 ...