Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

1
vote
1answer
1k views

Communication between Linux Containers (lxc)

I have a container for my Apache webserver, and another one for my Mysql server. I have given them 2 static IPs NAME STATE IPV4 IPV6 AUTOSTART ...
2
votes
2answers
147 views

How do I check services requiring a restart (of services, not the machine) by installing updates to other packages

If I run sudo apt-get upgrade then I get shown a list of packages and if any of these are services, they may need to be restarted (which is done automatically when installing the updates). How can I ...
0
votes
1answer
495 views

MySQL Ambiguous Option issue

MySQL is starting correctly as a service, and my WP instance / phpMyAdmin connects to it successfully. However, I've managed to screw something up such that when I try to log in from the prompt, ...
0
votes
1answer
2k 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
134 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
157 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 ...
8
votes
7answers
35k views

MySQL error: The partition with /var/lib/mysql is too full!

I get this error when trying to start MySQL: The partition with /var/lib/mysql is too full! Here is the output of df -h: Filesystem Size Used Avail Use% Mounted on /dev/sda1 455G 77G ...
0
votes
1answer
3k 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 ...
1
vote
2answers
243 views

MySQL takes ages to load (only when using WP)

I'm not sure what's happening but it's since a while that I'm experiencing using my dev site (running on a VM) on the local Ubuntu machine. The site runs on a Wordpress instance using MySQL setup to ...
0
votes
3answers
158 views

mysql questions for beginners

ok, I have a few questions regarding mysql. I am currently running ubuntu 12.04.4 LTS command line version. I am looking for a database that I can use. I am confused at this point because I am ...
1
vote
1answer
646 views

MySQL SSH Connection Setup

I want to connect to a MySQL db (running Ubuntu 14.04) with my Mac (running Mavericks). I will be connecting remote- home to work. How do I setup the ssh connection on MySQL workbench? Also, where do ...
1
vote
0answers
2k views

Apache Timeout (Problem loading page) on localhost

I am running a php script locally in my Firefox web browser. After exactly 300 seconds I get an error page. "Problem loading page. The connection has timed out. The server at localhost is taking too ...
1
vote
1answer
328 views

Postfix / Dovecot / MySQL- doesn't work!

I have just installed a Mail- Server on Postfix and Dovecot using MySQL to authenticate the user. But if I try to conntect to the Server via Outlook or Thunderbird, the following Error appears in the ...
0
votes
1answer
1k 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 ...
-1
votes
1answer
305 views

php5, mysql, phpmyadmin not working in ubuntu14.04

I have already installed lampserver in ubuntu 14.04. when i try to run http://'127.0.0.1', it shows it works. but it does not work when i try to run http://'127.0.0.1'/test.php. I have already created ...
2
votes
2answers
1k views

Auth succeeded No requires line available

Upgrading to Ubuntu 14.04 (and Apache2 2.4) server I can't use MySQL as htaccess; Before upgrading I was using MySQL as htaccess in the virtual host - worked nicely: <Directory ...
0
votes
1answer
414 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 ...
2
votes
0answers
113 views

404 not found error on apache2 [duplicate]

I have installed apache2, actual php version, mysql server and vsftp on my new Ubuntu server. I also installed wordpress and gave the user www-data all rights for /var/www/* and put it to 755. I ...
1
vote
1answer
7k 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 ...
2
votes
2answers
6k views

What does mysql -u root -p mean while logging in?

I am new to using Mysql and I do not understand what does -u and -p imply?
3
votes
4answers
14k views

Not able to uninstall MySQL with apt-get

I had downloaded the generic Linux 64 bit MySQL 5.6.17 TAR archive from http://dev.mysql.com/downloads/mysql/ and installed on my 64 bit Ubuntu 14.04, following the instructions at ...
2
votes
2answers
11k 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 ...
1
vote
1answer
278 views

Postfix and Ownclound mysql authentication

i'm using ubuntu 12.04 with roundcube/postfix and owncloud installed, and using mysql as login authentication. i would like to know if it's possible to make single login for these apps (without LDAP) ...
0
votes
2answers
4k 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 ...
1
vote
1answer
457 views

MySQL wont start with XAMPP

I have installed XAMPP on my Ubuntu 14.04 and everything works but not MySQL. MySQL is installed and works just fine with workbench but not when I try to reach it with a installation of Magento. ...
1
vote
1answer
385 views

mysql won't be installed on ubuntu

i tried to install apache on ubuntu, and worked, i tried to install php5 on ubuntu, and thats worked too. but if im installed mysql, it wont be installed, i didnt know whats going on, i'm new to ...
0
votes
1answer
87 views

Quick way to dump a Wordpress database without digging through configuration files?

I've got a load of Wordpress sites to move around and modify this afternoon. Yay. Like any good developer, I want to back up things before I Hulk-out and break everything. The site's files are mostly ...
5
votes
1answer
5k views

Unable to re install mysql on Ubuntu 14.04: Dependency problems

Ubuntu Unity 14.04 LTS with all lenses removed, except files. (Hate the dash.) I have a LAMP system for web site development. I want to put all my data files in a particular partition that I can ...
1
vote
1answer
237 views

Shutting down ALL services (server backup)

I am running Ubuntu server 12.04 LTS. After many trials and errors, the backup strategy I have selected resorts to using TAR (mostly because I was unable to find a tool to backup/restore dovecot ...
0
votes
1answer
3k views

sometimes Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

I've got my application up and running, with rails on my ubuntu VPS in Linode with mysql. here's the version of mysql: mysql Ver 14.14 Distrib 5.5.35, for debian-linux-gnu (x86_64) using readline ...
1
vote
0answers
23 views

How to install MySQL 5.6 in Ubuntu 14.04 Desktop? [duplicate]

Which are the steps to install MySQL in Ubuntu 14.04 (Trusty Tahr)?
1
vote
1answer
4k views

MySql Not starting even when status is ok ubuntu lampp

I am a Newbie to Ubuntu. I just installed the xampp Linux version through xampp-linux-1.8.3-4-installer.run file. Following are the commands that I used: cd /home/sammy/Downloads sudo chmod +x ...
1
vote
1answer
144 views

phpmyadmin connect using computer name?

I use phpmyadmin to connect to a remote server for Windows machine. I have to use the IP address and not the computer name. Is it possible to use the computer name to configure a connection to a ...
1
vote
0answers
442 views

Copying Folder while Preserving Permissions/Ownership Error: operation not permitted

I am trying to copy a folder while preserving ownership. When I use the command: sudo cp -R -p /var/lib/mysql /newpath the files copy but the ownership changes (my username becomes the owner on the ...
1
vote
0answers
128 views

Error Changing MYSQL Data Directory

I was trying to change the mysql data directory following these instructions. When I try to restart the database with step 8: sudo /etc/init.d/mysql restart Gets the following errror: Rather than ...
0
votes
1answer
549 views

Compiling the mysql_fdw for postgresql?

I'm attempting to compile the MySQL Foreign Data Wrapper for Postgresql 9.1+, on Ubuntu 12.04 LTS and having a fair bit of trouble getting it to work. So far I've managed to use git to download the ...
5
votes
2answers
21k views

unable to create database due access denied

I just logged in to Ubuntu 12.04 as a normal user (vivek) and opened the terminal to create a database, I wrote: create database Hello; and the error I had is: ERROR 1044 (42000): Access denied ...
91
votes
10answers
211k views

Mcrypt extension is missing in 14.04 server for mysql

The php mcrypt extension on ubuntu 14.04 shows that it is installed properly, but phpmyadmin says: The mcrypt extension is missing. Please check your PHP configuration. My current php config is ...
1
vote
1answer
2k views

Install MySQL in Ubuntu for XAMPP in 14.04

I was having problem since some time using XAMPP. In terminal the MySQL starts as normal but when it comes to app, it saying MySQL stopped working. So I removed MySQL and hope installing it again will ...
2
votes
1answer
673 views

MySQL import never completing

I wrote a bash script, and here is my problem. The script run for hours, and it never completes. I see the MySQL import process finish, but the script never gets any further. I have tried adding an ...
24
votes
6answers
29k views

Why did installation of MySQL 5.6 on Ubuntu 14.04 fail?

I wanted to get a look at MySQL 5.6 on Ubuntu 14.04 just out of curiosity. And based on this article it certainly looked like installation should be simple and straightforward. So I fired up an AWS ...
4
votes
1answer
15k views

MySql Workbench on Ubuntu 14

Hi I just installed the newest version of Ubuntu, 14, and now I need to install MySql Workbench. I download the .deb package from mysql site but when I try to install it I obtain this error: ...
1
vote
1answer
2k 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
158 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 ...
1
vote
1answer
121 views

Symbolic Link Error with MySQL Cluster and Ubuntu 12.04

I want to install MySQL Cluster on Ubuntu and I followed this tutorial Install MySQL Cluster on Ubuntu 12.04 LTS. My management node installed successfully, but I am having a problem in my database ...
7
votes
6answers
83k views

mysql server start failed

I am running ubuntu server. When I tried to login to mysql(which was running),I got the following error ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
0
votes
1answer
238 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
43 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 ...
1
vote
1answer
191 views

mysql server admin error from workbench

I installed MySQL Workbench and would like to create a new server instance to admin the server, but I got following error message when I create a instance for local server. Operation failed: File ...
0
votes
3answers
6k views

installing XAMPP error

I followed these instructions: http://ubuntuportal.com/2013/12/how-to-install-xampp-1-8-3-for-linux-in-ubuntu-desktop.html I already installed lampp in to my directory files under the opt. I am ...