Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

2
votes
0answers
62 views

Error after attempting to update php lampp and reinstall lampp

I tear my hair, it's been almost one day I try to reinstall lampp but it doesn't work. It's been almost one day I try to reinstall lampp on my ubuntu 14.04 LTS in vain. I installed first lamp with ...
0
votes
0answers
54 views

How to upgrade from mysql 5.6 to 5.7 on 14.04 LTS

I'm using mysql 5.6.30 now I want to upgrade mysql 5.7. What should I do? What are the steps? This is my current version root@xxxx:~# mysql --version mysql Ver 14.14 Distrib 5.6.30, for debian-...
0
votes
2answers
42 views

Connection Mysql fails

I need a little help installing/connecting an application to a mysql database. First time I faced many problems/errors, the most of them are gone and this is the result stull nothing haha... Does ...
0
votes
0answers
344 views

Uninstall MySQL from Ubuntu 16.04

I'm trying to uninstall completely MySQL from my computer to reinstall it again. These are the packages installed on my pc: giuseppecanto@acerAspire5750g:/etc/mysql$ sudo dpkg -l | grep mysql ii ...
1
vote
0answers
220 views

Apache2 and Mysql gone wrong after upgrade to 16.04

After I installed Ubuntu 16.04 I was not able anymore to access to my Mysql server from h-ttp://localhost/phpmyadmin. I tryed to uninstall and install mysql but unsuccessfully. I discovered that the ...
1
vote
1answer
45 views

Possible MySQL error occurred during system upgrade

Run on terminal the command sudo apt-get upgrade. After a few seconds appears this: Errors occurred while processing: /var/cache/apt/archives/mysql-server-5.5_5.5.49-0+deb8u1_amd64.deb E: Sub-process ...
0
votes
1answer
32 views

Connection mySQL to ws02

Folks, Im facing a problem with connecting/creating mysql database/tables to ws02 instead of h2 ws02@ws02:/usr/bin/wso2/wso2emm-2.0.1/bin$ sudo -E ./wso2server.sh -Dsetup [sudo] wachtwoord voor ...
1
vote
1answer
15 views

Problem exporting my database sql through the terminal

I have this issue when I try to export my database with the CLI instruction mysqldump -u [root] -p [guru99] > [guru99].sql root@YuveSys:/home/yuve# mysqldump -u [root] -p [guru99] > [guru99]....
1
vote
2answers
2k views

(K)Ubuntu 16.04 can't install mysql server unmet dependencies

When I try to sudo apt-get install mysql-server I keep getting following error: The following packages have unmet dependencies: mysql-server : Depends: mysql-community-server (= 5.7.12-1ubuntu15....
0
votes
1answer
106 views

Mariadb non-root user

I have installed mariadb and when as a Linux root user, I can run mysql command to access the database. But when I try to login as a normal Linux user and run mysql -u root -p, I am getting error: ...
1
vote
3answers
284 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
209 views

Does laravel 5.0 work in Ubuntu 16.04? [duplicate]

I had previously ubuntu 14.04 LTS installed and I have so many projects on laravel 5.0. After the release of Ubuntu 16.04 I installed it on my machine and I am facing a lot of difficulties to get ...
1
vote
1answer
176 views

MySQL server does not start because of missing permissions, but they are given

I just copied my old set of databases to /var/lib/mysql and got something strange. First the permissions were "root:root", because I used "sudo mc" to copy the backup from backup location. I ran chmod ...
0
votes
0answers
208 views

14.04 to 16.04 *KILLED* mysql

Definition: trust - Something that the Ubuntu LTS packagers have lost from me. I scrupulously maintained my 14.04 LTS web server machine. It only had four primary functions (ssh, ftp, http, and ...
2
votes
2answers
725 views

mysql don't ask for root password when installing

I use apt install mysql-server to install MySQL on Ubuntu 16.04 but during the installation, it does not ask for root password .After installation it had ERROR 1045 when i tried to login as root ,...
3
votes
2answers
68 views

Shell script password with special chars

I've build a shell mysql backup script which works very well. It only has problems with passwords with special chars like this: xgT{uic[Is?uJ+. Here is the important part of the script: #!/bin/sh ...
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 ...
0
votes
2answers
405 views

PHP installation appears to be missing the MySQL extension

After upgrading my ubuntu from 15.10 to 16.04 LTS, it is showing an error Your PHP installation appears to be missing the MySQL extension when taking any local website from my lamp. When I tried to ...
0
votes
0answers
107 views

can't install phpmyadmin

Please help , I installed phpmyadmin previously , I had an error so i used all methods I found to delete it, but now I can't install it again. That's what I get .. sudo apt-get install phpmyadmin ...
1
vote
1answer
1k views

Error Installing mySql on Ubuntu 16.04

I have been following the instructions on this page https://www.linode.com/docs/websites/lamp/lamp-on-ubuntu-14-04/ to install mysql on on Ubuntu 16.04. I am half way down that page at the section ...
0
votes
0answers
55 views

Problem with webserver. LAMP not working as expected. Can somebody help me?

Ok, this problem is driving me crazy. I had IIS 7.0 before in Windows Server 2008 and hosted there 8 wordpress websites. Websites can show from outside without problem, also I could access ...
-1
votes
1answer
55 views

PHP script killed by OOM killer

Please help ! I meet same question here but it's all not working for me. I can assume what I doing: 1.)Run huge script for selecting info from MySql database by php script, this is example (simple ...
0
votes
1answer
61 views

Black screen appears when trying to enter ubuntu - dual boot (windows10 - ubuntu 14.04)

I am having problem with Ubuntu again. Everything was perfect (for 1 month), after I installed mysql 5.7.12 and gtk 3.0 the problem started. When I try to enter Ubuntu a blank screen shows up. However,...
0
votes
3answers
39 views

ubuntu 12.04.5 not able to install mysql server

(I am new to Ubuntu) I need to install mysql server on Ubuntu 12.04.5 and I am getting follwing error. mysql-server Dependes hav unmet dependencies: mysql-server: Depends : mysql-server-5.5 but it ...
2
votes
1answer
1k views

pdo_mysql removed on updating to 16.04

I recently updated to 16.04 LTS. And it updated my php to 7.0. Now it some how removed pdo_mysql. I need this extension to develop magento website. In phpinfo, I find pdo support: enabled pdo ...
0
votes
0answers
65 views

Problem with Apache2 after upgrading to 16.04 webpage not displaying correctly

I have a page that displays my radio station information. It looks something like this: <html> <body style="background-color:transparent"> <?php require("config.php"); $db->...
1
vote
0answers
156 views

Ubuntu 16.04 Cannot install MySQL

After installing Ubuntu 16.04 and in the process of setting up a lampp stack. I tried to install MySQL as usual using the code below: sudo apt-get install mysql-server However I get the below ...
1
vote
0answers
204 views

Error on sudo apt-get upgrade and MySQL start job failed

I'm trying to start mysql on linux but i'm getting the job failed error. I'm trying to upgrade it just to check if it will fix the issue.. I get the following output when I do sudo apt-get upgrade: ...
0
votes
2answers
2k views

MySQL istallation problem on Ubuntu 16.04 (my.cnf public ip problem)

I follow these instructions to install mysql in Ubuntu 14.04 and it works great. But I make a clean installation of Ubuntu 16.04 and make the same steps to install MySQL and I have problems. The my....
4
votes
3answers
4k views

Cannot reinstall mysql-server after its purge

I recently did a fresh install of Ubuntu 16.04. I also installed mysql-server and mysql-client (their default version 5.7.12) via apt-get install. Because 5.7.12 was showing some issues, I decided to ...
0
votes
0answers
25 views

How long will mysql-server-5.5 on trusty receive security updates?

Looking at https://www.mysql.com/support/, MySQL 5.5 should only be supported with security patch updates through Dec 2015 on 'Premier' support, and up to Dec 2018 on 'Extended' support. I see that ...
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 ...
3
votes
1answer
3k views

Is it possible to install MySQL 5.5 or 5.6 on Ubuntu 16.04?

I recently upgraded to Ubuntu 16.04. Unfortunately I need to work MySQL 5.5 or 5.6. I tried many solutions to have MySQL 5.5 or 5.6 run on Ubuntu 16.04 like this Install MySql 5.6 on Ubuntu 16.04 . ...
0
votes
0answers
46 views

Software Updater Hanging installing “Auto configuration for MySQL APT Repo”

My Software updater is failing to install the package "Auto configuration for MySQL APT Repo". It always starts and during Post Install it starts consuming all my CPU and stays like that forever. I ...
0
votes
0answers
22 views

Ubuntu server and mysql with bitnami

I'm hoping someone can help me or point me in the right direction. I have an Ubuntu 14.4 server running as a web server which we run a WordPress installation on, We've used the Bitnami installer to ...
0
votes
1answer
1k views

Ubuntu 14.04 mysql-client-5.7 dependencies issue on update: Permanent solution?

When I run sudo apt-get update && sudo apt-get upgrade my package system gets broken because of mysql packages. I have tried to unistall the client and all the other packages, then to install ...
5
votes
1answer
2k views

Can't get mysql/phpmyadmin to work after updating to 16.04

After the update, mysql/phpmyadmin stopped working. When I do: sudo dpkg-reconfigure phpmyadmin I get this error: An error occurred while installing the database: │ ...
11
votes
3answers
13k views

Install MySql 5.6 on Ubuntu 16.04

It seems that Ubuntu 16.04 is coming with MySQL 5.7, however I need to install 5.6. When I try to install it explicitly sudo apt-get install mysql-server-5.6 I get the following error: Package mysql-...
1
vote
0answers
161 views

Mysql-Server installation stuck on root password

I trying to install mysql-server into a Docker container so in my Dockerfile I've added apt-get install mysql-server , install runs until it demand to provide the root user's password and then just ...
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 ...
5
votes
6answers
2k views

akonadi services and mysqld use too much memory in kubuntu 16.04

I recently installed kubuntu 16.04 on my Dell studio xps 1640 that has 8GB of Memory installed. Everything is working fine but Something is really bothering me. After a fresh boot up, when i check the ...
0
votes
0answers
17 views

Homebrew mysql question

I am trying to install mysql via homebrew but once it starts downloading it stays static at this screen: (I left my computer there the whole day hoping it will finish but nothing happened). Any ...
0
votes
1answer
330 views

Problems with Zonminder and MySQL after upgrading to 16.04

Upgrading to 16.04 is a nightmare... it has broken everything on my server that has been running for 10 years. I am slowly trying to get my server working again ... as of now I'm dealing with ...
0
votes
0answers
380 views

Xenial - Phpmyadmin - The mysqli|mysql extension is missing

I just installed Xenial, the current Ubuntu version and I have this error The mysqli|mysql extension is missing Also when I want to install an application I have a pb with this error fatal error: ...
33
votes
6answers
17k views

16.04 upgrade broke mysql-server

My overall upgrade went well, but I am left with a critically lingering issue of mysql-server not being able to install itself, and nothing I am trying gets it to work. This is the error I see when ...
0
votes
0answers
131 views

mysql Access denied for user 'viviana'@'localhost' (using password: NO)

I'm using a software pipeline called stacks using as database Mysql. When I start the pipeline the following error comes: ERROR 1045 (28000): Access denied for user 'jim'@'localhost' (using ...
0
votes
1answer
82 views

Mysql-common cannot be uninstalled

I'm trying to completely uninstall mysql to reinstall it later, after uninstalling all mysql-related packages, mysql-common seems to remain in a broken state. $ sudo dpkg -l | grep mysql pc mysql-...
0
votes
0answers
44 views

Unable to run MySQL workbench on Ubuntu 15.10

I have installed MySQL Workbench on my Ubuntu 15.10 system using the software center, however I am unable to run it either via the GUI or from the CLI. sudo mysql-workbench Bus error (core dumped) ...
0
votes
2answers
74 views

ubuntu server 14.04 LTS too slow

Last two weeks my ubuntu server is too slow. It happens every day. All the services are pretty slow or died. Reboot server helps for 4-5 hours and after that issue occurs again. I've made screenshots ...
0
votes
0answers
30 views

problem with installing mysql-server5.5 with ubuntu12.04, socket file not found

I am trying to create a database in ubuntu 12.04 after installing mysql-server5.5 but I got the following problem. after checking it seems the subfolder var\run\mysqld that should contain the socket ...