Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

1
vote
1answer
91 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
472 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 ...
0
votes
0answers
16 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
99 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
110 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
84 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
160 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
39 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
103 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
563 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
232 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
475 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
35 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
101 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
32 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
224 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
80 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
37 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
39 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
33 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
26 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
31 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
755 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
65 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
466 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
54 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
244 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
87 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
33 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
118 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
55 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
69 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
121 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
125 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 ...
3
votes
5answers
5k 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
1k 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
136 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
116 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
106 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 ...
4
votes
3answers
4k 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
4k 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
251 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
381 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
40 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
15 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
42 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
1answer
402 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
50 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 ...