Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
1answer
22 views

Setup /var/www for two groups

I have two groups. ftpgroup and www-data. I'm using proftpd and mysql to store the ftp users and their homes. When the user registers it creates the folder first and then creates the user account in ...
0
votes
0answers
71 views

in XAMMP MySQL Database is stoped

I'm running Xampp on Linux(Ubuntu 14.04) and while everything was working fine until an hour back right after I shut it down it suddenly starts throwing this error. the erreur : MySQL said: ...
0
votes
0answers
74 views

MySQL Database in XAMMP is stoped

I'm running Xampp on Linux(Ubuntu 14.04) and while everything was working fine until an hour back right after I shut it down it suddenly starts throwing this error. the erreur : MySQL said: ...
0
votes
0answers
35 views

what is the solution of Mysql database stoped

I have XAMPP for Linux 5.6.12-0 . When I Start the Xammp , It shows the following : Starting XAMPP for Linux 5.6.12-0... XAMPP: Starting Apache...ok. XAMPP: Starting MySQL...ok. XAMPP: Starting ...
0
votes
0answers
44 views

Mysql Workbench Import Data

Ubuntu 15.10 Using the import data wizard in Mysql Workbench to import 241 records from a csv file resulted in the successful importation of 97 records only. When I tried using another csv file, only ...
0
votes
0answers
42 views

Access phpmyadmin

I hope u can help me :D So my Apache2 server and MySql are both running. PHP is also working. I already included this line in the apache Configuration : Include /etc/phpmyadmin/apache.conf I´m using ...
0
votes
0answers
13 views

Lamp Server with two MySQL versions

I already have a LAMP Server running with MySQL version 5.5 and I want to add another MySQL version (5.6). Is that possible with Ubuntu 14.04.2 LTS? When yes, how can I do it?
1
vote
2answers
51 views

Unable to access remotely (LAMP issue)

I'm unable to access my home server remotely although it works fine in LAN. When I try to access it remotely using http://xxx.xxx.xxx.xxx/ I get router control panel page and when I browse ...
0
votes
1answer
61 views

Storing MySQL database in USB .. Permission problem (errno: 13)?

So, this page is what I'm using as a manual: Different locations for MySQL databases? I'm trying to store my database on USB (whether a good idea or not, please tell me how to do this if there is a ...
0
votes
0answers
49 views

Difficulty reinstalling MySQL on 14.04

I have recently upgraded to 14.04. After this upgrade I had various problems with apache, and my attempts to fix them appear to have wrecked my MySQL installation. I am attempting to reinstall MySQL ...
0
votes
0answers
42 views

How do I reset all MySQL databases, passwords, and settings, without resetting configuration?

As far as I know, MySQL comes with configuration to integrate with Apache and other Ubuntu software. To my knowledge, if I simply uninstall MySQL with Apt, that configuration will be lost. However, ...
0
votes
1answer
129 views

mysql-server apt-get install failing

I am trying to install mysql-server on a fresh copy of ubuntu/trusty64 (Ubuntu 14.04.3 LTS). I am using vagrant/virtualbox. I ssh into the box and run the commands below. You can easily replicate this ...
0
votes
0answers
60 views

Upgraded to 15.04. PHP/mysqli now having problems with “old passwords” Need to downgrade (what and how?)

I was using 14.04 and PHP 5.5. Upon upgrading, I can no longer use MySQL to access REMOTE and local databases because of old passwords: [Wed Jan 06 17:42:04.030738 2016] [:error] [pid 23736] PHP ...
0
votes
1answer
40 views

commands to upload database file to database

There is a database file in this path : /var/www/db.sql in server. Our database size is about 800mb. we have to upload this sql file to the database : "age" username : root, password : pass, ...
1
vote
0answers
59 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 ...
0
votes
2answers
2k views

Unable to locate package libapache2-mod-auth-mysql

Trying to install this package on Ubuntu using sudo apt-get install libapache2-mod-auth-mysql, but I get the message in the title. Why and how can I fix it?
0
votes
0answers
363 views

Unable to start Mysql 5.7

I am having the following error: Not connected : Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) This is what is in the log files: /usr/bin/mysqladmin: connect ...
0
votes
0answers
10 views

mysql-client : Depends: mysql-community-client (= 5.7.10-1ubuntu12.04) but it is not installable [duplicate]

I have tried to upgrade my mysql in 12.04 from 5.5 to 5.7 but after removing 5.5 I had to add 5.7 to apt. However when I did apt-get install mysql-server it asked me to install 5.5 again. So I did the ...
0
votes
0answers
25 views

How to keep read value after break [duplicate]

Evening, I am trying to have the mysqlpass entry stay throughout the script, without the break getting rid of it. But I can't figure out how. while true; do read -p "Password for MySQL " ...
0
votes
0answers
35 views

Random disconnects Ubuntu 15

I don't really know where to begin. I have a desktop that I recently switched from Window 7 to Ubuntu 15.10. I use it as a server to host media to my Kodi clients throughout the house. It worked fine ...
1
vote
1answer
103 views

Trying to purge MySQL fails

I'm running in circles currently, trying to fix some mysql problem. I couldn't use apt-get for a while now, because it always stuck at the line Setting up mysql-server-5.6 (5.6.27-0ubuntu0.15.04.1) ...
0
votes
1answer
44 views

Can you configure postfix in ubuntu to send a automated email when a user submits php webform?

How would you write a bash script to take a users informations from the php webform and email the user saved on the server using postfix when they submit the form? The users saved on the server should ...
0
votes
0answers
60 views

MySQL service is not starting successfully after server reboot

I have an Ubuntu 14.04 server with plesk installed on. I have a problem with MySQL server, which seems I can't figure out the solution: Each time after the server reboot, MySQL service is not ...
1
vote
0answers
1k 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 ...
0
votes
1answer
107 views

mysql dependencies installation problem

I am reinstalling mysql on a test server with Ubuntu 14.04 before I hadn't had any problems reinstalling it. When I reinstall it I do the following: use apt-get purge and remove on mysql-server-5.5 ...
0
votes
1answer
98 views

Why am I unable to connect to ftp, or git or mysql server from my ubuntu 14.04 LTS computer?

I am running on Ubuntu 14.04 LTS, and I used to manage my ftp connections through FileZilla, and use git through terminal as well as mysql through terminal... Then, today, nothing works. I try to ...
0
votes
1answer
35 views

“sudo start mysql” results in an error [duplicate]

minzaw@Dell-PC:~$ sudo start mysql [sudo] password for minzaw: start: *Unable to connect to Upstart: Failed to connect to socket /com/ubuntu/upstart: Connection refused* minzaw@Dell-PC:~$ sudo ...
0
votes
1answer
33 views

how can I create a MySQL account using terminal

I have tried using the root, but I receive errors. mysql -u root File "<ipython-input-6-c07024211ca7>", line 1 mysql -u root ^ SyntaxError: invalid syntax
0
votes
1answer
106 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
48 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
90 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
43 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
157 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
70 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
143 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
95 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
47 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 ...
1
vote
0answers
165 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
1answer
373 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
35 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
86 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
41 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
121 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
126 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
84 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
78 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
647 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
33 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
18 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 ...