Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
0answers
17 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 ...
1
vote
2answers
8k views

phpMyAdmin - Display all queries

I have installed a fresh desktop with ubuntu quantal and the following packages versions: MySQL: 5.5.28-0ubuntu0.12.10.1 Apache: 2.2.22 (Ubuntu) phpMyAdmin: 3.4.11.1deb1 I would like ...
0
votes
1answer
24 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 ...
0
votes
4answers
2k views

Working SQL client

I managed to get working Apache and everything's fine. Got MySQL running, which is nice. But then it turned out that I had to use terminal for all the SQL commands I had to put inside. I'm not close ...
0
votes
0answers
13 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
2answers
193 views

PHP installation appears to be missing the MySQL extension

After upgrading my ubuntu from 15.10 to 16.04 LTS, it is showing an error Your PHP installation appears to be missing the MySQL extension when taking any local website from my lamp. When I tried to ...
1
vote
5answers
3k views

How do I setup php+My sql development environment

How do I setup php + My sql development environment in Ubuntu ?
1
vote
0answers
41 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
64 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
1answer
25 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
0answers
18 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
32 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
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: ...
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
29 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 ...
0
votes
0answers
17 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 ...
1
vote
1answer
42 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 ...
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 ...
0
votes
1answer
4k 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
9 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 ...
1
vote
1answer
929 views

SonarQube installation

I have followed all the steps listed here: http://mamikon.net/blog/installing-sonarqube-ubuntu/ However, in my /opt/sonar/conf/sonar.properties , these 2 lines are missing: ...
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 ...
24
votes
5answers
7k views

16.04 upgrade broke mysql-server

My overall upgrade went well, but I am left with a critically lingering issue of mysql-server not being able to install itself, and nothing I am trying gets it to work. This is the error I see when ...
0
votes
1answer
31 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
97 views

MySQL Database in XAMMP is stoped

I'm running Xampp on Linux(Ubuntu 14.04) and while everything was working fine until an hour back right after I shut it down it suddenly starts throwing this error. the erreur : MySQL said: ...
1
vote
3answers
7k views

Problems installing mysql on Ubuntu 14.04

I hit the following error shortly on entering the mysql "root" password: An error occurred while setting the password for the MySQL administrative user. This may have happened because the account ...
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.
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 ...
-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...
0
votes
2answers
4k views

Errors installing php5-mysql extension

Getting error when installing php5-mysql. Looks like a dpkg error. Perhaps a broken package. Have tried to fix the broken package. Have reinstalled the lamp server and everything seems fine except ...
0
votes
1answer
34 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
4answers
6k 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 ...
4
votes
5answers
34k views

MySQL Access denied for user 'root'@'localhost'

In my server, everytime I try to access MySQL I get the error: Access denied for user 'root'@'localhost' (using password: NO) when I try mysqladmin -u root -p password I get Access ...
2
votes
2answers
78 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 ...
0
votes
0answers
31 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 ...
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 ...
1
vote
2answers
81 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 ...
-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
45 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
100 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
22 views

I just installed xampp on ubuntu 14.04, mysql is not starting in control panel

I just installed xampp on ubuntu. When I am starting xampp using sudo /opt/lampp/xampp start, I am getting: XAMPP: Starting Apache...already running. XAMPP: Starting MySQL...ok. XAMPP: Starting ...
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
38 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
102 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 ...
2
votes
3answers
18k views

How to stop mysqld process?

result of ps -e | grep mysqld running htop and clicking on memory usage.. It is taking 33% of 4gb memory. I just want to end the mysqld process.. running sudo pkill mysqld ends the process but ...
0
votes
0answers
20 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
1answer
30 views

install by bash

I install mysql-server by bash. But i can't make it auto enter password for root (this image below). And here's my code. #!/bin/bash cd /home/userver2 sudo apt-get -y install mysql-server ...
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 ...
27
votes
3answers
246k views

ERROR 1045(28000) : Access denied for user 'root@localhost' (using password: no )

I'm trying to install queXS cati app on my Ubuntu desktop and I installed MySQL server and PHP 5 and I cannot login into MySQL server as root without password: mysql -u root it says ERROR ...
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 ...