Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
1answer
10 views

mysql startup error '--safe-show-database' 160628 11:50:37 [ERROR]

On checking error log of /var/log/mysql/error.log, I see this: 160628 11:50:37 [ERROR] /usr/sbin/mysqld: unknown option '--safe-show-database' 160628 11:50:37 [ERROR] Aborting
0
votes
0answers
6 views

webmin: How to check mysql log?

My website is hosting with linode Ubuntu 14.04. I just found out my database server was shutdown and I had to manually start it. How can I check the mysql log so that I can get some hints about why my ...
0
votes
0answers
29 views

i am making a web app and i got this error with mysql

* Running on http://127.0.0.1:5000/ (Press CTRL+C to quit) [2016-06-27 01:37:28,036] ERROR in app: Exception on / [GET] Traceback (most recent call last): File "/home/ubuntu/.local/lib/python2.7/...
2
votes
0answers
32 views

Ubuntu update stops while configuring mysql-server-5.7

When I update my Ubuntu sofwares and applications using Software Updater in Ubuntu 16.04 LTS, the update stops while Configuring mysql-server-5.7(when the downloaded updates are being installed). And ...
0
votes
0answers
14 views

latest xampp on ubuntu utf8 encoding issue

I have installed latest version of xampp on my ubuntu server but I have issue I use mydac to establish connection to mysql server and every thing is fine . But when I try to insert a non latin ...
0
votes
2answers
16 views

Backup and restore single file?

I am planning to change my /etc/mysql/my.cnf file in Nano. I have 2 questions about this: Before I do this, is there a way to make a backup of this file? If something goes wrong, how can I restore ...
0
votes
0answers
9 views

bWAPP installation ERROR

I am trying to install bWAPP on my ubuntu gnome 16.04 computer. With this tutorial. When I try out number 6 I get an error 500. My guess is that I didn't set up php correctly. But it could be ...
1
vote
0answers
23 views

'mysqld' using a lot of ram in Ubuntu 16.04, is it normal?

I am working on my Django project and recently installed mysql-server on my ubuntu 16.04. It is using a lot of ram approx 800 MB to 1GB, is it normal? Picture attached :
0
votes
1answer
27 views

How to stop XAMPP/MySQL from defaulting to IPv6?

I installed XAMPP for Linux on a fresh Ubuntu 14.04. I started all servers and ran netstat -tupln. The mysql server is running on IPv6: tcp6 0 0 :::3306 :::* LISTEN 2818/mysqld I ...
0
votes
1answer
49 views

Cannot set a different database directory for mysql ( Errcode: 13 - Permission denied) [duplicate]

I am attempting to relocate the database directory for my mysql installation to a newly install ssd. Configuration: Ubuntu 16.04 mysql Ver 14.14 Distrib 5.7.12, for Linux (x86_64) using EditLine ...
0
votes
1answer
22 views

MySQL backup - incremental and differential [duplicate]

How can I backup MySQL database incrementally and differentially ? Does anyone have a script or recommended application for this purpose? Thanks.
3
votes
0answers
34 views

upgrade process stuck for too long while Preparing to unpack …/mysql-server-5.7_5.7.12-0ubuntu1.1_amd64.deb

I tried to do upgrade and its been unpacking for too long (20 minutes) is it normal?, not responding to ctrl+C too.What to do next? shubhendu@shubhendu-HP-Pavilion-g6-Notebook-PC:/opt$ sudo apt-get ...
1
vote
1answer
43 views

MySQL how to log into “root” from a user account after upgade to 5.7

Running Ubuntu Server 14.04, installed MySQL 5.7 using the MySQL APT Repository. I cannot access MySQL using the "root" user from a user account ($) but I can with sudo or sudo su - (#). The MySQL "...
1
vote
1answer
41 views

MySQL partition /var/lib/mysql is full BUT it is not full

i have the same issue as this old thread "MySQL error: The partition with /var/lib/mysql is too full!" but the answer offered is not working for me (which is to do a sudo mysql stop & a sudo mysql ...
-2
votes
0answers
19 views

Error in installing mysql server

hp@hp-HP-15-Notebook-PC:~$ sudo apt-get install mysql-server Reading package lists... Done Building dependency tree Reading state information... Done Some packages could not be installed. This ...
0
votes
0answers
18 views

Error in downloading mysql server

I am downloading mysql on ubauntu software center I am getting error as follows: The following packages have unmet dependencies: mysql-workbench: Depends: libgcc1 (>= 1:4.1.1) but 1:4.9.1-...
0
votes
0answers
16 views

Starting MySQL fails after upgrading to MySQL 5.6 [duplicate]

While setting up a test server for the development of a Magento plugin, I ran into the requirement of MySQL 5.6. I was already using MySQL 5.5 so running apt-get install mysql-server-5.6 should have ...
0
votes
0answers
43 views

dpkg: error processing package mysql-server (--configure)

I am getting the following error when I remove, autoremove, install, upgrade etc.. via terminal and also software updater. The sudo apt-get autoremove result is given below. The error says dpkg error ...
-3
votes
0answers
10 views

Amazon Linux AMI server (Centos), PHP 5.3.29 does not have mysql functions included [closed]

We have a legacy server, it's internal, and there is no way I'm going to be able to update PHP, so that's not an option. Currently it runs 5.3.3. The command cat /etc/issue returns Amazon Linux ...
1
vote
0answers
15 views

Does ubuntu's installation of mysql-server-5.7 now require apparmor?

Ubuntu 16.04: When I use apt to install mysql, it shows: The following additional packages will be installed: apparmor mysql-server-5.7 Suggested packages: apparmor-profiles apparmor-profiles-...
1
vote
1answer
16 views

Drop (copy) Previous mySql Tables Dir into upgrade MariaDB Directory

I've finally moved over to MariaDB from mySql 5.6 on my Ubuntu 16.04 (upgrade from 15.10). I have about a dozen previous web data tables sets (Drupal v7.4x) which are current and still in use on my ...
0
votes
0answers
24 views

Failure to access mysql db using the Hostname of the Remote Database server

Hostname of the Remote Db server is db-20.srv.saj.co.ug and IP 192.168.2.1. Hostname of Accessing Server is Mail-20.srv.saj.co.ug and IP 192.168.2.3 Ping from Mail-20.srv.saj.co.ug to the Remote is ...
0
votes
0answers
18 views

Mysql Workbench on 14.04 with mysqlserver 5.6

I'm running ubuntu 14.04 I was running mysql server 5.5 and mysql workbench. and the world was full of joy. but one day i wanted to run mysql server 5.6 to support a new functionality. I went ahead ...
0
votes
0answers
29 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
23 views

Could not find driver error

When I try to run index.php using this command - php -S localhost:8080 I get "could not find driver" error. But php files not using mysql runs correctly. What may be the issue and how do I fix ...
0
votes
0answers
29 views

custom mysql datadir ubuntu in 16.04

All, I noticed that in Ubuntu 16.04 if I have a custom datadir (/etc/mysql/mysql.conf.d/mysqld.cnf) the systemd service won't start because of sanity() check in /usr/share/mysql/mysql-systemd-start. ...
0
votes
1answer
117 views

How to install mysql on Ubuntu 16.04

I am following this digital ocean tutorial for Ubuntu 14.04 to install mysql on Ubuntu 16.04 for my Rails projects. I had, maybe wrongly, assumed that the procedure would be the same. However, when I ...
2
votes
1answer
47 views

Wrongly named variables in mysqld.cnf (Ubuntu 16.04)

Recently installed Ubuntu 16.04 and found that the default configuration file for MySQL has a few wrongly named variables, i.e. system variables whose name has changed over versions. In the file /etc/...
0
votes
0answers
19 views

Can I use one phpMyAdmin per virtualhost?

I worked on ubuntu 16.04 server, I will host multiple domains on my ubuntu server with apache virtualhost, my question is how to make phpmyadmin show only database created on my virtual host ? For ...
1
vote
1answer
50 views

Remotely connect to Amazon AWS Mysql

I have an Amazon AWS EC2 instance running Ubuntu 14.04. where I installed MYSQL 5.5. I am trying to connect to the MYSQL running on this instance from my local Windows10 machine running Navicat. ...
0
votes
1answer
29 views

Some boot-up services

I am trying to increase my boot-up speed on my 16.4 Ubuntu and would like to consult someone if removing some boot-up services is a smart idea, for i am unsure if there are consequences i am not aware ...
1
vote
1answer
31 views

MySQL does not accept password not lets me reset password by skip-grants-table, unable to login

I terminal I have typed: apt install mysql-server mysql-client It asked me for password and I gave it. Next I typed: mysql_secure_installation It prompted me for password. I am cent percent ...
2
votes
1answer
52 views

phpmyadmin: The json extension is missing

What I have done I have set up a LAMP webserver using these commands: sudo apt-get install apache2 sudo apt-get install mysql-server sudo apt-get install php5 libapache2-mod-php5 sudo /etc/init.d/...
0
votes
0answers
48 views

libmysqlclient.so.18 => not found

This is Ubuntu 14.04 I am trying to resolve a small problem with a module not being able to see the 'libmysqlclient.so.18', if we ldd the file we see: linux-gate.so.1 => (0xf7702000) ...
0
votes
0answers
21 views

Why does MySql 6.0 show menu items twice in the menu bar?

I installed mysql 6.0 in ubuntu 14.04. When I open it, it shows me the menu items twice in the menu bar. I attached a photo of it so you can better understand. Please have a look at and help me with ...
0
votes
0answers
31 views

need help debugging server networking

I have a basic headless Ubuntu 14.04 setup with mythtv (with ethernet attached HDHR silicon dust ASTC receiver), mysql, apache, and ssh. Everything was had been running pretty well for a long time, ...
1
vote
0answers
18 views

MySQL works fine with GUI, but won't start without it. Ubuntu-mate

This one is making me nuts. I have a Raspberry PI 2B with a Ubuntu-mate 16.04 installation. I use it to run PLexmediaserver and Owncloud, the last one over Apache, MySQL and PHP 7.0. Ubuntu-mate for ...
0
votes
0answers
18 views

Application Instantiation Error: Could not connect to MySQL

I have been getting this when attempting to access multiple virtual sites that I host: Application Instantiation Error: Could not connect to MySQL. This just recently started and I haven't been able ...
0
votes
0answers
14 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
1answer
26 views

MySQL Won't update

I'm updating my server after a year of being off, and running all the update commands to secure everything. Setting up mysql-server-5.5 (5.5.49-0ubuntu0.14.04.1) ... MySQL stop/waiting (infinite ...
0
votes
1answer
75 views

Uncaught PDOException: could not find driver after upgrading to ubuntu 16.04

After upgrading my php automatically upgraded to php7.but phpinfo(); shows no value on PDO section. and P.S pdo is showing Uncaught PDOException: could not find driver
2
votes
1answer
83 views

Upgrade to 16.04. Broken dependencies and impossibility to resolve them in usual ways [duplicate]

I upgraded the system some days ago and after that I had a problem of broken packages which affects to MySQL and several libraries. After that I can do updates but not install, upgrade, remove or ...
0
votes
0answers
35 views

MySQL doesn't shutdown cleanly sometimes

I have a fresh install of Ubuntu 16.04 LTS Server x64 in a VirtualBox VM with its provided MySQL, without any additional databases currently. Sometimes the shutdown of MySQL itself fails with the logs ...
1
vote
1answer
39 views

In phpmyadmin importing database, shows timeout error in ubuntu-15.10

I am facing a problem to import a database. It shows "Script timout passed.... ". While I have already been enlarge all digits like max_size max_filesize max_time mem_limit in php.ini. But the ...
0
votes
1answer
29 views

How to configuration Msql 5.7 to provide another access to the database

I install mysql 5.7 on ubuntu 16.04 . I grant user complete. But client not connect database on server. How to configuration Msql 5.7 to client connect and access to the database on mysql-server.
0
votes
1answer
33 views

Install xbacklight on Ubuntu 15.04 [closed]

I am trying to install xbacklight using sudo apt-get install -y xbacklight but getting error related to mysql.After running above command a new window pop up to set password for mysql.But after ...
0
votes
0answers
12 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
35 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
61 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 ...