Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
0answers
22 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"); ...
0
votes
1answer
5k 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. ...
2
votes
1answer
35 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 ...
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?
1
vote
3answers
1k views

phpmyadmin not working due to missing extensions

I am about to use phpmyadmin on Ubuntu 16.04. But it shows that the page is not working. the error log says error 500 PHP Fatal error: require_once(): Failed opening required ...
0
votes
2answers
64 views

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

I just installed Ubuntu 16.04 along with packages php, mariadb, nginx. I ran mysql_secure_installation and changed root password. Now when I try to login to mysql using mysql account root while logged ...
0
votes
0answers
8 views

cannot update/add data in table MySQLi+PHP

Cab someone tell why does my code not update or add any data into MySQL table? i've spend a lot time to reading and writing it but have no idea why is my code does not work. Appreciate every answer. ...
0
votes
0answers
24 views

Does laravel 5.0 work in Ubuntu 16.04?

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 ...
2
votes
2answers
55 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 ...
1
vote
1answer
29 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
54 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 ...
0
votes
1answer
36 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 ...
18
votes
5answers
4k 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 ...
2
votes
1answer
264 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: │ ...
0
votes
0answers
14 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 ...
0
votes
0answers
39 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
vote
1answer
91 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
1answer
70 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 ...
4
votes
2answers
6k views

How can I install specific version of MYSQL

I'm trying to install mysql-server 5.0. because I want to install a program which depend on this version. I've surfed the net to find a solution but none of them worked. I'm really disappointed. I ...
0
votes
2answers
825 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 ...
0
votes
0answers
30 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
votes
1answer
25 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
35 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 ı installed mysql 5.7.12, gtk 3.0, the problem started. when ı try to enter ubuntu A blank screen shows up. However, ...
1
vote
0answers
45 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
19 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 ...
1
vote
2answers
217 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
1answer
7k views

mysql: unrecognized service (apparmor)

Many questions on this point but I couldn't any help yet. Mysql was working then I tried to move mysql database directory as (in this ...
4
votes
5answers
32k views

MySQL Access denied for user 'root'@'localhost'

In my server, everytime I try to access MySQL I get the error: Access denied for user 'root'@'localhost' (using password: NO) when I try mysqladmin -u root -p password I get Access ...
1
vote
1answer
173 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 ...
-1
votes
0answers
13 views

Error on java.jar

Exception in thread "main" java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at ...
0
votes
2answers
185 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 ...
0
votes
1answer
289 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
2answers
364 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
17 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 ...
1
vote
1answer
16k 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 ...
0
votes
0answers
13 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
1answer
96 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 ...
0
votes
0answers
14 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 ...
82
votes
13answers
24k views

What's the easiest way to set up a LAMP stack?

I set up a new VPS instance of Ubuntu and am wondering what the easiest way is to get up and running with a basic LAMP stack (i.e. which packages are required, which configuration options need to be ...
0
votes
0answers
13 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 ...
0
votes
0answers
33 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
0answers
17 views

Running MySQL database browser GUI from lampp

I have followed the instructions in the How to start xampp GUI and get the following error when I type in the terminal: sudo /opt/lampp/share/xampp-control-panel/xampp-control-panel Error importing ...
0
votes
1answer
86 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
155 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: ...
1
vote
2answers
8k views

phpMyAdmin - Display all queries

I have installed a fresh desktop with ubuntu quantal and the following packages versions: MySQL: 5.5.28-0ubuntu0.12.10.1 Apache: 2.2.22 (Ubuntu) phpMyAdmin: 3.4.11.1deb1 I would like ...
0
votes
0answers
11 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 ...
7
votes
4answers
3k views

Systemd Mysql won't stop

After upgrading to 15.04, I have had lots of fun getting to know systemd. I think I have everything working except I am unable to stop mysql.service; the systemctl command just hangs and mysql just ...
1
vote
3answers
6k views

Problems installing mysql on Ubuntu 14.04

I hit the following error shortly on entering the mysql "root" password: An error occurred while setting the password for the MySQL administrative user. This may have happened because the account ...
0
votes
1answer
21 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 ...
-1
votes
0answers
11 views

MYSQL Restore from file fails

after shredding my Ubuntu system, I want to restore databases by the frm/MYD/MYI files I backed up. I restored my the all custom database folders into /var/lib/mysql I left the automatically ...