-1
votes
1answer
16 views

How to connect to sql server 2008?

I am using ubuntu 12.04, and i have a microsoft sql server 2008 which is running on a windows server 2008 on port 1433, but windows server 2008 is virtualized it is running on vmware and further this ...
0
votes
1answer
22 views

How do i export a database in ubuntu to specified location using terminal

I get a blank screen since i have installed the ATI graphic drivers. I tried a lot of things restore my laptop but all in vain. Only formatting seems to be the other option. So i want to export my ...
0
votes
0answers
35 views

Mysql failed to start

i tried to restore a db backup to a newly created database, suddenly its starts showing error. Can't connect to local MySQL server through socket /var/run/mysqld/mysqld.sock so i checked ...
0
votes
1answer
18 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 ...
1
vote
0answers
89 views

Apache and MySQL bringing server to a crawl several times a day

I am having difficulty troubleshooting a bottleneck problem with my Ubuntu 12.04 server. I run a very small intranet website off of the server. There are web requests (SOAP, HTML, REST, etc) at a ...
0
votes
0answers
97 views

initctl: Unknown job: mysql ubuntu 12.04.4

I just updated my Ubuntu and mysql service wont start up. I've tried to re-install million time, i still get this error message: initctl: Unknown job: mysql The error log shows this: ERROR: 1064 ...
0
votes
1answer
24 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
0answers
38 views

Problem after installing phpmyadmin in ubuntu 12.04

I have installed phpmyadmin from the following process sudo apt-get install phpmyadmin Then I opened it throghhttp://localhost/phpmyadmin/ But after giving username and password then pressing the ...
0
votes
1answer
257 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
1answer
281 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 ...
1
vote
1answer
39 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 ...
0
votes
0answers
57 views

How to get write permission on /etc/environment?

I want to add mysql Connector jar file to classpath and by browsing through the net. I read that a global way to do it is to update the /etc/enviroment but the file opens as readonly. What I don't get ...
0
votes
1answer
212 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
0answers
117 views

Ubuntu 12.04 problems with mysql

I use Ubuntu Server 12.04 for my Django project. On my local PC there is no errors and etc. Sometimes on server I have error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
0
votes
1answer
50 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
1answer
26 views

mysql problem with login in terminal

I read many post including https://help.ubuntu.com/community/MysqlPasswordReset this one one all of method. How much time I do this I don't know. Still my problem was't fixed. I already wasted 6 more ...
0
votes
0answers
29 views

Ubuntu precise 12.04 init.d issue after installing percona 5.5

First of all, it keeps on starting mysqld_safe even if it is not provided by my my.cnffile. I found this in the init.d script: "${PERCONA_PREFIX}"/bin/mysqld_safe > /dev/null 2>&1 & And ...
0
votes
1answer
550 views

how to upgrade phpmyadmin after installing mysql 5.6

After upgrading MySQL from 5.5 to 5.6 I got the following error in phpmyadmin: Your PHP MySQL library version 5.5.33 differs from your MySQL server version 5.6.13. This may cause unpredictable ...
2
votes
2answers
1k views

Unable to install mysql 5.6 in ubuntu 12.04

I download mysql-5.6.16-debian6.0-x86_64.deb from official site. Install using dpkg -i mysql-5.6.16-debian6.0-x86_64.deb It does create file in /opt/mysql/server-5.6/. root@ubuntu:~# cd ...
0
votes
0answers
43 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
3k views

MySQL Access denied for user 'root'@'localhost'

In my server, everytime I try to access MySQL I get the error: Access denied for user 'root'@'localhost' (using password: NO) when I try mysqladmin -u root -p password I get Access ...
1
vote
1answer
2k views

Installing MySQL 5.6 using PPA

I'm trying to install MySQL 5.6 on my Ubuntu 12.04 over the already installed 5.5 the easy way (using PPAs). I've found Ondřej Surý's PPA here. It sounds promising but I couldn't upgrade my MySQL. ...
0
votes
1answer
26 views

Where is the database file from redmine after using the defaultinstallation?

After I installed redmine, I have a database called redmine and through phpmyadmin I can take a backup etc. , but I can't find the default location of it. Where is it placed? Any Idea? Does mysql ...
0
votes
1answer
110 views

HTML doesn't show php script on Uuntu 12.04 ( PHP5, Apache2, mysql) all are installed properly

But info.php in /var/www/ does show the info. Only PHP embedded in html doesn't show the script. please help me.. I have tried the previous askubuntu questions and didnot get anything useful so ...
1
vote
2answers
1k views

Installing mysql 5.1 with Ubuntu 12.04

I have Ubuntu 12.04 installed, I need to install mysql 5.1 in that. Following steps I performed: Other things to be installed: Run this command to install alien and other necessary packages if not ...
0
votes
0answers
113 views

MySql cannot start: Job failed to start

I am trying to sync two databases using a local IP. A main database is created on host computer and I'm trying to sync data from another computer to this database through a local network. I changed ...
1
vote
2answers
341 views

Script timeout passed, if you want to finish import, please resubmit same file and import will resume

I am getting this error while importing the database in mysql, and when I resubmit the same file than I am getting this error Error SQL query: -- -- Dumping data for table `adminnotification_inbox` ...
0
votes
1answer
55 views

php and mysql issues

I've recently read Wallace Wang's “Beginning Programming for Dummies, 7 books in 1” and found it to be very enlightening, as it highlighted various differences between the three main operating systems ...
0
votes
1answer
158 views

12.04.4 + MySQL 5.5 + Wordpress - MySQL Service Fails to Start

It appears that the issue is around the MySQL services starting as I receive the following in my /var/log/syslog when I attempt to restart the mysql service: Jan 17 08:19:38 blog kernel: [ ...
0
votes
1answer
133 views

Installing libmysql on Ubuntu Server 12.04

I really need help installing the dependency of this, which is libmysql (here) I really have no idea how to install it. The author requires me to put it in a specific directory, but I have had no ...
1
vote
1answer
3k views

install libmysqlclient-dev 5.6

I can't use the mysql ruby gem because I get this error: Incorrect MySQL client library version! This gem was compiled for 5.6.15 but the client library is 5.5.34. (RuntimeError) apt-get is ...
0
votes
1answer
443 views

install mysql proxy via ubuntu terminal

How do i install MySql Proxy via ubuntu terminal http://dev.mysql.com/doc/refman/5.1/en/mysql-proxy-install-binary.html
0
votes
1answer
76 views

command line syntax that will show MySQL details

Is there a command-line syntax that will show details about my installed MySQL (eg. ports, config file paths, etc.)?
0
votes
0answers
95 views

Migrate from MySQL 5.5.34 to MariaDB 5.5.33 for Ubuntu 12.04 LTS

How to Migrate MySQL to MariaDB since I'm taking most of my time turning in Circles. Sorry if this question is to chicken for you guys. Since I'm new with Ubuntu and in MariaDB. Yet most of the time ...
1
vote
0answers
97 views

Can't purge mysql-server installation

Since I've got no privileged user in my current MySQL-installation on 12.04 LTS I want to re-install the mysql-server completely by using: sudo apt-get purge mysql-server After a very short while I ...
0
votes
1answer
213 views

Why isn't the cppconn folder in /usr/include?

I am new to C++. I am trying to make a MySQL connection. I found that it requires mysql-connector. I installed boost-dev-all . I have put my mysql-connector in local directory ~/bin. I have ...
0
votes
1answer
1k views

Turn off MySQL --skip-grant -tables

I reset my root mysql password with the following instructions: (Works for Ubuntu as well) http://www.debian-administration.org/articles/442 But now I can't turn off mysqld_safe --skip-grant-tables. ...
0
votes
1answer
193 views

replication checking shell script error

I'm trying to create a Database Replication checking script which checks master-master replication but I'm getting error while executing it. Here is the script #!/bin/bash ...
0
votes
0answers
231 views

Postfix+Courier+Mysql / SASL authentication error

Today I've installed Postfix/Courier with Mysql authorisation/virtual users using this guide: https://help.ubuntu.com/community/PostfixCompleteVirtualMailSystemHowto after a lot of searching and ...
2
votes
1answer
504 views

Create firebird database in specific directory

I want to be able to create a firebird database in a specific directory. I know that the firebird user needs to have r/w/x permissions to the directory where I want to create the db. I created a group ...
1
vote
1answer
1k views

can't start mysql service anymore

I had MySQL running ... with many different databases. I install MySQL workbench today.. and was able to create any entity relationship diagram etc. Then i decided to increase the size of my ...
2
votes
3answers
16k views

How to run mysql command from terminal?

I have the following sql command which I usually run in phpmyadmin by selecting the database, then running it in the command window. DELETE FROM `wp_posts` WHERE `post_type` = "attachment" However ...
0
votes
0answers
250 views

freeradius authentication in ubuntu 12.04 for vsftpd

I am using Ubuntu 12.04 based distro. I have configured Vsftpd and now want to configure freeradius server for authentication of vsftpd. I do not know the mechanism of freeradius and procedure that ...
1
vote
1answer
348 views

Backup MYSQL DB on one server and restore on other, do i need the same version of MYSQL?

I backupped my old db on ubuntu 10.10 server using mysql 5.1.49 using mysqldump now I want to restore the file on my other machine, using ubuntu 12.04 server with Mysql version 5.5.32 on it. I ...
0
votes
0answers
544 views

Disable running mysqld at system startup

I am using Ubuntu 12.04.2 LTS (GNU/Linux 3.5.0-37-generic x86_64). I have messed a little in my Ubuntu configuration. Now every startup I have mysqld running: $ ps aux | grep mysqld mysql 959 ...
0
votes
1answer
1k views

12.04 - MySql won't start by using service mysql start

The only way I was able to get MySql to start was to issue: mysqld When I issued this command, it started rolling back some database transactions that were conflicted. I have tried issuing ...
0
votes
1answer
209 views

How do I setup php and mysql cronjobs on ubuntu 12.04 server?

just made a lamp install adn got sftp working. My question now is how do I setup cronjobs in ubuntu server? I need to make some cronjobs for my php/mysql application. Look for un-activated users in ...
0
votes
0answers
35 views

Updated MySQL Workbench for 12.04

I currently have MySQL Workbench installed from the 12.04 repository. This is version 5.2.38. The current version is 5.2.47. Is there a PPA where I can get the latest version? I would like to stay on ...
0
votes
0answers
122 views

Working with existing database of a rails project in ubuntu12

I want to run a ruby on rails project in my Ubuntu 12 mechine.After running the command bundle install i used the following command rake db:drop db:setup it shows -- ...
0
votes
3answers
356 views

GUI mysql tool for multiple databases

I have two discrete mysql databases (located in different servers). In windows, I can use odbc and ms access and query from tables residing in different databases. In ubuntu, is there a way or tool to ...