Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

2
votes
0answers
16 views

MySQL: Can only login from command line or as root

I've been trying to solve this problem for the last 3h. I've just set up a MySQL server on my dedicated root server, running Ubuntu 14.04-minimal. I have no problem logging in as root anywhere - it ...
2
votes
1answer
21 views

How can I dump and restore MySQL databases to and from Dropbox from the command line?

I have a few MySQL databases that I would like to sync between two computers. What I'd like to do is be able to have a quick command or script on one computer that I can use to quickly dump the ...
0
votes
1answer
17 views

Is syncing a MySQL database with Dropbox this easy, and is it a backup solution?

Maybe I'm wrong, but I was sure that some time ago when I was looking for a way to sync my MySQL databases using Dropbox, I was told that this was not possible because of the way MySQL works. But I ...
0
votes
1answer
32 views

Installing FOG on Ubuntu 12.04

I am trying to install FOG on 12.04 Server LTS. I have downloaded the latest version from SF, but when I try to install it, it fails when trying to install MySQL, specifically with: The following ...
0
votes
0answers
15 views

Installing sql*plus on Ubuntu 14.04

I tried installing sql*plus on Ubuntu 14.04 by following 1, 2 and 3. But after downloading Instant Client I still facing following error; sqlplus: command not found I am new to Ubuntu, guide me to ...
0
votes
1answer
16 views

Licensing terms query

This is quite non technical question, but please help me with direction. One of our customer who is enterprise (and quite nontechnical folks), is planning to buy a solution from us. This solution ...
0
votes
1answer
20 views

install phpmyadmin error

I want to install phpmyadmin on Ubuntu 14.04 LTS and type the following commands, but I get the following error message on either one of the following command. Anything I can check the configuration ...
0
votes
1answer
18 views

How to install mysql 5.1. if I already have 5.5. installed?

Currently I have mysql 5.5 installed localy. How can I install and use mysql 5.1 server? I also need to be able to go back to 5.5. at one point.
1
vote
1answer
18 views

ubuntu - upload csv file using mysql [on hold]

I'm trying to upload a csv file to a mysql table and it keep giving me an error. I am in mysql using the database I want to upload the file. I've tried two queries at the command line. LOAD DATA ...
0
votes
0answers
5 views

Bind mounting for Site Storage Ubuntu and Plesk

I have Ubuntu 14.04 server installed and Plesk CP My system drive is too small to be 9f much use other than running the OS and software. So what I was thinking is I have another huge drive that id ...
0
votes
0answers
7 views

Temporarily unable to connect to database

I've got a fully patched Ubuntu 12.04 Server VM that I'm using to host a few low traffic sites. My site is PHP (WordPress) and uses mysqli to connect to a MySql database - pretty standard stuff :) ...
0
votes
0answers
24 views

Unable to configure the phpMyAdmin

I installed phpMyAdmin. It's working when I opened the link http://localhost/phpmyadmin There are no databases in the list of databases in the left pane of phpMyAdmin. When I checked below it says ...
0
votes
0answers
34 views

MySQL Workbench 6.17 error Ubuntu 12.04 x64

Im trying to run MySQL Workbench Migration to transfer a table from MS SQL to MySQL. Using the latest version of workbench (or in fact any of the latest ones), the migration fails instantly and gives ...
1
vote
2answers
26 views

Symlink are using both locations?

I've researched and didn't find any answers, so I decided to ask here. The /dev/sda2 disk of my WHM/Cpanel webserver got 100% full. The /var folder is on the /dev/sda2 disk and I've found that the ...
0
votes
1answer
7 views

Why is ubuntu server dovecot 2 coming up with Unknown setting: driver

So like I said in the quest dovecot 2 keeps coming up with "Unknown setting: driver". I've been following a guide and setup my auth-sql.conf.ext file however when I try and start up dovecot 2 I get ...
0
votes
0answers
16 views

phpmyadmin not longer working after updating ubuntu LTS12.04 to ubuntu LTS14.04

After I upgraded Ubuntu 12.04LTS to Ubuntu 14.04LTS, I found that phpmyadmin is no longer working by calling http://localhost/phpmyadmin. It did work on before upgrading. Now I get this when trying ...
0
votes
0answers
31 views

Try 'apt-get -f install' with no packages

I am using Ubuntu 14.04 lts OS. So when I go to installed mysql server using below command sudo apt-get install mysql-server I have some error message. This is the error message: Reading package ...
0
votes
0answers
30 views

Mysql fails to start after upgrade

I had mysql working fine, and then I upgraded from 5.1 to 5.5. Now I think it was still working after the upgrade, but I'm doubting myself now that I can't get it started again. I have looked at the ...
-1
votes
0answers
16 views

How to change the domain name or IP address in mysql database in every tables [on hold]

Iam Using openfire chat server in ubuntu which IP address 192.168.1.15, Now i want to move it to other ip 192.168.1.55 so i took the backup of my database. Database iam using is mysql so i took backup ...
0
votes
1answer
20 views

Unable to execute expect script via cron even with the permissions set to 777

I created an expect script that won't seem to run when called by cron. I included the full path in cron when calling it as follows. * * * * * /usr/local/sbin/checkForRemoteTasks ...
0
votes
1answer
18 views

Decent tutorial needed for setting up simple MySQL client-server system

Could anyone please comment what I have missed during Ubuntu setup, that I am allowed to nothing on my system? Always needing to sudo from command line is not practical if you are not familiar with ...
-2
votes
0answers
8 views

Error with Mysql and Mongodb server

I am trying to install mysql server in ubuntu, however i am facing mongodb error which i once tried to install and was unsuccesful. I already tried to remove mongodb but its not installed anyway. What ...
0
votes
1answer
25 views

Cron job from mysql and send an email with results

I have a ubuntu box hosted and need to setup a cron job for executing a stored procedure and sending the results via email to one address once a week. How can I do this? I am using Mailgun
-1
votes
0answers
10 views

unable to uinstall kibana in ubuntu

I was working on some data visualization project in which i had to install kibana , elastic search , logstash, redis and ngnix server. Now i tried to uninstall all but kibana is not removing . I am ...
0
votes
1answer
81 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
36 views

Unable to upload files (pdfs, images) larger than 1 MB

I have recently started PHP and Mysql project development on Ubuntu. In one part of the project I need to upload files. But my script is not uploading anything larger than 1 MB nor does it show any ...
0
votes
1answer
22 views

How to install mysql and other software to ubuntu12.04?

I've just installed Ubuntu 12.04 to my laptop. This is the first time I'm using this OS. Their is no software to watch videos and flash player to watch in web. I'm not being able to install also. I ...
0
votes
1answer
19 views

cant remove mysql

this is terminal report of returning mysql: kajair@kajair-VGN-CS16G-R:~$ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) but I can't ...
0
votes
0answers
37 views

Percona Xtradb Server Cluster 5.6 Setup

Thanks for any help you can provide I seem to be stuck on this error for hours. I am trying to setup a percona 5.6 cluster. I have installed on 14.04 these packages and removed any trace of mysql. ...
0
votes
0answers
40 views

Stuck booting after network adapter change

I have been switching around my VirtualBox network adapters recently, and when I got to the office today my Ubuntu 14.04 server VM got stuck at Starting MySQL [OK] (or whatever the phrasing is of that ...
0
votes
2answers
22 views

Have more than one mysql version installed at a time

I currently have mysql 5.5 installed, and working. I'd like to migrate everything to mysql 5.7 (for a number of reasons, but mostly the spatial functions). I would like to have both 5.5 and 5.7 be ...
0
votes
0answers
15 views

lampp MYSQL linux permissions

I decided to go safe. I am no linux expert either. I edited my.cnf and gave the mysql username (instead of nobody) I set it to 'nugget'. I then added a user named nugget and added it to the group ...
2
votes
2answers
20 views

Chown Not Responding as I expected.

New to Ubuntu, so bare with me. I recently changed the permission of mysql, /var/lib/mysql so I could save a database in it manually (was only option currently, instead of importing it the proper ...
0
votes
1answer
27 views

MySQL keeps crashing in Ubuntu 12.04

Every few hours, MySQL crashes on my Digital Ocean Ubuntu 12.04 machine. Below is the errors I am seeing in my MySQL error log. I thought it was a memory issue, so I added a swap, but that didn't fix ...
0
votes
0answers
42 views

Locked out of the MySQL database

I'm using Ubuntu 14.04 as my host for my apache-mysql-php server setup. At first, I tried installing XAMPP (from apachefriends.org) and deployed my Moodle and Wordpress sites. However, after a reboot ...
0
votes
1answer
12 views

2nd harddrive, /var/lib/mysql ownder is nvidia-persistenced when mounted, mysql when booted?

I have a second HDD that was my old OS. When I boot it the /var/lib/mysql folder is mysql:mysql but when I mount it (LVM) in my new OS it is nvidia-persistenced:vboxusers. I want to do a cp -pr to ...
0
votes
0answers
35 views

Application doesn't launch on startup (autostart) inside docker's container

the problem I faced with is none of applications doesn't launch on the system boot. I have image based on ubuntu:14.04 installed Nginx, Php5 and Mariadb. On every boot (!) I have to start services ...
-1
votes
1answer
198 views

Mysql strange installations problems

my problem is really strange, cause i tryied lots of ways to solve them but noone was working. My last output was: Reading package lists... Done Building dependency tree Reading state ...
0
votes
1answer
23 views

Just setup ubuntu as webserver, what about my AMP setup on my other computer do I remove it?

My question is now that I have setup the Ubuntu web server do I have to remove the Apache Mysql and php from the laptop so it doesnt conflict with the server and/or can I migrate the working settings ...
0
votes
1answer
103 views

How to install Zend Framework 2 on ubuntu?

I'm looking for a tutorial on how to install Zendframework 2 on Ubuntu 14.04, and also a tutorial teaching how to use ZendFramework 2. Could someone help me? If it is useful to know, I'm with XAMPP ...
0
votes
0answers
46 views

bugzilla in ubuntu 12.04 server

I am trying to install bugzilla on my Ubuntu 12.04 64 bit server machine. I am following these steps. The problem is that I am not able to find the localconfig file in the bugzilla folder or can I say ...
1
vote
1answer
31 views

A question on mysql command

I want to config postfix. I followed these instructions. On the first step I saw this mysql command: mysql > GRANT SELECT ON servermail.* TO 'usermail'@'127.0.0.1' IDENTIFIED BY 'mailpassword'; ...
0
votes
1answer
50 views

How to compile/install bind9 with DLZ (MySQL) support?

I am wondering how to compile or install a version of bind9 that supports DLZ (specifically, MySQL) on Ubuntu 14.04. According to my internet research, bind9 doesn't support it by default. Does anyone ...
0
votes
0answers
13 views

unsure of owncloud mysql password and database

I've recently attempted to make my pc an owncloud server. I attempted to logon on the same machine I am hosting it on. However, I first need to enter a mysql password, database name, etc., and I don't ...
0
votes
0answers
40 views

Local folder for specific MySQL databases with symlinks

Moving specific MySQL databases under home folder using symlink used to work in the past for me (maybe before upgrading from 13.10 to 14.04) but now, following the same procedure, it just does not ...
0
votes
0answers
22 views

installing mysql in other partition

I am trying to install mysql in other partition on fresh Ubuntu 14.04. I'm doing this and getting the errors below. Please help me, I'm new to Ubuntu. apt-get update apt-get install mysql-server ...
0
votes
1answer
35 views

Why access denied for user root right after I set up its password?

I have installed php and mysql. But cannot set the root password. This is what I've done so far: sudo apt-get install mysql-server sudo apt-get install mysql-client After that: mysql -u root -p ...
0
votes
0answers
10 views

Install MySQL to Non-System Drive?

Is it possible to install MySQL to a different drive than the system drive? If so, how? If I do something like the following, MySQL will be installed on the system drive. sudo apt-get install ...
1
vote
1answer
22 views

Find out what php librariers are installed

I really hope this question is no duplicate, but I just can't find an answer. I'm new to Linux and PHP. I have a manual telling me that I need PHP with certain libraries installed. Is there a ...
-1
votes
1answer
37 views

How to connect to sql server 2008?

I am using ubuntu 12.04, and i have a microsoft sql server 2008 which is running on a windows server 2008 on port 1433, but windows server 2008 is virtualized it is running on vmware and further this ...