Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
0answers
64 views

Phpmyadmin : Cannot connect: invalid settings

When I'm going on my phpmyadmin in localhost it returns me this error : Cannot connect: invalid settings. Connection for controluser as defined in your configuration failed. phpMyAdmin ...
0
votes
1answer
53 views

Phpmyadmin Access denied

When I go on localhost/phpmyadmin it returns me this : Cannot connect: invalid settings. phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should ...
0
votes
1answer
70 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
24 views

how to completely remove phpmyadmin and reinstall [duplicate]

I have a few problems with phpmyadmin on my Ubuntu, so I would like to uninstall it completely (with all configurations and that stuff) to restart a new full installation from scratch. I tried a lot ...
0
votes
0answers
41 views

Error in installing Mysql-server in ubuntu16.04

Here is the error i am getting Setting up mysql-server-5.7 (5.7.12-0ubuntu1.1) ... Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql....
0
votes
0answers
33 views

How to operate with mysql-server on Ubuntu Server

I ran into some issues in mysql-server operating on Ubuntu. So, the issue is strange. I need to perform "mysqld" by another user (i guess that root isn't appropriate to this target). When I installed ...
2
votes
2answers
45 views

Mysql service not starting Ubuntu 16.04

Every time I try to start mysql with sudo service mysql restart it returns Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "...
0
votes
1answer
21 views

mysql-server installation gives this error: useradd: existing lock file /etc/passwd.lock without a PID

After 3 to 4 hours of hard struggle I resolved this issue, but I am still curious about this /etc/passwd.lock What is /etc/password.lock? What /etc/passwd.lock does? And what I understood ...
1
vote
0answers
16 views

How to restore mysql databases after upgrading to mariadb

While installing mariadb-server, it moved all of my existing databases to /var/lib/mysql-5.7 and created a new /var/lib/mysql folder. How do I restore these databases from the backup folder?
0
votes
1answer
41 views

Run 'sudo mysql start' at boot time

I am using Ubuntu 16.04 LTS and mysql 5.6 in it. Each time after the server reboot, MySQL service is not starting automatically. I determine this by checking the directory: /var/run/mysqld/ and ...
-1
votes
1answer
22 views

Vm Ubuntu + xampp Vs C: windows + xampp

i have been going round in circles for days trying to figure this out.. i have c: windows and xampp working fine for years i have needed to install ubuntu so i put it on a virtual machine successfully....
0
votes
0answers
22 views

mysqlcheck error (when repairing databases)

MySQL hangs when i`m repairing databases in CRON with command: mysqlcheck -A --auto-repair -u root -p'[my_long_password]' Syslog shows: Jun 29 15:03:01 karsis CRON[4118]: (root) CMD (mysqlcheck -A ...
1
vote
1answer
702 views

How can I downgrade mysql 5.7 to 5.6 on Ubuntu 16.04?

I'm finding MySQL 5.7 to be a massive memory hog and want to roll back to MySQL 5.6. However everytime I try to uninstall 5.7 and install 5.6 I end up with a MySQL service that won't start. Also I ...
0
votes
1answer
18 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
11 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
37 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
1answer
83 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
24 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
21 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
14 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
67 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
39 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
103 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
27 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
83 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
71 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
53 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 ...
0
votes
0answers
24 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 ...
1
vote
0answers
79 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 ...
1
vote
0answers
29 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
19 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
33 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
31 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
1answer
52 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
33 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
46 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
271 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
65 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
26 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
71 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
39 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
104 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
86 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
25 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
32 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
20 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
20 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 ...
1
vote
2answers
71 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 ...