0
votes
0answers
5 views

Error while trying to create an album in MySQL in Trovebox

When trying to create a new album in TroveBox I just get an simple error message in the ui notifying me that it failed. No information is in logs from Apache and MySQL. The current user can write in ...
0
votes
2answers
31 views

Trovebox (OpenPhoto) setup hangs/fails at final step 3

I've been following the install instructions found here about how to install and configure Trovebox on a Ubuntu server running Apache: Ubuntu 14.04 LTS Apache: 2.4.7 MySQL: 5.5.37 PHP: 5.5.9 ...
0
votes
1answer
25 views

One database on Linux and Windows

I want to use MySQL database on my Ubuntu installation as of Windows 7, It should be dynamically, I mean when I change data in database on Ubuntu it should save also on Windows too. I've already ...
0
votes
0answers
44 views

Linux Has Become Very Slow Dealing With Large Data

Last year I bought a computer, for around $1,800, so it is relatively high-end. When I first got it I was particularly pleased at how quick it dealt with large MySQL queries, imports and exports. But ...
-1
votes
2answers
33 views

Which version of MySQL for Ubuntu

I have the 64 bit Ubuntu 14.04 on my machine. I want to install the MySQL server from here. But I am confused which version to download. My best guess is that, since Ubuntu is apparently a Debian ...
0
votes
2answers
56 views

mysql, ssh, rsync, git hang with dns name but not IP address on Ubuntu 12.04

Certain network based programs recently (problem did not exist a couple of weeks ago) started hanging for me. Some that I've experienced the problem with are mysql, ssh, rsync, and git. My first ...
0
votes
0answers
66 views

Trying to move the MySQL data directory on Ubuntu 12.04

OS: Ubuntu 12.04 I am trying to move the mysql data directory and log files to separate mounts to make it easier to swap out drives when needed in the future. ##Moving the MySQL data directory sudo ...
1
vote
2answers
51 views

How to completely shut MySQL server down on Ubuntu server

I had mysql server running. I stopped it, and removed it (apt-get remove mysql-server mysql-client) I then manually removed the directories: /var/lib/mysql /var/run/mysqld I rebooted. But when I ...
0
votes
0answers
19 views

Wy is mysqldump producing structure only

OS Version: Ubuntu 12.04.4 LTS MySQL server version: Server version: 5.5.35-0ubuntu0.12.04.2 (Ubuntu) I have been using the following command to produce a data dump: mysqldump -u someuser ...
-1
votes
2answers
75 views

How to make a MySQL database on Ubuntu server? [closed]

I am trying to make a WordPress blog and install WP manually, but the MySQL databases are giving me headaches. Can someone explain what is MySQL and how to make a database? I am using Ubuntu Server ...
2
votes
2answers
511 views

Installing phpmyadmin package ERROR 1045 (28000)

I need to create a new mySQL db for a local site, I thought I'd do that with phpMyAdmin so I installed that package like so: sudo apt-get install phpmyadmin During this process I get a couple of ...
0
votes
1answer
71 views

Multiple requests shut down MySQL

I have some problems with my MySQL database. I configured a server with the database and other services (apache, php) and put run multiple applications. There are two problems: Every day at the ...
1
vote
0answers
767 views

Postfix: SMTP, use port 587 rather than 465

I have set up a mail server on AWS EC2 using the instructions from Flurdy: http://flurdy.com/docs/postfix/ it has mostly gone well. My issue is that I would prefer to use SMTP port 587 with TLS ...
0
votes
3answers
7k views

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

So at first I was getting this error when trying to create databases for use in phpmyadmin. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I ...
1
vote
1answer
230 views

Apache/MySQL server blocks

I manage a server running Ubuntu 12.04. In the last couple of weeks, the server has started to misbehave, and I cannot think of anything important that has changed. This is the pattern: The server ...
0
votes
0answers
255 views

how to enable remote access to a MySQL server on an AZURE virtual machine

I have an AZURE virtual machine with a MySQL server installed on it running ubuntu 13.04. I am trying to remote connect to the MySQL server however get the simple error "Can't connect to MySQL server ...
0
votes
1answer
1k views

MySQL don't start (ubuntu): [ERROR] /usr/sbin/mysqld: unknown option '--skip-locking'

I can't start MYSQL. I changed a parameter in WEBMIN in the main mysql configuration: SKIP LOCKING OF TABLE FILES?... the original value was "NO", and I changed to "YES" This is the LOG file: ...
1
vote
0answers
120 views

After rebooting, why doesn't sudo prompt for password when I try to start MySQL server?

I'm having a minor problem, and I'm hoping someone can help me understand why my system behaves this way. By the way, I'm a MySQL + Terminal newbie, so please go easy on me! I've done some due ...
3
votes
3answers
7k views

Mysql Fail to start

I'm running a Ubuntu 12.04 LTS Virtual Machine. Last week, the VM stopped unexpectedly now mysql will not start on the VM. These two events may be related, they may not be. When I try to connect: ...
3
votes
1answer
558 views

“mysqld_safe --user=mysql &” hangs after fresh install

I'm having issues getting my new MySQL server (v5.6) to start on Ubuntu Desktop 12.04 (64-bit). Description of the problem: The problem is that, after following instructions for installing to Linux ...
4
votes
1answer
3k views

MySQL completely uninstalled and reinstall but database still exists on Ubuntu 12.04

I need to completely remove MySQL all databases and installation and reinstall, because root is broken. I followed this instructions: sudo apt-get remove --purge mysql-server mysql-client ...
1
vote
4answers
147 views

Accessing a mySQL database on an external server

I have a large (multi-gigabyte) SQL database on an external server. I can access it through SSH, but manually querying the data will be a major pain. I really need a GUI. I'm using Ubuntu 13.04, but ...
0
votes
3answers
3k views

ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111) [despite commenting out bind-address & skip-networking]

Okay, so disclaimer: I'm an absolute mysql noob. Gimme any other development type area and I'm fine. So, I just started using Ubuntu 12.04 an setup mysql. Never really used localhost since we have a ...
1
vote
1answer
253 views

Elementary OS - Stop MySQL from starting automatically at boot

MySQL is started automatically each time I boot my ElementaryOS Luna, how can I disable this and have MySQL off by default? I have verified that the mysql service is disabled at all runlevels using ...
0
votes
0answers
73 views

Reinstalling Mysql On Ubuntu 10.10(Stuck with bad repositories)

I recently configured NDB-cluster with mysql and Mysql just crashed ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) tried re-installing ...
1
vote
1answer
114 views

mySQL outfile & permissions under Ubuntu Linux

I know there are already several postings on the stackexchange sites about Linux permissions, but I can't find the answer to my problem. I'm working on my own laptop (no web server or anything) with ...
1
vote
1answer
24 views

Moving from one user to another in MySql

To login into mysql, in ubuntu we have a option from terminal like shell# mysql -uxxx -pyyyy; Now, I would be as "XXX" user in mysql. and terminal would be like mysql> Now, I want to ...
3
votes
3answers
3k views

phpmyadmin symlinks error after ubuntu upgrade

After the upgrade of my ubuntu server to 13.04 my phpmyadmin is no longer reachable. the browser reports 500 (internal server error) and in the error.log it says: PHP Fatal error: require_once(): ...
1
vote
1answer
438 views

apt-get fails at everything in Ubuntu due to postgresql error - how to fix?

I've got a server with zoneminder, mysql, ffserver and some ffmpeg instances running on it, but for some reason everything seems to be tied to PostgreSQL. I noticed an error when loading the ...
1
vote
0answers
372 views

How can I skip the root password prompt when installing mysql-server?

I am writing a bash script that involves installing the mysql-server package on Ubuntu. The package interactively asks the user for the root MySQL password desired, however this is not good for me as ...
1
vote
2answers
3k views

Can't stop mysql on Ubuntu

I reinstalled mysql on Ubuntu 12.10. Removing process works fine, but during the installation my attempt to set root password failed (because, as terminal said: the password had setted already). Then ...
0
votes
1answer
2k views

How to mount an external drive (in fuseblk) as ext4 file system?

I bought a 3TB WD Elements external hard drive. Now I want to mount it to my Ubuntu server (which runs inside WinXP/VMware), so that I can move Mysql database to it. It was auto-mounted under ...
1
vote
0answers
294 views

mysql remote connection on Amazon ec2 ubuntu

I installed a MySQL server in an Amazon EC2 instance. Then, I made the following changes in /etc/mysql/my.cnf: bind-address = 0.0.0.0 #skip-external-locking After restarting the server, I executed ...
0
votes
1answer
356 views

Slow PHP over ubuntu server | VirtualMachine

I have an Ubuntu-server 12.04LT-64x installed on VMware Player (I found VMWare works better than Virtualbox after few installations over vb). My host computer is an Intel i3 with 6GB-RAM and ...
1
vote
1answer
143 views

How do I setup a website on Ubuntu Server 12.04 with PHP, MySQL, and webmail?

I have a computer in my room running Ubuntu Server 12.04 and I would like to know how to run a website off of it. I already have installed PHP and MySQL but I don't know how to install webmail or how ...
1
vote
2answers
310 views

using virtual machine like mySql server

i'm developing a java program and i need a database. Now i'm using MAMP and it's pretty easy but i would have a virtual machine (ubuntu server) and i need to connect my java program with this virtual ...
2
votes
0answers
386 views

MySQL crashes when connecting from localhost with tcp (UNIX sockets work)

I have Ubuntu 12.04 running MySQL server 5.5.24. I can connect with mysql --user root -p. status shows me : ... Connection: Localhost via UNIX socket ... When I try to connect with mysql --host ...
1
vote
0answers
651 views

Ubuntu 10.04: mysqldump: command not found and wouldn't install mysql-client

Some packages have gone missing from my Ubuntu server and few things are not working because of that. When I try to install mysql-client I get this error: # sudo apt-get install mysql-client-5.1 ...
0
votes
1answer
331 views

mySQL sphinx Index location on Ubuntu

I am trying to test out a Sphinx cookbook, but I need a database to do so. I have created the database locally, but I need to know where the default path is for the index of the table I created. ...
1
vote
1answer
2k views

Can't get phpmyadmin to work on Ubuntu 12.04

Alright, I've been following this guide (along with others to double check) to attempt to get a working lamp stack installed, but phpmyadmin always throws an HTTP 500 server error. PHP executes fine, ...
0
votes
1answer
118 views

take mysql backup in ubuntu openfire

I have installed ubunto os in my system and also i have installed the openfire in that system.And i have installed spark chat also.I have created the users and its working perfectly.we can chat with ...
0
votes
1answer
175 views

Why I have to remove mysql-client-core-5.1 mysql-cluster-client-5.1 to install python-mysql

I nearly broke down when I was trying to get python-mysql installed because I have to remove mysql-cluster-client-5.1, which I don't know what it is exactly. And when removing it I came across another ...
3
votes
1answer
837 views

Mysql service refuses to start - /sys/devices/system/cpu/ read fail

mysqld service refuses to start. sudo service mysql start See listing below. Running mysql_upgrade did not help. I found some forum posts that it happens after Ubuntu upgrade, but found no ...
2
votes
1answer
315 views

'debian-sys-maint'@'localhost' privileges on Ubuntu

So I've changed my server OS to Ubuntu, which comes with a 'debian-sys-maint' SQL user when you install MySQL. Now the problem: If you don't have the user or it's got "insufficient" permissions, ...
2
votes
2answers
5k views

can't login in phpmyadmin and mysql after fresh installation of lamp server and phpmyadmin on ubuntu 12.04 LTS

I am trying to search a solution for this problem, but didn't find a solution. I am getting an error while login in phpmyadmin #1045 Cannot log in to the MySQL server Connection for controluser as ...
0
votes
1answer
200 views

mysql 4.1.22 in vagrant ubuntu precise 64

I need a vagrant machine for developing unluckily w/ mysql 4.1.22. Would you recommend any old packages from older ubunuts, or is it better to compile mysql on my own in ubuntu 12.04. Or is the ...
2
votes
3answers
3k views

Remote connection refused by mysql on vbox

I am currently using ubuntu server on a virtual box machine to have a secondary environment for testing. The server also has mysql-server installed but I would like to manage it through mysql ...
1
vote
0answers
160 views

Easiest way to install the Ubuntu Mysql Security Patch

I am looking for a quick and easy way to install the security fix for CVE-2012-2122 on my Ubuntu boxes. I don't want to risk installing any of the other updates and I just want to install the ...
1
vote
3answers
7k views

How to connect to MySQL server in LAN?

Here is the technical description. My laptop's config: IP Adress:192.168.2.5 MySQL Server 5.0 on port 3306 Operating System: Ubuntu The database is in this machine My friend's laptop config: ...
1
vote
1answer
6k views

Install MySQL 5.1 on Ubuntu 12.04

Only version 5.5 is available through apt-get, but I want to install 5.1. Is there a way to install it through apt-get? Perhaps by adding a certain repository. How can I install it manually without ...