Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
0answers
20 views

Test dev website

The task is to drop a few MySQL tables from a dev site and test if that generated any errors on the site, before doing it on the live site. Since the site is also a live site, I included the dev site ...
1
vote
1answer
128 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
231 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
132 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 ...
0
votes
1answer
261 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
66 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
104 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 ...
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
447 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
1k 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
57 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
212 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
62 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
632 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
113 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
48 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
55 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
40 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
39 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
33 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
1k 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
83 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
906 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
69 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
16 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
736 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
100 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
43 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
166 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
68 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
117 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
587 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
176 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 ...
11
votes
8answers
15k 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
266 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
184 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
145 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 ...
6
votes
3answers
7k 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
6k 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
337 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
596 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
47 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
16 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
57 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
3k 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
67 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
201 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
23 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 ...