Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
0answers
2 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 ...
0
votes
1answer
6 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
1answer
14 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
14 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.
0
votes
0answers
29 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
0answers
16 views

How to install mysql server 5.7.5 in ubuntu 15.04 (Vivid) [on hold]

I have mysql server 5.6.28 installed in my Ubuntu 15.04. I am developing a geodjango application with mysql db. The mysql server which i had installed has a default storage engine as InnoDB which ...
0
votes
1answer
29 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
57 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
82 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
20 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
33 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
37 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 ...
1
vote
0answers
14 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
15 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
30 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
44 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
10 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 ...
0
votes
0answers
18 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 ...
0
votes
1answer
32 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
17 views

mysql and phpmyadmin File Permissions at home

1-answer by me below 14.04 - mysql (community vers): What is best practice for dealing with user names and file permissions on a home (dev) Ubuntu Linux box? There are no users named mysql or ...
0
votes
1answer
15 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
33 views

Changing the root user of MySQL

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
20 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
37 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
34 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
87 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
votes
0answers
25 views

After adding php code whole website is blank [closed]

Im begginer so bear with me. I set up my LAMP on ubuntu and started to learn some php. I created a small form to learn how to make CRUD operations with MySql. Whenever I add php code, my whole website ...
1
vote
1answer
50 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
86 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 ...
3
votes
0answers
21 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
40 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 ...
0
votes
1answer
112 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
21 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
9 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 ...
0
votes
2answers
585 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 ...
1
vote
1answer
118 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
36 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
27 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 ...
0
votes
2answers
41 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
155 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 ...
0
votes
0answers
116 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 ...
1
vote
1answer
30 views

Possible MySQL error occurred during system upgrade

Run on terminal the command sudo apt-get upgrade. After a few seconds appears this: Errors occurred while processing: /var/cache/apt/archives/mysql-server-5.5_5.5.49-0+deb8u1_amd64.deb E: Sub-process ...
0
votes
1answer
27 views

Connection mySQL to ws02

Folks, Im facing a problem with connecting/creating mysql database/tables to ws02 instead of h2 ws02@ws02:/usr/bin/wso2/wso2emm-2.0.1/bin$ sudo -E ./wso2server.sh -Dsetup [sudo] wachtwoord voor ...
-1
votes
0answers
39 views

Ubuntu Dedicated Server can't install anithing (apt-get) because various errors

Hello guys yesterday I unistalled mysql server because I bought a dedicated server and it was already installed but host from I bought it didn't gave password for root access. so I decided to delete ...
1
vote
1answer
10 views

Problem exporting my database sql through the terminal

I have this issue when I try to export my database with the CLI instruction mysqldump -u [root] -p [guru99] > [guru99].sql root@YuveSys:/home/yuve# mysqldump -u [root] -p [guru99] > ...
1
vote
2answers
504 views

(K)Ubuntu 16.04 can't install mysql server unmet dependencies

When I try to sudo apt-get install mysql-server I keep getting following error: The following packages have unmet dependencies: mysql-server : Depends: mysql-community-server (= ...
0
votes
1answer
48 views

Mariadb non-root user

I have installed mariadb and when as a Linux root user, I can run mysql command to access the database. But when I try to login as a normal Linux user and run mysql -u root -p, I am getting error: ...
1
vote
2answers
105 views

Ubuntu 16.04 auth_pam broken

I'm trying to set up a mail server on a fresh Ubuntu 16.04 machine but I can't get it to work properly. I'm using a Postfix/Courier setup with MySQL for authentication. Receiving emails and reading ...
0
votes
1answer
149 views

Does laravel 5.0 work in Ubuntu 16.04? [duplicate]

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 ...
1
vote
1answer
95 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 ...