Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
0answers
13 views

Monit not monitoring Lemp

I have LEMP with MariaDB installed. I have Monit installed and configured to monitor php-fpm, mysqld and nginx but non of these services seem to be monitored as shown in the screenshot here I have ...
0
votes
0answers
36 views

Trouble Resetting Mysql root password

Fresh install of Mariadb. I tried following the instructions here to reset the root passwordCannot Log in to the MySQL Server. When got to sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking &...
0
votes
0answers
13 views

Understanding /var/log/dpkg.log on 12.04

Something or someone removed mysql-server : 2016-06-01 08:54:23 remove mysql-server 5.5.49-0ubuntu0.12.04.1 <none> Is there a way to understand what the initiator of this action was?
0
votes
1answer
64 views

MYSQL and PHPMYADMIN Error

I'm new here and totally new to ubuntu. Though, i have been using 14.01LTS for few weeks, but i wanted to upgrade to 16.04LTS. I started the upgrade, but i had some power issues. After i brought my PC ...
-1
votes
0answers
16 views

Deleted All Traces of Mysql

I was having issues with mysql not being recognized as a service or through init.d. In my frustration I opened nautilus with sudo and deleted every trace of MySQL. At this point I've tried ...
0
votes
0answers
11 views

Mysql Workbench on ubuntu 14.04 cannot export db

Hello fellow when I try to export a database (connected via ssh) I get the following error: 04:53:39 μμ Dumping cosmima (all tables) Running: mysqldump --defaults-extra-file="/tmp/tmpVGyoJZ/...
0
votes
0answers
17 views

Postfix config to add domain to mail directory

I am running a mail server with the MySQL, Postfix, Courier, SASL ( also with AMAVIS, Spamassasin, ClamAV, postfix admin & PHPmyadmin - bit I don't think these are relevant to my query) Postfix ...
0
votes
0answers
13 views

VPS won't connect to external databases

I'm having troubles with my Ubuntu VPS. It refuses to connect to any external databases. I can't really quite figure out why, as I've opened all the necessary ports, such as 3306 and other possible ...
0
votes
0answers
43 views

Can't connect to MySQL server on 'DOMAIN' (111)

I don't know what to do anymore... I can't connect with my webspace to my mysql db on server 2... Every time I get Error 111 or 110. I read so much topics, but nothing helped. I alrdy changed ...
0
votes
1answer
55 views

Joomla 3.0.3 installation gets stuck in the configuration section in Xubuntu 16.04 localhost

Trying to setup joomla 3.0.3 on my localhost on Xubuntu 16.04 but the installation gets stuck in the configuration section. After fulfilling all the tabs when I click next, it takes me back to the ...
0
votes
0answers
40 views

16.04 Akonadi for Kontact does not start

I upgraded from 12.04 to 16.04 in two steps today and the PIM tools, like Kontact, no longer work due to Akonadi/MySQL problems. akonadictl start gives this output/error: edA-qa@silent-red:~/.local/...
0
votes
0answers
79 views

mysql-community-server makes ubuntu shutdown very slow

Hi there: My question is about shutting down ubuntu xenial 16.04 LTS in a Dell machine dual-boot with Windows 10. Dual boot is working really well. The issue happens during ubuntu shutdown. The ...
1
vote
2answers
42 views

mysql-Workbench can't connect to server

In workbench the status of the server is STOPPED and the startup log message: 2016-05-28 11:14:37 - Checking server status... 2016-05-28 11:14:37 - Trying to connect to MySQL... 2016-05-28 11:14:37 - ...
0
votes
0answers
170 views

MySQL server can't start

I installed MySQL-server-5.7 use apt: apt-get install mysql-server-5.7 but when I want to start server using: systemctl start mysql I got error. using service msyql status to see the status, I get ...
0
votes
0answers
22 views

404 not found : After installing LAMP stack

I have installed Ubuntu and NGINX server, php7.0 and mysql database. After that I have installed the WordPress. When I opened the site with ip-address I am getting 404 not found.
1
vote
1answer
248 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
83 views

How to remove the MySQL Server 5.5 from Ubuntu 14.04?

I wanted to upgrade my MySQL server and client from v5.5.49 to the latest v5.6.*. To do this I firstly tried to uninstall the old version: $ apt-get remove mysql-server-5.5 mysql-server-core-5.5 ...
1
vote
1answer
271 views

Ubuntu 16.04 LAMP MySQL dpkg install problems

LAMP Ubuntu 16.04 MySQL server install problems tried to set up LAMP system on Ubuntu 16.04 with the following instructions. howtoforge ubuntu_lamp_for_newbies Apache and PHP installed and ...
1
vote
2answers
646 views

Uninstall MySQL from Ubuntu 16.04

I am trying to uninstall MySQL completely from Ubuntu 16.04 LTS,but I am facing an issue saying: The following packages have unmet dependencies: mariadb-client-10.0 : Depends: libdbd-mysql-perl ...
0
votes
0answers
40 views

phpmyadmin can't click users tab

I finally managed to install mysql-server-5.7 and phpmyadmin. I got root permissions, can log in with it everywhere, etc. What I can't do is to get to the Users tab in phpmyadmin web panel. Clicking ...
0
votes
1answer
113 views

Unable to locate package php5-mysqlnd-ms

Using Ubuntu Server 16 PHP5.5 FPM PHP Version 5.5.35-7+donate.sury.org~xenial+1 Trying to install Wordpress: Your PHP installation appears to be missing the MySQL extension which is required by ...
0
votes
1answer
76 views

Errors configuring mysql 7 after upgrade to ubuntu 16.04

I upgraded to Ubuntu 16.04 and now can not get MySQL 5.7 to work. I tried: sudo apt purge mariadb-client-10.0 mariadb-common mysql-client mysql- client-5.7 mysql-client-core-5.7 mysql-common ...
0
votes
0answers
22 views

Script of getting mysql user grant details

I am trying to get mysql user grant details and echo it to out file hari=mysql -sN -e "show grants for mysqladm"; echo $hari GRANT ALL PRIVILEGES ON prod_server_list.txt stage_server_list.txt ...
0
votes
1answer
32 views

Mysql package mysql-server-5.6 uninstallation error

When I am trying to uninstall mysql its giving fallowing ERROR $ apt-get remove --purge mysql*.* Reading package lists... Done Building dependency tree Reading state information... Done E: ...
0
votes
1answer
45 views

How to completely remove phpMyAdmin without knowing its password?

I know there are more questions about this problem "How to remove phpMyAdmin" but they did not work, because I lost my password! I lost my phpMyAdmin and MySQL password and username! I don't remember ...
1
vote
1answer
50 views

Port forwarding/bypass firewall

I have two servers located at two different places: Ubuntu Server (MySQL) Ubuntu Server (Tomcat) The problem here is that the Tomcat server cant send data to the mySQL server over port 7878 because ...
0
votes
0answers
17 views

Mutillidae cannot be available

I have install everything necessary file or program. I follow instructions by this pageApache2 seems to work fine and I can enter to localhost/html and it's okay Unfortunately when I type localhost/...
0
votes
0answers
28 views

red icon the panel

Reading package lists... Done Building dependency tree Reading state information... Done mysql-server is already the newest version (5.7.12-0ubuntu1). You might want to run 'apt-get -f install' ...
0
votes
1answer
49 views

Not able to kill Mysql process

I was trying to uninstall mysql using sudo apt-get --purge remove mysql-server but getting following error E: Could not get lock /var/lib/dpkg/lock - open (11: Resource temporarily unavailable) E: ...
0
votes
0answers
22 views

mysql and phpmyadmin File Permissions at home

14.04, Apache2 mysql php5.5.9: Can someone recommend a tutorial on usernames and file permissions for home, remote sandbox, and production servers for website development, or where can I find a ...
0
votes
1answer
17 views

Mysql database with phpmyadmin

I backed up the mysql database from my windows wamp and i copied the the data to ubuntu mysql. I am given the database only and not the table. any help in how to be able to get the table back.
-2
votes
1answer
41 views

Changing the root user of MySQL [closed]

How do I change my root user to any other local user on mysql db?Since I have installed Ubuntu all the work is done by this superuser root now just don't want root to do all stuff of mysql...
1
vote
1answer
24 views

Ubuntu 14.04 server went offline all of a sudden

I see the below in syslog, not sure what went wrong, any help will be appreciated. Is this beacause of an automatic kernel update as I see a new kernel version? May 17 10:20:36 vps rsyslogd: [origin ...
0
votes
1answer
67 views

Mysql need sudo to run in ubuntu 16.04

I can't run mysql without sudo. I think this the problem seen in 16.04 only. So I am looking for a solution for this. Can someone help me figure out this?
0
votes
0answers
61 views

Install mysql 5.5 on ubuntu 15.04

I have tried many ways to install mysql-server-5.5 on ubuntu 15.04. First I checked the following tutorial, but even after adding the ppa for mysql-5.5 and updating apt-get, mysql-5.6 is installed ...
2
votes
2answers
241 views

How to repair corrupt package installation (mysql)

After upgrading to Ubuntu 16.04, I noticed mysql was having mind-boggling errors. Convinced, it was a broken setup, I tried running a purge of mysql. That didn't seem to delete everything, so I tried ...
1
vote
1answer
74 views

fixing broken packages in ubuntu : repost

I have a lot of broken packages in my ubuntu 14.04 distro, which I am trying to fix. I am following this answer by one of our community member. I followed the first two commands and after editing the ...
1
vote
2answers
191 views

16.04 MariaDB -> Error in syslog (mysqlcheck)

i've found the following failure in my syslog after installing Ubuntu 16.04 and MariaDB from the Scratch using this really awesome tutorial https://www.howtoforge.com/tutorial/install-apache-with-php-...
3
votes
0answers
28 views

I need a correct help for MariaDB SSL support

I have to make my MariaDB authentication a bit safer than default. I tried to set up SSL support for this, but found only an old howto here: How to enable MySQL SSL on Ubuntu I followed it, however ...
0
votes
1answer
83 views

Mysql Error SQLSTATE[HY000] [1045] Access denied for user. While installing Drupal 7 in localhost

I recently did a clean upgrade from ubuntu 14.04 to ubuntu 16.04. I could easily install drupal 7 in ubuntu 14.04 but my problem is arising when i am creating a new database for drupal 7.43. I ...
1
vote
1answer
230 views

Cannot compile Qt 5.6.0 mysql plugin in Ubuntu 16.04 LTS - 64bit

I've recently upgraded both Qt to version 5.6.0 and my Ubuntu workstation to version 16.04 LTS. Now, I know I have to recompile mysql plugin and I've successfully done it several times. However, I had ...
0
votes
0answers
48 views

mysql gem issue on bundle install

I have a rails app. When I do bundle install, I am getting Make sure that gem install mysql2 -v '0.4.4' succeeds before bundling. I am getting below error E: Unable to locate package ...
0
votes
0answers
10 views

Can't run show tabels; with apparmor and mysql

I've moved my mysql directory and added some entries into apparmor to reflect this. I thought is was working fine.. The application (Jira) connects and works perfectly. But I noticed when trying to ...
1
vote
2answers
2k views

Unable to install MariaDB on Ubuntu 16.04 - unmet dependency

Here are the steps sudo apt-get install software-properties-common sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8 $ sudo add-apt-repository 'deb [arch=...
1
vote
1answer
255 views

MySQL installation on Ubuntu 16.4: no root password prompt and no `mysql` folders created

My server hard disk crashed and unfortunately my MySQL backup (which occurs once a day) was missing some important data, but I have the files from the folder /var/lib/mysql. On my new installation on ...
2
votes
0answers
48 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
45 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
283 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
192 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 ...