Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

1
vote
1answer
12 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
13 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
4answers
3k views

Having trouble in installing and removing mysql in ubuntu

I have trouble in installing or removing the partly installed mysql-server-5.6 in ubuntu15.04. The error I am getting was sudo apt-get -f install Reading package lists... Done Building dependency ...
4
votes
6answers
1k 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
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
30 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/...
84
votes
14answers
26k 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 ...
19
votes
7answers
45k views

Where is my phpMyAdmin installation?

I just finished installing mysql-server, and then installed phpmyadmin which came with Apache and PHP. It set it up alright and made a phpMyAdmin database, but I can't seem to find the URL to get to ...
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
15 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
1answer
7k views

Xampp : http://localhost/xampp/splash.php :english : nothing happens

After I start Xampp on my Ubuntu 12.04 I go to the localhost and I come to the site, where all languages are listed .... when I click any of these languages nothing happens. Follow steps are already ...
2
votes
3answers
28k views

how install mysql 5.6 and mysql workbench 6.0.9 on ubuntu 13.10

I am using Ubuntu 13.10 Saucy Salamander (64 bit System) . I want to install mysql 5.6 and workbench 6.0.9 on it. how i do it please describe step by step?
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
2answers
1k views

How can I get mysqldump to use the credentials from mysql_config_editor in a crontab-executed script?

I am setting up a daily backup of a MySQL 5.6.14 database using mysqldump on an Ubuntu 12.04 Precise server. I created the credentials file in the root home directory (.mylogin.cnf) according to the ...
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 ...
1
vote
0answers
128 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 ...
22
votes
3answers
21k views

How do I install MySQL without a password prompt?

I'm trying to install MySQL on Ubuntu Natty without the password prompt. However, I keep getting prompted for a password at some stage after the main installation. Also, when I do enter what I ...
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 "...
3
votes
3answers
3k 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
4answers
7k views

MySQL not starting in Xampp

I am using Ubuntu 14.04 and Xampp 5.6.3-0. I cannot get the MySQL server to run. I have tried executing these commands so far (run in this order): sudo chmod 755 /opt/lampp/etc/my.cnf sudo chmod -R ...
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 ...
0
votes
1answer
5k views

How to start mysqld through mysqld_safe

Specifications: MySQL Server version: 5.5.43-0ubuntu0.14.04.1 (Ubuntu) Ubuntu-Server 14.04 LTS Default MySQL-Config-File Question: Even after spending a long time I can not figure out why I can ...
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
2answers
4k views

Mysql 5.5 reinstallation 12.04

I had a broken installation of mariadb over mysql 5.5. For hours i have tried to reinstall mysql with the usage of apt-get - tried to purge, remove etc everything mysql related. Uninstalled php aswell....
-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 ...
3
votes
2answers
17k views

Changes for upload_max_filesize, memory_limit & post_max_size in the php.ini aren't affect

I'm trying to increase the upload_max_filesize etc in order to import bigger files with PHPMyadmin. I have changed the php.ini and restart Apache. I can see the changes on the PHPMyadmin import ...
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 ...
7
votes
7answers
88k views

mysql server start failed

I am running ubuntu server. When I tried to login to mysql(which was running),I got the following error ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/...
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 ...
-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
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. ...
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
118 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
2answers
4k views

Can't connect to local MySQL server through socket '/tmp/mysql_2.sock' during manual installation of mysql

I get the error below when attempting to manually install mysql-5.6.17-linux-glibc2.5-x86_64 Steps I followed: 1. tar -xzvf mysql-standard-5.1.34-linux-i686-glibc23.tar.gz 2. ln -s mysql-...
8
votes
9answers
6k views

mysql-workbench only shows splash screen when being launched

I've downloaded mysql-workbench 5.2.35 and installed it, but when i run it, it shows only the splash screen, nothing more.
0
votes
0answers
161 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
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 ...