Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
1answer
2k 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 ...
1
vote
2answers
695 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?
0
votes
2answers
3k 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 ...
0
votes
0answers
68 views

Configuring mysql-server-5.5 (amd64) hangs during installation

I run sudo apt-get install tasksel then I choose LAMP Server then I've been waiting to finish the configuration and when it comes to 81% which is Configuring mysql-server-5.5 (amd64) the ...
0
votes
1answer
625 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
0answers
85 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
1k 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
151 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. ...
0
votes
0answers
52 views

Can I restore mysqldump to a master-master replicated server?

Suppose I have two servers A and B replicating each other(Master-Master). I think all the permissions such as 'grant replication slave','CHANGE MASTER TO MASTER_HOST' are storing in the database ...
1
vote
1answer
75 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
0answers
59 views

How to solve Critical errors in mysql proxy?

I have installed the mysql proxy in ubuntu.And when i give mysql-proxy command,I get the following errors (critical) admin-plugin.c:569: --admin-username needs to be set (critical) ...
0
votes
0answers
50 views

“Error:Unknown option -D” while Simple Query Interception

I am working on MySQL proxy using lua.So i am trying for simple query interception.Using this link,i have done the following. I created a file example.lua,with the following code function ...
0
votes
0answers
25 views

How do I connect a mysql client? [duplicate]

I'm trying to run mysql in Ubuntu by running mysql -u root -p in the terminal and getting this error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
0
votes
1answer
36 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 ...
3
votes
1answer
2k 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
99 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
1k 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 ...
0
votes
0answers
85 views

PHP Mysql connection works but no data can be displayed

I wrote this simple php script that just to import basic information from mysql table. As a result, not even a error message, but a blank screen. Something to do with the PHP - Mysql connection, but ...
1
vote
0answers
17 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
1k 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 ...
0
votes
0answers
109 views

How to use NTFS media drive as mysql data directory in Ubuntu 14.04

I want to use my NTFS drive (local/logical) as MySQL data directory. Directory: /media/omar/Coding/mysql/data. I have added the following line to /etc/fstab to auto mount the drive. UUID=DriveID ...
1
vote
1answer
50 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
177 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
73 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
180 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 ...
2
votes
1answer
1k 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 ...
0
votes
0answers
195 views

Getting error on my Ubuntu 13.10 “libsnmp15 (>= 5.4.3~dfsg)”

I am going to install Zabbix (Server Monitoring tool) on my Ubuntu 13.10 server, but while installing it getting error like this, zabbix-server-mysql : Depends: libsnmp15 (>= 5.4.3~dfsg) but it ...
22
votes
8answers
31k 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 ...
0
votes
0answers
322 views

MySQL JDBC Connection using Eclipse

I have now read numerous installation guides and spent a few days reading in different forums, but I cannot get my program to find the class com.mysql.jdbc.Driver The current status is: I have added ...
0
votes
0answers
196 views

Ubuntu 12.04 server: Problem with apache internal processes using too much memory?

I've looked around and couldn't find an answer for this, tried quite a few of other people's solutions over the months, but nothing fixes this. I run 12.04 on a good VPS, but I've been having some ...
2
votes
1answer
225 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 ...
7
votes
3answers
10k 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 ...
3
votes
1answer
7k 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: ...
0
votes
0answers
378 views

mysql-server won't update and won't start

Whenever I update, I get errors in mysql configuration: start: Job failed to start invoke-rc.d: initscript mysql, action "start" failed. No apport report written because the error message indicates ...
0
votes
1answer
819 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
54 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
0answers
19 views

add remote server for phpmyadmin

After I install phpmyadmin that I can access local MySQL server, but I would like to add a remote MySQL on Windows. I can not add remote server from phpmyadmin. Are there any configuration files to ...
1
vote
1answer
69 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 ...
1
vote
2answers
8k 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
0answers
79 views

Install MySQL Workbench without installing MySQL (i.e. alongside Percona)

I have percona server and client installed locally and I would like to install MySQL Workbench as well. However, whenever I attempt to install MySQL Workbench, it tries to remove percona (and vice ...
0
votes
1answer
204 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
28 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
63 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
1k 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 ...
0
votes
1answer
62 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
48 views

How can I install the MySQL client? [duplicate]

I installed mysql server and want to install the mysql client using following code: apt-get install mysql-client but I got following error message: E: Could not open lock file /var/lib/dpkg/lock - ...
1
vote
2answers
4k views

Shell script issue: cron job script to Restart MySQL server when it stops accidentally

I have this script, I am using it to setup CRON job to execute this script, so it can check if MySQL service is running; if not then it restart the MySQL service: #!/bin/bash service mysql status| ...
0
votes
1answer
343 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
2k views

Mysql on Ubuntu 14.04 problem with AppArmor permissions for data directory

I've been using MySQL with a different location for the database date since Ubuntu 12.04 and had no problems. My configuration was like this: Data in /home/db/mysql Link in the default location sudo ...