Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

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
1answer
42 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
0answers
217 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
128 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
0answers
46 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 ...
0
votes
0answers
207 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
0answers
227 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 ...
0
votes
1answer
324 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
1answer
46 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
184 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
142 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
0answers
16 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 ...
0
votes
0answers
17 views

Insert the data in my XML file in a Database in Linux [duplicate]

My question is how to insert the data in my XML file in a Database in Linux.
0
votes
1answer
122 views

How to connect from MySQL to Web Application [duplicate]

I have been trying to setup a local instance for a web application. I am new to MySQL and I can't understand how to actually connect this database to the actual web application sitting in the ...
0
votes
1answer
81 views

Apache status suddenly stops

I have a problem with my apache, I am running Ubuntu server 12.04 on a VPS. I have a basic LAMP stack, my problem is this, every few days apache will just stop and I will just notice this if I checked ...
0
votes
1answer
1k views

Could Not Connect: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I am new to Ubuntu and using Ubuntu Server 14.40 LTS. I am trying to connect my mysql database to show database data on a php file but I am not able to connect it. I am getting error Could Not ...
0
votes
0answers
170 views

Running sudo apt-get upgrade gives error [duplicate]

After running sudo apt-get upgrade I got the following error: The following packages have unmet dependencies: gnome-user-guide : Depends: yelp (>= 3) but it is not installed lintian : Depends: ...
0
votes
2answers
431 views

debian.cnf file location in Ubuntu 14.04

Where can I find the "debian.cnf" file in Ubuntu 14.04? It was under "/etc/mysql/debian.cnf" in Ubuntu 12.04. Is there some location changes or name changes ? What I want is to reset MySQL root ...
0
votes
1answer
246 views

How to install mysql, mysql workbench on Ubuntu 14.04

I am having problems trying to install mysql workbench. Says there is no mysqlclient installed, but I already have. and when you run mysql server also gives error. I am using mysql 5:16:17. How do I ...
0
votes
1answer
62 views

Query mysql return an error Incorrect key file for table

I have a site in joomla I hosts locally on an Ubuntu server. When a query is executed by mysql, I get the following error: Incorrect key file for table '/tmp/#sql_6ef4_1.MYI'; Here is my ...
0
votes
1answer
930 views

Ubuntu Server 14 MySql php connect problem

I have ubuntu server 14.04 installed along side Apache, PHP5 and MySQL server all together. I can gain access to the server using putty and the mysql database using Heidi Sql remotely. On my laptop, ...
0
votes
1answer
69 views

After installing mysql-server, and doing $mysql, mysql won't start. Mysqld.sock missing

First, I installed mysql-server Next, I did $mysql I was going to add a database and edit some stuff. But I got this error: ERROR 2002 (HYOOO) : Can't connect to local MySQL server ...
0
votes
1answer
104 views

Starting mysql server problems

I am trying to get mysql (server?) to start. This is what I keep on getting: Rather than invoking init scripts through /etc/init.d, use service(8) utility, e.g. service mysql start THEN when I do ...
0
votes
1answer
2k views

Cannot Install/Start MySQL Server

Okay, I decided to migrate from MySQL Server 5.5.37 to Percona Server 5.6. I ended up removing MySQL Server by the following: sudo apt-get --purge remove mysql-server mysql-server-5.5 ...
0
votes
1answer
888 views

Unable to connect to mail server via IMAP and roundcube

I am having trouble getting the final parts of my mail server up and working. I followed this tutorial to get everything set up on the mail server side. I have installed roundcube for webmail and ...
0
votes
1answer
236 views

MySQL not working after server reboot?

Because of problem with host company node I migrate from one node to another. Now the server is working, but there seems to be a problem with mysql. In directadmin in MYSQL Management i see this ...
0
votes
1answer
4k views

Unable to Login as root after mysql service restart

I installed mysql on Ubuntu 14.04 LTS like: sudo apt-get install mysql-server libapache2-mod-auth-mysql php5-mysql after completely removing mysql with: sudo apt-get remove --purge mysql-server ...
0
votes
1answer
3k 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
2answers
2k views

ERROR 1064 (42000) creating table MySQL

I try to build my own website, and at my website I ask people to enter their name and write a little story. When they are done, they hit submit, and it sends the information to my database. I work ...
0
votes
1answer
1k views

Unable to uninstall MySQL 5.6.17 from Ubuntu 12.04

I installed MySQL 5.6.17 using binary file *.tar.gz. I need to remove MySQL from my Ubuntu system. I tried running the following commands: 1) sudo apt-get remove --purge mysql-server mysql-client ...
0
votes
1answer
81 views

Two servers using the same database files

Because I do often work out of the office I have implemented a provision mechanism with the a local server, so I have a "server" running on my laptop and one on my computer office. All my files are ...
0
votes
1answer
224 views

Broken dependencies while installing redmine using apt on fresh 14.04 [duplicate]

On vanilla 14.04: run aptitude chose package redmine see broken conflicting package problem (something with ruby-rack) How can I deal with it?
0
votes
1answer
31 views

Missing header files when installing

I am trying to install Mysql-5.5 directly through Terminal but I get an header files is missingerror and it fails to install. The problem stays when I run sudo apt-get update/upgrade Is ther any way ...
0
votes
1answer
82 views

Access MySQL and PHP after installation

After I installed Apache2, MySQL, MySQL Client, phpMyAdmin and PHP on my Ubuntu 13.10, I tested the Apache2 using 127.0.0.1 and it works. I would like to learn how I can access MySQL and create PHP ...
0
votes
1answer
753 views

Restoring MySQL files to new disk 14.04 - permissions?

I am rebuilding my computer with a new disk and have a backup of my MySQL db's - I have moved them to /var/lib/mysql and when I try: sudo /etc/init.d/mysql start MySQL refuses to start - the error ...
0
votes
1answer
581 views

Can't get latest PHP or Pear in Ubuntu 12.04 LTS

I'm attempting to install PEAR, and other components.. but getting the following. $ sudo apt-get install php5 libapache2-mod-php5 php5-mysql Reading package lists... Done Building dependency tree ...
0
votes
1answer
65 views

I have installed mysql on ubuntu 13.10, but don't seem to have rights to do anything?

This is possibly a problem that affects lots of users, I have have found similar posts, but none of the solutions have worked for me. I have installed mysql on my ubuntu 13.10, however I do not seem ...
0
votes
2answers
318 views

Apache unable to connect to MySQL

I installed apache server (this story). I cannot connect with remote (I tried local too) mysql server. After a long loading page I get error MySQL database connect failure. Mysql server is far from ...
0
votes
1answer
377 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
0answers
27 views

Error when installing mysql on ubuntu [duplicate]

I get This error when I try to install MySQL on ubuntu: sudo apt-get install mysql-server [sudo] password for xxxxx: Reading package lists... Done Building dependency tree Reading state ...
0
votes
0answers
30 views

How to solve mysql dependency problem [duplicate]

Hi I ran the following command sudo apt-get upgrade However I'm getting the following You might want to run 'apt-get -f install' to correct these. The following packages have unmet ...
0
votes
1answer
129 views

No reaction on service mysql start, init script works

After upgrading Ubuntu from 12.04 to 13.10, the MySQL server (now 5.5) does not start/stop with service mysql start|stop. When typing /etc/init.d/mysql start, everything works fine. Once it does ...
0
votes
0answers
44 views

Setting Max Connections in MySQL server Globally [duplicate]

I installed my UBUNTU 12.04.4 LTS X64 yesterday and didn't installed anything except mysql-server and mysql-client. But htop showing 20 mysqld identical processes. *--Process----- MEM%---VIRT --- ...
0
votes
2answers
2k views

Could not open connection to host (ubuntu server) on port 23, 5432, 3306

I have recently installed few packages for telnet, mysql and postgreSQL. I can access all these service locally on the ubuntu server but somehow I am not able to access these services from other ...
0
votes
1answer
1k views

Unable to install MySQL. Held broken packages [duplicate]

I tried installing MySQL using sudo apt-get install mysql-server, and I get an error saying Some packages could not be installed. This may mean that you have requested an impossible situation or if ...
0
votes
3answers
18k views

how install mysql 5.6 and mysql workbench 6.0.9 on ubuntu 13.10

I am using Ubuntu 13.10 Saucy Salamander (64 bit System) . I want to install mysql 5.6 and workbench 6.0.9 on it. how i do it please describe step by step?
0
votes
1answer
432 views

Why automatic installed mysql 5.5 when i install mysql workbench 6.0.9 from deb file using ubuntu software center

I am using Ubuntu 13.10 and already installed mysql 5.6.16 on it. I have downloaded mysql workbench deb file (mysql-workbench-community-6.0.9-1ubu1310-amd64) from mysql web site. Now when I run this ...
0
votes
2answers
569 views

Server crashed a few times due to lack of memory - how can I find out how much is available to each process? [duplicate]

We had a huge spike in traffic with lots of these errors: Feb 17 10:44:13 111488 kernel: [8275767.506198] Out of memory: Kill process 20577 (apache2) score 52 or sacrifice child Feb 17 11:02:06 ...
0
votes
1answer
90 views

Mysql died and won't start

I am working on Ubuntu 12.10 server with nginx, mysql and unicorn installed. There is something wrong with Mysql and has stopped working. Log message from /var/log/mysql/error.log Attempting ...
0
votes
1answer
217 views

mysql with ubuntu 13.10

I have a problem with mysql-server and client after a wrong configuration. I tried uninstalling both but I get an error when I uninstall mysql-server: start: Job failed to start invoke-rc.d: ...