Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
0answers
9 views

Can't find job mysql on crouton precise

I'm using Ubuntu precise as chroot in my chromebook machine. I'm trying to install mysql through apt-get install mysql-server. The thing is, when I try to start it, it can't find the job: ...
0
votes
0answers
23 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
32 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
46 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
1answer
21 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
14 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 ...
1
vote
2answers
21 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
0answers
14 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
46 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
43 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
54 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
0answers
13 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
68 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 ...
1
vote
1answer
59 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
26 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 ...
0
votes
1answer
46 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
38 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 ...
0
votes
0answers
28 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
1answer
47 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 ...
0
votes
1answer
33 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 │ │ ...
1
vote
0answers
17 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 ...
0
votes
0answers
82 views

MySQL wont start on boot after upgrading to 15.04

I recently rebuilt my server and decided to upgrade from 14.04 LTS to 15.04. I can't seem to figure out why MySQl won't start on boot. I have ran the following command. sudo update-rc.d mysql ...
0
votes
0answers
18 views

problem with mysql

I was trying to install wordpress locally. I didn't know how to do it so I tried a lot of tutorials and softwares like xampp and end with lot of problems that I can't figure. in one of this tutorials ...
-1
votes
0answers
13 views

mysqldump problems

I am trying to get mysqldump to work properly. I've created a root user/password combo in ~/.my.cnf, and I enter mysqldump --databases [database] > [dump file path] It produces an empty, but ...
0
votes
1answer
47 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 ...
1
vote
1answer
31 views

Mysql Table in use

I have downloaded mysql directory: /var/lib/mysql to my computer to test out. And this is what i see near the table wp_posts: I have tried to select the table above and repair it but It didn't ...
1
vote
1answer
30 views

How to reinstall mysql-community-server on Ubuntu?

I am trying to install mysql server on Ubuntu. I am getting this error message which says: root@ujenlinux:~# apt-get -f install -o Dpkg::Options::="--force-overwrite" Reading package lists... Done ...
0
votes
0answers
19 views

MySQL default passowrd

I originally posted this question on Stackoverflow, but it was downvoted their. In one of the comments it was mentioned that AskUbuntu is the appropriate place to ask this question, so posting it here ...
1
vote
0answers
43 views

MySQL Connection Issue [closed]

When I deploy my war file on EC2 AWS Server, then I get MySQL connection error, such as not open connection and connection timeout. But when I run my application on my system, that is working fine, ...
0
votes
1answer
23 views

Why do I keep getting mysql error 1042?

I'm creating an ASP.NET web api on a linux VPS, using Apache and mod_mono. I have everything set up and have successfully demonstrated that the web api routes are working. My newest local changes ...
0
votes
1answer
20 views

Fresh Virtualmin install - MySQL root password?

I've searched and searched as this seems like such a newbie problem but after many hours still haven't found the answer. I followed this guide. I did a fresh install of Virtualmin GPL on a fresh ...
0
votes
2answers
58 views

trying to install mysql-connector for python 3

my experience is minimal with Linux so i need a little help! i am trying to install the python mysql-connector for python3.2, i was able to use pip to install it for python2.7 with 'pip install ...
0
votes
0answers
29 views

Prevent multiple login in squid authentication

I am using a php script that read a sql database to authenticate squid3 proxy users on a ubuntu server 14.04. However it allows multiple simultaneous logins with the same username and password from ...
0
votes
1answer
25 views

How to connect .sql file to MySQL Server to work with application server

I have an information system programmed using XAMPP. It has a .sql file, in which I'm sure it is a database file. I used Ubuntu Server and installed LAMP on it. I put the info. system in the server ...
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
1answer
41 views

Copy file from one ubuntu to another ubuntu

By using cron job I've successfully created a backup of mysql database on the Ubuntu. Below is the command under mysqldump.sh /opt/lampp/bin/./mysqldump -u root database-name | gzip ...
0
votes
2answers
24 views

apache2,php and mysql - facing problem in editing the files and loading them in browser

friends, I have installed apache2 , php and mysql but now the problem is I don't know where to write the programs and put them back into the server folder so that I can access them back.My file i.e ...
1
vote
0answers
44 views

Have localhost with dual boot (Windows/Ubuntu) share htdocs & mysql databases with XAMPP

I just got a new machine with dual boot Ubuntu+Windows 8.1 and set up a localhost using XAMPP in a way that allows me to edit and preview the files on both OSes (so htdocs and mysql databases have to ...
0
votes
0answers
27 views

HostGator to Amazon PHP send mail not working

After I transferred hosts from hostgator to aws ubuntu, all my send mail does not work. for example when someone register's, it is supposed to send an automated email to that user. I am using X-Mailer ...
0
votes
1answer
47 views

mysql-server hangs on setting password

Every time I try install mysql-server it hangs on this screen This is the case of not entering a password, but when I do enter a password it hangs on this screen after pressing OK I've been ...
0
votes
0answers
24 views

Ubuntu 14.04 problems with mysql

My problem is when I try to install mysql-server, I get some errors during the installation. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) ...
0
votes
0answers
47 views

Installing Bacula while running MySQL 5.6

I am attempting to install Bacula (5.2.6+dfsg-9.1ubuntu3) on our server running Ubuntu 14.04 LTS. However, I am having troubles very early in the installation process. Running the command apt-get ...
0
votes
3answers
359 views

MySql did not install properly and now I can not use the software center or remove MySql

When I open the software center I got an error saying "New software cannot be installed, because there is a problem with the software currently installed. Do you want to repair this problem now?" ...
2
votes
1answer
106 views

mysql-client-5.5 update error

I just run apt-get upgrade and many packets should be updated. I allowed them all (question after Disk Space and verification). After the download and my configured packages Ubuntu told me from an ...
0
votes
4answers
74 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 ...
0
votes
2answers
52 views

How to insert data from text to mysql? [closed]

I get this text from router via ssh. But I want to insert user(fr-XXX) and macadress(F0:24:75:33:22:11) to mysql routerusers table. Flags: M - mac-cookie # USER DOMAIN ...
0
votes
0answers
22 views

remove mysql with its unmet dependencies from ubuntu

I tried to install mysql into ubuntu The installation file was .deb It was not properly installed. Now i want to remove it. I used following command to remove it sudo apt-get remove --purge ...
0
votes
1answer
23 views

How can I stop another working webserver?

I get this error when I try to start Apache web server. I've been working on it for about a month and suddenly this error appeared today: error:: xampp: another webserver is already running. any ...