Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

1
vote
2answers
721 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 ...
18
votes
5answers
82k views

how to reinstall mysql?

A software upgrade broke, among other things, mysql and I have not been able to get it back up yet. Suspected cause: I had a near-full boot disk; the upgrade filled up the disk before completing and ...
1
vote
1answer
525 views

Can I scale out the mysql charm instead of adding another database?

I have question how to scaling mysql service because I make deployment from here: https://jujucharms.com/docs/stable/charms-deploying And I have wordpress and mysql related but is there possible to ...
0
votes
1answer
49 views

cannot connect to MYSQL server through phpmyadmin

This is my phpmyadmin login page. I am using Ubuntu 16.04 . I am using the XAMPP server. Apache and php server are working fine ,but I cannot access the phpmyadmin. When I use sudo /opt/lampp/lampp ...
0
votes
1answer
7k views

Xampp : http://localhost/xampp/splash.php :english : nothing happens

After I start Xampp on my Ubuntu 12.04 I go to the localhost and I come to the site, where all languages are listed .... when I click any of these languages nothing happens. Follow steps are already ...
0
votes
1answer
35 views

Unable to purge mysql -server

I am new to ubuntu. I am trying to uninstall mysql-server, while i'm doing it the purging process gets stuck at the line Renaming removed key_buffer and myisam-recover options (if present) and later ...
0
votes
1answer
14 views

Can't start nor remove MySQL

I was using MySQL without any error on Ubuntu 15.04.But yesterday I upgraded to 16.04LTS from 15.04 yesterday(15.04 to 15.10 and 15.10 to 16.04LTS). I'm having some issues now When I check MySQL ...
0
votes
4answers
3k views

Having trouble in installing and removing mysql in ubuntu

I have trouble in installing or removing the partly installed mysql-server-5.6 in ubuntu15.04. The error I am getting was sudo apt-get -f install Reading package lists... Done Building dependency ...
0
votes
1answer
5k views

How to start mysqld through mysqld_safe

Specifications: MySQL Server version: 5.5.43-0ubuntu0.14.04.1 (Ubuntu) Ubuntu-Server 14.04 LTS Default MySQL-Config-File Question: Even after spending a long time I can not figure out why I can ...
2
votes
2answers
34 views

Reinstall Apache2, after remove on Ubuntu 16.04

I have few errors with mysql-server, and after i tried more command in terminal, i don't find a proper way to resolve. I decided to remove all (phpmyadmin, mysql, apache2). Mysql and phpmyadmin, ...
0
votes
0answers
7 views

Cant Post Data Lamp

I had install and configuration lamp. For running my web and show data from mysql it works but after i do login and register data from my web page it cannot works. Is there command about lamp for ...
0
votes
0answers
9 views

Problems with installing phpMyAdmin

I Installed phpMyAdmin (Ubuntu 16.04) and the installation failed. Initially I accidentally named the phpmyadmin table to 'test', and after reinstalling phpmyadmin with another table name (phpmyadmin),...
1
vote
1answer
14 views

Can I install MySQL and MariaDB both on Ubuntu 16.04 and connection with phpMyAdmin

I have been using MySQL since long but no idea at all about MariaDB and wanted to learn. Before I install MariaDB I would like to know whether it is possible to install along with MySQL and connect it ...
0
votes
1answer
60 views

Ubuntu 16.04 : can t apt due to mysql-server-5.7 issue

I m trying to install / update packages and everytime the process failed because of a mysql-server error : sudo apt install graylog-server Lecture des listes de paquets... Fait ...
3
votes
2answers
4k views

Mysql 5.5 reinstallation 12.04

I had a broken installation of mariadb over mysql 5.5. For hours i have tried to reinstall mysql with the usage of apt-get - tried to purge, remove etc everything mysql related. Uninstalled php aswell....
4
votes
7answers
2k views

can't login as mysql user root from normal user account in ubuntu 16.04

I just installed Ubuntu 16.04 LTS along with the packages php, mariadb and nginx. I ran mysql_secure_installation and changed the root password. Now when I try to login to mysql using the root ...
1
vote
2answers
70 views

Unable to start mysql , if provided data directory exist on ntfs file stystem

sudo mysqld --debug 2016-06-06 11:02:35 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name ...
0
votes
0answers
6 views

How can I retrieve Mysql Database Results to my Applet in my Browser?

I have been trying to get my applet to display database values from MySQL server, something it does very well when i debug it in Netbeans, so I do not understand. I have set the java security levels ...
0
votes
0answers
130 views

Starting ZoneMinder: DBI connect('database=zm;host=localhost','zmuser',…) failed:

I have installed zoneminder on ubuntu 14.4 server. When system boots up I have this error show up after Apache starts. Starting ZoneMinder: DBI connect('database=zm;host=localhost','zmuser',...) ...
1
vote
1answer
27 views

find history of mysql commands on ubuntu

i use mysql on ubuntu.i find all last commands history on terminal by history command but it exclude mysql query or commands.is there any method or command like history to find last mysql queries ...
0
votes
0answers
36 views

Ubuntu 16.04 Error Processing archive mysql-common

I've a problem when I'm tried to run apt-get update, error appears as follows: Reading package lists... Done Building dependency tree Reading state information... Done You might want to run '...
0
votes
1answer
24 views

Install older version of LAMP in Ubunutu 16.04 LTS

I recently installed Ubuntu 16.04 LTS (I used to have 14.04 LTS and I had to reinstall everything), since I'm still working with PHP 5.6 I must install lamp environment that'll work with that, ...
76
votes
10answers
144k views

MySQL GUI Tools

Does anyone have any good ideas as to native MySQL GUI clients for Ubuntu? So far I've tried MySQL Workbench, which never seemed to work properly, phpMyAdmin which I found a bit slow, and Navicat ...
1
vote
1answer
414 views

MySQL not working after upgrade from 14.04 to 16.04

After a good deal of troubleshooting I have managed to get Plasma running however MySQL will still not start systemctl status mysql.service â mysql.service - MySQL Community Server Loaded: loaded ...
0
votes
1answer
13 views

14.04: How to convert mysql to postgresql?

is there anyway to convert a mysql file (.sql) to a postgresql file? I have a number of tables and creating them all over again in phppgadmin is gonna take a lot of time. Any help will be greatly ...
2
votes
1answer
91 views

Installing Ubuntu 16.04 LTS: How to install ODBC?

After installing a fresh new copy of Ubuntu 16.04, I tried to install MySQL ODBC as per the official documentation at https://help.ubuntu.com/community/ODBC: # apt-get install libmyodbc Reading ...
0
votes
1answer
17 views

I started trying to install MariaDB MySQL. Now I have a mess, looks like I can't install packages now

First of all, I don't know very much about Ubuntu. It's Ubuntu 16.04 Server (64 bits). I needed to install a MySQL database, using apt-get install mariadb-server. It worked, it's been installed but ...
0
votes
0answers
12 views

PHP 5.6 sending errors through email regarding mysqli

After struggling to set up mysql and mysqli on my Ubuntu (16.04) server (PHP insisted on loading .dlls that did not exist and that were not requested in any of the configuration files), I finally got ...
0
votes
2answers
62 views

Can't install mysql-server on 14.04

Ubuntu Server 14.04, everything on the server is fully updated. No matter what I try, I cannot get mysql-server to install. I followed all answers to this question, and I even tried sudo apt-get purge ...
1
vote
3answers
277 views

Ubuntu 16.04 auth_pam broken

I'm trying to set up a mail server on a fresh Ubuntu 16.04 machine but I can't get it to work properly. I'm using a Postfix/Courier setup with MySQL for authentication. Receiving emails and reading ...
0
votes
1answer
5k views

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection XAMPP

Hi i am intend to connect phpMyAdmin, i have install XAMPP but i change the port using this guide Cannot start XAMPP on Ubuntu 11.10 I use this URL to enter phpMyAdmin http://localhost:2145/...
0
votes
1answer
28 views

PHP Startup: Unable to load dynamic library '/usr/lib/php/20151012/php_openssl.dll'

I have ubuntu 14.04., php 7 and nginx. I want to use mysql ssl so I have enabled by removing ";" in front of extension=php_openssl.dll in /etc/php/7.0/fpm/php.ini /etc/php/7.0/cli/php.ini ...
2
votes
1answer
41 views

Apache can't be accessed externally

I have Ubuntu server with pre-installed apache2, mssql, php5. I install vTiger CRM and it's available on my localhost and internal IP. But i can't reach it using my external IP. I checked all setups ...
-1
votes
2answers
37 views

s3cmd asking for S3 URI while using s3cmd get

I have uploaded a mysql backup file onto amazon s3 s3://bucketname/object/mysqlbackupfile. When i am trying to retrieve it using s3cmd get s3://bucketname/object/mysqlbackupfile there is an error ...
2
votes
1answer
33 views

Working with cronjobs, bashscripts to automate MySQL backups

I am currently setting up a system which uses a MySQL database. I want to create automated backups which run every evening at 10:00PM and also keep the backups for 30 days. I know there is a way ...
0
votes
0answers
29 views

Install error for Mysql-Server

I try to install mysql-server and phpMyAdmin, after first instalation i have an error for log with user root ...and after this, error #2002 - No such file or directory. Ok, I tried to uninstall mysql-...
0
votes
1answer
65 views

MySql not running; Ubuntu 16.04

Following error. systemctl status mysql.service● mysql.service - MySQL Community Server Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: en Active: activating (...
0
votes
0answers
11 views

Not able to access MySQL, not via Virtualmin or SSH. Tried everything

Using Ubuntu on 14.04. I installed Virtualmin and it says ''MySQL does not appear to be installed and running on your system, or has not yet been set up properly in Webmin's MySQL Database module. If ...
0
votes
0answers
10 views

Ubuntu 16.06 mysql 5.6 file privileges

I have mysql 5.6 installed on Ubuntu 16.06. I get an error on LOAD DATA INFILE saying (Errcode: 13 - Permission denied). I have tried to set secure_file_priv, in a config file but I don't even know ...
2
votes
1answer
2k views

Cannot enter phpmyadmin as root (MySQL 5.7)

I'm using Ubuntu desktop 16.04 (upgraded from 15.10). I had installed phpmyadmin from by apt-get install phpmyadmin. It works if I go to localhost/phpmyadmin but I cannot log into it as root. I have ...
0
votes
2answers
30 views

importing database from localhost to AWS RDS?

I've tried to export database from AWS RDS to localhost by command line it works the command is mysqlump -h r.rds.server -u rdsusername -p rdsdatabase > backupfile.dump but it doesn't works for ...
2
votes
3answers
1k views

Auth succeeded No requires line available

Upgrading to Ubuntu 14.04 (and Apache2 2.4) server I can't use MySQL as htaccess; Before upgrading I was using MySQL as htaccess in the virtual host - worked nicely: <Directory /var/www/html/...
1
vote
1answer
18k views

How to deal with MySql ERROR 1133 (42000): Can't find any matching row in the user table?

I am constantly get the following error message: 1045 Cannot log in to the MySQL server I have tried the following: sudo service mysql stop (Went fine) sudo /usr/sbin/mysqld --skip-grant-...
0
votes
1answer
87 views

How to install pdo_mysql extension for Php7 [closed]

I am total newbie on Linux so may be I will have weird questions. So as I found out I have two instalaions of php on my Linux Mint. When I tried to use php in terminal I fouded out this php has no ...
8
votes
7answers
38k views

MySQL error: The partition with /var/lib/mysql is too full!

I get this error when trying to start MySQL: The partition with /var/lib/mysql is too full! Here is the output of df -h: Filesystem Size Used Avail Use% Mounted on /dev/sda1 455G 77G ...
0
votes
1answer
6k views

Turn off MySQL --skip-grant -tables

I reset my root mysql password with the following instructions: (Works for Ubuntu as well) http://www.debian-administration.org/articles/442 But now I can't turn off mysqld_safe --skip-grant-tables. ...
1
vote
2answers
4k views

Can't connect to local MySQL server through socket '/tmp/mysql_2.sock' during manual installation of mysql

I get the error below when attempting to manually install mysql-5.6.17-linux-glibc2.5-x86_64 Steps I followed: 1. tar -xzvf mysql-standard-5.1.34-linux-i686-glibc23.tar.gz 2. ln -s mysql-...
12
votes
3answers
41k views

Cannot install mysql-server-5.5/the following packages have unmet dependicies

I'm a newbie here so please bear with me. I'm using ubuntu 14.04. I tried entering mysql with the following command: mysql -u root -p and I got the following message: The program mysql can be ...
-1
votes
0answers
33 views

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I have installed apache2 and mysql-server-5.6 on linux ubuntu 14.04, when i browse ip address apache is working fine, but mysql is not running--> I have run commands sudo service mysql start or ...
0
votes
1answer
38 views

Crontab runs /etc/init.d/ scripts but won't run service restart?

I am very new to Linux so please bare with me. I'm writing a script to restart mysql and send me an email whenever it goes down. I'm using crontab to run the script every x minutes. I'm having an ...