Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
1answer
44 views

Ubuntu 14.04 LTS:error parsing `Gemfile`: Undefined local variable or method `urce' for Gemfile. Bundler cannot continue

I'm new to Web App Development beginning with Ruby On Rails. To get started I followed this. I'm in the final steps where it asks to create a Database (I'm using mysql) by running rake db:create but ...
0
votes
2answers
39 views

1045 Error using mysql -u root

i didn't find my answer on similiar questions so i ask my question here : I've followed the instructions on ApacheMySQLPHP page on help.ubuntu.com but after the installation of MySQL & using the ...
0
votes
1answer
53 views

Bulk email sending issue with Ubuntu 14.04 (Linode VPS)

I have an email server on Linode.com with the following specs: Ubuntu 14.04 Apache & MySQL Postfix, Dovecot, Spamassassin, Postgrey, RoundCube, sievemail components. Problem: Everything works ...
0
votes
0answers
20 views

How to use both remote server's username and password and Mysql username password in phpmyadmin

I need configuration for phpmyadmin to connect to remote machine, having a username and password. Details are: remote machine: Host: X.x.X.x, Some-Username, Some-password MYSQL: username:root, ...
1
vote
0answers
86 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 ...
0
votes
1answer
44 views

Upgrade MySQL 5.5 to 5.6 on Ubuntu 12.04 LTS

I'm trying to upgrade MySQL 5.5 to version 5.6 on my Ubuntu 12.04 LTS server. I've tried the following: apt-get -y remove mysql-server apt-get -y autoremove apt-get -y install ...
0
votes
1answer
79 views

MySQL doesn't start after reboot

I've got a problem on one of my servers: MySQL doesn't (didn't) start after a reboot. So I have (had) to do a sudo service mysql start/restart My MySQL-Version: mysql Ver 14.14 Distrib 5.5.46, ...
1
vote
4answers
67 views

Does Ubuntu 14.04 support PHP, Mysql, Apache?

Versions are: Ubuntu server version is 10.04 PHP version is 5.4.7 Mysql version is 5.1.69 Apache server version is 2.4.3 Now, I would like to update to Ubuntu 14.04 but no update PHP, Mysql and ...
-3
votes
1answer
39 views

when i am running `service mysql status` it is reporting unrecognized service. should i install mysql server as well? [closed]

i have installed MYSQL for Python with the below command. sudo apt-get install python-mysqldb but when i am running service mysql status it is reporting unrecognized service. should i install mysql ...
0
votes
0answers
61 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 ...
2
votes
1answer
87 views

Error while installing DBeaver On Ubuntu 14.04

I am trying to install Dbeaver 3.5.6 on Ubuntu 14.04, but it shows some Java run-time missing error even though I've Java7 installed on my system. Here's how I tried to install ...
0
votes
1answer
29 views

not able to login to mysql

when I am trying to login to mysql using mysql -u root -p I am getting the following error mysql -u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: ...
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 ...
0
votes
1answer
27 views

unmet dependency error on ubuntu 14.04 while installing

whenever I am trying to install php5 or my-sql I am getting below error. The following packages have unmet dependencies: mysql-server : Depends: mysql-server-5.5 but it is not going to be ...
0
votes
0answers
40 views

MySQL module for php command line

I'm having a bit of trouble trying to rescan my owncloud files, when I type: sudo php console.php files:scan --all I get: An unhandled exception has been thrown: exception ...
0
votes
0answers
64 views

14.04 “/var/run/mysqld/mysqld.sock” “Permission Denied”

I tried to install and manage MySQL 5.5 with ODBC and Asterisk 11 in my Ubuntu Server 14.04, but appeared for me some erros. Please see below echo "select 1" | isql -v asterisk-connector asterisk ...
0
votes
2answers
57 views

Cannot install mysql server locally

I user ubuntu 14.04 version. So I can't install mysql-server. Unpacking mysql-server-core-5.6 (5.6.27-0ubuntu0.14.04.1) ... Processing triggers for man-db (2.6.7.1-1ubuntu1) ... Setting up ...
1
vote
1answer
51 views

mysql cron job - Email only when restarted

I've got the following cron job and it runs every 5 minutes (it actually works) #!/bin/bash PATH=/usr/sbin:/usr/bin:/sbin:/bin if [[ "$(/usr/sbin/service mysql status)" != *start/running* ]] then ...
0
votes
0answers
16 views

How to install mysql 5.7 on 14.04 using apt-get - W: GPG error: [duplicate]

How to I get the keys for installing mysql? I dont know how to add the keys. gpg --recv-keys 5072E1F5 curl -s ??????? | sudo apt-key add - echo 'deb http://repo.mysql.com/apt/ubuntu trusty ...
2
votes
1answer
218 views

Problems installing MySQL Server

I am having an issue installing mysql and/or mariadb. I'm getting the following: sudo apt-get install mysql-server Reading package lists... Done Building dependency tree Reading state ...
0
votes
0answers
21 views

Cron Shutsdown MySQL every day

I'm not a sysadmin, but I run several VPS on my daily work most of all for WP sites. In one VPS (DigitalOcean) 2GB RAM / 2CPUs 40GB SSD Disk my MySQL dies after a Cron Job Runs, here are my Crontab. ...
0
votes
0answers
16 views

Query performance problems in mysql with the kernel 3.13.0-71

Last week I install the kernel 3.13.0-71, on a server 14.04.3 LTS. The problem I got was that the query performance of MySQL on the server went down completely. To resolve I had to return the kernel ...
0
votes
0answers
20 views

MySQL Workbench available only via command line

This might be a silly question: I downloaded MySQL Workbench but I cannot find it in the finder area. If I go to the command line and type mysql-workbench then run, I'm able to launch it. But it ...
0
votes
0answers
33 views

cannot change php and mysql/percona to use utf-8

Ubuntu 14.04 amd64 What I had done: Set as below in php.ini, restart php5-fpm default_charset = "UTF-8" Set as below under http section of nginx.conf, restart nginx charset utf-8 Set below ...
0
votes
2answers
62 views

How to remove mysql-server-core-5.5 even if it has dependencies?

I am trying a clean install of mysql so I tried uninstalling mysql-client and mysql-server. I can't seem to uninstall mysql-server-core-5.5 using sudo dpkg --remove mysql-server-core-5.5 because of ...
0
votes
0answers
153 views

Server 15.04 and MySql 5.7.9

I'm having difficulties getting MySql installed on my Ubuntu server. I have included the steps which I take to install it. Once I get it installed, I then attempt to change the default storage path ...
0
votes
2answers
444 views

Ubuntu 15.10 mysql error 1524 - unix_socket

On Ubuntu 15.10, at a point (maybe after an install & remove of mariadb) mysql was unable to operate. Tasks are up, but the server is down. At the command: mysql -u root -p the system reply ...
0
votes
0answers
21 views

Unable to log in to Ubuntu after fixing MySql Upstart issue

I am in a bit of a pickle. I had a working Unbuntu 15.04 system, and a fully functional MySql server that was running beautifully. Today I upgraded from 15.04 to 15.10 and suddenly MySql can no ...
0
votes
0answers
39 views

MySQL install error saying that there are dependency issues on Ubuntu 14.04?

Here's my error: Preparing to unpack .../dpkg_1.17.5ubuntu5.5_amd64.deb ... Unpacking dpkg (1.17.5ubuntu5.5) over (1.17.5ubuntu5.5) ... Processing triggers for man-db (2.6.7.1-1ubuntu1) ... Setting ...
0
votes
1answer
23 views

install by bash

I install mysql-server by bash. But i can't make it auto enter password for root (this image below). enter image description here And here's my code. #!/bin/bash cd /home/userver2 sudo apt-get -y ...
0
votes
0answers
25 views

Why does my Ubuntu server shut down the MySQL connection the same time every night?

At the same time every day (around 10 PM EST) my MySQL (now MariaDB) server goes offline and my sites crash. I can't for the life of me figure out why. When I look in the syslog I see that there are ...
2
votes
1answer
409 views

MariaDB 10.1 server won't start after update

Today I ran apt-get upgrade and there was an upgrade for MariaDB 10.1 ob Ubuntu Server 14.04 which failed: Setting up libmysqlclient18 (10.1.9+maria-1~trusty) ... Setting up libmariadbclient18 ...
1
vote
0answers
51 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 ...
0
votes
0answers
681 views

Having problems with MySql

I installed Ubuntu headless server 14.04 yesterday. The only thing, at that point, that I installed was ssh. I updated the server then installed Plesk with their automated install script. This is a ...
0
votes
1answer
90 views

unable to install php5-mysql

Setting up php5-mysql (5.5.9+dfsg-1ubuntu4.14) ... Creating config file /etc/php5/mods-available/mysql.ini with new version cp: cannot create regular file ‘/etc/php5/mods-available/mysql.ini’: No ...
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 ...
0
votes
0answers
206 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 ...
0
votes
0answers
47 views

can't remove nginx

I have recently upgraded my virtual machine from Ubuntu 15.04 to Ubuntu 15.10. Previously I was running an Apache2 web server with PHP and MySQL installed. Now when I access localhost, or the IP ...
0
votes
3answers
72 views

Errors when installing LAMP on my Ubuntu server (apache2-bin, mysql-client-5.5, mysql-serer-5.5, mysql-server-core-5.5, php5-common)

I tried installing LAMP following this tutorial: https://help.ubuntu.com/community/ApacheMySQLPHP the first command was: $ sudo apt-get install lamp-server^ Which gave me these errors: I tried ...
1
vote
0answers
75 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 ...
0
votes
0answers
23 views

Everytime I run a sudo command, the warning comes : sudo: unable to resolve host XXXXX [duplicate]

Some weeks ago, I just changed the apperance of my terminal by making it colorful. It was said to change a particular line in the bashrc file by opening it using this command gedit ~/.bashrc. After ...
1
vote
4answers
108 views

mysql-server taking too much time to be installed and generated failed

I am trying to Run and Install the mysql-server on my ubuntu, it's always stating preparing to unpack ../mysql-server-5.6_5.6.27-0ubunbu0.15.04_amd64deb ... in addition to the above I have a problem ...
1
vote
1answer
96 views

How install or uninstall half-installed mysql-client-5.6 on/from ubuntu 15.10?

I probably corrupted my mysql configuration when I tried to install it (again) using the ubuntu package manager (stuck in the middle, because of the required interaction for which there is no screen, ...
3
votes
1answer
23 views

How to activate MySQL general log in version >= 5.6?

I am having trouble to activate general logs in mysql since version 5.6. What is the proper way to do it ?
0
votes
1answer
128 views

Updating to MySQL 5.6.27 fails but why?

I am using Ubuntu 14.04.3 LTS, I was using MySQL 5.6.24 via (https://launchpad.net/~ondrej/+archive/ubuntu/mysql-5.6) and have just tried to update it but it dies with: 0 [Note] /usr/sbin/mysqld ...
1
vote
2answers
293 views

Why /etc/mysql/my.cnf is EMPTY?

I am trying to edit the my.cnf file to allow remote access and ultimately using software from my Windows Server to configure scheduled backup for MySQL Server. I was following these instructions. ...
0
votes
0answers
19 views

How can I diagnose a MySQL server randomly stopping?

I have an Ubuntu 14.04 LTS server hosted on a small Digital Ocean droplet (Intel(R) Xeon(R) CPU E5-2630L v2 @ 2.40GHz with 500mb RAM). It runs ~30 very low-traffic WordPress blogs. Twice now I've had ...
0
votes
0answers
53 views

Setting up mysql-server-5.5, every time I am using apt-get?

Every time i use commands like sudo apt-get install sudo apt-get remove sudo apt-get --purge remove and tries to install/remove any package, there is a line > Setting up mysql-server-5.5 ...
2
votes
2answers
55 views

Install mysql-server version 5.5.40-0ubuntu0.14.04.1

I have a test VM with mysql-server version 5.5.40-0ubuntu0.14.04.1 I want to setup another test VM with the same version of mysql-server, but apt-get is not able to find the repository for this ...
0
votes
1answer
70 views

Error occuring while setting up the mysql database in production

I am trying to run command rake db:setup RAILS_ENV="production" But it's giving the following error : DEPRECATION WARNING: Passing a string to ActiveRecord::Base.establish_connection for a ...