Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
0answers
9 views

How do you fix “unmet dependencies … but [something] is to be installed” error?

I am trying to install and configure an Ubuntu, Django, and MariaDB stack. I have the latest (as of writing) MariaDB 10.0 installed, and as per the Django documentation regarding databases, I am ...
-1
votes
0answers
28 views

creating new column based on existing column

ALTER table results ADD result varchar(5); UPDATE results SET result=IF(credits=0,fail,pass); new column 'result' should display pass or fail.if credits are 0 it should display fail and for other ...
0
votes
1answer
40 views

apt-get -f install suggests removing python2.7 and installing python3

Since I have some dependencies problems (I am trying to install mysql-workbench in a Ubuntu 12.04), I tried to run sudo apt-get -f install. However, the output looks very scary, since it suggests ...
0
votes
3answers
4k views

Import error :No module named MYSQLdb

I have a problem so a connection a python to database local of MySQLdb. Message of error is: import MYSQL ImportError:No module named MYSQLdb. This is a script in python 3.4 to connection my ...
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 ...
1
vote
2answers
4k views

How to get mysql-server setup on Ubuntu 15.04?

When I was upgrading from 14.10 to 15.04 my mysql somehow broke. When I run sudo dpkg --configure -a After a long wait I get the following response Setting up mysql-server-5.6 (5.6.24-0ubuntu2) ...
0
votes
1answer
48 views

Does someone knows how to fix this installation bug in ubuntu?mysql-server-5.6 E: Sub-process /usr/bin/dpkg returned an error code (1)

I'm trying to remove mysql-workbench. But everytime when I try to remove something related with mysql, I get this error. Reading package lists... Done Building dependency tree Reading state ...
0
votes
2answers
78 views

How to install bind9 with DLZ unbuntu server 14.04

i am trying to install bind 9 with dlz as the native bind does not have such capabilities. Found a source of compilation on Ubuntu 11.10 but it doesn't seem to work. can't find a decent tutorial or ...
1
vote
1answer
12k views

How to deal with MySql ERROR 1133 (42000): Can't find any matching row in the user table?

I am constantly get the following error message: 1045 Cannot log in to the MySQL server I have tried the following: sudo service mysql stop (Went fine) sudo /usr/sbin/mysqld ...
0
votes
1answer
20 views

How to view the data from a .mysql file?

I have a .mysql database file. I need to open it and view the data. I've MySQL Server & MySQL Workbench installed into my Ubuntu 14.04. Now how do I open the .mysql file and view the data inside ...
0
votes
1answer
14 views

Change location of mysql database

I am trying to move the location of a mysql database. I tried to follow the instructions here and elsewhere, which say to change the "datadir" directory in "/etc/mysql/my.cnf". My problem is that ...
1
vote
0answers
11 views

ProFTPD - set a group manager to access all users files in the group tree

I am currently developing a client application with pyqt and ftplib to help backup/restore file to/from a ProFTPD server. The company is divided into many agencies and every agency is a ftp group with ...
0
votes
4answers
69 views

How to setup an environment for running php scripts in Ubuntu?

In Windows,i used WAMP and adobe dreamweaver. In Ubuntu,i am planning to use bluefish editor. I hear that WAMP server equivalent is LAMP in ubuntu. I need detailed and simple explaination to ...
1
vote
2answers
19 views

Get mysql to start automatically on startup

I realize that there are many questions around here to answer that problem - but none seems to work for me so far. I attempted: sudo update-rc.d mysql defaults This resulted in a locale error, ...
0
votes
1answer
469 views

Unable to connect - Apache2 in Ubuntu 12.04 VirtualHost

I have followed the tutorial from here https://www.digitalocean.com/community/articles/how-to-set-up-apache-virtual-hosts-on-ubuntu-12-04-lts to set a local website. I just changed the port 80 to ...
0
votes
3answers
138 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 ...
0
votes
1answer
38 views

how to access mysql in console

I installed mysql alone with xampp and runing all services successfully, but when i try to login to mysql server using mysql-client it gives the following error. user@user-pc:~$ sudo /opt/lampp/lampp ...
0
votes
0answers
16 views

Place of incoming and outgoing mails Postfix, Dovecot and MYSQL? [closed]

I use ubuntu server. Does someone know, where is the place of emails in Postfix mail server (with Dovecot and MySQL)? For example: in folders such as /home/../user/maildir/... or in MySql DB?
0
votes
1answer
4k views

Turn off MySQL --skip-grant -tables

I reset my root mysql password with the following instructions: (Works for Ubuntu as well) http://www.debian-administration.org/articles/442 But now I can't turn off mysqld_safe --skip-grant-tables. ...
0
votes
1answer
42 views

Check which services are running on the server (python script) and restart them if they have stopped?

I am trying to write a python script which shows me the services which are running on my server. The thing is that mongodb keeps going down on the server and each time it happens I have to manually ...
0
votes
0answers
12 views

phpmyadmin and red5-server

I'm a new ubuntu user. I installed ubuntu 14.04 server, then I installed LAMP package, then I installed java 7. I installed red5-server and phpmyadmin at the end. Now either red5-server is working nor ...
0
votes
1answer
4k views

“'Access denied for user 'root'@'localhost'” when trying to do commands

The other day I was using MySQL on my local database fine from the terminal. However, when I rebooted the next day and tried to use it, I get the following error for just about EVERYTHING related to ...
0
votes
1answer
39 views

How do I install oursql using pip?

I have been attempting to install oursql using pip (7.1.0, I installed it using sudo easy_install pip as for my purposes the version provided by python-pip is too old) via running: sudo pip install ...
0
votes
0answers
38 views

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection XAMPP

Hi i am intend to connect phpMyAdmin, i have install XAMPP but i change the port using this guide Cannot start XAMPP on Ubuntu 11.10 I use this URL to enter phpMyAdmin ...
1
vote
0answers
47 views

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' in Ubuntu 12.04.5 LTS

I encountered with the error Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' in Ubuntu 12.04.5 LTS. So,I uninstalled mysql 5.5 from Ubuntu 12.04.5 LTS.But when i tried ...
0
votes
1answer
2k views

Mysql 5.5 server not working

I had Ubuntu 14.04 installed on my system. I recently updated ubuntu and now my mysql does not start and workbench says that mysql server has been stopped. And when i try to start it gives me the ...
0
votes
2answers
3k 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 ...
34
votes
5answers
58k views

Moving MySQL datadir

I am trying to move the data directory of my MySQL database to a second disk array that I have as a mount point /array2/. The problem I am having is I have tried everything and after I modify the ...
0
votes
0answers
10 views

MythTV frontend not starting

I'm in the process of setting up (the first) remote frontend for a new MythTV installation on Ubuntu 15.04. The backend is up and running, channel scans were successful, etc. However, when I try to ...
0
votes
1answer
59 views

MySQL Installation Issues on Ubuntu 15.04

Firstly, I'm running Ubuntu 15.04 (Velvet) on my local machine. I recently uninstalled the LAMP stack due to several config issues I was experiencing (especially when I tried working with ...
2
votes
1answer
7k views

how to run php web application in lamp server and mysql connection also

i need your help. 1.i wanted to install php , mysql and server appache like.. 2.how to run php web application in server? 3.how to connect php web application into mysql.
1
vote
1answer
48 views

Dependency is not satisfiable: libglibmm-2.4-1c2a (>= 2.42.0)

Updated my mysql to 5.6 and as a consequence broke my preexisting mysql workbench. Trying to reinstall the newest mysql workbench, from both the Software Manager and the latest .deb from their ...
0
votes
1answer
24 views

Error installing mysql?

I'm trying to install mysql-server php5-mysql phpmyadmin but I'm running into the following error: An error occurred while installing the database: mysql said: ERROR 1006 (HY000) at line 1: Can't ...
4
votes
4answers
15k 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 ...
1
vote
2answers
7k 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
41 views

dependency problem mysql-server

I upgrade my server time to time with apt-get update then apt-get upgrade and dont use anything else. but these days I have a problem with mysql-server. apt-get cannot upgrade anything else, it break ...
0
votes
0answers
31 views

I can't connect with remote MySQL server via VPN

Help me pls. I am not an expert in networks. I need make a task, and download data from remote MySQL. Company gave me VPN coordinates of their server: PPTP, IP, username, password. Also they gave me ...
1
vote
1answer
43 views

Unable to install anything on Ubuntu Server

whatever7788@ubuntuServer:~$ sudo apt-get install pptpd Reading package lists... Done Building dependency tree Reading state information... Done pptpd is already the newest version. 0 to upgrade, 0 to ...
4
votes
1answer
4k views

Unable to re install mysql on Ubuntu 14.04: Dependency problems

Ubuntu Unity 14.04 LTS with all lenses removed, except files. (Hate the dash.) I have a LAMP system for web site development. I want to put all my data files in a particular partition that I can ...
0
votes
0answers
26 views

problem accessing phpmyadmin Ubuntu 14.04 LTS

I've recently fix the problem from apache2 services issue now phpmyadmin is configured, but I can't get access to login panel it shown this phpMyAdmin - Error Cannot start session without ...
1
vote
2answers
492 views

Installing MySQL Workbench ⇒ Error

I have installed MySQL Workbench in the past using MySQL APT. My software repositories lists have recently been updated and since then my MySQL Workbench disappeared. It is still on the disk but it ...
0
votes
1answer
29 views

Unable to set password for the MySQL “root” user, start: Job failed to start

┌───────────────────────Configuring mysql-server-5.5─────────────────────────┐ │ Unable to set password for the MySQL "root" user │ │ ...
12
votes
4answers
4k views

OpenSource Document Management

I'm looking for Web-based, Opensource, PHP-MySQL Document Managment for my organization with these features: Features : Full text searching Document Metadata User access previledges Document ...
6
votes
4answers
55k views

How to run mysql command from terminal?

I have the following sql command which I usually run in phpmyadmin by selecting the database, then running it in the command window. DELETE FROM `wp_posts` WHERE `post_type` = "attachment" However ...
1
vote
0answers
14 views

Problem with libmyodbc - segfault error

I have an issue with libmyodbc as I am not able to connect to the MySQL database that it is pointing to. When I try from isql I get a "Floating point exception (core dumped)" error, and when I try ...
0
votes
0answers
8 views

Upgrading to 15.04 stalls when trying to install MySQL 5.6

I've just tried to upgrade my ubuntu OS (desktop) and it's just stopped when installing MySQL. It said that i had to update the password (did this twice in the install) but the second time it said ...
9
votes
7answers
32k views

Unable to set password for the mysql “root” user

I am new to Ubuntu. I am running Ubuntu 12.10. I am trying to install apache,php,mysql. However I have installed apache and it is running perfectly. sudo apt-get install apache2 But when I tried to ...
6
votes
7answers
21k views

dpkg: invoke-rc.d: initscript mysql, action “start” failed

I have read a number of the posts here and they all state to run the following commands: Apt-get -f remove ** apt-get update apt-get upgrade apt-get -f install ** I have seen these in various ...
4
votes
4answers
10k views

'Unable to set password for the MySQL “root” user' on a Openvz VPS

I'm trying to install mysql server on my Openvz based VPS running Ubuntu 13.04 64bit and i keep getting this error at the install. I tried multiple times and i also re installed the os with no change ...
0
votes
1answer
46 views

Step By Step : Making a server accessible worldwide

I am new to Ubuntu Server, and in general with servers, so consider me as a beginner... (But, I know how to use the terminal.) Note: I use a router, not a modem nor a broadband connection. The ...