0
votes
0answers
16 views

importing issue with mysql version to another

I have got an issue with mysql import, I have taken a backup of the mysql version 5.1.32 with the help of command mysqldump -u root -p --routines oneclicksite > oneclick.sql and importing it with ...
0
votes
1answer
89 views

Fatal error (bad field count) while configuring Postfix

I'm using this tutorial to configure a mail server using postfix, dovecot and mysql. While configuring Postfix I have to uncomment the following lines and then restart Postfix with service postfix ...
0
votes
0answers
17 views

How to open PHP myadmin in XAMPP for linux?

I am running Linux Mint 17 (based on Ubuntu), and i have successfully installed Xampp. I would like to now work with MYSQL, so i was wondering how to open the PHP myadmin page in my browser. ...
0
votes
1answer
137 views

How do I create & restore a mysql database dump with Chef?

Environment Ubuntu 12.04 Precise64 Enterprise Chef opscode-cookbooks/mysql opscode-cookbooks/database Wordpress 3.9 Objective I am trying to replicate/clone my production Wordpress server. I'd ...
0
votes
0answers
47 views

Installing mysql - Fedora20 - Where is the installation directory

I am trying to install mysql on to a Fedora 20 box. I am using the below guide which states the following; First, MySQL was replaced by MariaDB since Fedora 19 ...
0
votes
2answers
125 views

Ubuntu - Secure PHPMyAdmin in Nginx

I followed the instruction on this site for installing PHPMyAdmin. However, this configuration is for an Apache, and I am using Nginx. I can't find any tutorial online on how to restrict the allowed ...
0
votes
1answer
57 views

analyzing htop data in ubuntu

i am trying to find bottleneck in my server, specifically in my web application of why things are running super slow. Here is a screenshot of my htop: As far as I can tell mysql here is almost ...
0
votes
1answer
102 views

Difference between connecting to 127.0.0.1 and server ip

I am brand new to php, databases, and linux and had a problem where I could not connect to mysql databse with the php mysql_connection function. When I used the ip address of my VM I kepy getting a ...
0
votes
0answers
17 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
189 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
30 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
68 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
91 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
107 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
329 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
70 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
21 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
86 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
1k 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
84 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 ...
2
votes
0answers
1k 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
11k 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
333 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
282 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
2k 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
141 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
9k 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
849 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 ...
5
votes
1answer
5k 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
169 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
4k 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
303 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
79 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
139 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 ...
5
votes
3answers
4k 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(): ...
2
votes
1answer
474 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
448 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
4k 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
331 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
399 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
144 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
372 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
493 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
785 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
383 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
130 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
185 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 ...