Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

3
votes
0answers
763 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 ...
3
votes
0answers
796 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
504 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
818 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
261 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
646 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
332 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
16 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
32 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
48 views

Can't change open-files-limit for mysql on Ubuntu 14.04

I have a LEMP stack on Ubuntu 14.04 with MariaDB. Mysql is a huge bottleneck for my server. I have tried everything of which I am aware to raise the open files limit for mysql. I have added ...
1
vote
0answers
43 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
43 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
160 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
356 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
192 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 ...
1
vote
0answers
257 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
1k 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 ...
1
vote
0answers
132 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
226 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
139 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
147 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
207 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
94 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
301 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
331 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
2k 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
300 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
225 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
252 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
692 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
343 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
281 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
76 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
175 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
115 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
789 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 console client do not take non-ASCII characters

I use Ubuntu 15.04 and mysql client 5.6 My locale is $ locale LANG=ru_RU.UTF-8 LANGUAGE=ru:en LC_CTYPE="ru_RU.UTF-8" LC_NUMERIC=ru_RU.UTF-8 LC_TIME=ru_RU.UTF-8 LC_COLLATE="ru_RU.UTF-8" ...
0
votes
0answers
6 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: ...
0
votes
0answers
8 views

Changing the location of mysql database

I have installed mysql on my machine. What I am looking to do is to store the db in my cloud folder (copy), so that I can connect other laptops to it. So I can connect whilst on one laptop, save my ...
0
votes
0answers
13 views

How to fix LocalHost Error

I am a student of computer science. We were asked to install XAMPP to use MySQL. There was a warning that antivirus software could affect XAMPP. My XAMPP works well but I cannot access LocalHost ...
0
votes
0answers
43 views

Problem during installing mysql server

I tried to install mysql server and mysql workbench with Ubuntu software center but It could not install them. Then I used command line to install mysql server and I run the following code repectivly: ...
0
votes
0answers
7 views

Xubuntu 15.04: Can no longer navigate with Ctrl + left/right on MySQL shell

In previous versions of Ubuntu (and other Linuxes), I was able to jump word-by-word in the MySQL shell with Ctrl+←/Ctrl+→. This does not seem to work in 15.04. Instead I get ;5D (Ctrl+←) and ;5C ...
0
votes
0answers
15 views

What does (mysql-workbench-bin:4022): Gtk-CRITICAL **: gtk_tree_view_unref_tree_helper: assertion 'node != NULL' failed means?

I'am running a Mysql server at my Linux system locally running the Debian version, and I start the server and that's okay. Then I start Mysql Workbench and when I execute the Mysql script, I can see ...
0
votes
0answers
22 views

Error while updating with drush

I have an ubuntu server with apache that is going to be the host of our public web site (the site is using Drupal). We currently have a public web site and are moving that site to a new server. I ...
0
votes
0answers
37 views

MySQL can't install after bad remove

Some time ago I wanted to have MySQL on my VirtualMachine and I installed mysql-server-5.6. Something went wrong so some site told me that I had to manually purge packages so I did something like ...
0
votes
0answers
27 views

Unable to connect to mysql server via terminal

My MySQL server is up and running. But when I try to connect to a DB by typing the command: mysql test I get the following: root@holy-pc:/opt/lampp/htdocs# mysql test mysql: ambiguous ...
0
votes
0answers
280 views

Can't install mysql-server on Server 15.04

I have a fresh VPS at Digital Ocean, imaged with Server 15.04 x64. I'm trying to install mysql-server, but it errors out. Why is this happening? The only system configuration-related thing I did ...
0
votes
0answers
30 views

MYSQL How to delete and set permissions to root@localhost

I have a problem using mysql, I keep getting this error message for the root user (access denied) : julian@julian-desktop:~$ mysql -u root ERROR 1045 (28000): Access denied for user ...