Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

1
vote
1answer
457 views

Linux-Ubuntu Problem : Cannot find mysql database after connection is made to mysql

I have a war file deployed in webapps folder at /srv/apache-tomcat-7.0.53/webapps/ War name is InIndia.war I have deployed inindiadb.properties in classpath which is /srv/apache-tomcat-7.0.53/lib ...
0
votes
1answer
765 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
1answer
79 views

I have installed mysql on ubuntu 13.10, but don't seem to have rights to do anything?

This is possibly a problem that affects lots of users, I have have found similar posts, but none of the solutions have worked for me. I have installed mysql on my ubuntu 13.10, however I do not seem ...
2
votes
1answer
72 views

Start services only when really required

I use my desktop box as dev "server", so I have installed mysql+apache+whatever. This causes boot to last longer, also memory consumption is high since I have all this services running. Does a ...
1
vote
3answers
32k views

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

I know that some users may say that this is a duplication but seriously I have combed the answers and those on the internet for over half a day and I am so frustrated i am going to explode. Now that ...
1
vote
0answers
416 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
2answers
689 views

Apache unable to connect to MySQL

I installed apache server (this story). I cannot connect with remote (I tried local too) mysql server. After a long loading page I get error MySQL database connect failure. Mysql server is far from me....
1
vote
2answers
4k views

Can't connect to local MySQL server through socket '/tmp/mysql_2.sock' during manual installation of mysql

I get the error below when attempting to manually install mysql-5.6.17-linux-glibc2.5-x86_64 Steps I followed: 1. tar -xzvf mysql-standard-5.1.34-linux-i686-glibc23.tar.gz 2. ln -s mysql-...
0
votes
1answer
858 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
51 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 ...
1
vote
3answers
430 views

Is MySQL still running after uninstall it?

I had mysql server running. I stopped it, and removed it (apt-get remove mysql-server mysql-client) I then manually removed the directories: /var/lib/mysql /var/run/mysqld I rebooted. But when I ...
1
vote
0answers
595 views

Subdirectories Show 404 Not Found on 13.10 web server

I recently set up a web server on Ubuntu 13.10 and when I enter the external IP it works fine showing the index file of var/www/ but whenever I try to add a folder, say one called test, and I go to ...
0
votes
1answer
1k views

mysql error : Incorrect key file for table '/tmp/#sql_5115_0.MYI

Query failed by reason : Incorrect key file for table '/tmp/#sql_5115_0.MYI i read that it may be realted to disk space issue but i ma not sure how that is as df -h returns Filesystem Size ...
3
votes
1answer
1k views

How to transfer MySQL database from Windows to Ubuntu?

I want to transfer my database from WAMP on my local machine to my Ubuntu VPS. Can I just copy the folder of the database from C:\wamp\bin\mysql\mysql5.6.12\data to /var/lib/mysql?
3
votes
2answers
8k 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 ...
1
vote
1answer
1k views

How to install mysql without root access?

I found this article that explains how to install MySQL without root access. However, on the MySQL download page is no download link for Ubuntu. Which one should I choose in this case? If it has a "...
1
vote
2answers
9k views

Cannot start mysql server [closed]

I'm tring to run a website from my server, so I installed php, apache and mysql. I'm having problems with mysql. After installation, it failed to restart. This is the output: root@ns213360:/etc/...
6
votes
2answers
11k views

Mysql couldn't write to /tmp then failed to restart

I was running orthomcl program which uses mysql. This program has operated just fine on the same computer before. This time I had an error message. DBD::mysql::st execute failed: Can't create/write ...
1
vote
0answers
4k views

MySQL not starting because “mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)”

I am setting up a new LAMP server with Ubuntu Server 13.10 and MySQL 5.5 and was in the middle of migrating mysql databases to new server when I realized mysql server is not running. All was fine last ...
0
votes
1answer
122 views

target 'php5-mysql' is not a directory error

I'm trying to get LAMP up and running in VirtualBox for an assignment I have. I've installed Ubuntu and then Apache 2 and PHP 5. I'm using the instructions found here: https://help.ubuntu.com/...
1
vote
5answers
3k views

crontab not running as root

Mysql backup scripts not running as root crontab - help I'm trying to run a crontab as root but the script is not running successfully. I can see in syslog that the script is executing but it does ...
-1
votes
2answers
346 views

how to connect to mysql server in another system from ubuntu

I am using ubuntu, and am programming in android. So in my application i need to connect to mysql database which is in another system. When i searched, i foud that wamp server is need, wanp only works ...
2
votes
1answer
3k views

Where is mysqldbcompare?

The MySQL docs refer to a utility mysqldbcompare. But it doesn't seem like I have it installed, and when I type mysqldbcompare it doesn't suggest any packages (Ubuntu 12.04). Where can I find this ...
2
votes
4answers
3k views

Unable to send data to mysql database. It is not taking by my php code [closed]

I am new to PHP in Ubuntu 13.10. But I am pretty much able to handle Ubuntu. However my question is that I can't add any data to phpmyadmin through a PHP code, though my code is perfect. Because I ...
3
votes
1answer
10k views

Remotely access mysql db on vm from windows as host [closed]

I have ubuntu on vmware. I've installed mysql-server on it. And now I'd like to connect to this db directly from the Host(windows) machine. Ubuntu is connected to the router via bridge. I can ping it ...
1
vote
1answer
368 views

Mysql data provider for TORA

I was a MySQL query browser user in Windows. I switched to Ubuntu 13.10 and now I can't get MySQL query browser so I tried TORA referenced from MySQL GUI Tools Now I could not get any option in ...
0
votes
0answers
29 views

Error when installing mysql on ubuntu [duplicate]

I get This error when I try to install MySQL on ubuntu: sudo apt-get install mysql-server [sudo] password for xxxxx: Reading package lists... Done Building dependency tree Reading state ...
2
votes
4answers
8k 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 /var/lib/...
0
votes
0answers
31 views

How to solve mysql dependency problem [duplicate]

Hi I ran the following command sudo apt-get upgrade However I'm getting the following You might want to run 'apt-get -f install' to correct these. The following packages have unmet ...
2
votes
0answers
19 views

SSL is not in use on MySQL server [duplicate]

I installed MySQL server and I want to allow SSL support. I added these lines to my.cnf [client] ssl-ca=/etc/mysql/ca-cert.pem ssl-cert=/etc/mysql/client-cert.pem ssl-key=/etc/mysql/client-key.pem [...
1
vote
0answers
496 views

What does this mysql error mean?

I'm on Xubuntu 13.10 64 bit. I know the password of my mysql database, but still can't login as root. I try to change the password sudo mysqld_safe --skip-grant-tables & I get [1] 8863 mypc ~: ...
3
votes
2answers
4k views

Mysql 5.5 reinstallation 12.04

I had a broken installation of mariadb over mysql 5.5. For hours i have tried to reinstall mysql with the usage of apt-get - tried to purge, remove etc everything mysql related. Uninstalled php aswell....
2
votes
1answer
709 views

How do I set up a Tor server?

I would like to host a tor hidden services website (aka .onion site) on my Ubuntu desktop with the LAMP stack installed. While the tor docs offer some guidance on running an anonymous server, the ...
0
votes
1answer
203 views

No reaction on service mysql start, init script works

After upgrading Ubuntu from 12.04 to 13.10, the MySQL server (now 5.5) does not start/stop with service mysql start|stop. When typing /etc/init.d/mysql start, everything works fine. Once it does ...
0
votes
0answers
44 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

Could not open connection to host (ubuntu server) on port 23, 5432, 3306

I have recently installed few packages for telnet, mysql and postgreSQL. I can access all these service locally on the ubuntu server but somehow I am not able to access these services from other ...
4
votes
1answer
147 views

Destroying service before removing the relation causes both services to hang at dying

I deployed wordpress and mysql and add relation between wordpress and mysql. I try to destroy wordpress before removing the relation between wordpress and mysql. Now, both services are hanging at ...
4
votes
5answers
38k 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 ...
0
votes
1answer
3k views

Unable to install MySQL. Held broken packages [duplicate]

I tried installing MySQL using sudo apt-get install mysql-server, and I get an error saying Some packages could not be installed. This may mean that you have requested an impossible situation or if ...
2
votes
3answers
28k views

how install mysql 5.6 and mysql workbench 6.0.9 on ubuntu 13.10

I am using Ubuntu 13.10 Saucy Salamander (64 bit System) . I want to install mysql 5.6 and workbench 6.0.9 on it. how i do it please describe step by step?
0
votes
1answer
566 views

Why automatic installed mysql 5.5 when i install mysql workbench 6.0.9 from deb file using ubuntu software center

I am using Ubuntu 13.10 and already installed mysql 5.6.16 on it. I have downloaded mysql workbench deb file (mysql-workbench-community-6.0.9-1ubu1310-amd64) from mysql web site. Now when I run this ...
1
vote
1answer
74 views

How can I determine the available amount of disk space when using a charm?

When using juju to deploy a DB, how can I determine the available amount of disk space when using the DB charm? Suppose that I'm using EC2 (or anywhere else) to deploy a PostgreSQL/MySQL/WhateverDB ...
1
vote
1answer
1k views

kill sleeping process in mysql?

I have a MySQL database, which is very often filling with sleep process and I have to open my workbench and then have to kill them to free connections & then it will work fine. Is there any way ...
0
votes
1answer
482 views

aptitude problem using mariadb repository on Ubuntu 13.10

I installed mariadb 5.5 on my ubuntu laptop like described here: sudo add-apt-repository "deb http://ftp.osuosl.org/pub/mariadb/repo/5.5/ubuntu $(lsb_release -c -s) main" and it works fine so far, ...
1
vote
3answers
431 views

Migrate whole mysql to another server [closed]

I'm switching from a vps to another one and i need to migrate my mysql server. Is there an easy way to backup/restore ALL databases and users (with permissions) at once? Many thanks
4
votes
1answer
13k 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
2answers
960 views

Server crashed a few times due to lack of memory - how can I find out how much is available to each process? [duplicate]

We had a huge spike in traffic with lots of these errors: Feb 17 10:44:13 111488 kernel: [8275767.506198] Out of memory: Kill process 20577 (apache2) score 52 or sacrifice child Feb 17 11:02:06 ...
5
votes
2answers
16k views

Optimising MySQL settings - mysqld running out of memory

I'm a bit confused about which settings to change in my my.conf file to optimise for my server (the mysql server keeps crashing due to our high traffic). Here's the my.cnf file: [mysqld] user ...
2
votes
2answers
5k views

How can I activate MySQL Database Server?

I have a problem with my xampp that's installed on Ubuntu 12.04 64-bit. After successfully installing my xampp server, I do get access to the lampp server which further indicates that the mysql ...
2
votes
2answers
14k views

Trouble Installing MySQL workbench [closed]

I am new to Ubuntu Linux. My Professor asked us to download Ubuntu 10.10. I have made several attempts to download MySQL as 32 and 64 bit in Debian packages and it keeps failing. See below for what i ...